/// <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; }