protected void btnLoanUpdate_Click(object sender, EventArgs e)
{
string errMsg = "";
LoanDetailsProperty objLoanDetailsProperty = new LoanDetailsProperty();
objLoanDetailsProperty.LoanId = Convert.ToInt16(hdnLoanId.Value);
objLoanDetailsProperty.BankId = Convert.ToInt16(Request.QueryString["BankId"]);
objLoanDetailsProperty.Eligibilty = txtEligibiltyUp.Text.Trim();
objLoanDetailsProperty.StudyPlaceId = Convert.ToInt16(ddlLoanCategory.SelectedValue);
objLoanDetailsProperty.LoanRangeId = Convert.ToInt16(ddlLoanRange.SelectedValue);
objLoanDetailsProperty.Security = txtSecurityUp.Text.Trim();
objLoanDetailsProperty.RateOfInterest = txtRoi.Text.Trim();
objLoanDetailsProperty.Margin = txtMarginUp.Text.Trim();
objLoanDetailsProperty.ProcessingFees = txtFeesUp.Text.Trim();
objLoanDetailsProperty.ProcessingTime = txtPTimeUp.Text.Trim();
objLoanDetailsProperty.Remark = txtRemarkUp.Text.Trim();
objLoanDetailsProperty.RepaymentDuration = txtRepayentUP.Text.Trim();
int result1 = BankProvider.Instance.UpdateLoanInfo(objLoanDetailsProperty, LoggedInUserId, out errMsg);
if (result1 > 0)
{
BindLoanDetails(Request.QueryString["BankId"]);
lblSuccess.Visible = true;
lblSuccess.Text = errMsg;
}
else
{
lblInform.Visible = true;
lblInform.Text = errMsg;
}
}
private List <LoanDetailsProperty> BindLoanList(DataTable datatable)
{
var objLoanList = new List <LoanDetailsProperty>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objLoanListProperty = new LoanDetailsProperty
{
BankId = (datatable.Rows[j]["AjBankId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjBankId"]),
LoanId = (datatable.Rows[j]["AjLoanId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjLoanId"]),
LoanRangeId = (datatable.Rows[j]["AjLoanRangeId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjLoanRangeId"]),
StudyPlaceId = (datatable.Rows[j]["AjStudyPlaceId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjStudyPlaceId"]),
Eligibilty = (datatable.Rows[j]["AjEligibilty"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjEligibilty"]),
Security = (datatable.Rows[j]["AjSecurity"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjSecurity"]),
RepaymentDuration = (datatable.Rows[j]["AjRepaymentDuration"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRepaymentDuration"]),
Remark = (datatable.Rows[j]["AjRemark"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRemark"]),
RateOfInterest = (datatable.Rows[j]["AjRateOfInterest"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRateOfInterest"]),
ProcessingFees = (datatable.Rows[j]["AjProcessingFees"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjProcessingFees"]),
ProcessingTime = (datatable.Rows[j]["AjProcessingTime"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjProcessingTime"]),
Margin = (datatable.Rows[j]["AjMargin"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjMargin"]),
Amount = (datatable.Rows[j]["AjAmount"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjAmount"]),
StudyPlaceName = (datatable.Rows[j]["AjStudyPlaceName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjStudyPlaceName"])
};
objLoanList.Add(objLoanListProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindBankList in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objLoanList);
}
public override int UpdateLoanInfo(LoanDetailsProperty objLoanDetailsProperty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@LoanId", objLoanDetailsProperty.LoanId);
_objDataWrapper.AddParameter("@BankId", objLoanDetailsProperty.BankId);
_objDataWrapper.AddParameter("@LoanRangeId", objLoanDetailsProperty.LoanRangeId);
_objDataWrapper.AddParameter("@StudyPlaceId", objLoanDetailsProperty.StudyPlaceId);
_objDataWrapper.AddParameter("@Eligibilty", objLoanDetailsProperty.Eligibilty);
_objDataWrapper.AddParameter("@Security", objLoanDetailsProperty.Security);
_objDataWrapper.AddParameter("@Margin", objLoanDetailsProperty.Margin);
_objDataWrapper.AddParameter("@ProcessingFees", objLoanDetailsProperty.ProcessingFees);
_objDataWrapper.AddParameter("@ProcessingTime", objLoanDetailsProperty.ProcessingTime);
_objDataWrapper.AddParameter("@RateOfInterest", objLoanDetailsProperty.RateOfInterest);
_objDataWrapper.AddParameter("@Remark", objLoanDetailsProperty.Remark);
_objDataWrapper.AddParameter("@RepaymentDuration", objLoanDetailsProperty.RepaymentDuration);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateLoanInfoDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errmsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateLoanInfo in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
LoanDetailsProperty objLoanDetailsProperty = new LoanDetailsProperty();
int result;
int bankId;
string errMsg;
var objBankDetailsProperty = new BankDetailsProperty
{
BankName = txtBankName.Text.Trim(),
BankShortName = txtBankShortName.Text.Trim(),
BankAddress = txtBankAddress.Text.Trim(),
BankShortDescription = fckBankDesc.FckValue,
BankPhoneNo = txtBankPhone.Text.Trim(),
BankUrl = txtBankUrl.Text.Trim(),
BankContactPerson = txtContactPerson.Text.Trim(),
BankContactPersonDesignation = txtContactDesignation.Text.Trim(),
BankContactPersonEmailId = txtContactEmailId.Text.Trim(),
BankContactPersonMobile = txtContactMobile.Text.Trim(),
BankLogo = hdnFileName.Value
};
if (btnAdd.Text == "Save")
{
result = BankProvider.Instance.InsertBankInfo(objBankDetailsProperty, LoggedInUserId, out errMsg, out bankId);
if (result > 0)
{
objLoanDetailsProperty.BankId = bankId;
objLoanDetailsProperty.Eligibilty = txtEligibilty.Text.Trim();
objLoanDetailsProperty.StudyPlaceId = Convert.ToInt16(ddlCategory1.SelectedValue) != 0?Convert.ToInt16(ddlCategory1.SelectedValue):0;
objLoanDetailsProperty.LoanRangeId = Convert.ToInt16(ddlLoanRange1.SelectedValue) != 0 ? Convert.ToInt16(ddlLoanRange1.SelectedValue) : 0;
objLoanDetailsProperty.Security = txtSecurity.Text.Trim();
objLoanDetailsProperty.RateOfInterest = txtRateOfInterest.Text.Trim();
objLoanDetailsProperty.Margin = txtMargin.Text.Trim();
objLoanDetailsProperty.ProcessingFees = txtProcessingFee.Text.Trim();
objLoanDetailsProperty.ProcessingTime = txtProcessingTime.Text.Trim();
objLoanDetailsProperty.Remark = txtRemark.Text.Trim();
objLoanDetailsProperty.RepaymentDuration = txtRepaymentDuration.Text.Trim();
int result1 = BankProvider.Instance.InsertLoanInfo(objLoanDetailsProperty, LoggedInUserId, out errMsg);
objLoanDetailsProperty.StudyPlaceId = Convert.ToInt16(ddlCategory2.SelectedValue) != 0 ? Convert.ToInt16(ddlCategory2.SelectedValue) : 0;
objLoanDetailsProperty.LoanRangeId = Convert.ToInt16(ddlLoanRange2.SelectedValue) != 0 ? Convert.ToInt16(ddlLoanRange2.SelectedValue) : 0;
objLoanDetailsProperty.Security = txtSecurity1.Text.Trim();
objLoanDetailsProperty.RateOfInterest = txtRateOfInterest1.Text.Trim();
objLoanDetailsProperty.Margin = txtMargin1.Text.Trim();
objLoanDetailsProperty.ProcessingFees = txtProcessingFee1.Text.Trim();
objLoanDetailsProperty.ProcessingTime = txtProcessingTime1.Text.Trim();
objLoanDetailsProperty.Remark = txtRemark1.Text.Trim();
objLoanDetailsProperty.RepaymentDuration = txtRepaymentDuration1.Text.Trim();
int result2 = BankProvider.Instance.InsertLoanInfo(objLoanDetailsProperty, LoggedInUserId, out errMsg);
objLoanDetailsProperty.StudyPlaceId = Convert.ToInt16(ddlCategory3.SelectedValue) != 0 ? Convert.ToInt16(ddlCategory3.SelectedValue) : 0;
objLoanDetailsProperty.LoanRangeId = Convert.ToInt16(ddlLoanRange3.SelectedValue) != 0 ? Convert.ToInt16(ddlLoanRange3.SelectedValue) : 0;
objLoanDetailsProperty.Security = txtSecurity2.Text.Trim();
objLoanDetailsProperty.RateOfInterest = txtRateOfInterest2.Text.Trim();
objLoanDetailsProperty.Margin = txtMargin2.Text.Trim();
objLoanDetailsProperty.ProcessingFees = txtProcessingFee2.Text.Trim();
objLoanDetailsProperty.ProcessingTime = txtProcessingTime2.Text.Trim();
objLoanDetailsProperty.Remark = txtRemark2.Text.Trim();
objLoanDetailsProperty.RepaymentDuration = txtRepaymentDuration2.Text.Trim();
int result3 = BankProvider.Instance.InsertLoanInfo(objLoanDetailsProperty, LoggedInUserId, out errMsg);
objLoanDetailsProperty.StudyPlaceId = Convert.ToInt16(ddlCategory4.SelectedValue) != 0 ? Convert.ToInt16(ddlCategory4.SelectedValue) : 0;
objLoanDetailsProperty.LoanRangeId = Convert.ToInt16(ddlLoanRange4.SelectedValue) != 0 ? Convert.ToInt16(ddlLoanRange4.SelectedValue) : 0;
objLoanDetailsProperty.Security = txtSecurity3.Text.Trim();
objLoanDetailsProperty.RateOfInterest = txtRateOfInterest3.Text.Trim();
objLoanDetailsProperty.Margin = txtMargin3.Text.Trim();
objLoanDetailsProperty.ProcessingFees = txtProcessingFee3.Text.Trim();
objLoanDetailsProperty.ProcessingTime = txtProcessingTime3.Text.Trim();
objLoanDetailsProperty.Remark = txtRemark3.Text.Trim();
objLoanDetailsProperty.RepaymentDuration = txtRepaymentDuration3.Text.Trim();
int result4 = BankProvider.Instance.InsertLoanInfo(objLoanDetailsProperty, LoggedInUserId, out errMsg);
Response.Redirect("", true);
}
}
else
{
objBankDetailsProperty.BankId = Convert.ToInt16(Request.QueryString["BankId"]);
result = BankProvider.Instance.UpdateBankInfo(objBankDetailsProperty, LoggedInUserId, out errMsg);
if (result > 0)
{
ClearControl();
btnAdd.Text = "Save";
lblSuccess.Visible = true;
lblSuccess.Text = errMsg;
}
else
{
lblInform.Visible = true;
lblInform.Text = errMsg;
}
}
}
public abstract int UpdateLoanInfo(LoanDetailsProperty objLoanProperty, int createdBy, out string errmsg);
