protected void GridCuttingReservation_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow gv = GridCuttingReservation.SelectedRow; int ReservedID = Convert.ToInt32(gv.Cells[1].Text.ToString()); var ReservedMaterial = db.ReservedCuttingMaterials.Where(x => x.ID == ReservedID).FirstOrDefault(); decimal QTY = Convert.ToDecimal(ReservedMaterial.Quantity); string ReservationNote = ReservedMaterial.Note; decimal PaidAmount = Convert.ToDecimal(ReservedMaterial.PaidAmount); int cuttingListID = Convert.ToInt32(ReservedMaterial.CuttingMaterialID); ReservedMaterial.IsDeleted = true; var CMaterial = db.CuttingListsMaterials.Where(x => x.ID == cuttingListID).FirstOrDefault(); CMaterial.ReservedQTY -= QTY; CMaterial.IsActive = true; if (PaidAmount != 0) { CMaterial.Quantity += QTY; } Logger log = new Logger(); log.Action = "Cancel Reservation of CuttingList Material ( " + CMaterial.Material.MaterialName.ToString() + " ) in Store ( " + CMaterial.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(); GridCuttingReservation.DataBind(); GridCuttingReservation.Visible = true; GridMaterial.DataBind(); GridMaterial.Visible = true; }
protected void ButtonConfirmar_Click(object sender, EventArgs e) { TextBoxCaracteristicas.Text = ""; TextBoxNumSerie.Text = ""; MostrarTablaMateriales(); GridMaterial.DataBind(); }
private void GetMaterials() { MaterialBusiness MB = new MaterialBusiness(); List <WorkShopMaterial> Ls = MB.GetMaterials(); GridMaterial.DataSource = Ls; GridMaterial.DataBind(); }
//protected void btnGetMaterialData_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(); // //itemname.Value = Ms.Material.MaterialName; // //txtstock.Value = Ms.StockOnHand.ToString(); // //txtReservedStock.Value = ""; // //SafetyStock.Value = Ms.SafetyStock.ToString(); // //materialimg.Src = Ms.Material.imagepath; // //pnlMaterialData.Visible = true; // pnlAvailableMaterial.Visible = true; // GridMaterial.DataBind(); //} protected void btnReserveStock_Click(object sender, EventArgs e) { var mt = Convert.ToInt32(dsMaterials.SelectedValue); var s = Convert.ToInt16(dsStores.SelectedValue); if (txtNotes.Value == "") { lblError.Text = "Please insert your Notes"; Page.ClientScript.RegisterStartupScript(this.GetType(), "EnterText", "SetNoteError();", true); lblError.ForeColor = Color.Red; lblError.Visible = true; pnlMaterialData.Visible = true; } else { if (txtReservedStock.Value == "") { lblError.Text = "Please Quantity you want to Reserve"; lblError.ForeColor = Color.Red; lblError.Visible = true; pnlMaterialData.Visible = true; Page.ClientScript.RegisterStartupScript(this.GetType(), "EnterText", "SetQuantityError();", true); } else { decimal stock = Convert.ToDecimal(txtstock.Value.ToString()); decimal reserved = Convert.ToDecimal(txtReservedStock.Value); var material = db.MaterialInStocks.Where(x => x.MaterialID == mt && x.StoreID == s).FirstOrDefault(); if (stock < reserved) { lblError.ForeColor = Color.Red; lblError.Text = " The Stock < The Requested Quantity"; lblError.Visible = true; pnlMaterialData.Visible = true; Page.ClientScript.RegisterStartupScript(this.GetType(), "EnterText", "SetQuantityError();", true); Page.ClientScript.RegisterStartupScript(this.GetType(), "EnterText", "SetStockError();", true); } else { if (itemtype.Value.ToLower() == "material") { ReserveStock(); } else if (itemtype.Value.ToLower() == "cuttinglist") { ReserveCuttingList(); } pnlMaterialData.Visible = false; GridMaterial.DataBind(); } } } }
protected void dsMaterials_SelectedIndexChanged(object sender, EventArgs e) { pnlAvailableMaterial.Visible = true; GridMaterial.DataBind(); }