/// <summary> /// To Get Reason For Finance ID /// </summary> /// <param name="ReasonForFinanceID"></param> /// <returns></returns> public ReasonforFinancingBO GetReasonForFinanceID(int ReasonForFinanceID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETDETAIL_REASN_FIN"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("F_FINANCEREASONID", ReasonForFinanceID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ReasonforFinancingBO Boobj = null; ReasonforFinancingList Listobj = new ReasonforFinancingList(); Boobj = new ReasonforFinancingBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("FINANCEREASON"))) { Boobj.FINANCEREASON = dr.GetString(dr.GetOrdinal("FINANCEREASON")); } if (!dr.IsDBNull(dr.GetOrdinal("FINANCEREASONID"))) { Boobj.FINANCEREASONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FINANCEREASONID"))); } } dr.Close(); return(Boobj); }
/// <summary> /// To Get All Reason For Finance /// </summary> /// <param name="financereason"></param> /// <returns></returns> public ReasonforFinancingList GetAllReasonForFinance(string financereason) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GET_ALL_FIN_REASON "; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; if (financereason.ToString() == "") { cmd.Parameters.Add("@FINANCEREASON_", DBNull.Value); } else { cmd.Parameters.Add("@FINANCEREASON_", financereason.ToString()); } cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ReasonforFinancingBO Boobj = null; ReasonforFinancingList Listobj = new ReasonforFinancingList(); while (dr.Read()) { Boobj = new ReasonforFinancingBO(); if (!dr.IsDBNull(dr.GetOrdinal("FINANCEREASONID"))) { Boobj.FINANCEREASONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FINANCEREASONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("FINANCEREASON"))) { Boobj.FINANCEREASON = dr.GetString(dr.GetOrdinal("FINANCEREASON")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { Boobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED")); } Listobj.Add(Boobj); } dr.Close(); return(Listobj); }
/// <summary> /// To Update /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string Update(ReasonforFinancingBO BOobj) { ReasonforFinancingDAL DALobj = new ReasonforFinancingDAL(); //Data pass -to Database Layer try { return(DALobj.Update(BOobj)); } catch { throw; } finally { DALobj = null; } }
/// <summary> /// To Insert /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string Insert(ReasonforFinancingBO BOobj) { ReasonforFinancingDAL DALobj = new ReasonforFinancingDAL(); //Data pass -to Database Layer try { return(DALobj.Insert(BOobj)); } catch (Exception ex) { throw ex; } finally { DALobj = null; } }
/// <summary> /// To fetch details from database and assign to textbox /// </summary> private void GetReasonFoprFinanceDetail() { ReasonforFinancingBLL BLLobj = new ReasonforFinancingBLL(); int ReasonForFinanceID = 0; if (ViewState["FINANCEREASONID"] != null) { ReasonForFinanceID = Convert.ToInt32(ViewState["FINANCEREASONID"]); } ReasonforFinancingBO BOobj = new ReasonforFinancingBO(); BOobj = BLLobj.GetReasonForFinanceID(ReasonForFinanceID); ReasonTextBox.Text = BOobj.FINANCEREASON; ReasonIDTextBox.Text = BOobj.FINANCEREASONID.ToString(); }
/// <summary> /// To Update /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string Update(ReasonforFinancingBO BOobj) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPD_REASON_FIN", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("F_FINANCEREASONID", BOobj.FINANCEREASONID); dcmd.Parameters.Add("F_FINANCEREASON", BOobj.FINANCEREASON); dcmd.Parameters.Add("F_UPDATEDBY", BOobj.CREATEDBY); //return dcmd.ExecuteNonQuery(); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(returnResult); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (ReasonIDTextBox.Text.ToString().Trim() == string.Empty) { ReasonforFinancingBLL BLLobj = new ReasonforFinancingBLL(); try { string uID = Session["USER_ID"].ToString(); ReasonforFinancingBO BOobj = new ReasonforFinancingBO(); BOobj.FINANCEREASON = ReasonTextBox.Text; BOobj.CREATEDBY = Convert.ToInt32(uID); ReasonforFinancingBLL ReasonforFinancingBLLobj = new ReasonforFinancingBLL(); message = ReasonforFinancingBLLobj.Insert(BOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearAll(); BindGrid(true, true); } //BindGrid(true, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Vaccination details added successfully');", true); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } } else if (ReasonIDTextBox.Text.ToString().Trim() != string.Empty) { ReasonforFinancingBLL BLLobj = new ReasonforFinancingBLL(); try { string uID = Session["USER_ID"].ToString(); ReasonforFinancingBO BOobj = new ReasonforFinancingBO(); BOobj.FINANCEREASON = ReasonTextBox.Text; BOobj.FINANCEREASONID = Convert.ToInt32(ReasonIDTextBox.Text); BOobj.CREATEDBY = Convert.ToInt32(uID); ReasonforFinancingBLL ReasonforFinancingBLLobj = new ReasonforFinancingBLL(); message = ReasonforFinancingBLLobj.Update(BOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearAll(); BindGrid(true, true); } //BindGrid(true, true); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Vaccination details added successfully');", true); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }