internal int UpdateProdCutting(Prod_Cutting _objProdCutting)
{
try
{
Prod_Cutting obj = _Context.Prod_Cutting.FirstOrDefault(x => x.ID == _objProdCutting.ID);
obj.OrderNo = _objProdCutting.OrderNo;
obj.OrderQty = _objProdCutting.OrderQty;
obj.GoodsName = _objProdCutting.GoodsName;
obj.FGoodsQty = _objProdCutting.FGoodsQty;
obj.FGoodsUnit = _objProdCutting.FGoodsUnit;
obj.CuttingReceivedDate = _objProdCutting.CuttingReceivedDate;
obj.CuttingReceivedQty = _objProdCutting.CuttingReceivedQty;
obj.CuttingReceivedUnit = _objProdCutting.CuttingReceivedUnit;
obj.CuttingCompleteDate = _objProdCutting.CuttingCompleteDate;
obj.TotalCuttingCompleteQty = _objProdCutting.TotalCuttingCompleteQty;
obj.TotalCuttingCompleteUnit = _objProdCutting.TotalCuttingCompleteUnit;
obj.Edit_User = _objProdCutting.Edit_User;
obj.Edit_Date = _objProdCutting.Edit_Date;
_Context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal Prod_Cutting GetCuttingbyId(int cID)
{
Prod_Cutting buyeres = (from pc in _Context.Prod_Cutting
where pc.ID == cID
select pc).FirstOrDefault();
return(buyeres);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Prod_Cutting _objProdCutting = new Prod_Cutting();
_objProdCutting.OrderNo = txtOrderNoFill.Text;
_objProdCutting.BuyerID = Convert.ToInt32(txthidBuyer.Value);
_objProdCutting.OrderQty = Convert.ToDouble(txtOderQty.Text);
_objProdCutting.GoodsName = txtFinishGoods.Text;
//_objProdCutting.OrderDate = Convert.ToDateTime(txtOrderDate.Text);
_objProdCutting.FGoodsQty = Convert.ToDouble(txtFinishGoodsQty.Text);
_objProdCutting.FGoodsUnit = txtUnits.Text;
_objProdCutting.CuttingReceivedDate = Convert.ToDateTime(txtCuttingReceivedDate.Text);
_objProdCutting.CuttingReceivedQty = Convert.ToDouble(txtCuttingReceivedQty.Text);
_objProdCutting.CuttingReceivedUnit = Convert.ToInt32(ddlUnit.SelectedValue.ToString());
if (divCCDShow.Visible == true)
{
_objProdCutting.CuttingCompleteDate = Convert.ToDateTime(txtCuttingCompleteDate.Text);
}
if (divCCQShow.Visible == true)
{
_objProdCutting.TotalCuttingCompleteQty = Convert.ToDouble(txtCCompleteCuttingQty.Text);
_objProdCutting.TotalCuttingCompleteUnit = Convert.ToInt32(ddlTUnits.SelectedValue.ToString());
}
_objProdCutting.Create_Date = DateTime.Now;
_objProdCutting.Create_User = ((SessionUser)Session["SessionUser"]).UserId;
_objProdCutting.OCode = ((SessionUser)Session["SessionUser"]).OCode;
if (btnSubmit.Text == "Submit")
{
int result = _cuttingbll.InsertProdCutting(_objProdCutting);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
}
}
else
{
_objProdCutting.Edit_Date = DateTime.Now;
_objProdCutting.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
_objProdCutting.ID = Convert.ToInt16(txthidID.Value);
int result = _cuttingbll.UpdateProdCutting(_objProdCutting);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true);
btnSubmit.Text = "Submit";
}
}
LoadCuttingDetails();
ClearUi();
}
catch (Exception ex)
{
throw ex;
}
}
internal int InsertProdCutting(Prod_Cutting _objProdCutting)
{
try
{
_Context.Prod_Cutting.AddObject(_objProdCutting);
_Context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnCuttingDetails_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imgbtn = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgbtn.NamingContainer;
Label lblId = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblId");
//Label lblOrderNo = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblOrderNo");
//Label lblOrder_Qty = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblOrderQty");
//Label lblGoodsName = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblFinishedGoodsName");
//Label lblFGoodsQty = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblFGoodsQty");
//Label lblFGoodsUnit = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblFGoodsUnit");
//Label lblCuttingReceivedDate = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblCuttingReceivedDate");
//Label lblCuttingReceivedQty = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblCuttingReceivedQty");
//Label lblCuttingReceivedUnit = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblCuttingReceivedUnit");
//Label lblCuttingCompleteDate = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblCuttingCompleteDate");
//Label lblTotalCuttingCompleteQty = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblTotalCuttingCompleteQty");
// Label lblTotalCuttingCompleteUnit = (Label)grdCuttingDetails.Rows[row.RowIndex].FindControl("lblTotalCuttingCompleteUnit");
int cID = Convert.ToInt16(lblId.Text);
Prod_Cutting _ID = _cuttingbll.GetCuttingbyId(cID);
if (_ID != null)
{
txthidID.Value = _ID.ID.ToString();
txtOrderNoFill.Text = _ID.OrderNo.ToString();
txthidBuyer.Value = _ID.BuyerID.ToString();
txtOderQty.Text = _ID.OrderQty.ToString();
txtFinishGoods.Text = _ID.GoodsName.ToString();
txtFinishGoodsQty.Text = _ID.FGoodsQty.ToString();
txtUnits.Text = _ID.FGoodsUnit.ToString();
txtCuttingReceivedDate.Text = _ID.CuttingReceivedDate.ToString();
txtCuttingReceivedQty.Text = _ID.CuttingReceivedQty.ToString();
ddlUnit.Text = _ID.CuttingReceivedUnit.ToString();
txtCuttingCompleteDate.Text = _ID.CuttingCompleteDate.ToString();
txtCCompleteCuttingQty.Text = _ID.TotalCuttingCompleteQty.ToString();
//ddlTUnits.Text = _ID.TotalCuttingCompleteUnit.ToString();
//txthidID.Value = lblId.ToString();
//Session["lblId"] = txthidID.Value;
//txtOrderNoFill.Text = lblOrderNo.Text;
//txtOderQty.Text = lblOrder_Qty.Text;
//txtFinishGoods.Text = lblGoodsName.Text;
//txtFinishGoodsQty.Text = lblOrder_Qty.Text;
//txtUnits.Text = lblFGoodsUnit.Text;
//txtCuttingReceivedDate.Text = lblCuttingReceivedDate.Text;
//txtCuttingReceivedQty.Text = lblCuttingReceivedQty.Text;
//ddlUnit.Text = lblCuttingReceivedUnit.Text;
//txtCuttingCompleteDate.Text = lblCuttingCompleteDate.Text;
//txtCCompleteCuttingQty.Text = lblTotalCuttingCompleteQty.Text;
//ddlTUnits.Text = lblTotalCuttingCompleteUnit.Text;
btnSubmit.Text = "Update";
divCCDShow.Visible = true;
divCCQShow.Visible = true;
}
FillTotalunit();
}
catch (Exception ex)
{
throw ex;
}
}
internal int UpdateProdCutting(Prod_Cutting _objProdCutting)
{
return(_cuttingdal.UpdateProdCutting(_objProdCutting));
}
internal int InsertProdCutting(Prod_Cutting _objProdCutting)
{
return(_cuttingdal.InsertProdCutting(_objProdCutting));
}
