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