Picturebox error in C# and MVP

Question

0.00/5 (No votes)

See more:

, +

i have forum with picturebox and some texts so i want to insert photo to database how can i do that .

my code like so :

Models:
<pre lang="c#">namespace TestMVP.Models
{
    class OpsModel
    {
        public int CustomerID { get; set; }
        public string CustomerName { get; set; }
        public string CustomerEmail { get; set; }
        public string CustomerPhone { get; set; }
        public bool CustomerStatus { get; set; }
        public object CustomerPhoto { get; set; }

    }
}

Inetrfaces

C#

namespace TestMVP.Views.Inerfaces
{
    public interface IOps
    {
        int CustomerID { get; set; }
        string CustomerName { get; set; }
        string CustomerEmail { get; set; }
        string CustomerPhone { get; set; }
        bool CustomerStatus { get; set; }
        object DataGridView { get; set; }
        DataGridView DataGridViewRows { get; set; }
        object simpleButton2 { get; set; }
        object simpleButton3 { get; set; }
        object simpleButton4 { get; set; }
        object Cbx { get; set; }
        string CustomerDisplayMember { get; set; }
        string CustomerValueMember { get; set; }
        object CustomerPhoto { get; set; }
    }
}

Services:

C#

private static void CumstomerParamerterInsert(int CustomerID, string CustomerName, string CustomerEmail, string CustomerPhone, bool CustomerStatus, SqlCommand command)
        {
            command.Parameters.Add("@CustomerID", SqlDbType.Int).Value = CustomerID;
            command.Parameters.Add("@CustomerName", SqlDbType.NVarChar, 150).Value = CustomerName;
            command.Parameters.Add("@CustomerEmail", SqlDbType.NVarChar, 50).Value = CustomerEmail;
            command.Parameters.Add("@CustomerPhone", SqlDbType.NVarChar, 10).Value = CustomerPhone;
            command.Parameters.Add("@CustomerStatus", SqlDbType.Bit).Value = CustomerStatus;
            FrmOps f = new FrmOps();
            command.Parameters.Add("@CustomerPhoto", SqlDbType.Image).Value =Main_Classes.CLS_Photos.ImageToByteArray(f.MyPictureBox.Image);
        }

<pre>
    //This Method For Insert Customer To Database
    static public bool InsertCustomer(int CustomerID, string CustomerName, string CustomerEmail, string CustomerPhone, bool CustomerStatus)
    {
        return DBHelper.ExcuteData("Save_Customer", () => CumstomerParamerterInsert(CustomerID, CustomerName, CustomerEmail, CustomerPhone, CustomerStatus, DBHelper.command));
    }

Presenter:

C#

namespace TestMVP.Logic.Presenter
{
    class OpsPresenter
    {
        IOps iops;
        OpsModel opsModel = new OpsModel();

<pre>
    public OpsPresenter(IOps view)
    {
        iops = view;
    }

    // Connect Between Model And Interface
    private void ConnectBetweenModelAndInterface()
    {
        opsModel.CustomerID = iops.CustomerID;
        opsModel.CustomerName = iops.CustomerName;
        opsModel.CustomerEmail = iops.CustomerEmail;
        opsModel.CustomerPhone = iops.CustomerPhone;
        opsModel.CustomerStatus = iops.CustomerStatus;
        opsModel.CustomerPhoto = iops.CustomerPhoto;
    }

