private void AssignRecord(Boolean IsSave) { try { if (IsSave) { sect.SECTIONCODE = mtxtSectionCode.Text; sect.SECTIONDESC = mtxtSectionDesc.Text; sect.IsActive = mcbActive.Checked; sect.ISCOSTING = mcbCosting.Checked; sect.SUPERVISOR = mtxtSectionSupervisor.Text; } else { sect = sectbal.GetByID(SectionCode); if (sect != null) { mtxtSectionCode.Text = sect.SECTIONCODE.ToString(); mtxtSectionDesc.Text = sect.SECTIONDESC; mtxtSectionSupervisor.Text = sect.SUPERVISOR; mcbActive.Checked = sect.IsActive; mcbCosting.Checked = sect.ISCOSTING; } else { throw new Exception("Record doesn't exist!"); } } } catch (Exception ex) { throw ex; } }
public frmSection() { InitializeComponent(); sectbal = new SectionBAL(); sect = new tbl_000_SECTION(); err = new ErrorProviderExtended(); }
public Boolean Save(tbl_000_SECTION record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { db.SectionList.Add(record); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Delete(tbl_000_SECTION record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var existrecord = GetByID(record.SECTIONCODE); db.SectionList.Remove(existrecord); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Delete(tbl_000_SECTION record) { try { if (record == null) { throw new Exception("Invalid Parameter!"); } if (!compdal.IsExistID(record.SECTIONCODE)) { throw new Exception("Record does not exist!"); } return(compdal.Delete(record)); } catch (Exception ex) { throw ex; } }
public Boolean Save(tbl_000_SECTION record) { try { if (record == null) { throw new Exception("Invalid Parameter!"); } if (compdal.IsExistSectionDesc(record.SECTIONDESC)) { throw new Exception("Description already taken!"); } if (compdal.IsExistID(record.SECTIONCODE)) { throw new Exception("Code already taken!"); } return(compdal.Save(record)); } catch (Exception ex) { throw ex; } }
public void DeleteRecord() { try { var sectioncode = mgridList.Rows[mgridList.SelectedCells[0].RowIndex].Cells["colSectionCode"].Value.ToString(); string scode = sectioncode; if (MessageHelpers.ShowQuestion("Are you sure you want to delete record?") == System.Windows.Forms.DialogResult.Yes) { var DeletingisSuccess = false; var msg = "Deleting"; sect = Sectionbal.GetByID(sectioncode); if (Sectionbal.Delete(sect)) { DeletingisSuccess = true; } if (DeletingisSuccess) { MessageHelpers.ShowInfo(msg + " Successful!"); RefreshGrid(); PageManager(1); } else { MessageHelpers.ShowWarning(msg + " Failed!"); } } } catch (Exception ex) { MessageHelpers.ShowError(ex.Message); } finally { FormHelpers.CursorWait(false); } }