private void UpdateLocation()
{
if (locationId == "" || locationId == null)
{
MessageBox.Show("Please click Data Grid User");
}
else
{
if (txtLocationName.Text == "")
{
MessageBox.Show("Required is Location Name");
txtLocationName.Focus();
}
else if (txtLocationAddress.Text == "")
{
MessageBox.Show("Required is Location Address");
txtLocationAddress.Focus();
}
else if (pbLocationPhoto.Image == null)
{
MessageBox.Show("Please click Photo Browse");
btnPhoto.Focus();
}
else
{
frmMainForm frmmain = new frmMainForm();
userId = frmmain.userId;
string date = DateTime.Now.ToShortDateString();
Database.LocationImageClass locobj = new LocationImageClass();
locobj.LocationId = locationId;
locobj.LocationName = txtLocationName.Text;
locobj.LocationAddress = txtLocationAddress.Text;
locobj.UpdatedBy = frmMainForm.UserId;
//locobj.Date = date;
//locobj.Time = DateTime.Now.ToShortTimeString();
// locobj.LocationImage = img;
img = ImageToBase64(pbLocationPhoto.Image, System.Drawing.Imaging.ImageFormat.Png);
locobj.LocationImage = img;
locobjdal.UpdateLocation(locobj);
Clear();
}
}
}
private void dataGridLocation_CellClick(object sender, DataGridViewCellEventArgs e)
{
locationId = dataGridLocation.CurrentRow.Cells[0].Value.ToString();
if (locationId != "")
{
LocationImageClass locimg = new LocationImageClass();
locimg = locobjdal.ShowLocation(locationId);
txtLocationName.Text = locimg.LocationName;
txtLocationAddress.Text = locimg.LocationAddress;
if (locimg.LocationImage != "")
{
pbLocationPhoto.Image = Base64ToImage(locimg.LocationImage);
}
btnSave.Text = "Update";
lblLocationId.Text = "LocationId : " + locationId;
}
}
private void InsertLocation()
{
if (txtLocationName.Text == "")
{
MessageBox.Show("Required is Location Name");
txtLocationName.Focus();
}
else if (txtLocationAddress.Text == "")
{
MessageBox.Show("Required is Location Address");
txtLocationAddress.Focus();
}
else if (img == null)
{
MessageBox.Show("Please click Photo Browse");
btnPhoto.Focus();
}
else
{
frmMainForm frmmain = new frmMainForm();
userId = frmMainForm.UserId;
GetId();
string date = DateTime.Now.ToShortDateString();
Database.LocationImageClass locobj = new LocationImageClass();
locobj.LocationId = nextLocationId;
locobj.LocationName = txtLocationName.Text;
locobj.LocationAddress = txtLocationAddress.Text;
locobj.UpdatedBy = frmMainForm.UserId;
locobj.Date = date;
locobj.Time = DateTime.Now.ToShortTimeString();
locobj.LocationImage = img;
locobjdal.InsertLocation(locobj);
ShowLocation();
Clear();
}
}
