internal int BackToBackApprove(List <LC_BackToBack> lstLC_BackToBack)
{
try
{
foreach (LC_BackToBack aReq in lstLC_BackToBack)
{
LC_BackToBack obj = _Context.LC_BackToBack.First(x => x.B2BId == aReq.B2BId);
obj.ApproveDate = aReq.ApproveDate;
obj.ApproveNo = aReq.ApproveNo;
obj.ApproveStatus = aReq.ApproveStatus;
obj.EditDate = DateTime.Today;
obj.EditUser = aReq.EditUser;
_Context.SaveChanges();
}
_Context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
LC_BackToBack LcBack = new LC_BackToBack();
List <LC_BackToBack_Temp> _LC_BackToBack = new List <LC_BackToBack_Temp>();
if (txtPIDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input PI Date !')", true);
return;
}
if (txtBBLCDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input BBLC Date !')", true);
return;
}
foreach (GridViewRow gvRow in grvOrderSheetEntry.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
LC_BackToBack_Temp _orderPlanning = new LC_BackToBack_Temp();
if (rowChkBox.Checked == true)
{
Label lblProductId = ((Label)gvRow.FindControl("lblProductId"));
Label lblCpu = ((Label)gvRow.FindControl("lblCpu"));
Label lblBalanceQty = ((Label)gvRow.FindControl("lblBalanceQty"));
Label lblProductName = ((Label)gvRow.FindControl("lblProductName"));
Label lblUnitName = ((Label)gvRow.FindControl("lblUnitName"));
Label lblStyleSize = ((Label)gvRow.FindControl("lblStyleSize"));
Label lblBrand = ((Label)gvRow.FindControl("lblBrand"));
TextBox txtQty = ((TextBox)gvRow.FindControl("txtQty"));
TextBox txtUSDRate = ((TextBox)gvRow.FindControl("txtUSDRate"));
// TextBox txtBDTRate = ((TextBox)gvRow.FindControl("txtBDTRate"));
Label lblValue = ((Label)gvRow.FindControl("lblValue"));
// Label lblBDTValue = ((Label)gvRow.FindControl("lblBDTValue"));
if (txtUSDRate.Text == "")
{
_orderPlanning.USDRate = 0;
}
else
{
_orderPlanning.USDRate = Convert.ToDecimal(txtUSDRate.Text.ToString());
_orderPlanning.USDValue = Convert.ToDecimal(lblValue.Text.ToString());
}
//if (txtBDTRate.Text == "")
//{
// _orderPlanning.BDTRate = 0;
// _orderPlanning.BDTValue = 0;
//}
//else
//{
// _orderPlanning.BDTRate = Convert.ToDecimal(txtBDTRate.Text.ToString());
// _orderPlanning.BDTValue = Convert.ToDecimal(lblBDTValue.Text.ToString());
//}
if (txtQty.Text == "")
{
_orderPlanning.ReqQty = 0;
}
else
{
_orderPlanning.ReqQty = Convert.ToDouble(txtQty.Text.ToString());
}
if (lblCpu.Text == "")
{
_orderPlanning.CPU = 0;
}
else
{
_orderPlanning.CPU = Convert.ToDecimal(lblCpu.Text.ToString());
}
if (rdbForeign.Checked == true)
{
_orderPlanning.BayerType = rdbForeign.Text;
}
else
{
_orderPlanning.BayerType = rdbLocal.Text;
}
_orderPlanning.BBLCDate = Convert.ToDateTime(txtBBLCDate.Text);
_orderPlanning.ExpireDate = Convert.ToDateTime(txtExpireDate.Text);
_orderPlanning.BBLCAutoId = txtAutoChallanId.Text;
_orderPlanning.BBLCShipmentDate = Convert.ToDateTime(txtBBLCDate.Text);
_orderPlanning.SightDaysInterest = txtSigntDayInterest.Text;
_orderPlanning.ProductId = Convert.ToInt32(lblProductId.Text.ToString());
_orderPlanning.Barcode = lblProductId.Text.ToString();
_orderPlanning.ProductName = lblProductName.Text.ToString();
_orderPlanning.Brand = lblBrand.Text.ToString();
_orderPlanning.StyleSize = lblStyleSize.Text.ToString();
_orderPlanning.Unit = lblUnitName.Text.ToString();
_orderPlanning.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_orderPlanning.EditDate = DateTime.Now;
_orderPlanning.CreateUser = ((SessionUser)Session["SessionUser"]).UserId;
_orderPlanning.Season = ddlSeason.SelectedItem.Text;
_orderPlanning.POOrderNo = ddlPoOrder.SelectedItem.Text;
_orderPlanning.Style = ddlStyle.SelectedItem.Text;
_orderPlanning.Article = ddlArticle.SelectedItem.Text;
_orderPlanning.MasterLC = txtMasterLC.Text;
_orderPlanning.B2BLCNo = txtB2BLCNo.Text;
_orderPlanning.PI = txtPI.Text;
_orderPlanning.PIDate = Convert.ToDateTime(txtPIDate.Text);
_orderPlanning.ProductGroupId = Convert.ToInt32(drpItemCategory.SelectedValue);
_orderPlanning.SupplierId = ddlSupplier.SelectedValue.ToString();
_LC_BackToBack.Add(_orderPlanning);
}
}
if (_LC_BackToBack.Count > 0)
{
int result = _orderSheetbll.InsertBackToBack(_LC_BackToBack);
if (result == 1)
{
Clear();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
GridBackTobBackLoad();
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
}
catch (Exception ex)
{
throw;
}
}
protected void btnProcess_Click(object sender, EventArgs e)
{
try
{
List <LC_BackToBack> lstLC_BackToBack = new List <LC_BackToBack>();
if (txtAccNo.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input Approved no')", true);
return;
}
if (txtDate.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Insert Date')", true);
return;
}
foreach (GridViewRow gvr in grvOrderSheetEntry.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvr.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
LC_BackToBack objLC_BackToBack = new LC_BackToBack();
Label lblId = (Label)gvr.FindControl("Id");
Label lblblProductId = (Label)gvr.FindControl("lblProductId");
Label lblBalanceQty = (Label)gvr.FindControl("lblBalanceQty");
DropDownList ddlStatus = (DropDownList)gvr.FindControl("ddlStatus");
string Status = ddlStatus.SelectedItem.Text;
objLC_BackToBack.B2BId = Convert.ToInt32(lblId.Text);
if (ddlStatus.SelectedItem.Text == "Approved")
{
objLC_BackToBack.ApproveStatus = "Approved";
}
else
{
objLC_BackToBack.ApproveStatus = "Pending";
}
objLC_BackToBack.ApproveDate = Convert.ToDateTime(txtDate.Text.ToString());
objLC_BackToBack.ApproveNo = txtAccNo.Text;
//objLC_BackToBack.EditUser =((Guid)Session["UserID"]);
lstLC_BackToBack.Add(objLC_BackToBack);
}
}
int result = _orderSheetbll.BackToBackApprove(lstLC_BackToBack);
getdateforLoad();
grvOrderSheetEntry.DataSource = null;
grvOrderSheetEntry.DataBind();
//LoadRequisitionsItem(reqNo);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data recorded successfully')", true);
//lblMessage.Text = "Data Recorded Successfully.";
}
catch (Exception ex)
{
throw ex;
// ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Adding Failure!')", true);
//lblMessage.Text = "<font color='red'>Data Adding Failure!</font>";
}
}
protected void btnProcess_Click(object sender, EventArgs e)
{
try
{
List <LC_BackToBack> lstLC_BackToBack = new List <LC_BackToBack>();
bool status = true;
bool CheckStatus = false;
foreach (GridViewRow gvRow in grvOrderSheetEntry.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
CheckStatus = true;
}
}
if (CheckStatus)
{
foreach (GridViewRow gvRow in grvOrderSheetEntry.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
TextBox txtbxReceive = (TextBox)gvRow.FindControl("txtReceivedQty");
if (txtbxReceive.Text != "")
{
// Label lblLastRceceive = ((Label)gvRow.FindControl("lblLastReceive"));
// double lastReceive = Convert.ToDouble(lblLastRceceive.Text);
double ReceiveQty = Convert.ToDouble(txtbxReceive.Text);
Label lblOrderQty = ((Label)gvRow.FindControl("lblBalanceQty"));
double Poqty = Convert.ToDouble(lblOrderQty.Text);
if (ReceiveQty == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Quantity!')", true);
status = false;
break;
}
else if (ReceiveQty > Poqty)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Check Quantity!')", true);
status = false;
break;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Receive Qty!')", true);
status = false;
break;
}
}
}
foreach (GridViewRow gvr in grvOrderSheetEntry.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvr.FindControl("rowLevelCheckBox"));
if (rowChkBox.Checked == true)
{
LC_BackToBack objLC_BackToBack = new LC_BackToBack();
Label lblId = (Label)gvr.FindControl("Id");
Label lblblProductId = (Label)gvr.FindControl("lblProductId");
Label lblBalanceQty = (Label)gvr.FindControl("lblBalanceQty");
objLC_BackToBack.B2BId = Convert.ToInt32(lblId.Text);
lstLC_BackToBack.Add(objLC_BackToBack);
}
}
int result = _orderSheetbll.BackToBackApprove(lstLC_BackToBack);
getdateforLoad();
grvOrderSheetEntry.DataSource = null;
grvOrderSheetEntry.DataBind();
//LoadRequisitionsItem(reqNo);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data recorded successfully')", true);
//lblMessage.Text = "Data Recorded Successfully.";
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
