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;
}
}
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;
}
}
protected void SelectedPartDetail(string item)
{
try
{
if (ViewState["lookupid"].ToString() == "73")
{
txtExtno.Text = item;
txtLossNo.Text = SysFunc.GetStringValuesAgainstCodes("CustomerEstimateCode='" + txtExtno.Text + "' and DealerCode='" + Session["DealerCode"].ToString() + "'", "CustomerEstimateMaster", "LossNo");
string lossdate = SysFunc.GetStringValuesAgainstCodes("CustomerEstimateCode='" + txtExtno.Text + "' and DealerCode='" + Session["DealerCode"].ToString() + "'", "CustomerEstimateMaster", "LossDate");
if (lossdate != null && lossdate != "")
{
txtCreateDate.Text = SysFuncs.GetDate(lossdate);
}
}
}
catch (Exception ex)
{
SysFunc.UserMsg(lblMsg, Color.Red, ex.Message);
}
}
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();
}
}