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;
}
}
