protected void ddlType_IndexChanged(object sender, EventArgs e)
{
if (txtToDate.Text == "" && txtFromDate.Text == "")
{
lblMessage.Text = "Please Select Dates";
return;
}
LoadEmptyGrid();
lblMessage.Text = string.Empty;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@Type", SqlDbType.Char, 3), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //0
new SqlParameter("@ToDate", SqlDbType.DateTime), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlTypes.SelectedValue;
param[2].Value = sysFunc.SaveDate(txtFromDate.Text);
param[3].Value = sysFunc.SaveDate(txtToDate.Text);
ds = ObjGenral.FillDataSet("sp_2W_Service_GetClaimBillingData_new", param);
if (ds.Tables[0].Rows.Count > 0)
{
Grdbillings.DataSource = ds;
Grdbillings.DataBind();
Session["JENDetail"] = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
foreach (GridViewRow gvr in Grdbillings.Rows)
{
PST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["HandlingAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTSubletAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTLaborAmount"].ToString());
GST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["GSTAmount"].ToString());
TotalAmount = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["TotalAmount"].ToString());
CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
Chk.Checked = true;
//ChkBox.Checked = true;
}
txtLabPST.Text = PST.ToString();
txtGSTAmt.Text = GST.ToString();
txtTotalAmount.Text = TotalAmount.ToString();
//CalculatePSTPercentage();
}
}
else
{
//txtPstAmt.Text = "";
//txtPerc.Text = "";
lblMessage.Text = "No Record Found !!!";
}
}
protected void btnAdjAmt_Click(object sender, EventArgs e)
{
if (txtins_amount.Text == "")
{
SysFunc.UserMsg(success_add_item, Color.Red, "Please Enter Amount First!", txtins_amount);
}
double InsAmt, AdvBal;
AdvBal = SysFunctions.CustomCDBL(txtBalance.Text);
InsAmt = SysFunctions.CustomCDBL(txtins_amount.Text);
AdvBal = SysFunctions.CustomCDBL(AdvBal - InsAmt);
txtBalance.Text = AdvBal.ToString();
Session["Adj"] = "Adj";
}
private int GetTotalCount()
{
string sql = "Select Count(*) from CustomerInvoice where Delflag='N' and DealerCode='" + Session["DealerCode"].ToString() + "'";
int count = 0;
dt = new DataTable();
dt = sysfun.GetData(sql);
if (dt.Rows.Count > 0)
{
count = Convert.ToInt16(SysFunctions.CustomCDBL(dt.Rows[0][0].ToString()));
}
return(count);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (txtTaxHead.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Tax Head should not left blank", txtTaxHead);
return;
}
//if (txt.Text == "")
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg);
// return;
//}
//if (txtRemarks.Text == "")
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg);
// return;
//}
DataTable dt = (DataTable)Session["TaxTypeDS"];
try
{
string max = sysFuncs.GetNewMaxID("TaxType", "TaxID", 2, "COMON");
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@TaxID", SqlDbType.Char, 2), //1
new SqlParameter("@TaxHead", SqlDbType.VarChar, 50), //2
new SqlParameter("@TaxPer", SqlDbType.Decimal), //3
new SqlParameter("@Active", SqlDbType.Char, 1), //4
new SqlParameter("@Type", SqlDbType.VarChar, 50), //5
new SqlParameter("@TaxApplicable", SqlDbType.VarChar, 20), //6
new SqlParameter("@AccCode", SqlDbType.Char, 16), //7
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8
new SqlParameter("@UpdDate", SqlDbType.DateTime), //9
new SqlParameter("@UpdTime", SqlDbType.DateTime), //10
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 11
};
string activeCheck = "";
if (CheckId.Checked)
{
activeCheck = "Y";
}
else
{
activeCheck = "N";
}
// txtAccCode.Text = textAccCode;
param[0].Value = "COMON";
param[1].Value = max;
param[2].Value = txtTaxHead.Text;
param[3].Value = SysFunctions.CustomCDBL(txtTaxPercent.Text);
param[4].Value = activeCheck;
param[5].Value = ddlType.Text;
param[6].Value = ddlTaxApplicable.Text;
param[7].Value = txtAccCode.Text;
param[8].Value = Session["UserName"].ToString();
param[9].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
param[10].Value = DateTime.Now;
param[11].Value = "1";
if (sysFunc.ExecuteSP_NonQuery("SP_Insert_TaxType", param))
{
sysFunc.ClearTextBoxes(Page);
createGrid();
sysFuncs.UserMsg(lblMessage, Color.Green, "Record " + max + " Insert Sucessfully", txtTaxId);
}
else
{
sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtTaxId);
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
//protected void ChkBox_CheckedChanged(object sender, EventArgs e)
//{
// if (ChkBox.Checked)
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// TotalAmount = TotalAmount + Convert.ToDecimal(gvr.Cells[5].Text.Trim());
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = true;
// }
// txtTotalAmount.Text = TotalAmount.ToString();
// CalculatePSTPercentage();
// }
// else
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = false;
// txtTotalAmount.Text = "0.00";
// //txtPstAmt.Text = "0.00";
// }
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2583", "002"))
{
Response.Redirect("~/Test.aspx");
}
try
{
int grd = Grdbillings.Rows.Count;
if (grd > 0)
{
//Auto Generated Code//
DateTime dt = DateTime.Now;
string strYear = dt.Year.ToString();
string BillNo;
if (ddlBillingNo.SelectedValue.Trim() == "0")
{
BillNo = ObjGenral.AutoGen("JENBillMaster", "JENBillNo", DateTime.Now.ToString("dd-MM-yyyy"));
}
else
{
BillNo = ddlBillingNo.SelectedValue.Trim();
}
//Auto Generated Code//
string Remarks = txtRemarks.Text.Trim().ToString();
float BillRecAmount = 0;
string DelFlag = "N", PostFlag = "N";
string UpdUser = Session["UserName"].ToString();
//FFI PDI Master Insert here
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@BillDate", SqlDbType.DateTime), //2
new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //3
new SqlParameter("@BillQty", SqlDbType.Int), //4
new SqlParameter("@BillAmount", SqlDbType.Float, 15), //5
new SqlParameter("@BillRecAmount", SqlDbType.Float, 15), //6
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8
new SqlParameter("@UpdUser", SqlDbType.VarChar, 5), //9
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//10
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//11
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //12
new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //13
new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //14
new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //15
new SqlParameter("@SoftwareVersion", SqlDbType.VarChar, 25), //16
new SqlParameter("@BillType", SqlDbType.VarChar, 5), //17
new SqlParameter("@VehType", SqlDbType.Char, 3), //17
new SqlParameter("@CreditNo", SqlDbType.VarChar, 50), //17
new SqlParameter("@GSTAmount", SqlDbType.Decimal, 50), //17
new SqlParameter("@SSTAmount", SqlDbType.Decimal, 50), //17
//new SqlParameter("@SSTAge",SqlDbType.Decimal,18),//18
//new SqlParameter("@SSTAmount",SqlDbType.Decimal,18),//19
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = BillNo;
param[2].Value = ObjGenral.SaveDate(txtBillDate.Text);
//param[2].Value = txtBillDate.Text;
param[3].Value = Remarks.ToUpper();
param[4].Value = Grdbillings.Rows.Count;
param[5].Value = txtTotalAmount.Text.Trim().ToString();
param[6].Value = BillRecAmount;
param[7].Value = DelFlag;
param[8].Value = PostFlag;
param[9].Value = Session["UserName"].ToString();
//param[10].Value = ObjGenral.SaveDate(DateTime.Now.ToString());
//param[11].Value = ObjGenral.SaveTime(DateTime.Now.ToString());
param[10].Value = GlobalVar.mUserIPAddress;
param[11].Value = "C";
param[12].Value = null;
param[13].Value = null;
param[14].Value = null;
param[15].Value = ddlTypes.SelectedValue.ToString();
param[16].Value = txtCreditNo.Text;
param[17].Value = txtGSTAmt.Text.Trim();
param[18].Value = txtLabPST.Text.Trim();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillMaster_Insert", param, Trans))
{
lblLastBillNo.Text = "Last Code Generated : " + " " + BillNo;
}
}
else
{
lblMessage.Text = "Error";
}
//FFI PDI Master Insert here
//Insert Detail Data Here
foreach (GridViewRow gvr in Grdbillings.Rows)
{
string DealerCode = Session["DealerCode"].ToString();
string PPRCode = gvr.Cells[1].Text.Trim().ToString();
string BillNoDetail = BillNo;
// string Billtype = ddlTypes.SelectedValue.ToString();
string BillAmount = gvr.Cells[5].Text.Trim().ToString();
CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@JENBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@PPRCode", SqlDbType.Char, 8), //2
new SqlParameter("@PPRDate", SqlDbType.DateTime), //3
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 15), //4
new SqlParameter("@Parts", SqlDbType.Float), //5
new SqlParameter("@Sublet", SqlDbType.Float), //6
new SqlParameter("@Labor", SqlDbType.Float), //7
new SqlParameter("@TotalAmount", SqlDbType.Float), //8
new SqlParameter("@GSTAmount", SqlDbType.Float), //9
new SqlParameter("@PSTLaborAmount", SqlDbType.Float), //10
new SqlParameter("@PSTSublet", SqlDbType.Float), //11
new SqlParameter("@HandlingAmount", SqlDbType.Float), //12
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = BillNoDetail;
param1[2].Value = PPRCode;
param1[3].Value = sysFunc.SaveDate(gvr.Cells[2].Text.Trim().ToString());
param1[4].Value = gvr.Cells[4].Text.Trim().ToString();
param1[5].Value = SysFunctions.CustomCDBL(gvr.Cells[12].Text);
param1[6].Value = SysFunctions.CustomCDBL(gvr.Cells[13].Text);
param1[7].Value = SysFunctions.CustomCDBL(gvr.Cells[14].Text);
param1[8].Value = SysFunctions.CustomCDBL(gvr.Cells[15].Text);
param1[9].Value = SysFunctions.CustomCDBL(gvr.Cells[7].Text);
param1[10].Value = SysFunctions.CustomCDBL(gvr.Cells[9].Text);
param1[11].Value = SysFunctions.CustomCDBL(gvr.Cells[11].Text);
param1[12].Value = SysFunctions.CustomCDBL(gvr.Cells[6].Text);
// param1[3].Value = Billtype;
if (Chk.Checked == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1, Trans))
{
lblMessage.Text = "Record Has been Inserted Sucessfully !!!";
ClearAll();
}
// ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1,Trans);
}
//Insert Detail Data Here
}
}
else
{
string script = "alert(\"User should select some Bills !!!\");";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true);
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Text = ex.Message;
}
ObjTrans.CommittTransaction(ref Trans);
}
