public void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2542", "002"))
{
Response.Redirect("~/Test.aspx");
}
if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date > Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd")).Date)
{
myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not greater then current date.");
return;
}
if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date < Convert.ToDateTime(myFunc.SaveDate(txtPODate.Text)).Date)
{
myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not less then PO Date.");
return;
}
if (txtVendorDCn0.Text == "")
{
myFunc.UserMsg(lblMessage, Color.Red, "Please enter vendor DC Number.");
return;
}
if (gv_DC.Rows.Count == 0)
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "Please Select PO Number.";
return;
}
string newDCNo = "";
if (ddlDCno.SelectedValue == "0")
{
//newDCNo = myFunc.GetNewDCNumber(this.Session["DealerCode"].ToString());
newDCNo = myFunc.AutoGen("DCMaster", "DCNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
if (ddlDCno.SelectedValue != "")
{
if (!sec.UserRight("2542", "003"))
{
Response.Redirect("~/Test.aspx");
}
newDCNo = ddlDCno.SelectedValue;
}
else
{
newDCNo = this.Session["DCNumber"].ToString();
}
}
string sql = "";
if (myFunc.isDCExist(newDCNo, Session["DealerCode"].ToString()))
{
sql = "UPDATE DCMaster SET VendorDCNo='" + txtVendorDCn0.Text + "',Remarks='" + txtRemarks.Text + "' where DCNo='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'";
}
else
{
sql = "INSERT INTO DCMaster (DealerCode,DCNo,DCDate,PONo,VendorDCNo,VendorCode,Remarks,DelFlag,UpdUser,UpdDate,UpdTime)";
sql += " VALUES ('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + myFunc.SaveDate(txtDCDate.Text) + "','" + ddlPONo.SelectedValue + "','";
sql += txtVendorDCn0.Text.Trim() + "','" + txtVendor.Text + "','" + txtRemarks.Text.Trim() + "','N','" + this.Session["UserID"].ToString() + "',";
sql += "CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)";
}
try
{
int slct = 0;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
myFunc.ExecuteQuery_NonQuery(sql, Trans);
// save detail
RemoveQTYFromPO(newDCNo, "-");
sql = "delete from DCDetail where DCNo ='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'";
myFunc.ExecuteQuery_NonQuery(sql, Trans);
DataTable dt = (DataTable)Session["DCTable"];
string ItemCode = "";
int i = 0;
foreach (GridViewRow row in gv_DC.Rows)
{
CheckBox chkSelect = (CheckBox)row.FindControl("cbSelect");
if (chkSelect.Checked)
{
ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString(), Session["DealerCode"].ToString());
sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)";
sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','";
sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')";
myFunc.ExecuteQuery_NonQuery(sql, Trans);
slct++;
}
i++;
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
}
//Commented By Uzair
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// slct = dt.Rows[i]["Selected"].ToString();
// if (slct == "True")
// {
// ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString());
// sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)";
// sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','";
// sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')";
// myFunc.GetData(sql);
// }
//}
if (slct > 0)
{
ObjTrans.CommittTransaction(ref Trans);
RemoveQTYFromPO(newDCNo, "+");
lblMessage.ForeColor = Color.Green;
lblMessage.Text = newDCNo + " has been saved";
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + newDCNo + "')", true);
ClearAll();
lOADddl();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "At least one row should be selected";
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
}
//ddDCNumber.Text = newDCNo;
}
private void Posting(ref bool Check)
{
SqlTransaction Trans = null;
string strSQL = string.Empty;
DataSet dsItemStock = new DataSet();
string strMaster = string.Empty;
Check = false;
string strSrNo = string.Empty;
try
{
if (GvMain.Rows.Count == 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Details should not be left blank...");
return;
}
else
{
LbErr.Text = string.Empty;
}
///Transection Begin
if (ObjTrans.BeginTransaction(ref Trans) == false)
{
return;
}
//if (ddl)
//{
Save_InsertMasterDetail(Trans, ref Check, ref strSrNo);
if (Check == true)
{
///Start Posting
foreach (GridViewRow gvr in GvMain.Rows)
{
//'<<<<<<<< Update the ItemSotck >>>>>>>>>>>
bool NewFlag = false;
Label LbItemCode = (Label)gvr.FindControl("LbItemCode");
Label LbQty = (Label)gvr.FindControl("LbQty");
Label LbAmt = (Label)gvr.FindControl("LbAmount");
HiddenField hdLocCode = (HiddenField)gvr.FindControl("HDPartsTransLocCode");
strSQL = "SELECT * From ItemStock where ItemCode = '" + LbItemCode.Text + "' AND PartsTransLocCode = '" + hdLocCode.Value + "'";
if (SysFunc.ExecuteQuery(strSQL, ref dsItemStock) == false)
{
NewFlag = true;
}
if (NewFlag)
{
strSQL = "INSERT into ItemStock(DealerCode, PartsTransLocCode, ItemCode, RetQty, RetVal,SaleVal,SaleQty,RetSupp,Rejqty,IssVal,IssQty,RecVal,RecQty) values (" +
" '" + Session["DealerCode"].ToString() + "'," +
" '" + hdLocCode.Value + "'," +
" '" + LbItemCode.Text + "'," +
" '" + LbQty.Text.Trim() + "'," +
" '" + LbAmt.Text + "',0,0,0,0,0,0,0,0) ";
}
else
{
strSQL = "UPDATE ItemStock Set RetQty = RetQty + " + LbQty.Text.Trim() + ", RetVal = RetVal + " + LbAmt.Text + " Where DealerCode = '" + Session["DealerCode"].ToString() + "' AND PartsTransLocCode = '" + hdLocCode.Value + "' And ItemCode = '" + LbItemCode.Text + "'";
}
if (SysFunc.ExecuteQuery_NonQuery(strSQL, Trans) == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "Can Not Post, Not found ItemStock");
ObjTrans.RollBackTransaction(ref Trans);
Check = false;
return;
}
strSQL = "UPDATE StockIssueDetail SET RetQty=" + LbQty.Text.Trim() + " WHERE Dealercode='" + Session["DealerCode"].ToString() + "' And IssueNo='" + txtIssueNo.Text.Trim() + "' And ItemCode='" + LbItemCode.Text.Trim() + "'";
if (SysFunc.ExecuteQuery_NonQuery(strSQL, Trans) == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "Can Not Post, Not found ItemStock");
ObjTrans.RollBackTransaction(ref Trans);
Check = false;
return;
}
}
//for adjust customer outstanding
if (rdCounterSale.Checked)
{
strMaster = "Update CounterSaleMaster set InvoiceAmount = InvoiceAmount - '" + txtTotalAmount.Text + "' Where saleinvno='" + ddlSaleInvNo.SelectedValue.ToString() + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'";
if (SysFunc.ExecuteQuery_NonQuery(strMaster, Trans) == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "Can Not Post, Not found ItemStock");
ObjTrans.RollBackTransaction(ref Trans);
Check = false;
return;
}
}
if (rdJobCard.Checked)
{
if (SysFunc.CodeExists("CustomerInvoice", "JobcardCode", ddlSaleInvNo.SelectedValue.ToString(), " And DelFlag = 'N' and invType in ('Inv','Clb')") == true)
{
strMaster = "Update CustomerInvoice set NetAmountCustomer = NetAmountCustomer - '" + txtTotalAmount.Text + "' Where jobcardCode='" + ddlSaleInvNo.SelectedValue.ToString() + "' and DealerCode = '" + Session["DealerCode"].ToString() + "' and invType in ('Inv','Clb')";
if (SysFunc.ExecuteQuery_NonQuery(strMaster, Trans) == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "Can Not Post, Not found ItemStock");
ObjTrans.RollBackTransaction(ref Trans);
Check = false;
return;
}
}
}
if (UpdatePost(strSrNo, ref Trans) == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "UpdatePost Error");
ObjTrans.RollBackTransaction(ref Trans);
Check = false;
return;
}
else
{
Check = true;
}
}
if (Check == false)
{
ObjTrans.RollBackTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Red, "Record can not save. Try again...");
}
else
{
ObjTrans.CommittTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Green, "Record Posted successfuly. Return No.: " + strSrNo);
Load_ddlSRNo();
CtlClear("T");
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
