private void LoadGrid()
{
try
{
control = Convert.ToString(Request.QueryString["Control"]);
_obj_smhr_loanTrans = new SMHR_LOANTRANS();
if (Convert.ToInt32(Session["ORG_ID"]) != null)
{
_obj_smhr_loanTrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if (control != null)
{
_obj_smhr_loanTrans.LOANTRANS_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
}
else
{
_obj_smhr_loanTrans.OPERATION = operation.Select;
}
DataTable dtgrid = BLL.get_EmpLoanDeposits(_obj_smhr_loanTrans);
if (dtgrid.Rows.Count > 0)
{
Rg_Loandeposits.DataSource = dtgrid;
}
else
{
DataTable dt = new DataTable();
Rg_Loandeposits.DataSource = dt;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void rcmb_loanno_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
if (rcmb_loanno.SelectedIndex > 0)
{
_obj_smhr_loanTrans = new SMHR_LOANTRANS();
_obj_smhr_loanTrans.LOANTRANS_ID = Convert.ToInt32(rcmb_loanno.SelectedValue);
_obj_smhr_loanTrans.OPERATION = operation.Select_New;
DataTable dtaccbalance = BLL.get_EmpLoanDeposits(_obj_smhr_loanTrans);
if (dtaccbalance.Rows.Count > 0)
{
rad_AccumulativeBalance.Text = (dtaccbalance.Rows[0]["AccumulativeBalance"].ToString());
rad_AccumulativeBalance.Enabled = false;
}
else
{
rad_AccumulativeBalance.Value = 0;
}
rtxt_Amount.Text = string.Empty;
rad_UpdatedLoanBalance.Text = string.Empty;
}
else
{
rtxt_Amount.Text = string.Empty;
rad_AccumulativeBalance.Text = string.Empty;
rad_UpdatedLoanBalance.Text = string.Empty;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (rad_UpdatedLoanBalance.Text != string.Empty)
{
_obj_smhr_loanTrans = new SMHR_LOANTRANS();
_obj_smhr_loanTrans.LOANTRANS_EMP_ID = Convert.ToInt32(rcmb_EmployeeName.SelectedValue);
_obj_smhr_loanTrans.BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue);
_obj_smhr_loanTrans.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_smhr_loanTrans.LOANTRANS_LOANNO = Convert.ToString(rcmb_loanno.SelectedItem.Text);
_obj_smhr_loanTrans.LOANTRANS_LOANTYPE_ID = Convert.ToInt32(rcmb_loantype.SelectedValue);
_obj_smhr_loanTrans.LOANTRANS_ID = Convert.ToInt32(rcmb_loanno.SelectedValue);
_obj_smhr_loanTrans.LOANTRANS_LOANAMOUNT = Convert.ToDouble(rtxt_Amount.Text);
_obj_smhr_loanTrans.CREATEDDATE = System.DateTime.Now;
//_obj_smhr_loanTrans.CREATEDBY = Convert.ToInt32(Session["EMP_ID"]);
_obj_smhr_loanTrans.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_smhr_loanTrans.UpdatedLoanAmt = Convert.ToDouble(rad_UpdatedLoanBalance.Text);
_obj_smhr_loanTrans.AccumulativeBalance = Convert.ToDouble(rad_AccumulativeBalance.Text);
_obj_smhr_loanTrans.OPERATION = operation.Insert;
if (BLL.set_LoanDeposits(_obj_smhr_loanTrans))
{
BLL.ShowMessage(this, "Record Inserted Successfully");
}
else
{
BLL.ShowMessage(this, "Record Not Inserted");
}
clearControls();
LoadGrid();
Rg_Loandeposits.DataBind();
Rm_LoanDep_page.SelectedIndex = 0;
}
else
{
BLL.ShowMessage(this, "Please Click on Apply Link Button");
return;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public static DataTable get_EmpLoanDeposits(SMHR_LOANTRANS _obj_smhr_loanTrans)
{
try
{
if (_obj_smhr_loanTrans.OPERATION == operation.Get)
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Get', @EMPLOYEEID = '" + _obj_smhr_loanTrans.LOANTRANS_EMP_ID + "'"));
}
else if (_obj_smhr_loanTrans.OPERATION == operation.Check1)
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Check1',@EMPLOYEEID = '" + _obj_smhr_loanTrans.LOANTRANS_EMP_ID + "', @LOANTRANS_LOANTYPE_ID = '" + _obj_smhr_loanTrans.LOANTRANS_LOANTYPE_ID + "'"));
}
else if (_obj_smhr_loanTrans.OPERATION == operation.Select)
{
if (_obj_smhr_loanTrans.LOANTRANS_EMP_ID != 0)
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Select',@EMPLOYEEID = '" + _obj_smhr_loanTrans.LOANTRANS_EMP_ID + "', @OrganisationId = '" + _obj_smhr_loanTrans.ORGANISATION_ID + "'"));
}
else
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Select', @OrganisationId = '" + _obj_smhr_loanTrans.ORGANISATION_ID + "'"));
}
}
else if (_obj_smhr_loanTrans.OPERATION == operation.Select_New)
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Select_New', @LoanTransId = '" + _obj_smhr_loanTrans.LOANTRANS_ID + "'"));
}
else if (_obj_smhr_loanTrans.OPERATION == operation.Check_New)
{
return(ExecuteQuery("EXEC USP_LoanDeposits @Operation = 'Check_New', @DepositsId= '" + _obj_smhr_loanTrans.DepositsId + "'"));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw (ex);
SMHR.BLL.Error_Log(HttpContext.Current.Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "SMHR_KNA_3", ex.StackTrace, DateTime.Now);
HttpContext.Current.Response.Redirect("~/Frm_ErrorPage.aspx");
return(null);
}
}
protected void lnk_View_Command(object sender, CommandEventArgs e)
{
try
{
Rm_LoanDep_page.SelectedIndex = 1;
RPV_Loans.Selected = true;
_obj_smhr_loanTrans = new SMHR_LOANTRANS();
LoadBusinessUint();
// LoadEmployee();
//LoanType();
//Loanno();
_obj_smhr_loanTrans.DepositsId = (Convert.ToInt32(Convert.ToString(e.CommandArgument)));
_obj_smhr_loanTrans.OPERATION = operation.Check_New;
DataTable dtview = BLL.get_EmpLoanDeposits(_obj_smhr_loanTrans);
rcmb_BusinessUnit.Enabled = false;
rcmb_EmployeeName.Enabled = false;
rcmb_loantype.Enabled = false;
rcmb_loanno.Enabled = false;
rtxt_Amount.Enabled = false;
btn_Save.Visible = false;
lnk_Apply.Visible = false;
rdpt_boostdate.Enabled = false;
if (dtview.Rows.Count > 0)
{
rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.FindItemIndexByValue(dtview.Rows[0]["EMP_BUSINESSUNIT_ID"].ToString());
rcmb_EmployeeName.Text = (dtview.Rows[0]["EmployeeName"].ToString());
rcmb_loantype.Text = (dtview.Rows[0]["PAYITEM_PAYITEMNAME"].ToString());
rcmb_loanno.Text = (dtview.Rows[0]["LOANTRANS_LOANNO"].ToString());
rdpt_boostdate.SelectedDate = Convert.ToDateTime(dtview.Rows[0]["DepositDate"]);
rtxt_Amount.Value = Convert.ToDouble(dtview.Rows[0]["DepositAmount"]);
rad_AccumulativeBalance.Value = Convert.ToDouble(dtview.Rows[0]["AccumulativeBal"]);
rad_UpdatedLoanBalance.Value = Convert.ToDouble(dtview.Rows[0]["UpdatedLoanAmt"]);
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoanType()
{
try
{
_obj_smhr_loanTrans = new SMHR_LOANTRANS();
if (rcmb_EmployeeName.SelectedIndex > 0)
{
_obj_smhr_loanTrans.LOANTRANS_EMP_ID = Convert.ToInt32(rcmb_EmployeeName.SelectedValue);
_obj_smhr_loanTrans.OPERATION = operation.Get;
DataTable dt_loantype = BLL.get_EmpLoanDeposits(_obj_smhr_loanTrans);
if (dt_loantype.Rows.Count > 0)
{
rcmb_loantype.DataSource = dt_loantype;
rcmb_loantype.DataTextField = "PAYITEM_PAYITEMNAME";
rcmb_loantype.DataValueField = "PAYITEM_ID";
rcmb_loantype.DataBind();
rcmb_loantype.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
else
{
rcmb_loantype.Items.Clear();
rcmb_loantype.ClearSelection();
rcmb_loantype.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
rcmb_loanno.Items.Clear();
rcmb_loanno.Text = string.Empty;
rcmb_loanno.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
rtxt_Amount.Text = string.Empty;
rad_AccumulativeBalance.Text = string.Empty;
rad_UpdatedLoanBalance.Text = string.Empty;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanDeposits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public static bool set_LoanDeposits(SMHR_LOANTRANS _obj_smhr_loanTrans)
{
bool status = false;
if (_obj_smhr_loanTrans.OPERATION == operation.Insert)
{
if (ExecuteNonQuery("EXEC USP_LoanDeposits @Operation ='Insert',@EmpId='" + _obj_smhr_loanTrans.LOANTRANS_EMP_ID +
"',@BusinessUnitId='" + _obj_smhr_loanTrans.BUSINESSUNIT_ID + "',@OrganisationId='" + _obj_smhr_loanTrans.ORGANISATION_ID +
"',@LoanNo='" + _obj_smhr_loanTrans.LOANTRANS_LOANNO + "',@LoanTypeId='" + _obj_smhr_loanTrans.LOANTRANS_LOANTYPE_ID +
"',@LoanTransId='" + _obj_smhr_loanTrans.LOANTRANS_ID + "',@DepositAmount='" + _obj_smhr_loanTrans.LOANTRANS_LOANAMOUNT +
"',@CreatedDate='" + _obj_smhr_loanTrans.CREATEDDATE + "',@CreatedBy='" + _obj_smhr_loanTrans.CREATEDBY +
"',@UpdatedLoanAmt='" + _obj_smhr_loanTrans.UpdatedLoanAmt +
"',@AccumulativeBal='" + _obj_smhr_loanTrans.AccumulativeBalance + "'"))
{
status = true;
}
else
{
status = false;
}
}
return(status);
}
