Comments by khalid4775 (Top 29 by date)

i have been created the object but iam getting the error below

CS0161 'ManageVisitsTypesService.InsertVisitsTypes(int, string, bool, string, int)': not all code paths return a value

Yes that what i did but its not inserting the data to database

Cannot implicitly convert type 'bool' to 'DBHelper.SaveResult'

In DBHelper.SaveResult contain this

public enum SaveResult
{
Ok,
DuplicateId,
DuplicateName,
UnknownError,
}

yes i have tried that like so :

ManageVisitsTypesService.InsertVisitsTypes(ManageVisitsTypesModel.VisitTypeID, ManageVisitsTypesModel.VisitTypeName, ManageVisitsTypesModel.VisitTypeStatus, ManageVisitsTypesModel.VisitTypeNotes, ManageVisitsTypesModel.CreatedBy);


but its getting the same error

this works correct :)

MemoryStream ms = new MemoryStream((byte[])selectedRow.Cells[5].Value);
iops.CustomerPhoto = Image.FromStream(ms);

i tried but not working i got this error :

'Unable to cast object of type 'System.Byte[]' to type 'System.Drawing.Image

Thanks alot for help yes working fine now

but if i want get the photo from datagridview to picturebox on click event i use this method :


public void GetDataToTextBox(DataGridViewCellEventArgs e)
{
int index = e.RowIndex;// get the Row Index
DataGridViewRow selectedRow = iops.DataGridViewRows.Rows[index];
iops.CustomerID = Convert.ToInt32(selectedRow.Cells[0].Value);
iops.CustomerName = selectedRow.Cells[1].Value.ToString();
iops.CustomerEmail = selectedRow.Cells[2].Value.ToString();
iops.CustomerPhone = selectedRow.Cells[3].Value.ToString();
iops.CustomerStatus = Convert.ToBoolean(selectedRow.Cells[4].Value);
iops.CustomerPhoto = selectedRow.Cells[5].Value;
}

but there error Cannot implicitly convert type 'object' to 'System.Drawing.Image'. An explicit conversion exists (are you missing a cast?)

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 :)

How can i insert image database

Updated ...

Iam New in MVP can you modify it for me ?
Thanks

Updated The Question :)

Solved Thanks :)

just added
using static Test.Data_Layer.DataAccessLayer;

ok sir i have added CustomerSaveResult enum to DAL class but iam unable call it to other class or form : i added this to DAL class :

public enum CustomerSaveResult
{
Ok,
DuplicateId,
DuplicateName,
UnknownError,
}

private void button3_Click(object sender, EventArgs e)
{
if (textBox3.Text.Trim() == "")
{
MessageBox.Show("Enter Customer Name");
return;
}
CustomerSaveResult saveResult = Saving.Save_Customers(Convert.ToInt32(textBox4.Text.Trim()), textBox3.Text.Trim());
if (saveResult == CustomerSaveResult.DuplicateId)
{
MessageBox.Show("Custumer Id Exites");
}
else if (saveResult == CustomerSaveResult.DuplicateName)
{
MessageBox.Show("Custumer Name Exites");
}
{

https://ibb.co/2ZPzc0t



Error CS0266 Cannot implicitly convert type 'Test.Business_Layer.CLS_AddUpdateDelete.CustomerSaveResult' to 'Test.PL.FrmAddUpdateDelete.CustomerSaveResult'. An explicit conversion exists (are you missing a cast?)

https://ibb.co/TH4r0Vj

Yes serious iam new in C# so i try to read and search for solution for my errors before i send question
now i got error
Cannot implicitly convert type to. An explicit conversion exists (are you missing a cast?)
can you help me with this :)

https://ibb.co/TH4r0Vj

Thank you Thank you Thank you
i have add this code to button save

Saving.Save_Customers(Convert.ToInt32(textBox4.Text.Trim()), textBox3.Text.Trim());

How to inspect the returned CustomerSaveResult value and display it in message

Than you very much

Thanks For help but iam getting errors :


1.CS0246 C# The type or namespace name could not be found (are you missing a using directive or an assembly reference?)


2.CS0103 C# The name does not exist in the current context

https://ibb.co/t20h3N3][img]https://i.ibb.co/090XQWQ/d.jpg[^][^]

http://store6.up-00.com/2017-04/149183753091961.jpg

But image is there


http://store6.up-00.com/2017-04/149183753103342.jpg

in Module

i have tried this


@CustomerID int output,
@CustomerName nvarchar (50),
@CustomerPhoto image = null,
@CustomerEmail nvarchar(Max),
@CustomerPhone1 nvarchar(12),
@CustomerPhone2 nvarchar(12),
@CustomerAddress nvarchar(Max),
@CustomerFax nvarchar(12),
@CustomerStatus bit,
@CountryID int,
@CityID int,
@Notes nvarchar (Max),
@ModifiedBy nvarchar (30)


as

BEGIN
update CustomersTbl set
CustomerID=@CustomerID,
CustomerName=@CustomerName,
CustomerPhoto=@CustomerPhoto,
CustomerEmail=@CustomerEmail,
CustomerPhone1=@CustomerPhone1,
CustomerPhone2=@CustomerPhone2,
CustomerAddress=@CustomerAddress,
CustomerFax=@CustomerFax,
CustomerStatus=@CustomerStatus,
CountryID=@CountryID,
CityID=@CityID,
Notes=@Notes,
ModifiedDate=getdate(),
ModifiedBy=@ModifiedBy
where CustomerID=@CustomerID

END


But the image has been set to Null

http://store6.up-00.com/2017-04/149183753091961.jpg

But image is there


http://store6.up-00.com/2017-04/149183753103342.jpg

Public Function GetPhoto(ByVal filePath As String) As Byte()
Dim stream As FileStream = New FileStream(filePath, FileMode.Open, FileAccess.Read)
Dim reader As BinaryReader = New BinaryReader(stream)
Dim photo() As Byte = reader.ReadBytes(stream.Length)
reader.Close()
stream.Close()
Return photo
End Function


Public Function byteArrayToImage(ByVal byt As Byte()) As Image
Dim ms As New System.IO.MemoryStream()
Dim drwimg As Image = Nothing
Try
ms.Write(byt, 0, byt.Length)
drwimg = New Bitmap(ms)
Finally
ms.Close()
End Try
Return drwimg
End Function