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(); } }