private void RetrieveDetailData()
{
DataSet ds = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlBillingNo.SelectedValue.Trim().ToString();
//ObjMainBll.ExecuteSP_NonQuery("sp_2W_Service_GetMasterData", param);
ds = ObjGenral.FillDataSet("sp_2W_Service_GetDetailData", param);
Grdbillings.DataSource = ds;
Grdbillings.DataBind();
foreach (GridViewRow gvr in Grdbillings.Rows)
{
CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
Chk.Checked = true;
//ChkBox.Checked = true;
}
}
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 !!!";
}
}
private void AddNewRow()
{
try
{
dttemp = (DataTable)Session["BillingDetails"];
DataRow dr;
dr = dttemp.NewRow();
dr["PPRCode"] = "";
dr["PPRDate"] = "";
dr["VehChassisNo"] = "";
dr["ProdDesc"] = "";
dr["TotalParts"] = "";
dr["TotalSublet"] = "";
dr["TotalLabor"] = "";
dr["TotalAmount"] = "";
dttemp.Rows.Add(dr);
dttemp.AcceptChanges();
Grdbillings.DataSource = dttemp;
Grdbillings.DataBind();
}
catch (Exception ex) { throw ex; }
}
protected void ddlBillingNo_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string sql = "Select Format(BillDate,'dd-MM-yyyy')BillDate,Remarks,BillAmount,GSTNo,GSTAmount,SSTNo,SSTAmount,PostFlag,CreditMemoNo from JENBillMaster where DealerCode='" + Session["DealerCode"].ToString() + "' And JENBillNo = '" + ddlBillingNo.SelectedValue + "' and DelFlag='N'";
dt = sysFunc.GetData(sql);
txtBillDate.Text = dt.Rows[0]["BillDate"].ToString();
txtRemarks.Text = dt.Rows[0]["Remarks"].ToString();
txtTotalAmount.Text = dt.Rows[0]["BillAmount"].ToString();
txtGSTAmt.Text = dt.Rows[0]["GSTAmount"].ToString().Replace(" ", "").Trim() == "" ? "0" : dt.Rows[0]["GSTAmount"].ToString().Replace(" ", "").Trim();
txtLabPST.Text = dt.Rows[0]["SSTAmount"].ToString().Replace(" ", "").Trim() == "" ? "0" : dt.Rows[0]["SSTAmount"].ToString().Replace(" ", "").Trim();
txtGSTCode.Text = dt.Rows[0]["GSTNo"].ToString();
txtPSTCode.Text = dt.Rows[0]["SSTNo"].ToString();
txtCreditNo.Text = dt.Rows[0]["CreditMemoNo"].ToString();
if (dt.Rows[0]["PostFlag"].ToString() == "Y")
{
btnSave.Enabled = false;
btnPost.Enabled = false;
btnDelete.Enabled = false;
}
// ddlTypes.SelectedValue = dt.Rows[0]["BillType"].ToString();
DataTable dt2 = new DataTable();
string sql2 = "Select * from JENBillDetail where DealerCode='" + Session["DealerCode"].ToString() + "' And JENBillNo = '" + ddlBillingNo.SelectedValue + "'";
dt2 = sysFunc.GetData(sql2);
DataTable dt3 = (DataTable)Session["BillingDetails"];
dt3.Rows.RemoveAt(0);
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@JENBillNo", SqlDbType.Char, 8),
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = ddlBillingNo.SelectedValue;
dsJENDEtail = ObjGenral.FillDataSet("sp_2W_Service_JENDetail", param1);
if (dsJENDEtail.Tables[0].Rows.Count > 0)
{
ddlTypes.SelectedValue = dsJENDEtail.Tables[0].Rows[0]["VehicleCategory"].ToString();
Grdbillings.DataSource = dsJENDEtail.Tables[0];
Grdbillings.DataBind();
//for (int j = 0; j < dt2.Rows.Count; j++)
//{
// DataRow row = dt3.NewRow();
// row["JobCardCode"] = dt2.Rows[j]["JobCardCode"].ToString();
// row["ChassisNo"] = dt2.Rows[j]["ChassisNo"].ToString();
// row["JobTypeDesc"] = dt2.Rows[j]["JobTypeCode"].ToString();
// row["PaidC"] = dt2.Rows[j]["BillAmount"].ToString();
// dt3.Rows.Add(row);
//}
}
else
{
lblMessage.Text = "No Record Found";
LoadEmptyGrid();
return;
}
// Grdbillings.DataSource = dt3;
// Grdbillings.DataBind();
Session["BillingDetails"] = dsJENDEtail.Tables[0];
}
