private void RetrieveMasterData()
{
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_GetMasterData", param);
if (ds.Tables[0].Rows[0]["BillDate"].ToString() == "")
{
txtRemarks.Text = "";
}
else
{
txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString();
}
//txtCode.Text = ds.Tables[0].Rows[0]["SSTNo"].ToString();
// ddlTypes.SelectedValue = ds.Tables[0].Rows[0]["BillType"].ToString();
txtBillDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["BillDate"].ToString()).ToString("dd/MM/yyyy");
txtTotalAmount.Text = ds.Tables[0].Rows[0]["BillAmount"].ToString();
//txtPerc.Text = ds.Tables[0].Rows[0]["SSTAge"].ToString();
//txtPstAmt.Text = ds.Tables[0].Rows[0]["SSTAmount"].ToString();
lblLastBillNo.Text = "";
}
public void GetRefundDetail(string item)
{
SqlParameter[] dsMasterParam = { new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@RefundNo", SqlDbType.Char, 8), };
dsMasterParam[0].Value = Session["DealerCode"].ToString();
dsMasterParam[1].Value = item;
DataSet dsJobCardMaster = new DataSet();
dsJobCardMaster = SysFunc.FillDataSet("sp_AdvanceInsurance_Detail", dsMasterParam);
if (dsJobCardMaster.Tables[0].Rows.Count > 0)
{
txtVoucherNo.Text = dsJobCardMaster.Tables[0].Rows[0]["VoucherNo"].ToString();
txtRefundDate.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceDate"].ToString();
txtins_amount.Text = dsJobCardMaster.Tables[0].Rows[0]["InsAmount"].ToString();
ddlpayment_mode.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["PayModeCode"].ToString();
txtinstrument_no.Text = dsJobCardMaster.Tables[0].Rows[0]["InsNo"].ToString();
txtinstrument_date.Text = SysFuncs.GetDate(dsJobCardMaster.Tables[0].Rows[0]["InsDate"].ToString());
ddlbank.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BankCode"].ToString().Trim();
txtbranch.Text = dsJobCardMaster.Tables[0].Rows[0]["Branch"].ToString();
ddlInsCo.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["InsCompCode"].ToString().Trim();
ddlInsCo_SelectedIndexChanged(null, null);
ddlInsBranch.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BranchCode"].ToString().Trim();
btn_save.Enabled = false;
}
}
private void CalcTotals()
{
DataSet ds = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@GRNNo", SqlDbType.Char),
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlGRN.SelectedValue.ToString().Trim();
//Load_Detail("sp_Select_GRNDetail_on_PayableInvForm", ddlGRN.SelectedValue.ToString().Trim(), "@GRNNo");
ds = SysFunc.FillDataSet("sp_Select_GRNDetail_on_PayableInvForm", param);
decimal SumOfGSTAmt = 0;
decimal SumOfFurTaxAmt = 0;
decimal SumOfExTaxAmt = 0;
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect");
Label lblGrossAmt = (Label)gvr.Cells[10].FindControl("lblGrossAmt");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (chkSelect.Checked == true)
{
if (dr["ItemCode"].ToString() == gvr.Cells[1].Text)
{
SumOfGSTAmt = SumOfGSTAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["GSTPercent"].ToString())) / 100);
SumOfExTaxAmt = SumOfExTaxAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["ExTaxPercent"].ToString())) / 100);
SumOfFurTaxAmt = SumOfFurTaxAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["FurTaxPercent"].ToString())) / 100);
}
}
}
}
lblGstPerc.Text = ds.Tables[0].Rows[0]["GSTPercent"].ToString() + "%";
lblFurTaxPerc.Text = ds.Tables[0].Rows[0]["FurTaxPercent"].ToString() + "%";
lblExTaxPerc.Text = ds.Tables[0].Rows[0]["ExTaxPercent"].ToString() + "%";
txtGstAmt.Text = SumOfGSTAmt.ToString(("#.##"));
txtExTaxAmt.Text = SumOfExTaxAmt.ToString(("#.##"));
txtFurTaxAmt.Text = SumOfFurTaxAmt.ToString(("#.##"));
Label lblFooterGrossAmt = (Label)gvPurInvDetail.FooterRow.Cells[10].FindControl("lblFooterGrossAmt");
txtTotalAmt.Text = (SumOfGSTAmt + SumOfExTaxAmt + SumOfFurTaxAmt + Convert.ToDecimal(lblFooterGrossAmt.Text)).ToString();
}
protected void ddlVinNo_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet dsVehInfo = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.VarChar, 5),
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlVinNo.SelectedValue.ToString().Trim(); // ddlRegNo.Text.Trim();//(HFRegNo.Value == "" ? null : HFRegNo.Value);
dsVehInfo = sysfuncs.FillDataSet("sp_W2_CustomerVehicleDTR_Select", param);
if (dsVehInfo.Tables[0].Rows.Count > 0)
{
setVehcileInfo(dsVehInfo);
}
}
private void PopulateGrid()
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@FromDate", SqlDbType.DateTime),
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Calendar1.SelectedDate.ToString("yyyy-MM-dd");
DataSet ds = new DataSet();
ds = myFunc.FillDataSet("SP_NDM_LetterSendDate", param);
if (ds.Tables[0].Rows.Count > 0)
{
grdNextDueMaintenance.DataSource = ds;
grdNextDueMaintenance.DataBind();
Session["NextDueMaintenance"] = ds;
}
ds.Dispose();
ds = myFunc.FillDataSet("SP_NDM_CallDate", param);
if (ds.Tables[0].Rows.Count > 0)
{
gvCallSend.DataSource = ds;
gvCallSend.DataBind();
Session["CallDate"] = ds;
}
ds.Dispose();
ds = myFunc.FillDataSet("SP_NDM_SMSDate", param);
if (ds.Tables[0].Rows.Count > 0)
{
gvSMSSend.DataSource = ds;
gvSMSSend.DataBind();
Session["SMSDate"] = ds;
}
}
protected void ddlRegNo_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string RegNo = ddlRegNo.SelectedValue.ToString();
SqlParameter[] RegNo_param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*0*/ new SqlParameter("@RegNo", SqlDbType.VarChar, 100)
};
RegNo_param[0].Value = Session["DealerCode"].ToString();
RegNo_param[1].Value = RegNo;
ds = myFunc.FillDataSet("sp_2W_LoadChassisEngineRegNo_RegNoParameter_History", RegNo_param);
ddlEngineNo.SelectedValue = ds.Tables[0].Rows[0]["EngineNo"].ToString();
ddlChassisNo.SelectedValue = ds.Tables[0].Rows[0]["ChassisNo"].ToString();
txtCusCode.Text = ds.Tables[0].Rows[0]["CusCode"].ToString();
txtCustomer.Text = ds.Tables[0].Rows[0]["CusDesc"].ToString().ToUpper();
txtProduct.Text = ds.Tables[0].Rows[0]["ProdCode"].ToString();
txtVersionCode.Text = ds.Tables[0].Rows[0]["VersionCode"].ToString();
txtVerDesc.Text = ds.Tables[0].Rows[0]["ProdTitle"].ToString();
lblMSG.Text = "";
}
public void GetGatePassDetail()
{
DataSet dsGatePassInfo = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.VarChar, 5),
new SqlParameter("@GatePassCode", SqlDbType.Char, 8)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtGatePassCode.Text;
dsGatePassInfo = myFunc.FillDataSet("sp_W2_GatePass_Select", param);
if (dsGatePassInfo.Tables[0].Rows.Count > 0)
{
setGatePassInfo(dsGatePassInfo);
}
DataSet dsVeh = new DataSet();
dsVeh = myFunc.FillDataSet("sp_W2_GatePass_VehicleDetail_Select", param);
//if (dsJobCardParts.Tables[0].Rows.Count == 0) dsJobCardParts.Tables[0].Rows.Add(dsJobCardParts.Tables[0].NewRow());
ViewState["Veh"] = dsVeh.Tables[0]; gvVehicle.DataSource = dsVeh.Tables[0]; gvVehicle.DataBind();
}
private void PopulateGrid()
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@FromDate", SqlDbType.DateTime),
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Calendar1.SelectedDate.ToString("yyyy-MM-dd");
DataSet ds = new DataSet();
ds = myFunc.FillDataSet("sp_2W_Post_PostServiceFollowup", param);
grdPostServiceFollowup.DataSource = ds;
grdPostServiceFollowup.DataBind();
Session["PostServiceFollowup"] = ds;
lbltotalCustomer.Text = ds.Tables[0].Rows.Count.ToString();
}
// ddlWFPolicyMasterCode
protected void ddlWFPolicyMasterCode_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlDataReader dr = null;
// Data load in ddlchargoutNo
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char, 8), //1
};
param[0].Value = Session["DealerCode"].ToString(); // 0
param[1].Value = ddlWFPolicyMasterCode.SelectedValue.Trim();
ds = sysFuncs.FillDataSet("SP_WFPolicyMaster_WFSelect", param);
// Showing Data in Text Field through DropDownLIST
if (ds.Tables[0].Rows.Count > 0)
{
txtPolicyDesc.Text = ds.Tables[0].Rows[0]["WFPolicyMasterDesc"].ToString().Trim();
ddlSolution.SelectedValue = ds.Tables[0].Rows[0]["Solution_Code"].ToString().Trim();
ddlPolicyType.SelectedValue = ds.Tables[0].Rows[0]["PolicyType"].ToString().Trim();
ddlStatus.SelectedValue = ds.Tables[0].Rows[0]["Status"].ToString().Trim();
txtStartDate.Text = ds.Tables[0].Rows[0]["PolicyStartDate"].ToString().Trim();
txtEndDate.Text = ds.Tables[0].Rows[0]["PolicyEndDate"].ToString().Trim();
txtComment.Text = ds.Tables[0].Rows[0]["Comments"].ToString().Trim();
gv_WFPolicy.DataSource = ds.Tables[0];
gv_WFPolicy.DataBind();
}
else
{
Create_Grid();
return;
}
Session["WFPolicyDS"] = ds;
}
public void GetRefundDetail(string item)
{
SqlParameter[] dsMasterParam = { new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@RefundNo", SqlDbType.Char, 8), };
dsMasterParam[0].Value = Session["DealerCode"].ToString();
dsMasterParam[1].Value = item;
DataSet dsJobCardMaster = new DataSet();
dsJobCardMaster = SysFunc.FillDataSet("sp_PaymentRefund_Detail", dsMasterParam);
if (dsJobCardMaster.Tables[0].Rows.Count > 0)
{
if (dsJobCardMaster.Tables[0].Rows[0]["RefundType"].ToString() == "Customer")
{
RbtnType.SelectedValue = "Customer";
lblType.Text = "Customer";
}
else
{
RbtnType.SelectedValue = "Vendor";
lblType.Text = "Vendor";
}
txtCusVenCode.Text = dsJobCardMaster.Tables[0].Rows[0]["VoucherNo"].ToString();
txtCusVenCode.Text = dsJobCardMaster.Tables[0].Rows[0]["CusCode"].ToString();
txtCUSVen.Text = dsJobCardMaster.Tables[0].Rows[0]["CusDesc"].ToString();
txtRefundDate.Text = dsJobCardMaster.Tables[0].Rows[0]["RDate"].ToString();
txtins_amount.Text = dsJobCardMaster.Tables[0].Rows[0]["InsAmount"].ToString();
ddlpayment_mode.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["PayModeCode"].ToString();
txtinstrument_no.Text = dsJobCardMaster.Tables[0].Rows[0]["InsNo"].ToString();
txtinstrument_date.Text = SysFuncs.GetDate(dsJobCardMaster.Tables[0].Rows[0]["InsDate"].ToString());
ddlbank.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BankCode"].ToString().Trim();
txtbranch.Text = dsJobCardMaster.Tables[0].Rows[0]["Branch"].ToString();
txtInvType.Text = dsJobCardMaster.Tables[0].Rows[0]["ReceiptType"].ToString();
txtBalance.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceBalanceAmount"].ToString();
txtAdvReceiptNo.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceCode"].ToString();
ddlReceiptNo.Visible = false;
txtAdvReceiptNo.Visible = true;
btnAdjAmt.Enabled = false;
btn_save.Enabled = false;
}
}
private void DisplayItem()
{
DataSet ds = new DataSet();
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@ItemCode", SqlDbType.Char),
new SqlParameter("@IssueNo", SqlDbType.Char)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPartsNo.SelectedValue.ToString();
param[2].Value = ddlIssueNo.SelectedValue.ToString();
ds = SysFunc.FillDataSet("sp_StockReturn_Part_Select", param);
txtPartItemDesc.Text = ds.Tables[0].Rows[0]["ItemDesc"].ToString();
txtPartItemNo.Text = ds.Tables[0].Rows[0]["PartItemNo"].ToString();
txtLocCode.Text = ds.Tables[0].Rows[0]["PartsTransLocCode"].ToString();
txtLocDesc.Text = ds.Tables[0].Rows[0]["PartsTransLocDesc"].ToString();
txtUnitCode.Text = ds.Tables[0].Rows[0]["UnitCode"].ToString();
txtUnit.Text = ds.Tables[0].Rows[0]["UnitDesc"].ToString();
txtIssueQty.Text = ds.Tables[0].Rows[0]["IssueQty"].ToString();
txtIssueRate.Text = ds.Tables[0].Rows[0]["Rate"].ToString();
txtRemaining.Text = (Convert.ToDouble(txtIssueQty.Text) - Convert.ToDouble(ds.Tables[0].Rows[0]["RetQty"].ToString())).ToString();
ds = SysFunc.PartStock(ddlPartsNo.SelectedValue.ToString().Trim(), Session["DealerCode"].ToString(), txtLocCode.Text);
txtTotalStock.Text = ds.Tables[0].Rows[0]["Balance"].ToString();
ds = SysFunc.PartStockAtLoaction(ddlPartsNo.SelectedValue.ToString().Trim(), Session["DealerCode"].ToString(), txtLocCode.Text);
txtStockLoc.Text = ds.Tables[0].Rows[0]["Balance"].ToString();
}
catch (Exception ex)
{
LbErr.Text = ex.Message;
}
}
protected void btnCheck_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
// Data load in ddlchargoutNo
SqlParameter[] param =
{
new SqlParameter("@PartNo", SqlDbType.VarChar, 50), //0
new SqlParameter("@PartDesc", SqlDbType.VarChar, 100), //1
new SqlParameter("@Source", SqlDbType.VarChar, 10), //2
new SqlParameter("@qty", SqlDbType.Int), //3
};
param[0].Value = txtPartNo.Text; // 0
param[1].Value = txtPartDesc.Text;
param[2].Value = txtSource.Text; // 0
param[3].Value = txtQty.Text;
DataSet ds = new DataSet();
ds = sysFuncs.FillDataSet("SP_OnlinePartCheck", param);
gv_DC.DataSource = ds;
gv_DC.DataBind();
}
private void LoadGrid(string DCNumber, string PONumber, string DealerCode)
{
DataTable dtParts = new DataTable();
DataTable dt = new DataTable();
DataSet dsParts = new DataSet();
SqlDataReader dr = null;
string mPONo = "";
string mDCNo = "";
if (PONumber == "")
{
mPONo = Session["PONumber"].ToString();
}
else
{
mPONo = PONumber;
}
if (DCNumber == "")
{
mDCNo = Session["DCNumber"].ToString();
}
else
{
mDCNo = DCNumber;
}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@PONO", SqlDbType.Char, 10)
};
param[0].Value = this.Session["DealerCode"].ToString();
param[1].Value = mPONo;
myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr);
dtParts.Load(dr);
//ds = (DataSet)ViewState["ObjPOds"];
dt = (DataTable)this.Session["DCTable"];
dt.Rows.Clear();
if (dtParts.Rows.Count != 0)
{
foreach (DataRow dRow in dtParts.Rows)
{
SqlParameter[] paramPO_Parts =
{
new SqlParameter("@PONO", SqlDbType.Char, 10),
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@ItemCode", SqlDbType.Char, 10)
};
paramPO_Parts[0].Value = mPONo;
paramPO_Parts[1].Value = this.Session["DealerCode"].ToString();
paramPO_Parts[2].Value = dRow["ItemCode"].ToString();
dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo_New", paramPO_Parts);
DataRow row = dt.NewRow();
row["Sno"] = dt.Rows.Count + 1;
row["PartItemNo"] = dsParts.Tables[0].Rows[0]["PartItemNo"].ToString();
row["PartItemName"] = dsParts.Tables[0].Rows[0]["ItemDesc"].ToString();
row["unit"] = dsParts.Tables[0].Rows[0]["Unit"].ToString();
row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString();
row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
//row["Selected"] = true;
dt.Rows.Add(row);
}
}
Session["DCTable"] = dt;
gv_DC.DataSource = dt;
gv_DC.DataSourceID = null;
gv_DC.DataBind();
}
catch (Exception ex)
{
//ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo);
}
}
public void ViewData()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string sql = "exec SP_Select_PPRMaster '" + Session["DealerCode"].ToString() + "','" + ddlPRNo.SelectedValue + "'";
dt = sysFunc.GetData(sql);
txtJobCode.Text = dt.Rows[0]["JobCardCode"].ToString();
txtJobCardDate.Text = dt.Rows[0]["PPRDate"].ToString(); //Convert.ToDateTime(sysFuncs.GetStringValuesAgainstCodes("JobCardCode", ddljob_code.SelectedValue, "RecDate", "JobCardMaster")).ToString("dd/MM/yyyy");
txtPPRTotalAmount.Text = dt.Rows[0]["TotalAmount"].ToString();
txtRegNo.Text = dt.Rows[0]["VehRegNo"].ToString();
txtChasisNo.Text = dt.Rows[0]["VehChassisNo"].ToString();
txtEngNo.Text = dt.Rows[0]["VehEngineNo"].ToString();
txtVehModel.Text = Convert.ToDateTime(dt.Rows[0]["InvoiceDate"].ToString()).ToString("yyyy");
txtInvoiceNo.Text = dt.Rows[0]["InvoiceNo"].ToString();
txtInvDate.Text = Convert.ToDateTime(dt.Rows[0]["InvoiceDate"].ToString()).ToString("dd/MM/yyyy");
//txtDealerCode.Text = dt.Rows[0]["SaleDealerCode"].ToString();
//txtDealerName.Text = dt.Rows[0]["SaleDealerName"].ToString();
txtProdCode.Text = dt.Rows[0]["ProdCode"].ToString();
txtVehColor.Text = dt.Rows[0]["Color"].ToString();
txtKM.Text = dt.Rows[0]["MeterReadingKM"].ToString();
if (dt.Rows[0]["CompletionDate"].ToString() != "")
{
dtComplitionDate.Text = sysFunc.GetDate(dt.Rows[0]["CompletionDate"]); //Convert.ToDateTime(Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(6, 4) + "/" + Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(3, 2) + "/" + Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(0, 2)); //Convert.ToDateTime(Convert.ToDateTime(gvr.Cells[4].Text).ToString("yyyy-MM-dd"));
}
dtProblemDate.Text = sysFunc.GetDate(dt.Rows[0]["DateOfProblem"]); //Convert.ToDateTime(Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(6, 4) + "/" + Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(3, 2) + "/" + Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(0, 2)); //Convert.ToDateTime(Convert.ToDateTime(gvr.Cells[4].Text).ToString("yyyy-MM-dd"));
txtCustCode.Text = dt.Rows[0]["CusCode"].ToString();
txtCustName.Text = dt.Rows[0]["UserName"].ToString();
txtUserName.Text = dt.Rows[0]["UserName"].ToString().Trim();
txtUserAddress.Text = dt.Rows[0]["UserAddress1"].ToString();
txtPhoneNo.Text = dt.Rows[0]["UserPhoneNo"].ToString();
ddlRoadCond.SelectedValue = dt.Rows[0]["RoadCondition"].ToString().Trim();
txtAprovalDate.Text = dt.Rows[0]["ApprovalDate"].ToString();
txtAprovalNo.Text = dt.Rows[0]["ApprovalNo"].ToString();
txtComplainRemarks.Text = dt.Rows[0]["ComplainRemarks"].ToString();
txtTRDate.Text = dt.Rows[0]["TRDate"].ToString();
txtTRNo.Text = dt.Rows[0]["TRNo"].ToString();
if (dt.Rows[0]["ApprovalStatus"].ToString() == "")
{
ddlAppSt.SelectedIndex = 0;
}
else
{
ddlAppSt.SelectedValue = dt.Rows[0]["ApprovalStatus"].ToString().Trim();
}
DataSet dsPPRDetail = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@PPRCode", SqlDbType.Char, 8),
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPRNo.SelectedValue;
dsPPRDetail = sysFuncs.FillDataSet("sp_2W_Service_Select_PPRDetail", param);
ddlComplains.SelectedValue = dsPPRDetail.Tables[0].Rows[0]["ComplainCode"].ToString();
txtCompletionDesc.Text = dsPPRDetail.Tables[0].Rows[0]["ComplaintDesc"].ToString();
ddlDefect.SelectedValue = dsPPRDetail.Tables[0].Rows[0]["DefectCode"].ToString();
txtLaborDesc.Text = dsPPRDetail.Tables[0].Rows[0]["LabourDesc"].ToString();
txtLaborAmount.Text = dsPPRDetail.Tables[0].Rows[0]["LabourRate"].ToString();
txtRootCauseFailure.Text = dsPPRDetail.Tables[0].Rows[0]["RootCauseFailure"].ToString();
txtCorrectiveAction.Text = dsPPRDetail.Tables[0].Rows[0]["CorrectiveAction"].ToString();
dsParts = new DataSet();
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@PPRCode", SqlDbType.Char, 8),
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = ddlPRNo.SelectedValue;
sql = "SELECT VendorCode FROM PPRPartsDetail WHERE PPRCode = '" + ddlPRNo.SelectedValue + "' AND DealerCode = '" + Session["DealerCode"].ToString() + "'";
dt = sysFunc.GetData(sql);
if (dt.Rows.Count > 0)
{
ddlVendor.SelectedValue = dt.Rows[0]["VendorCode"].ToString().Trim();
}
dsParts = sysFuncs.FillDataSet("sp_2W_Service_Select_PPRPartsDetail", param1);
if (dsParts.Tables[0].Rows.Count > 0)
{
LoadGrid();
}
}
private void LoadGrid(string DCNumber, string PONumber, string DealerCode)
{
DataTable dtParts = new DataTable();
DataSet ds = new DataSet();
DataSet dsParts = new DataSet();
SqlDataReader dr = null;
string mPONo = "";
string mDCNo = "";
if (PONumber == "")
{
mPONo = this.Session["PONumber"].ToString();
}
else
{
mPONo = PONumber;
}
//if (DCNumber == "")
//{
// mDCNo = this.Session["DCNumber"].ToString();
//}
//else
//{
// mDCNo = DCNumber;
//}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@PONO", SqlDbType.Char, 10)
};
param[0].Value = this.Session["DealerCode"].ToString();
param[1].Value = mPONo;
myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr);
dtParts.Load(dr);
//ds = (DataSet)ViewState["ObjPOds"];
ds = (DataSet)this.Session["DCDataSet"];
ds.Tables["DCItems"].Rows.Clear();
if (dtParts.Rows.Count != 0)
{
foreach (DataRow dRow in dtParts.Rows)
{
SqlParameter[] paramPO_Parts =
{
new SqlParameter("@PONO", SqlDbType.Char, 10),
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@ItemCode", SqlDbType.Char, 10)
};
paramPO_Parts[0].Value = mPONo;
paramPO_Parts[1].Value = this.Session["DealerCode"].ToString();
paramPO_Parts[2].Value = dRow["ItemCode"].ToString();
dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts);
DataRow row = ds.Tables["DCItems"].NewRow();
row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1;
row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item");
row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item");
row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc");
row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString();
row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
if (DCNumber == "")
{
row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
}
else
{
row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString());
}
row["Selected"] = true;
ds.Tables["DCItems"].Rows.Add(row);
}
//if (GridViewDC.VisibleRowCount > 0)
//{
// CheckBox chkSelect;
// TextBox txtDCQty;
// Label lblBalQty;
// foreach (GridViewRow gvr in GridViewDC.Rows)
// {
// chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect");
// txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity");
// lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity");
// chkSelect.Checked = true;
// txtDCQty.Text = lblBalQty.Text;
// //chkSelect.Enabled = false;
// }
//}
//txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString();
//txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString();
}
Session["DCDataSet"] = ds;
GridViewDC.DataSource = ds.Tables["DCItems"];
GridViewDC.DataSourceID = null;
GridViewDC.DataBind();
}
catch (Exception ex)
{
//ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo);
}
}
protected void txtCustomer_TextChanged(object sender, EventArgs e)
{
if (txtCustomer.Text == "" && txtCellNo.Text == "" && txtCNIC.Text == "" && txtNTN.Text == "" && txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "")
{
sysfun.UserMsg(lblMsg, Color.Red, "Type Something For Search", txtCustomer);
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@CusCode", SqlDbType.VarChar, 50), //1
new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //2
new SqlParameter("@NIC", SqlDbType.VarChar, 15), //3
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 50), //4
new SqlParameter("@EngineNo", SqlDbType.VarChar, 50), //5
new SqlParameter("@Regno", SqlDbType.VarChar, 20), //6
new SqlParameter("@Product", SqlDbType.VarChar, 20) //7
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtCustomer.Text.Trim();
param[2].Value = txtCellNo.Text.Trim();
param[3].Value = txtCNIC.Text.Trim();
param[4].Value = txtChasisNo.Text.Trim();
param[5].Value = txtEngineNo.Text.Trim();
param[6].Value = txtRegno.Text.Trim();
param[7].Value = txtProduct.Text.Trim();
#region Comment
//sQuery = "Select B.CusDesc Customer , B.CellNo ,A.ChassisNo , A.EngineNo , A.RegNo , V.ProdDesc ProdCode from Customer B " +
// "inner join CustomerVehicle A on A.CusCode = B.CusCode and A.DealerCode = B.DealerCode " +
// "inner join Vehicle V on A.DealerCode = V.DealerCode and A.ProdCode = V.ProdCode " +
// " where B.DealerCode = '" + Session["DealerCode"].ToString() + "' ";
//if (txtCellNo.Text.Trim() != string.Empty)
//{
// param[0].Value = txtCellNo.Text.Trim();
// //sQuery = sQuery + " and CellNo like '%" + txtCellNo.Text.Trim() + "%'";
//}
//else
//{
// param[1].Value = "";
//}
//if (txtCustomer.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and (B.CusDesc like '%" + txtCustomer.Text.Trim() + "%' or B.CusCode like '%" + txtCustomer.Text.Trim() + "%' )";
//}
//if (txtCNIC.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and B.NIC like '%" + txtCNIC.Text.Trim() + "%' ";
//}
//if (txtNTN.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and B.NTNNo like '%" + txtNTN.Text.Trim() + "%' ";
//}
//if (txtChasisNo.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.ChassisNo like '%" + txtChasisNo.Text.Trim() + "%' ";
//}
//if (txtEngineNo.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.EngineNo like '%" + txtEngineNo.Text.Trim() + "%' ";
//}
//if (txtRegno.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and A.RegNo like '%" + txtRegno.Text.Trim() + "%' ";
//}
//if (txtProduct.Text.Trim() != string.Empty)
//{
// //sQuery = sQuery + " and (V.ProdDesc like '%" + txtProduct.Text.Trim() + "%' or V.ProdCode like '%" + txtProduct.Text.Trim() + "%') ";
//}
#endregion
DataSet ds = new DataSet();
try
{
ds = sysfuns.FillDataSet("SP_CustomerVehicleSearch", param);
gvCusVeh.DataSource = ds.Tables[0]; gvCusVeh.DataBind(); ViewState["Cusveh"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_JobCardSearch", param);
gvJobCard.DataSource = ds.Tables[0]; gvJobCard.DataBind(); ViewState["JobCard"] = ds.Tables[0];
if (txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "")
{
ds = sysfuns.FillDataSet("SP_CounterSaleSearch", param);
gvCounterSale.DataSource = ds.Tables[0]; gvCounterSale.DataBind(); ViewState["CounterSale"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_PaymentReceiptSearch", param);
gvPaymentReceipt.DataSource = ds.Tables[0]; gvPaymentReceipt.DataBind(); ViewState["PaymentReceipt"] = ds.Tables[0];
ds = sysfuns.FillDataSet("SP_BalanceAmountSearch", param);
gvBalanceAmount.DataSource = ds.Tables[0]; gvBalanceAmount.DataBind(); ViewState["BalAmt"] = ds.Tables[0];
if (ds.Tables[0].Rows.Count < 1)
{
return;
}
if (ds.Tables[0].Rows[0]["CustomerOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["InsuranceOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["DirectSale"].ToString() != "")
{
object sumCustOut, sumInsOut, sumDirectSale;
sumCustOut = ds.Tables[0].Compute("Sum(CustomerOustanding)", string.Empty);
sumInsOut = ds.Tables[0].Compute("Sum(InsuranceOustanding)", string.Empty);
sumDirectSale = ds.Tables[0].Compute("Sum(DirectSale)", string.Empty);
double sum = Convert.ToDouble(sumCustOut) + Convert.ToDouble(sumInsOut) + Convert.ToDouble(sumDirectSale);
lblCusOut.Text = sumCustOut.ToString();
lblInsOut.Text = sumInsOut.ToString();
lblDirectSales.Text = sumDirectSale.ToString();
lblTotalAmount.Text = sum.ToString();
}
}
}
catch (Exception ex)
{
sysfun.UserMsg(lblMsg, Color.Red, ex.Message);
return;
}
}
