internal int UpdateProdWashing(Prod_Washing _objProdWashing) { try { Prod_Washing obj = _Context.Prod_Washing.FirstOrDefault(x => x.ID == _objProdWashing.ID); obj.OrderNo = _objProdWashing.OrderNo; obj.OrderQty = _objProdWashing.OrderQty; obj.GoodsName = _objProdWashing.GoodsName; obj.FGoodsQty = _objProdWashing.FGoodsQty; obj.FGoodsUnit = _objProdWashing.FGoodsUnit; obj.TotalSewingCompleteQty = _objProdWashing.TotalSewingCompleteQty; obj.TotalSewingCompleteUnit = _objProdWashing.TotalSewingCompleteUnit; obj.TotalWashingReceivedDate = _objProdWashing.TotalWashingReceivedDate; obj.TotalWashingReceivedQty = _objProdWashing.TotalWashingReceivedQty; obj.TotalWashingReceivedUnit = _objProdWashing.TotalWashingReceivedUnit; obj.TotalWashingCompleteDate = _objProdWashing.TotalWashingCompleteDate; obj.TotalWashingCompleteQty = _objProdWashing.TotalWashingCompleteQty; obj.TotalWashingCompleteUnit = _objProdWashing.TotalWashingCompleteUnit; obj.Edit_User = _objProdWashing.Edit_User; obj.Edit_Date = _objProdWashing.Edit_Date; _Context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
internal Prod_Washing GetWashinggbyId(int wID) { Prod_Washing was = (from ws in _Context.Prod_Washing where ws.ID == wID select ws).FirstOrDefault(); return(was); }
internal int InsertProdWashing(Prod_Washing _objProdWashing) { try { _Context.Prod_Washing.AddObject(_objProdWashing); _Context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void imgbtnWashingDetails_Click(object sender, ImageClickEventArgs e) { try { ImageButton imgbtn = (ImageButton)sender; GridViewRow row = (GridViewRow)imgbtn.NamingContainer; Label lblId = (Label)grdWashingDetails.Rows[row.RowIndex].FindControl("lblId"); int wID = Convert.ToInt16(lblId.Text); Prod_Washing _ID = _washingbll.GetWashinggbyId(wID); if (_ID != null) { txthidID.Value = _ID.ID.ToString(); txthidCuttingID.Value = _ID.CuttingID.ToString(); txthidSewingID.Value = _ID.SewingID.ToString(); txthidBuyer.Value = _ID.BuyerID.ToString(); txtOrderNoFill.Text = _ID.OrderNo.ToString(); txtOderQty.Text = _ID.OrderQty.ToString(); txtFinishGoods.Text = _ID.GoodsName.ToString(); txtFinishGoodsQty.Text = _ID.FGoodsQty.ToString(); txtFinishGoodsUnits.Text = _ID.FGoodsUnit.ToString(); txtSewingCompleteQty.Text = _ID.TotalSewingCompleteQty.ToString(); txtSewingCompleteUnit.Text = _ID.TotalSewingCompleteUnit.ToString(); txtWashingReceivedDate.Text = _ID.TotalWashingReceivedDate.ToString(); txtWashingReceivedQty.Text = _ID.TotalWashingReceivedQty.ToString(); ddlWashingUnit.Text = _ID.TotalWashingReceivedUnit.ToString(); txtWashingCompleteDate.Text = _ID.TotalWashingCompleteDate.ToString(); txtCCompleteWashingQty.Text = _ID.TotalWashingCompleteQty.ToString(); //ddlTUnits.Text = _ID.TotalWashingCompleteUnit.ToString(); btnSubmit.Text = "Update"; divCCDShow.Visible = true; divCCQShow.Visible = true; txtWashingReceivedDate.Enabled = false; txtWashingReceivedQty.ReadOnly = true; ddlWashingUnit.Enabled = false; } FillTotalunit(); } catch (Exception ex) { throw ex; } }
internal int UpdateProdWashing(Prod_Washing _objProdWashing) { return(_washingdal.UpdateProdWashing(_objProdWashing)); }
internal int InsertProdWashing(Prod_Washing _objProdWashing) { return(_washingdal.InsertProdWashing(_objProdWashing)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Prod_Washing _objProdWashing = new Prod_Washing(); _objProdWashing.CuttingID = Convert.ToInt32(txthidCuttingID.Value); _objProdWashing.SewingID = Convert.ToInt32(txthidSewingID.Value); _objProdWashing.OrderNo = txtOrderNoFill.Text; _objProdWashing.BuyerID = Convert.ToInt32(txthidBuyer.Value); _objProdWashing.OrderQty = Convert.ToDouble(txtOderQty.Text); _objProdWashing.GoodsName = txtFinishGoods.Text; _objProdWashing.FGoodsQty = Convert.ToDouble(txtFinishGoodsQty.Text); _objProdWashing.FGoodsUnit = txtFinishGoodsUnits.Text; _objProdWashing.TotalSewingCompleteQty = Convert.ToDouble(txtSewingCompleteQty.Text); _objProdWashing.TotalSewingCompleteUnit = Convert.ToInt32(txtSewingCompleteUnit.Text); _objProdWashing.TotalWashingReceivedDate = Convert.ToDateTime(txtWashingReceivedDate.Text); _objProdWashing.TotalWashingReceivedQty = Convert.ToDouble(txtWashingReceivedQty.Text); _objProdWashing.TotalWashingReceivedUnit = Convert.ToInt32(ddlWashingUnit.SelectedValue.ToString()); if (divCCDShow.Visible == true) { _objProdWashing.TotalWashingCompleteDate = Convert.ToDateTime(txtWashingCompleteDate.Text); } if (divCCQShow.Visible == true) { _objProdWashing.TotalWashingCompleteQty = Convert.ToDouble(txtCCompleteWashingQty.Text); _objProdWashing.TotalWashingCompleteUnit = Convert.ToInt32(ddlTUnits.SelectedValue.ToString()); } _objProdWashing.Create_Date = DateTime.Now; _objProdWashing.Create_User = ((SessionUser)Session["SessionUser"]).UserId; _objProdWashing.OCode = ((SessionUser)Session["SessionUser"]).OCode; if (btnSubmit.Text == "Submit") { int result = _washingbll.InsertProdWashing(_objProdWashing); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } else { _objProdWashing.Edit_Date = DateTime.Now; _objProdWashing.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; _objProdWashing.ID = Convert.ToInt16(txthidID.Value); int result = _washingbll.UpdateProdWashing(_objProdWashing); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); btnSubmit.Text = "Submit"; } } ClearUi(); LoadWashingDetails(); } catch (Exception ex) { throw ex; } }