internal int UpdateProdCutting(Prod_Sewing _objProdSewing) { try { Prod_Sewing obj = _Context.Prod_Sewing.FirstOrDefault(x => x.ID == _objProdSewing.ID); obj.OrderNo = _objProdSewing.OrderNo; obj.OrderQty = _objProdSewing.OrderQty; obj.GoodsName = _objProdSewing.GoodsName; obj.FGoodsQty = _objProdSewing.FGoodsQty; obj.FGoodsUnit = _objProdSewing.FGoodsUnit; //obj.CuttingCompleteDate = _objProdSewing.CuttingCompleteDate; obj.TotalCuttingCompleteQty = _objProdSewing.TotalCuttingCompleteQty; obj.TotalCuttingCompleteUnit = _objProdSewing.TotalCuttingCompleteUnit; obj.SewingReceivedDate = _objProdSewing.SewingReceivedDate; obj.TotalSewingReceivedQty = _objProdSewing.TotalSewingReceivedQty; obj.TotalSewingReceivedUnit = _objProdSewing.TotalSewingReceivedUnit; obj.SewingCompleteDate = _objProdSewing.SewingCompleteDate; obj.TotalSewingCompleteQty = _objProdSewing.TotalSewingCompleteQty; obj.TotalSewingCompleteUnit = _objProdSewing.TotalSewingCompleteUnit; obj.Edit_User = _objProdSewing.Edit_User; obj.Edit_Date = _objProdSewing.Edit_Date; _Context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
internal Prod_Sewing GetCuttingbyId(int sID) { Prod_Sewing sew = (from ps in _Context.Prod_Sewing where ps.ID == sID select ps).FirstOrDefault(); return(sew); }
internal int InsertProdSewing(Prod_Sewing _objProdSewing) { try { _Context.Prod_Sewing.AddObject(_objProdSewing); _Context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
protected void imgbtnSewingDetails_Click(object sender, ImageClickEventArgs e) { try { ImageButton imgbtn = (ImageButton)sender; GridViewRow row = (GridViewRow)imgbtn.NamingContainer; Label lblId = (Label)grdSewingDetails.Rows[row.RowIndex].FindControl("lblId"); int sID = Convert.ToInt16(lblId.Text); Prod_Sewing _ID = _sewingbll.GetCuttingbyId(sID); if (_ID != null) { txthidID.Value = _ID.ID.ToString(); txthidCuttingID.Value = _ID.CuttingID.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(); txtReceivedQty.Text = _ID.TotalCuttingCompleteQty.ToString(); txtReceivedUnit.Text = _ID.TotalCuttingCompleteUnit.ToString(); txtSewingReceivedDate.Text = _ID.SewingReceivedDate.ToString(); txtSewingReceivedQty.Text = _ID.TotalSewingReceivedQty.ToString(); ddlSewingUnit.Text = _ID.TotalSewingReceivedUnit.ToString(); txtSewingCompleteDate.Text = _ID.SewingCompleteDate.ToString(); txtCCompleteSewingQty.Text = _ID.TotalSewingCompleteQty.ToString(); //ddlTUnits.Text = _ID.TotalSewingCompleteUnit.ToString(); btnSubmit.Text = "Update"; divCCDShow.Visible = true; divCCQShow.Visible = true; } FillTotalunit(); } catch (Exception ex) { throw ex; } }
internal int UpdateProdCutting(Prod_Sewing _objProdSewing) { return(_sewingdal.UpdateProdCutting(_objProdSewing)); }
internal int InsertProdSewing(Prod_Sewing _objProdSewing) { return(_sewingdal.InsertProdSewing(_objProdSewing)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Prod_Sewing _objProdSewing = new Prod_Sewing(); _objProdSewing.CuttingID = Convert.ToInt32(txthidCuttingID.Value); _objProdSewing.OrderNo = txtOrderNoFill.Text; _objProdSewing.BuyerID = Convert.ToInt32(txthidBuyer.Value); _objProdSewing.OrderQty = Convert.ToDouble(txtOderQty.Text); _objProdSewing.GoodsName = txtFinishGoods.Text; _objProdSewing.FGoodsQty = Convert.ToDouble(txtFinishGoodsQty.Text); _objProdSewing.FGoodsUnit = txtFinishGoodsUnits.Text; _objProdSewing.TotalCuttingCompleteQty = Convert.ToDouble(txtReceivedQty.Text); _objProdSewing.TotalCuttingCompleteUnit = txtReceivedUnit.Text; _objProdSewing.SewingReceivedDate = Convert.ToDateTime(txtSewingReceivedDate.Text); _objProdSewing.TotalSewingReceivedQty = Convert.ToDouble(txtSewingReceivedQty.Text); _objProdSewing.TotalSewingReceivedUnit = Convert.ToInt32(ddlSewingUnit.SelectedValue.ToString()); if (divCCDShow.Visible == true) { _objProdSewing.SewingCompleteDate = Convert.ToDateTime(txtSewingReceivedDate.Text); } if (divCCQShow.Visible == true) { _objProdSewing.TotalSewingCompleteQty = Convert.ToDouble(txtCCompleteSewingQty.Text); _objProdSewing.TotalSewingCompleteUnit = Convert.ToInt32(ddlTUnits.SelectedValue.ToString()); } _objProdSewing.Create_Date = DateTime.Now; _objProdSewing.Create_User = ((SessionUser)Session["SessionUser"]).UserId; _objProdSewing.OCode = ((SessionUser)Session["SessionUser"]).OCode; if (btnSubmit.Text == "Submit") { int result = _sewingbll.InsertProdSewing(_objProdSewing); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } else { _objProdSewing.Edit_Date = DateTime.Now; _objProdSewing.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; _objProdSewing.ID = Convert.ToInt16(txthidID.Value); int result = _sewingbll.UpdateProdCutting(_objProdSewing); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); btnSubmit.Text = "Submit"; } } LoadCuttingDetails(); LoadSewingDetails(); ClearUi(); } catch (Exception ex) { throw ex; } }