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