//protected void GridData_SelectedIndexChanged(object sender, EventArgs e) //{ // // Reservation ID, MaterialName,Quantity // //ReservedDate,Note,UserName, // //Paid,PaidAmount,ReservedStock, // //StockOnHand,MaterialID,StoreID // GridViewRow gv = GridData.SelectedRow; // int ReservedID = Convert.ToInt32(gv.Cells[1].Text.ToString()); // var resmaterial = db.ReservedMaterials.Where(x => x.ID == ReservedID).FirstOrDefault(); // //string name = gv.Cells[2].Text; // string name = resmaterial.MaterialInStock1.Material.MaterialName; // //decimal QTY = Convert.ToDecimal(gv.Cells[3].Text); // decimal QTY = Convert.ToDecimal(resmaterial.Quantity); // string ReservationNote = resmaterial.Note; // //string ReservationNote = gv.Cells[5].Text.ToString(); // decimal pai = Convert.ToDecimal(resmaterial.PaidAmount); // //decimal pai = 0; // if(gv.Cells[7].Text !=" ") // { // pai = Convert.ToDecimal(gv.Cells[8].Text); // } // //decimal reserved = Convert.ToDecimal(gv.Cells[9].Text); // decimal reserved = Convert.ToDecimal(resmaterial.MaterialInStock1.ReservedStock); // //decimal stock = Convert.ToDecimal(gv.Cells[10].Text); // decimal stock = Convert.ToDecimal(resmaterial.MaterialInStock1.StockOnHand); // //int materialid = Convert.ToInt32(gv.Cells[11].Text); // int materialid = Convert.ToInt32(resmaterial.MaterialInStock1.MaterialID); // //int storeid = Convert.ToInt32(gv.Cells[12].Text); // int storeid = Convert.ToInt32(resmaterial.MaterialInStock1.StoreID); // var item = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid ).FirstOrDefault(); // if (pai != 0) // { // decimal oldstock = Convert.ToDecimal(item.StockOnHand); // decimal newstock = oldstock + QTY; // item.StockOnHand = newstock; // LogSalesReservation(oldstock, newstock, item.ID, false); // } // item.ReservedStock = reserved - QTY; // db.SaveChanges(); // //var materilainstock = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid).FirstOrDefault(); // StockLogger st = new StockLogger(); // st.MaterialInStock = item.ID; // st.OldStock = stock; // if (pai != 0 ) // st.NewStock = stock + reserved; // else // st.NewStock = stock; // st.OldReservedStock = reserved; // st.NewReservedStock = reserved - QTY; // st.Notes = "Reservation Cancelled By " + User.Identity.Name; // db.StockLoggers.Add(st); // db.SaveChanges(); // //var resmaterial = db.ReservedMaterials.Where(x => x.MaterialInStock == item.ID && x.PaidAmount == pai && x.Quantity == QTY && x.Note == ReservationNote ).FirstOrDefault(); // resmaterial.IsDeleted = true; // db.SaveChanges(); // Logger log = new Logger(); // log.Action ="Reservation of " + name + " in Store " + storeid.ToString() + " with Quantity "+ QTY.ToString()+" is cancelled "; // log.ActionDate = DateTime.Now; // log.UserName = User.Identity.Name; // log.ActionType = "Cancel Reservation"; // db.Loggers.Add(log); // db.SaveChanges(); // GridData.DataBind(); //} protected void GridData_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow gv = GridData.SelectedRow; int ReservedID = Convert.ToInt32(gv.Cells[1].Text.ToString()); var ReservedMaterial = db.ReservedMaterials.Where(x => x.ID == ReservedID).FirstOrDefault(); string name = ReservedMaterial.MaterialInStock1.Material.MaterialName; decimal QTY = Convert.ToDecimal(ReservedMaterial.Quantity); string ReservationNote = ReservedMaterial.Note; decimal PaidAmount = Convert.ToDecimal(ReservedMaterial.PaidAmount); decimal TotalReserved = Convert.ToDecimal(ReservedMaterial.MaterialInStock1.ReservedStock); decimal stock = Convert.ToDecimal(ReservedMaterial.MaterialInStock1.StockOnHand); int materialid = Convert.ToInt32(ReservedMaterial.MaterialInStock1.MaterialID); int storeid = Convert.ToInt32(ReservedMaterial.MaterialInStock1.StoreID); var item = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid).FirstOrDefault(); if (PaidAmount != 0) { decimal oldstock = Convert.ToDecimal(item.StockOnHand); decimal newstock = oldstock + QTY; item.StockOnHand = newstock; LogSalesReservation(oldstock, newstock, item.ID, false); } item.ReservedStock = TotalReserved - QTY; db.SaveChanges(); StockLogger st = new StockLogger(); st.MaterialInStock = item.ID; st.OldStock = stock; if (PaidAmount != 0) { st.NewStock = stock + QTY; } else { st.NewStock = stock; } st.OldReservedStock = TotalReserved; st.NewReservedStock = TotalReserved - QTY; st.Notes = "Cancel Reservation of Material ( " + item.Material.MaterialName.ToString() + " ) In Store ( " + item.Store.StoreName.ToString() + " ) Cancelled By " + User.Identity.Name; db.StockLoggers.Add(st); db.SaveChanges(); ReservedMaterial.IsDeleted = true; db.SaveChanges(); Logger log = new Logger(); log.Action = "Cancel Reservation of Material ( " + item.Material.MaterialName.ToString() + " ) in Store ( " + item.Store.StoreName.ToString() + " ) with Quantity " + QTY.ToString() + " is cancelled "; log.ActionDate = DateTime.Now; log.UserName = User.Identity.Name; log.ActionType = "Cancel Reservation"; db.Loggers.Add(log); db.SaveChanges(); GridData.DataBind(); }
private void AddNewStock(int storeid, int materialid, decimal QTY) { try { var MS = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid).FirstOrDefault(); decimal oldstock, newstock; oldstock = Convert.ToDecimal(MS.StockOnHand); newstock = oldstock + QTY; MS.StockOnHand = newstock; db.SaveChanges(); Logger log = new Logger(); log.UserName = User.Identity.Name; log.Action = "Material " + MS.Material.MaterialName.ToString() + " Stock is now increased From " + oldstock.ToString() + " To " + newstock.ToString(); log.ActionType = "Item Addition"; log.ActionDate = DateTime.Now; db.Loggers.Add(log); db.SaveChanges(); StockLogger stLog = new StockLogger(); stLog.ActionDate = DateTime.Now; stLog.MaterialInStock = MS.ID; stLog.NewStock = newstock; stLog.OldStock = oldstock; stLog.UserName = User.Identity.Name; stLog.Notes = "Material " + MS.Material.MaterialName.ToString() + " stock increased in Container " + txtContainerNumber.Value.ToString(); db.StockLoggers.Add(stLog); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.MaterialID = materialid; MH.StoreID = storeid; MH.NewStock = newstock; MH.OldStock = oldstock; MH.TransactionName = "Addition"; MH.UserName = User.Identity.Name; MH.ActionDate = DateTime.Now; MH.Note = "Material " + MS.Material.MaterialName.ToString() + " stock increased in Container " + txtContainerNumber.Value.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); lblAddItemErr.Text = "Item Entered Successfully"; lblAddItemErr.Visible = true; lblAddItemErr.ForeColor = Color.Green; } catch (Exception ex) { lblAddItemErr.Text = "Error in new stock addition " + ex.InnerException.Message; lblAddItemErr.Visible = true; lblAddItemErr.ForeColor = Color.Green; } }
private void MaterialStock() { var MaterialID = Convert.ToInt32(txtMaterialID.Value); var MaterialStore = Convert.ToInt32(txtStore.Value); var MaterialStock = Convert.ToDecimal(txtCurrentStock.Value); var newstock = MaterialStock - Convert.ToDecimal(txtRequestedStock.Value); var item = db.MaterialInStocks.Where(x => x.MaterialID == MaterialID && x.StoreID == MaterialStore).FirstOrDefault(); item.StockOnHand -= Convert.ToDecimal(txtRequestedStock.Value); db.SaveChanges(); var ss = db.MaterialInStocks.Where(x => x.MaterialID == MaterialID && x.StoreID == MaterialStore).FirstOrDefault(); StockLogger stlog = new StockLogger(); stlog.MaterialInStock = ss.ID; stlog.OldStock = MaterialStock; stlog.ActionDate = DateTime.Now; stlog.UserName = User.Identity.Name; stlog.NewStock = MaterialStock - Convert.ToDecimal(txtRequestedStock.Value); stlog.Notes = "Order Number " + LblOrderID.Text.ToString() + " For Customer " + Customer.SelectedItem.ToString(); db.StockLoggers.Add(stlog); db.SaveChanges(); Logger log = new Logger(); log.Action = " Material Order (" + item.Material.MaterialName.ToString() + " ) , The Stock changed from " + MaterialStock.ToString() + " to " + newstock.ToString() + " For Customer " + Customer.SelectedItem.ToString(); log.ActionDate = DateTime.Now; log.ActionType = "Material Order"; log.UserName = User.Identity.Name; db.Loggers.Add(log); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = MaterialID; MH.StoreID = MaterialStore; MH.TransactionName = "Sales Material"; MH.UserName = User.Identity.Name; MH.NewStock = newstock; MH.OldStock = MaterialStock; MH.Note = "Material " + item.Material.MaterialName.ToString() + " is now invoiced in Store " + MaterialStore.ToString() + " In order ID " + LblOrderID.Text.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); }
private void MaterialReturn(int materialid, string name, int orderid, decimal QTY, decimal height, decimal width, string store) { var st = db.Stores.Where(x => x.StoreName == store).FirstOrDefault(); int storeid = st.ID; var mat = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid).FirstOrDefault(); if (mat != null) { decimal oldstock = decimal.Parse(mat.StockOnHand.ToString()); decimal newstock = oldstock + QTY; mat.StockOnHand = newstock; db.SaveChanges(); StockLogger stlog = new StockLogger(); stlog.ActionDate = DateTime.Now; stlog.UserName = User.Identity.Name; stlog.MaterialInStock = mat.ID; stlog.NewStock = newstock; stlog.OldStock = oldstock; stlog.Notes = "Return of Good Material ( " + name + " ) In store ( " + store + " ) from Order ( " + orderid + " )"; db.StockLoggers.Add(stlog); db.SaveChanges(); Logger log = new Logger(); log.ActionType = "Material Return"; log.ActionDate = DateTime.Now; log.UserName = User.Identity.Name; log.Action = "Return of Good List of Material ( " + name + " ) In store ( " + store + " ) from Order ( " + orderid + " )"; db.Loggers.Add(log); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = materialid; MH.StoreID = storeid; MH.TransactionName = "Return Material"; MH.UserName = User.Identity.Name; MH.NewStock = newstock; MH.OldStock = oldstock; MH.Note = "Material ( " + name + " ) is now returned in Store ( " + storeid.ToString() + " ) From order ( " + orderid + " ) "; db.MaterialHistories.Add(MH); db.SaveChanges(); } }
private void LogAction(decimal?oldstock, decimal?oldreserved, decimal?newstock, decimal?newreserved, int materialinstock) { try { StockLogger st = new StockLogger(); st.MaterialInStock = materialinstock; st.OldStock = oldstock; st.NewStock = newstock; st.OldReservedStock = oldreserved; st.NewReservedStock = newreserved; st.UserName = User.Identity.Name; st.Notes = txtNotes.Value; db.StockLoggers.Add(st); db.SaveChanges(); } catch (Exception ex) { lblError.Text = "Error in Stock Log " + ex.InnerException.InnerException.Message; lblError.ForeColor = Color.Red; lblError.Visible = true; } }
protected void btnUpdateMaterial_Click(object sender, EventArgs e) { var materialid = Convert.ToInt32(dsMaterials.SelectedValue); var storeid = Convert.ToInt32(dsStores.SelectedValue); var Ms = db.MaterialInStocks.Where(x => x.MaterialID == materialid && x.StoreID == storeid).FirstOrDefault(); decimal OldStock = Convert.ToDecimal(Ms.StockOnHand.ToString()); var oldsafetystock = Ms.SafetyStock.ToString(); var oldreserved = Ms.ReservedStock.ToString(); decimal newstock = Convert.ToDecimal(txtstock.Value); string oldname = Ms.Material.MaterialName.ToString(); string newname = itemname.Value.ToString(); int oldtype = Convert.ToInt32(Ms.Material.TypeID); string oldtypename = Ms.Material.SubCategory.SubCategoryName.ToString(); int newtype = Convert.ToInt32(materialcategory.SelectedValue); try { Ms.ReservedStock = Convert.ToDecimal(txtReservedStock.Value); Ms.StockOnHand = Convert.ToDecimal(txtstock.Value); Ms.SafetyStock = Convert.ToDecimal(SafetyStock.Value); if (oldname != newname) { Ms.Material.MaterialName = newname; } if (oldtype != newtype) { Ms.Material.TypeID = newtype; } db.SaveChanges(); dsMaterials.DataBind(); lblError.Text = "The Material Data Updated Successfully"; lblError.Visible = true; lblError.ForeColor = System.Drawing.Color.Green; StockLogger stLog = new StockLogger(); stLog.OldStock = OldStock; stLog.NewStock = Convert.ToDecimal(txtstock.Value); stLog.OldSafetyStock = Convert.ToDecimal(oldsafetystock); stLog.newSafetyStock = Convert.ToDecimal(SafetyStock.Value); stLog.OldReservedStock = Convert.ToDecimal(oldreserved); stLog.NewReservedStock = Convert.ToDecimal(txtReservedStock.Value); stLog.UserName = User.Identity.Name; stLog.ActionDate = DateTime.Now; stLog.MaterialInStock = Ms.ID; db.StockLoggers.Add(stLog); db.SaveChanges(); Logger Log = new Logger(); Log.ActionType = "Update Material"; string Action = "Material ( " + Ms.Material.MaterialName + " ) Stock in Store ( " + Ms.Store.StoreName + " ) is ( " + txtstock.Value.ToString() + " ) And Safety Stock is ( " + SafetyStock.Value.ToString() + " ) "; if (oldname == newname) { Log.Action = Action; } else { Log.Action = Action + " and Material Name Changed From ( '" + oldname + "' ) To ( '" + newname + "' ) "; } if (oldtype != newtype) { Log.Action += " and Category changed from ( '" + oldtypename + "' ) To ('" + materialcategory.SelectedItem.ToString() + "') )"; } Log.UserName = User.Identity.Name; Log.ActionDate = DateTime.Now; db.Loggers.Add(Log); db.SaveChanges(); if (OldStock != newstock) { MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = materialid; MH.StoreID = storeid; MH.TransactionName = "Update Stock"; MH.UserName = User.Identity.Name; MH.NewStock = Convert.ToDecimal(txtstock.Value); MH.OldStock = Convert.ToDecimal(OldStock); MH.Note = "Material ( " + Ms.Material.MaterialName + " ) Stock is now updated in Store " + Ms.Store.StoreName.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); } } catch (Exception ex) { lblError.Text = "Error in Update Material Data " + ex.Message; lblError.Visible = true; lblError.ForeColor = System.Drawing.Color.Red; } }
private void MaterialStock() { var MaterialID = Convert.ToInt32(txtMaterialID.Value); var StoreFrom = Convert.ToInt32(FromStore.SelectedValue); var MaterialStock = Convert.ToDecimal(txtCurrentStock.Value); var store2 = Convert.ToInt32(ToStore.SelectedValue); //Update Current Stock Of From Store var item = db.MaterialInStocks.Where(x => x.MaterialID == MaterialID && x.StoreID == StoreFrom).FirstOrDefault(); var stock1 = item.StockOnHand; var newstock1 = item.StockOnHand - Convert.ToDecimal(txtRequestedStock.Value); item.StockOnHand -= Convert.ToDecimal(txtRequestedStock.Value); db.SaveChanges(); StockLogger stlog = new StockLogger(); stlog.MaterialInStock = item.ID; stlog.OldStock = stock1; stlog.NewStock = newstock1; stlog.UserName = User.Identity.Name; stlog.ActionDate = DateTime.Now; stlog.Notes = "Transfer Number " + LblTransferID.Text.ToString() + " From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; db.StockLoggers.Add(stlog); Logger log2 = new Logger(); log2.Action = "Transfer Number ( " + LblTransferID.Text + " ) of Material (" + item.Material.MaterialName.ToString() + " ) , The Stock changed from ( " + stock1.ToString() + " ) to ( " + newstock1.ToString() + " ) From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; log2.ActionDate = DateTime.Now; log2.ActionType = "Material Transfer"; log2.UserName = User.Identity.Name; db.Loggers.Add(log2); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.MaterialID = MaterialID; MH.StoreID = Convert.ToInt32(FromStore.SelectedValue); MH.OldStock = stock1; MH.NewStock = newstock1; MH.ActionDate = DateTime.Now; MH.UserName = User.Identity.Name; MH.Note = " Material Transfer No ( " + LblTransferID.Text.ToString() + " ) From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; MH.TransactionName = "Material Transfer"; db.MaterialHistories.Add(MH); db.SaveChanges(); //To Store Actions var itemstore2 = db.MaterialInStocks.Where(x => x.MaterialID == MaterialID && x.StoreID == store2).FirstOrDefault(); var storestock = itemstore2.StockOnHand; var storestock2 = storestock + Convert.ToDecimal(txtRequestedStock.Value); itemstore2.StockOnHand = storestock2; db.SaveChanges(); //stockLogger StockLogger stlog2 = new StockLogger(); stlog2.MaterialInStock = itemstore2.ID; stlog2.OldStock = storestock; stlog2.NewStock = storestock2; stlog2.UserName = User.Identity.Name; stlog2.ActionDate = DateTime.Now; stlog2.Notes = "Transfer Number " + LblTransferID.Text.ToString() + " From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; db.StockLoggers.Add(stlog2); db.SaveChanges(); //Insert Logger Logger log = new Logger(); log.Action = "Transfer Number ( " + LblTransferID.Text + " ) of Material (" + item.Material.MaterialName.ToString() + " ) , The Stock changed from " + storestock.ToString() + " to " + storestock2.ToString() + " From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; log.ActionDate = DateTime.Now; log.ActionType = "Material Transfer"; log.UserName = User.Identity.Name; db.Loggers.Add(log); db.SaveChanges(); MaterialHistory MH2 = new MaterialHistory(); MH2.MaterialID = MaterialID; MH2.StoreID = Convert.ToInt32(ToStore.SelectedValue); MH2.OldStock = storestock; MH2.NewStock = storestock2; MH2.ActionDate = DateTime.Now; MH2.UserName = User.Identity.Name; MH2.Note = " Material Transfer No ( " + LblTransferID.Text.ToString() + " ) From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; MH2.TransactionName = "Material Transfer"; db.MaterialHistories.Add(MH2); db.SaveChanges(); }