private void Delete() { try { FormHelpers.CursorWait(true); var msg = "Deleting"; if (MessageHelpers.ShowQuestion("Are you sure you want to delete record?") == System.Windows.Forms.DialogResult.Yes) { var yearused = UserSettings.LogInYear; var partno = mgridListAssy.Rows[mgridListAssy.SelectedCells[0].RowIndex].Cells["colPartNoAssy"].Value.ToString(); assy = assybal.GetByID(Convert.ToInt32(yearused), partno.ToString());; if (assybal.Delete(assy)) { MessageHelpers.ShowInfo(msg + " Successful!"); RefreshGrid(); PageManager(1); } else { MessageHelpers.ShowWarning(msg + " Failed!"); } } } catch (Exception ex) { MessageHelpers.ShowError(ex.Message); } finally { FormHelpers.CursorWait(false); } }
public frmMT_Assy() { InitializeComponent(); assybal = new AssymblyBAL(); assy = new tbl_000_H_ASSY(); err = new ErrorProviderExtended(); }
private void AssignRecord(Boolean IsSave) { try { if (IsSave) { tbl_000_H_ASSY existassy = new tbl_000_H_ASSY(); existassy = assybal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && w.PartNo == mtxtPartNo.Text).FirstOrDefault(); if (existassy == null) { assy.CreatedDate = DateTime.Now; assy.CreatedBy = UserSettings.Username; assy.IsCopied = false; assy.CopyDate = DateTime.Now; assy.IsImported = false; assy.ImportDate = DateTime.Now; assy.ImportBy = UserSettings.Username; } assy.YEARUSED = UserSettings.LogInYear; assy.PartNo = mtxtPartNo.Text; assy.PartName = mtxtPartName.Text; assy.HC = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtHC.Text, 0)); assy.Qty = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtQty.Text, 0)); assy.RATEPERHOUR = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtRatePerHour.Text, 0)); assy.IsLocked = mcbLocked.Checked; assy.UpdatedDate = DateTime.Now; assy.UpdatedBy = UserSettings.Username; } else { assy = assybal.GetByID(yearused, partno); if (assy != null) { mtxtPartNo.Text = assy.PartNo; mtxtPartName.Text = assy.PartName; mtxtHC.Text = ((double)assy.HC).ToString(); mtxtQty.Text = ((double)assy.Qty).ToString(); mtxtRatePerHour.Text = assy.RATEPERHOUR.ToString(); mcbLocked.Checked = assy.IsLocked; assy.UpdatedDate = DateTime.Now; assy.UpdatedBy = UserSettings.Username; } } } catch (Exception ex) { throw ex; } }
public Boolean Save(tbl_000_H_ASSY record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { db.AssymblyList.Add(record); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Delete(tbl_000_H_ASSY record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var existrecord = GetByID(record.YEARUSED, record.PartNo); db.AssymblyList.Remove(existrecord); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Update(tbl_000_H_ASSY record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var existrecord = GetByID(record.YEARUSED, record.PartNo); db.Entry(existrecord).CurrentValues.SetValues(record); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Delete(tbl_000_H_ASSY record) { try { if (record == null) { throw new Exception("Invalid Parameter!"); } if (!assydal.IsExistID(record.YEARUSED, record.PartNo)) { throw new Exception("Record does not exist!"); } return(assydal.Delete(record)); } catch (Exception ex) { throw ex; } }
public Boolean Save(tbl_000_H_ASSY record) { try { if (record == null) { throw new Exception("Invalid Paramter!"); } if (assydal.IsExistID(record.YEARUSED, record.PartNo)) { throw new Exception("No. already taken!"); } return(assydal.Save(record)); } catch (Exception ex) { throw ex; } }
public frm_DynamicList() { InitializeComponent(); combal = new ComponentBAL(); com = new tbl_000_H_PART(); pibal = new PlasticInjectionBAL(); pi = new tbl_000_H_PI(); vpbal = new VacuumPlatingBAL(); vp = new tbl_000_H_VP(); assybal = new AssymblyBAL(); assy = new tbl_000_H_ASSY(); mrbal = new MODRCBAL(); modrc = new tbl_000_MODRC(); itembal = new ItemBAL(); item = new tbl_000_H_ITEM(); catbal = new CategoryBAL(); cat = new tbl_000_H_CATEGORY(); comlist = new List <tbl_000_H_PART>(); }
public frmMT_AssyList() { InitializeComponent(); assybal = new AssymblyBAL(); assy = new tbl_000_H_ASSY(); }