//private void CheckReportType()
//{
// try
// {
// if (hdnBorrowerType.Value.ToUpper() == "C")
// {
// lblBtype.Text = "Corporate";
// lblDob.Text = "Date of Eshtablishment";
// divIndividual.Attributes.CssStyle.Add("display", "none");
// divCorporate.Attributes.CssStyle.Add("display", "block");
// divGender.Attributes.CssStyle.Add("display", "none");
// }
// else
// {
// lblBtype.Text = "Individual";
// lblDob.Text = "Date of Birth";
// divIndividual.Attributes.CssStyle.Add("display", "block");
// divCorporate.Attributes.CssStyle.Add("display", "none");
// divGender.Attributes.CssStyle.Add("display", "block");
// }
// }
// catch (Exception ex)
// {
// objMasters.InsertWebsiteLog(Common.TOKEN, "ucReportDebt.aspx.cs", "CheckReportType", "", ex.ToString());
// }
//}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Guid _reportId = Guid.NewGuid();
try
{
#region UserReportReportingType
List<UserReportReportingType> objLReportingType = new List<UserReportReportingType>();
UserReportReportingType objReportingType;
if (chkReportType1.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 1;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType2.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 2;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType3.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 3;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType4.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 4;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType5.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 5;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType6.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 6;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType7.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 7;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType8.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 8;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType9.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 9;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
if (chkReportType10.Checked)
{
objReportingType = new UserReportReportingType();
objReportingType.REPORTID = _reportId;
objReportingType.REPORTINGTYPE = 10;
objReportingType.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objReportingType.STATUS = true;
objLReportingType.Add(objReportingType);
}
#endregion
#region UserReportDetail
UserReportDetail objRequest = new UserReportDetail();
objRequest.ID = _reportId;
objRequest.REPORTID = "R" + Convert.ToString(DateTime.Now.ToString("yyyyMMddHHmmss"));
objRequest.UNIQUEUSERID = objMasters.GenerateCorporateUniqueId(txtBCompanyname.Text.Trim(), Convert.ToDateTime(txtDob.Value.Trim()));
objRequest.REPORTTYPE = 2;
#region Borrower's Details
objRequest.FIRSTNAME = txtBFirstname.Text.Trim();
objRequest.LASTNAME = txtBLastname.Text.Trim();
objRequest.COMPANYNAME = txtBCompanyname.Text.Trim();
objRequest.DOB = Convert.ToDateTime(txtDob.Value.Trim());
objRequest.GENDER = 0;
objRequest.BUSINESSTYPEID = Convert.ToInt32(ddlBusiness.SelectedValue);
objRequest.EMAIL = txtEmail.Text.Trim();
objRequest.MOBILE = txtMobile.Text.Trim();
#endregion
#region Borrower's Address Details
objRequest.ADDRESS = txtBAddress.Text.Trim();
objRequest.PINCODE = txtBPincode.Text.Trim();
objRequest.STATEID = Convert.ToInt32(ddlBState.SelectedValue);
objRequest.CITYID = Convert.ToInt32(ddlBCity.SelectedValue);
#endregion
#region Borrower's ID Details
objRequest.PAN = txtPAN.Text.Trim().ToUpper();
objRequest.SHOPESTABLISHMENT = txtShopEstablishment.Text.Trim().ToUpper();
objRequest.VAT = txtVat.Text.Trim().ToUpper();
objRequest.CST = txtCst.Text.Trim().ToUpper();
#endregion
#region Borrower's Borrowing Details
objRequest.BORROWINGDATE = Convert.ToDateTime(txtBorrowingDate.Value.Trim());
objRequest.BORROWINGAMOUNT = txtBorrowingAmount.Text.Trim();
objRequest.HIDEBORROWINGAMOUNT = chkHideAmount.Checked;
objRequest.BORROWINGDESCRIPTION = txtDescription.Text.Trim();
#endregion
objRequest.ISVERIFIED = 0;
objRequest.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objRequest.STATUS = true;
#endregion
#region Borrower's Other Details
UserReportOtherDetails objOtherDetails = new UserReportOtherDetails();
objOtherDetails.REPORTID = _reportId;
objOtherDetails.COMMERCIALPREMISES = Convert.ToInt32(ddlCommercialPremises.SelectedValue);
objOtherDetails.OPERATESMORETHANONEBANKACCOUNT = Convert.ToInt32(ddlMoreBankAccount.SelectedValue);
objOtherDetails.RESIDENTIALPREMISES = Convert.ToInt32(ddlResidentialPremises.SelectedValue);
objOtherDetails.PREVIOUSPAYMENTBEHAVIOUR = Convert.ToInt32(ddlPaymentBehavior.SelectedValue);
objOtherDetails.LIVINGATPRESENTADDRESS = Convert.ToInt32(ddlLivingAddress.SelectedValue);
objOtherDetails.CHEQUERETURNHABIT = Convert.ToInt32(ddlChequeReturn.SelectedValue);
objOtherDetails.LIVINGWITHFAMILY = Convert.ToInt32(ddlLivingWith.SelectedValue);
//objOtherDetails.FINANCIALWORTHINESS = Convert.ToInt32(ddlFinancialWorthiness.SelectedValue);
//objOtherDetails.SOCIALSTATUS = Convert.ToInt32(ddlSocialStatus.SelectedValue);
objOtherDetails.RELATIONSHIPPERIOD = Convert.ToInt32(ddlRelationshipPeriod.SelectedValue);
objOtherDetails.CREATEDBY = new Guid(Request.Cookies["USERID"].Value);
objOtherDetails.STATUS = true;
#endregion
objReport = new Report();
int _result1 = objReport.InsertUserReportDetails(objRequest);
int _result2 = objReport.InsertUserReportReportingType(objLReportingType);
int _result3 = objReport.InsertUserReportOtherDetails(objOtherDetails);
if (_result1 == 1 && _result2 == 1 && _result3 == 1)
{
SendReportingEmailtoReporter(objRequest);
SendReportingEmailtoBorrower(objRequest);
Response.Redirect("~/thank-you/report-debt.aspx", false);
}
else
{
lblMsg.Text = "Oops! Seems like there is some problem while reporting.";
}
}
catch (Exception ex)
{
objMasters.InsertWebsiteLog(Common.TOKEN, "ucReportDebt.aspx.cs", "btnSubmit_Click", "", ex.ToString());
}
}
public int InsertUserReportOtherDetails(UserReportOtherDetails objRequest)
{
int result = -1;
try
{
SqlParameter[] sqlParams = new SqlParameter[13];
sqlParams[0] = new SqlParameter("@REPORTID", SqlDbType.UniqueIdentifier);
sqlParams[0].Value = objRequest.REPORTID;
sqlParams[1] = new SqlParameter("@COMMERCIALPREMISES", SqlDbType.Int);
sqlParams[1].Value = objRequest.COMMERCIALPREMISES;
sqlParams[2] = new SqlParameter("@OPERATESMORETHANONEBANKACCOUNT", SqlDbType.Int);
sqlParams[2].Value = objRequest.OPERATESMORETHANONEBANKACCOUNT;
sqlParams[3] = new SqlParameter("@RESIDENTIALPREMISES", SqlDbType.Int);
sqlParams[3].Value = objRequest.RESIDENTIALPREMISES;
sqlParams[4] = new SqlParameter("@PREVIOUSPAYMENTBEHAVIOUR", SqlDbType.Int);
sqlParams[4].Value = objRequest.PREVIOUSPAYMENTBEHAVIOUR;
sqlParams[5] = new SqlParameter("@LIVINGATPRESENTADDRESS", SqlDbType.Int);
sqlParams[5].Value = objRequest.LIVINGATPRESENTADDRESS;
sqlParams[6] = new SqlParameter("@CHEQUERETURNHABIT", SqlDbType.Int);
sqlParams[6].Value = objRequest.CHEQUERETURNHABIT;
sqlParams[7] = new SqlParameter("@LIVINGWITHFAMILY", SqlDbType.Int);
sqlParams[7].Value = objRequest.LIVINGWITHFAMILY;
//sqlParams[8] = new SqlParameter("@FINANCIALWORTHINESS", SqlDbType.Int);
//sqlParams[8].Value = objRequest.FINANCIALWORTHINESS;
//sqlParams[9] = new SqlParameter("@SOCIALSTATUS", SqlDbType.Int);
//sqlParams[9].Value = objRequest.SOCIALSTATUS;
sqlParams[8] = new SqlParameter("@RELATIONSHIPPERIOD", SqlDbType.Int);
sqlParams[8].Value = objRequest.RELATIONSHIPPERIOD;
sqlParams[9] = new SqlParameter("@CREATEDBY", SqlDbType.UniqueIdentifier);
sqlParams[9].Value = objRequest.CREATEDBY;
sqlParams[10] = new SqlParameter("@STATUS", SqlDbType.Bit);
sqlParams[10].Value = objRequest.STATUS;
result = CExecuteNonQuery("USP_INSERTREPORTOTHERDETAILS", sqlParams);
}
catch (Exception ex)
{
InsertWebsiteLog(Common.TOKEN, "Report.cs", "InsertUserReportOtherDetails", JsonConvert.SerializeObject(objRequest), ex.ToString());
}
return result;
}
