/// <summary>
/// To Get Loan
/// </summary>
/// <param name="EncumbrancepurposeName"></param>
/// <returns></returns>
public LoanList GetLoan(string EncumbrancepurposeName)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ENCUMBRANCEPURPOSE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (EncumbrancepurposeName.ToString() == "")
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", DBNull.Value);
}
else
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", EncumbrancepurposeName.ToString());
}
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LoanBO objLoan = null;
LoanList Loan = new LoanList();
while (dr.Read())
{
objLoan = new LoanBO();
objLoan.EncumbranceId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ENCUMBRANCEID")));
objLoan.Encumbrancepurpose = dr.GetString(dr.GetOrdinal("ENCUMBRANCEPURPOSE"));
objLoan.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
Loan.Add(objLoan);
}
dr.Close();
return(Loan);
}
/// <summary>
/// To Add Loan
/// </summary>
/// <param name="objLoan"></param>
/// <returns></returns>
public string AddLoan(LoanBO objLoan)
{
string result = "";
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_MST_INS_ENCUMBRANCEPURPOSE", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@ENCUMBRANCEPURPOSENameIN", objLoan.Encumbrancepurpose);
myCommand.Parameters.Add("@ISDELETEDIN", "False");
myCommand.Parameters.Add("@USERIDIN", objLoan.CreatedBy);
myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
myConnection.Open();
myCommand.ExecuteNonQuery();
if (myCommand.Parameters["errorMessage_"].Value != null)
{
result = myCommand.Parameters["errorMessage_"].Value.ToString();
}
myConnection.Close();
return(result);
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GrdPurposeofencumbrance_RowCommand(object sender, GridViewCommandEventArgs e)
{
string message = string.Empty;
if (e.CommandName == "EditRow")
{
ShowHideSections(true, false);
ViewState["ENCUMBRANCEID"] = e.CommandArgument;
LoanBLL objLoanBLL = new LoanBLL();
LoanBO objLoan = objLoanBLL.GetLoanByLoanID(Convert.ToInt32(ViewState["ENCUMBRANCEID"]));
txtPurposeofencumbrance.Text = objLoan.Encumbrancepurpose;
SetUpdateMode(true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true);
}
else if (e.CommandName == "DeleteRow")
{
LoanBLL objLoanBLL = new LoanBLL();
objLoanBLL.DeleteLoan(Convert.ToInt32(e.CommandArgument));
SetUpdateMode(false);
BindGrid();
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data deleted successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
string message = "";
LoanBO objLoan = new LoanBO();
objLoan.EncumbranceId = Convert.ToInt32(ViewState["ENCUMBRANCEID"]);
objLoan.Encumbrancepurpose = txtPurposeofencumbrance.Text.Trim();
LoanBLL objLoanBLL = new LoanBLL();
if (objLoan.EncumbranceId == 0)
{
objLoan.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objLoanBLL.AddLoan(objLoan);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
}
else
{
objLoan.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objLoanBLL.UpdateLoan(objLoan);
// SetUpdateMode(false);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
SetUpdateMode(false);
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearDetails();
BindGrid();
}
/// <summary>
/// To Get Loan By Loan ID
/// </summary>
/// <param name="EncumbranceId"></param>
/// <returns></returns>
public LoanBO GetLoanByLoanID(int EncumbranceId)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ENCPURPOSEBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EncumbranceIDIN", EncumbranceId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LoanBO obLoan = null;
while (dr.Read())
{
obLoan = new LoanBO();
obLoan.EncumbranceId = dr.GetInt32(dr.GetOrdinal("ENCUMBRANCEID"));
obLoan.Encumbrancepurpose = dr.GetString(dr.GetOrdinal("ENCUMBRANCEPURPOSE"));
}
dr.Close();
return(obLoan);
}
protected virtual MasterEmployeeLoanBO FindExistingLoan(MasterDataBO newMasterData, LoanBO loanReference)
{
return(newMasterData.MasterEmployeeLoans
.SingleOrDefault(a => a.LoanID == loanReference.LoanID));
}
/// <summary>
/// To Update Loan
/// </summary>
/// <param name="objLoan"></param>
/// <returns></returns>
public string UpdateLoan(LoanBO objLoan)
{
LoanDAL objLoanDAL = new LoanDAL();
return(objLoanDAL.UpdateLoan(objLoan));
}
/// <summary>
/// To Add Loan
/// </summary>
/// <param name="objLoan"></param>
/// <returns></returns>
public string AddLoan(LoanBO objLoan)
{
LoanDAL objLoanDAL = new LoanDAL();
return(objLoanDAL.AddLoan(objLoan));
}
public LoansController(EmployeeBO employeeBo, LoanBO loanBO, LoanTypeBO loanTypesBO)
{
_employeeBo = employeeBo;
_loanBO = loanBO;
_loanTypesBO = loanTypesBO;
}
public HMOPremiumPayableLoanCmd(IProcessTrackerBase processTracker, MasterDataBO oldMasterData, MasterDataBO newMasterData, LoanBO reference)
: base(processTracker, oldMasterData, newMasterData, reference)
{
Loan = reference;
}
