private void btnDelete_Click(object sender, EventArgs e) { try { DEWSRMEntities db = new DEWSRMEntities(); int[] selRows = ((GridView)grdDProducts.MainView).GetSelectedRows(); DataRowView oDesignationID = (DataRowView)(((GridView)grdDProducts.MainView).GetRow(selRows[0])); int nID = Convert.ToInt32(oDesignationID["ID"]); DamageProduct oDP = db.DamageProducts.FirstOrDefault(p => p.DamageProID == nID); if (oDP == null) { MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.DamageProducts.Attach(oDP); db.DamageProducts.Remove(oDP); db.SaveChanges(); MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
public void ShowDlg(DamageProduct oDamageProduct) { _DamageProduct = oDamageProduct; if (_DamageProduct.DamageProID == 0) { _DamageProduct = new DamageProduct(); _DamageProduct.CreatedBy = Global.CurrentUser.UserID; _DamageProduct.CreateDate = DateTime.Now; } else { _DamageProduct.ModifiedDate = (DateTime)DateTime.Today; _DamageProduct.ModifiedBy = (int)Global.CurrentUser.UserID; } RefreshValue(); this.ShowDialog(); }
private void btnEdit_Click(object sender, EventArgs e) { try { DEWSRMEntities db = new DEWSRMEntities(); int[] selRows = ((GridView)grdDProducts.MainView).GetSelectedRows(); DataRowView oDID = (DataRowView)(((GridView)grdDProducts.MainView).GetRow(selRows[0])); DataRowView oEDate = (DataRowView)(((GridView)grdDProducts.MainView).GetRow(selRows[0])); int nDPID = Convert.ToInt32(oDID["ID"]); DateTime dEDate = Convert.ToDateTime(oEDate["EDate"]); DamageProduct oDProduct = db.DamageProducts.FirstOrDefault(p => p.DamageProID == nDPID); if (oDProduct == null) { MessageBox.Show("select an item to edit", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (Global.CurrentUser.ISEditable == 1) { if (dEDate < DateTime.Today) { MessageBox.Show("This damage order can't be editable, Please contact BD Team", "Unauthorized Access", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } fDamageProduct frm = new fDamageProduct(); frm.ItemChanged = RefreshList; frm.ShowDlg(oDProduct); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task <IActionResult> Create(DamageProduct damageProduct) { int count = _context.DamageProducts.Count(); damageProduct.VoucharNo = "DV000" + count.ToString(); damageProduct.TonAMount = damageProduct.KGAmount / 1000; var purchase = await _context.Purchases .Include(m => m.PackSize) .Where(m => m.Id == damageProduct.PurchaseId).FirstOrDefaultAsync(); damageProduct.PackAmount = damageProduct.KGAmount / purchase.PackSize.TotalKilo; damageProduct.Status = 0; if (ModelState.IsValid) { _context.Add(damageProduct); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["PurchaseId"] = new SelectList(_context.Purchases.Where(m => m.Status == 1), "Id", "VoucharNo", damageProduct.PurchaseId); return(View(damageProduct)); }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { bool isNew = false; #region Stock if (_stock != null) { _stock.Quantity = _stock.Quantity - numQTY.Value; } if (_StockDetail != null) { _StockDetail.Status = (int)EnumStockDetailStatus.Damage; } //if (_oProduct.IsBarCode == 3) //{ // if (numStock.Value == 0) // { // _StockDetail.Status = (int)EnumStockDetailStatus.Sold; // } //} //else //{ // _StockDetail.Status = (int)EnumStockDetailStatus.Sold; //} #endregion if (_DamageProduct.DamageProID <= 0) { RefreshObject(); _DamageProduct.CreatedBy = Global.CurrentUser.UserID; _DamageProduct.CreateDate = DateTime.Now; _DamageProduct.SDetailID = _StockDetail.SDetailID; //_DamageProduct.DamageProID = db.DamageProducts.Count() > 0 ? db.DamageProducts.Max(obj => obj.DamageProID) + 1 : 1; db.DamageProducts.Add(_DamageProduct); isNew = true; } else { _DamageProduct = db.DamageProducts.FirstOrDefault(obj => obj.DamageProID == _DamageProduct.DamageProID); RefreshObject(); _DamageProduct.SDetailID = ctlProduct.SelectedID; _DamageProduct.ModifiedDate = (DateTime)DateTime.Today; _DamageProduct.ModifiedBy = (int)Global.CurrentUser.UserID; } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _DamageProduct = new DamageProduct(); RefreshValue(); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }