private void LogSalesReservation(decimal?oldstock, decimal?newstock, int iD, bool reserve) { try { var material = db.MaterialInStocks.Where(x => x.ID == iD).FirstOrDefault(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = material.MaterialID; MH.StoreID = material.StoreID; MH.OldStock = oldstock; MH.NewStock = newstock; if (reserve) { MH.Note = " Sales Reservation Of Material ( " + material.Material.MaterialName.ToString() + " ) in Store ( " + material.Store.StoreName.ToString() + " ) By " + User.Identity.Name.ToString(); MH.TransactionName = "Sales Reservation"; } else { MH.Note = " Sales Reservation of Material ( " + material.Material.MaterialName.ToString() + " ) in Store ( " + material.Store.StoreName.ToString() + " ) Cancelled By " + User.Identity.Name.ToString(); MH.TransactionName = "Cancel Reservation"; } MH.UserName = User.Identity.Name.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); } catch (Exception ex) { lblError.Text = "Error in Log History of Reservation , Error is " + ex.InnerException.Message; lblError.Visible = true; lblError.ForeColor = System.Drawing.Color.Red; } }
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 DeadMaterialStock() { var MaterialID = Convert.ToInt32(txtMaterialID.Value); var MaterialStore = Convert.ToInt32(txtStore.Value); var Materialheight = Convert.ToDecimal(txtitemHieght.Value); var MaterialWidth = Convert.ToDecimal(txtItemWidth.Value); var MaterialNotes = txtItemNotes.Value.ToString(); var MaterialStock = Convert.ToDecimal(txtCurrentStock.Value); var newstock = MaterialStock - Convert.ToDecimal(txtRequestedStock.Value); var item = db.DeadMaterials.Where(x => x.MaterialID == MaterialID && x.StoreID == MaterialStore && x.Height == Materialheight && x.Width == MaterialWidth && x.Notes == MaterialNotes.ToString()).FirstOrDefault(); item.Quantity = item.Quantity - Convert.ToDecimal(txtRequestedStock.Value); db.SaveChanges(); Logger log = new Logger(); log.Action = "Dead Material (" + item.Material.MaterialName.ToString() + " ) , The Stock changed from " + MaterialStock.ToString() + " to " + newstock.ToString(); log.ActionDate = DateTime.Now; log.ActionType = "DeadMaterial 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 DeadList"; MH.UserName = User.Identity.Name; MH.NewStock = newstock; MH.OldStock = MaterialStock; MH.Note = "DeadMaterial " + item.Material.MaterialName.ToString() + " is now invoiced in Store " + MaterialStore.ToString() + "With Height " + Materialheight.ToString() + " and Width " + MaterialWidth.ToString() + " In Order ID " + LblOrderID.Text.ToString() + " In Order ID " + LblOrderID.Text.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); }
private void AddHistory(int materialID, int storeID, decimal newstock, Material m) { try { MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = materialID; MH.StoreID = storeID; MH.TransactionName = "Initial Stock"; MH.UserName = User.Identity.Name; MH.NewStock = newstock; MH.OldStock = 0; MH.Note = "Material " + m.MaterialName + " is now created in Store " + storeID.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); } catch (Exception ex) { LblAddItemToStore.Text = ex.InnerException.InnerException.Message; LblAddItemToStore.Visible = true; LblAddItemToStore.ForeColor = System.Drawing.Color.Red; } }
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 AddNewDeadMaterial() { decimal QTY; decimal Height; decimal Width; DeadMaterial DM = new DeadMaterial(); DM.StoreID = Convert.ToInt32(SelectStores.SelectedValue); DM.MaterialID = Convert.ToInt32(selectitem.SelectedValue); DM.Notes = DeadNote.Value; //Get Quantity Value if (Quantity.Value == "") { QTY = 0; } else { QTY = Convert.ToDecimal(Quantity.Value); } DM.Quantity = QTY; //Get Height Value if (Sheight.Value == "") { Height = 0; } else { Height = Convert.ToDecimal(Sheight.Value); } DM.Height = Height; //Get Width Value if (SWidth.Value == "") { Width = 0; } else { Width = Convert.ToDecimal(SWidth.Value); } DM.Width = Width; DM.UnitID = Convert.ToInt32(itemunit.SelectedValue); DM.UserName = User.Identity.Name.ToString(); DM.ActionDate = DateTime.Now; DM.IsActive = true; db.DeadMaterials.Add(DM); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.UserName = User.Identity.Name; MH.TransactionName = "New DeadMaterial"; MH.OldStock = 0; MH.NewStock = Convert.ToDecimal(Quantity.Value); MH.Note = "New Dead Material With Height " + Height.ToString() + " And Width " + Width.ToString(); MH.MaterialID = Convert.ToInt32(selectitem.SelectedValue); MH.StoreID = Convert.ToInt32(SelectStores.SelectedValue); db.MaterialHistories.Add(MH); db.SaveChanges(); Logger log = new Logger(); log.UserName = User.Identity.Name; log.Action = @"New Dead Material of ( " + selectitem.SelectedItem.ToString() + " ) is added successfully to " + "store( " + SelectStores.SelectedItem.ToString() + " ) With Height " + Sheight.Value.ToString() + " and Width " + SWidth.Value.ToString(); log.ActionType = "New DeadMaterial"; log.ActionDate = DateTime.Now; db.Loggers.Add(log); db.SaveChanges(); LblError.Text = "New Dead Material is added Successfully"; LblError.Visible = true; LblError.ForeColor = System.Drawing.Color.Green; Quantity.Value = ""; Sheight.Value = ""; SWidth.Value = ""; DeadNote.Value = ""; //selectitem.SelectedIndex = 0; //SelectStores.SelectedIndex = 0; //itemunit.SelectedIndex = 0; }
private void CuttingItemStock() { var MaterialID = Convert.ToInt32(txtMaterialID.Value); var MaterialStore = Convert.ToInt32(FromStore.SelectedValue); var Materialheight = Convert.ToDecimal(txtitemHieght.Value); var MaterialWidth = Convert.ToDecimal(txtItemWidth.Value); var MaterialNotes = txtItemNotes.Value.ToString(); var MaterialStock = Convert.ToDecimal(txtCurrentStock.Value); var storeto = Convert.ToInt32(ToStore.SelectedValue); var newstock = MaterialStock - Convert.ToDecimal(txtRequestedStock.Value); var fromitem = db.CuttingListsMaterials.Where(x => x.MaterialID == MaterialID && x.StoreID == MaterialStore && x.Height == Materialheight && x.Width == MaterialWidth && x.Notes == MaterialNotes.ToString()).FirstOrDefault(); var toitem = db.CuttingListsMaterials.Where(x => x.MaterialID == MaterialID && x.StoreID == storeto && x.Height == Materialheight && x.Width == MaterialWidth && x.Notes == MaterialNotes.ToString()).FirstOrDefault(); if (fromitem != null) { fromitem.Quantity -= Convert.ToDecimal(txtRequestedStock.Value); db.SaveChanges(); } CuttingListsMaterial CS = new CuttingListsMaterial(); CS.StoreID = Convert.ToInt32(ToStore.SelectedValue); CS.MaterialID = MaterialID; CS.Height = Materialheight; CS.Width = MaterialWidth; CS.Quantity = Convert.ToDecimal(txtRequestedStock.Value); CS.UserName = User.Identity.Name; CS.ActionDate = DateTime.Now; CS.Notes = "Transferred From Store " + MaterialStore.ToString() + " At " + DateTime.Now.ToString() + " Transfer Number " + LblTransferID.Text; CS.IsActive = true; db.CuttingListsMaterials.Add(CS); db.SaveChanges(); Logger log = new Logger(); log.Action = "Transfer Number ( " + LblTransferID.Text + " ) CuttingList Material (" + fromitem.Material.MaterialName.ToString() + " ) , " + "The Stock changed from " + MaterialStock.ToString() + " to " + newstock.ToString() + " From Store ( " + FromStore.SelectedItem.ToString() + " ) To Store ( " + ToStore.SelectedItem.ToString() + " )"; log.ActionDate = DateTime.Now; log.ActionType = "CuttingList Transfer"; log.UserName = User.Identity.Name; db.Loggers.Add(log); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.MaterialID = MaterialID; MH.StoreID = MaterialStore; MH.OldStock = MaterialStock; MH.NewStock = newstock; MH.ActionDate = DateTime.Now; MH.UserName = User.Identity.Name; MH.Note = " Cutting List Transfer No " + LblTransferID.Text.ToString() + " With Height " + Materialheight.ToString() + " and Width " + MaterialWidth.ToString(); MH.TransactionName = "CuttingList Transfer"; db.MaterialHistories.Add(MH); db.SaveChanges(); MaterialHistory MH2 = new MaterialHistory(); MH2.MaterialID = MaterialID; MH2.StoreID = Convert.ToInt32(ToStore.SelectedValue); MH2.OldStock = 0; MH2.NewStock = Convert.ToDecimal(txtRequestedStock.Value); MH2.ActionDate = DateTime.Now; MH2.UserName = User.Identity.Name; MH2.Note = " Cutting List Transfer No " + LblTransferID.Text.ToString() + " With Height " + Materialheight.ToString() + " and Width " + MaterialWidth.ToString(); MH2.TransactionName = "CuttingList Transfer"; db.MaterialHistories.Add(MH2); db.SaveChanges(); }
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(); }
private void CuttingItemReturn(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; decimal oldstock, newstock; var custlist = db.CuttingListsMaterials.Where(x => x.MaterialID == materialid && x.StoreID == storeid && x.Height == height && x.Width == width).FirstOrDefault(); if (custlist != null) { oldstock = Convert.ToDecimal(custlist.Quantity); newstock = oldstock + QTY; custlist.Quantity = newstock; db.SaveChanges(); Logger log = new Logger(); log.Action = "Return of Cutting List of Material ( " + name + " ) In store ( " + store + " ) from Order ( " + orderid + " )"; log.ActionDate = DateTime.Now; log.UserName = User.Identity.Name; log.ActionType = "CuttingList Return"; db.Loggers.Add(log); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = materialid; MH.StoreID = storeid; MH.TransactionName = "Return CuttingList"; MH.UserName = User.Identity.Name; MH.NewStock = newstock; MH.OldStock = oldstock; MH.Note = "CuttingListMaterial ( " + name + " ) is now returned in Store ( " + storeid.ToString() + " ) From order ( " + orderid + " ) With Height " + height.ToString() + " and Width " + width.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); } else { CuttingListsMaterial cs = new CuttingListsMaterial(); cs.Quantity = QTY; cs.StoreID = storeid; cs.MaterialID = materialid; cs.IsActive = true; cs.Height = height; cs.Width = width; cs.UserName = User.Identity.Name; cs.Notes = "Return of Cutting List of Material ( " + name + " ) In store ( " + store + " ) from Order ( " + orderid + " )"; cs.ActionDate = DateTime.Now; db.CuttingListsMaterials.Add(cs); db.SaveChanges(); MaterialHistory MH = new MaterialHistory(); MH.ActionDate = DateTime.Now; MH.MaterialID = materialid; MH.StoreID = storeid; MH.TransactionName = "Return CuttingList"; MH.UserName = User.Identity.Name; MH.NewStock = Convert.ToDecimal(QTY); MH.OldStock = 0; MH.Note = "CuttingListMaterial ( " + name + " ) is now returned in Store ( " + storeid.ToString() + " ) From order ( " + orderid + " ) With Height " + height.ToString() + " and Width " + width.ToString(); db.MaterialHistories.Add(MH); db.SaveChanges(); } }