    // Insert Customer To Database
    public void CusInsert()
    {
        if (iops.CustomerName == "")
        {
            MessageBox.Show("Please Enter Customer Name");
            return;
        }
        if (iops.CustomerEmail == "")
        {
            MessageBox.Show("Please Enter Customer Email");
            return;
        }
        if (iops.CustomerPhone == "")
        {
            MessageBox.Show("Please Enter Customer Phone");
            return;
        }
        else
        {
            ConnectBetweenModelAndInterface();
            OpsService.InsertCustomer(opsModel.CustomerID, opsModel.CustomerName, opsModel.CustomerEmail, opsModel.CustomerPhone, opsModel.CustomerStatus);
            GetAllCus();
            AutoNumber();
            MessageBox.Show("Customer Added ... ");
        }
    }

Now In form i have Implement the object

C#

<pre>public object CustomerPhoto { get => pictureBox1.Image; set => pictureBox1.Image; }

the image not insert to database and i have change to picturebox.Initalimage but also not working

error : Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement

What I have tried:

public object CustomerPhoto { get => pictureBox1.InitialImage; set => pictureBox1.Image; }

and

public object CustomerPhoto { get => pictureBox1.Image; set => pictureBox1.Image = value; }

Posted 15-Dec-20 2:15am

khalid4775

Updated 15-Dec-20 3:34am

Add a Solution

2 solutions

Solution 1

You are close, but your property is the problem: you have declared it as an object which means it "doesn't really have a type".

C#

public object CustomerPhoto { get => pictureBox1.Image; set => pictureBox1.Image = value; }

Change that, and it should start to work:

C#

public Image CustomerPhoto
    {
    get => pictureBox1.Image;
    set => pictureBox1.Image = value;
    }

Posted 15-Dec-20 2:28am

OriginalGriff

Comments

khalid4775 15-Dec-20 8:52am

Thanks but it dosent work i change the property to Image on all classes

Interface :

Image CustomerPhoto { get; set; }

Model:

public Image CustomerPhoto { get; set; }

And Finally Impemented in the form as

public Image CustomerPhoto
{
get => pictureBox1.Image;
set => pictureBox1.Image = value;
}

not able to insert or update image
Kind Regards :)

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2020-12-15T03:34:00

Quote:

C#

FrmOps f = new FrmOps();
command.Parameters.Add("@CustomerPhoto", SqlDbType.Image).Value = Main_Classes.CLS_Photos.ImageToByteArray(f.MyPictureBox.Image);

You create a new, empty instance of your form class, and expect it to magically pick up the picture from a completely difference instance of the form.

Your CumstomerParamerterInsert method should have no idea about your FrpOps form. Instead, you should pass in the picture you want to save as a parameter to this method.

C#

private static void CustomerParamerterInsert(int CustomerID, string CustomerName, string CustomerEmail, string CustomerPhone, bool CustomerStatus, Image CustomerPhoto, SqlCommand command)
{
    command.Parameters.Add("@CustomerID", SqlDbType.Int).Value = CustomerID;
    command.Parameters.Add("@CustomerName", SqlDbType.NVarChar, 150).Value = CustomerName;
    command.Parameters.Add("@CustomerEmail", SqlDbType.NVarChar, 50).Value = CustomerEmail;
    command.Parameters.Add("@CustomerPhone", SqlDbType.NVarChar, 10).Value = CustomerPhone;
    command.Parameters.Add("@CustomerStatus", SqlDbType.Bit).Value = CustomerStatus;
    command.Parameters.Add("@CustomerPhoto", SqlDbType.Image).Value = Main_Classes.CLS_Photos.ImageToByteArray(CustomerPhoto);
}

static public bool InsertCustomer(int CustomerID, string CustomerName, string CustomerEmail, string CustomerPhone, bool CustomerStatus, Image CustomerPhoto)
{
    return DBHelper.ExcuteData("Save_Customer", () => CustomerParamerterInsert(CustomerID, CustomerName, CustomerEmail, CustomerPhone, CustomerStatus, CustomerPhoto, DBHelper.command));
}

C#

public interface IOps
{
    ...
    Image CustomerPhoto { get; set; }
}

class OpsModel
{
    ...
    public Image CustomerPhoto { get; set; }
}

C#

public void CusInsert()
{
    ...
    OpsService.InsertCustomer(opsModel.CustomerID, opsModel.CustomerName, opsModel.CustomerEmail, opsModel.CustomerPhone, opsModel.CustomerStatus, opsModel.CustomerPhoto);
    ...
}

C#

public Image CustomerPhoto
{
    get => this.MyPictureBox.Image;
    set => this.MyPictureBox.Image = value;
}

Picturebox error in C# and MVP

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Picturebox error in C# and MVP

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us