// BTN REMOVE
protected void BtnRemove_PayMode_Click(object sender, ImageClickEventArgs e)
{
DataSet dsdelete = new DataSet();
DataTable dt = new DataTable();
try
{
dt = (DataTable)Session["PayModeDS"];
ImageButton BtnLnk2 = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk2.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
String code = dt.Rows[rowGvIndex]["PayModeCode"].ToString();
if (sysFunc.CodeExists("PaymentReceiptMaster", "PayModeCode", code, Session["DealerCode"].ToString(), ref dsdelete))
{
lblMessage.Text = "Cannot delete , this PaymentMode is already in use";
return;
}
if (sysFunc.CodeExists("OutgoingPaymentMaster", "PayModeCode", code, Session["DealerCode"].ToString(), ref dsdelete))
{
lblMessage.Text = "Cannot delete , this PaymentMode is already in use";
return;
}
dt.Rows[rowGvIndex].Delete();
dt.AcceptChanges();
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
gv_paymode.DataSource = dt;
gv_paymode.DataBind();
Session["PayModeDS"] = dt;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
//and CountryDesc = '" + txtStateDescription.Text + "' and VersionCode = '" + dsdelete.Tables[0].Rows[rowGvIndex]["Version"].ToString() + "'
string sql = "delete from PaymentMode where PayModeCode = '" + code.Trim() + "' ";
SqlDataReader reader = null;
sysFunc.ExecuteQuery(sql, ref reader);
}
ObjTrans.CommittTransaction(ref Trans);
lblMessage.Text = "Record Deleted";
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
protected void BtnRemove_City_Click(object sender, ImageClickEventArgs e)
{
DataSet dsdelete = new DataSet();
DataTable dt = new DataTable();
try
{
dt = (DataTable)Session["JobCatDS"];
ImageButton BtnLnk2 = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk2.Parent.Parent;
int rowGvIndex = rowGv.RowIndex + gv_JobCat.PageIndex * gv_JobCat.PageSize;
String code = dt.Rows[rowGvIndex]["JobCatCode"].ToString();
String Desc = dt.Rows[rowGvIndex]["JobCatDesc"].ToString();
if (sysFunc.CodeExists("defaultjob", "JobCatCode", code, Session["DealerCode"].ToString(), ref dsdelete))
{
lblMessage.Text = "Record Cannot be deleted , this Job Category is already in use";
return;
}
dt.Rows[rowGvIndex].Delete();
dt.AcceptChanges();
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
gv_JobCat.DataSource = dt;
gv_JobCat.DataBind();
Session["JobCatDS"] = dt;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
//and CountryDesc = '" + txtStateDescription.Text + "' and VersionCode = '" + dsdelete.Tables[0].Rows[rowGvIndex]["Version"].ToString() + "'
string sql = "delete from JobCategory where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCatCode = '" + code.Trim() + "' ";
SqlDataReader reader = null;
sysFunc.ExecuteQuery(sql, ref reader);
}
ObjTrans.CommittTransaction(ref Trans);
lblMessage.Text = "Record " + Desc.Trim() + " Deleted";
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
// Remove Button Code
protected void BtnRemove_WorkFlowRolls_Click(object sender, ImageClickEventArgs e)
{
DataSet dsdelete = new DataSet();
DataTable dt = new DataTable();
try
{
dt = (DataTable)Session["WFRollsDS"];
ImageButton BtnLnk2 = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk2.Parent.Parent;
int rowGvIndex = rowGv.RowIndex + gv_WFRolls.PageIndex * gv_WFRolls.PageSize;
String code = dt.Rows[rowGvIndex]["RollsID"].ToString();
dt.Rows[rowGvIndex].Delete();
dt.AcceptChanges();
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
gv_WFRolls.DataSource = dt;
gv_WFRolls.DataBind();
Session["WFRollsDS"] = dt;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
string sql = "delete from Rolls where RollsID = '" + code.Trim() + "' ";
SqlDataReader reader = null;
sysFunc.ExecuteQuery(sql, ref reader);
}
ObjTrans.CommittTransaction(ref Trans);
lblMessage.Text = "Record Deleted";
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
protected void BtnRemove_WFPolicy_Click(object sender, ImageClickEventArgs e)
{
DataSet dsdelete = new DataSet();
try
{
dsdelete = (DataSet)Session["WFPolicyDS"];
ImageButton BtnLnk2 = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk2.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
//String code = dsdelete.Tables[0].Rows[rowGvIndex]["ApprovalCode"].ToString();
String code = dsdelete.Tables[0].Rows[rowGvIndex]["ApprovalCode"].ToString();
dsdelete.Tables[0].Rows[rowGvIndex].Delete();
dsdelete.Tables[0].AcceptChanges();
if (dsdelete.Tables[0].Rows.Count == 0)
{
DataRow dr = dsdelete.Tables[0].NewRow();
dsdelete.Tables[0].Rows.Add(dr);
}
gv_WFPolicy.DataSource = dsdelete.Tables[0];
gv_WFPolicy.DataBind();
Session["WFPolicyDS"] = dsdelete;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
string sql = "delete from WFPolicyDetail where ApprovalCode = '" + code.Trim() + "' ";
SqlDataReader reader = null;
sysFunc.ExecuteQuery(sql, ref reader);
}
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
if (ddlDRNo.SelectedIndex == 0)
{
lblMsg.Text = "Please select DTR No first";
return;
}
else
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
//and CountryDesc = '" + txtStateDescription.Text + "' and VersionCode = '" + dsdelete.Tables[0].Rows[rowGvIndex]["Version"].ToString() + "'
string sql = "Update FIRMaster Set PostFlag='Y',ApprovalFlag='N',PostDate='" + sysfunc.SaveDate(txtPostDate.Text) + "' where FIRCode='" + ddlDRNo.SelectedValue.ToString().Trim() + "' and DealerCode='" + Session["DealerCode"].ToString() + "'";
SqlDataReader reader = null;
sysfunc.ExecuteQuery(sql, ref reader);
}
ObjTrans.CommittTransaction(ref Trans);
lblMsg.Text = "DTR Posted";
clearAll();
}
}
public void Load_ItemLocation_ddl(DropDownList ddlCSItem, string DealerCode)
{
SqlDataReader Reader = null;
string strSql = string.Empty;
strSql = "WITH maxLen AS (SELECT " +
"max(len(rtrim(A.ItemCode))) Len0, " +
"max(len(rtrim(A.ItemDesc))) Len1, " +
"max(len(rtrim(A.PartItemNo))) Len2, " +
"MAX(len(RTRIM(B.PartsTransLocCode))) Len3, " +
"MAX(len(LTrim(RTrim(PL.PartsLocDesc)) +','+ LTrim(RTrim(PSL.PartsSubLocDesc)) +','+ LTrim(RTrim(PTL.PartsTransLocDesc)) )) Len4 " +
"FROM Item A Inner Join ItemStock B " +
"On A.ItemCode=B.ItemCode And B.DealerCode in ('" + Session["DealerCode"].ToString() + "','COMON') " +
"inner join PartsTransLocation PTL " +
"On B.PartsTransLocCode=PTL.PartsTransLocCode and B.DealerCode=PTL.DealerCode " +
"Inner join partslocation PL " +
"On PTL.PartsLocCode=PL.PartsLocCode " +
"And PTL.DealerCode=PL.DealerCode " +
"Inner join PartsSubLocation PSL " +
"On PTL.PartsSubLocCode=PSL.PartsSubLocCode " +
"And PTL.DealerCode=PSL.DealerCode " +
"Where A.DealerCode in ('" + DealerCode + "','COMON')) " +
"SELECT A.ItemCode + ',' + B.PartsTransLocCode As ItemCode, "
+ "+' | '+" + "(rtrim(A.ItemCode) + space((1+maxLen.Len0)-len(rtrim(A.ItemCode))) "
+ "+' | '+" + "rtrim(A.ItemDesc) + space((1+maxLen.Len1)-len(rtrim(A.ItemDesc))) "
+ "+' | '+" + "rtrim(A.PartItemNo) + space((1+maxLen.Len2)-len(rtrim(A.PartItemNo))) "
+ "+' | '+" + "rtrim(B.PartsTransLocCode) + space((1+maxLen.Len3)-len(rtrim(B.PartsTransLocCode))) "
+ "+' | '+" + "rtrim(LTrim(RTrim(PL.PartsLocDesc)) +','+ LTrim(RTrim(PSL.PartsSubLocDesc)) +','+ LTrim(RTrim(PTL.PartsTransLocDesc))) + space((1+maxLen.Len4)-len(rtrim(LTrim(RTrim(PL.PartsLocDesc)) +','+ LTrim(RTrim(PSL.PartsSubLocDesc)) +','+ LTrim(RTrim(PTL.PartsTransLocDesc)) ))) "
+ "+' | '+" + "rtrim(IsNull(Sum(B.RecQty) + Sum(B.PurRetQty) + Sum(B.RetQty) - ((Sum(B.IssQty) + Sum(B.ChargeOutQty)) ), 0)) ) As Name " +
"from Item A Inner Join ItemStock B " +
"On A.ItemCode=B.ItemCode And B.DealerCode in ('" + Session["DealerCode"].ToString() + "','COMON')" +
"inner join PartsTransLocation PTL " +
"On B.PartsTransLocCode=PTL.PartsTransLocCode and B.DealerCode=PTL.DealerCode " +
"Inner join partslocation PL " +
"On PTL.PartsLocCode=PL.PartsLocCode " +
"And PTL.DealerCode=PL.DealerCode " +
"Inner join PartsSubLocation PSL " +
"On PTL.PartsSubLocCode=PSL.PartsSubLocCode " +
"And PTL.DealerCode=PSL.DealerCode,maxLen " +
"Where A.DealerCode in('" + DealerCode + "','COMON') " +
"Group by A.ItemCode,maxLen.Len0,A.ItemDesc,maxLen.Len1,A.PartItemNo, " +
"maxLen.Len2,B.PartsTransLocCode,maxLen.Len3,PTL.PartsTransLocDesc,PL.PartsLocDesc,PSL.PartsSubLocDesc,maxLen.Len4 ";
if (Reader != null && Reader.IsClosed == false)
{
Reader.Close();
}
SysFunc.ExecuteQuery(strSql, ref Reader);
ddlCSItem.Items.Clear();
ListItem item = new ListItem();
item.Text = "Select";
item.Value = "0";
ddlCSItem.Items.Add(item);
while (Reader.Read())
{
StringWriter myWriter = new StringWriter();
HttpUtility.HtmlDecode(Reader["NAME"].ToString().Replace(" ", " "), myWriter);//ddlEmp.Items.Add(myWriter.ToString());
item = new ListItem();
item.Text = myWriter.ToString();
item.Value = Reader["ItemCode"].ToString();
ddlCSItem.Items.Add(item);
}
Reader.Close();
}
public static bool Insert_PaymentDetail(List <PaymentReceiptDetailVM> modelDetail, string DealerCode, ref string msg)
{
// var code = "MCM01";
//SysFunction Sys = new SysFunction();
//SysFunction sys = new SysFunction();
try
{
if (modelDetail != null)
{
foreach (var item in modelDetail)
{
SqlParameter[] PmtRecDetail_param =
{
/*0*/ new SqlParameter("@DealerCode", DealerCode),
/*1*/ new SqlParameter("@ReceiptNo", strAutoCode),
/*2*/ new SqlParameter("@InvoiceType", item.InvoiceType),
/*3*/ new SqlParameter("@InvoiceNo", item.InvoiceNo),
/*4*/ new SqlParameter("@InvoiceDate", sysfun.SaveDate(item.InvoiceDate)),
/*5*/ new SqlParameter("@InvAmount", SysFunction.CustomCDBL(item.InvAmount)),
/*6*/ new SqlParameter("@OutStAmount", SysFunction.CustomCDBL(item.OutStAmount)),
/*7*/ new SqlParameter("@AdjAmount", SysFunction.CustomCDBL(item.AdjAmount))
};
if (sysfun.ExecuteSP_NonQuery("sp_W2_PaymentReceipt_Detail_Insert", PmtRecDetail_param, Trans) == true)
{
if (item.InvoiceType == "CSI")
{
string IQuery = "Update VehicleSaleMaster set PaidAmount= isnull(PaidAmount,0) +'" + SysFunction.CustomCDBL(item.AdjAmount) + "' " +
"Where DealerCode='" + DealerCode + "' and TransCode='" + item.InvoiceNo + "'";
sysfun.ExecuteQuery(IQuery, Trans);
}
else if (item.InvoiceType == "ASC")
{
string IQuery = "Update ReceiptMaster set PaidC= PaidC +'" + SysFunction.CustomCDBL(item.AdjAmount) + "' " +
"Where DealerCode='" + DealerCode + "' and ReceiptNo='" + item.InvoiceNo + "'";
sysfun.ExecuteQuery(IQuery, Trans);
}
IsSaved = true;
}
}
}
else
{
ObjTrans.CommittTransaction(ref Trans);
IsSaved = true;
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
// ObjTrans.CommittTransaction(ref Trans);
return(IsSaved);
}