/// <summary>
/// to fetch details
/// </summary>
/// <returns></returns>
public LivelihoodList GetLivelihood()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETLIVELIHOOD";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LivelihoodBO objLivelihood = null;
LivelihoodList Livelihoods = new LivelihoodList();
while (dr.Read())
{
objLivelihood = new LivelihoodBO();
objLivelihood.Itemid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ITEMID")));
objLivelihood.ITEMNAME = dr.GetString(dr.GetOrdinal("ITEMNAME"));
Livelihoods.Add(objLivelihood);
}
dr.Close();
return(Livelihoods);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private string Insert()
{
string message = string.Empty;
string uID = Session["USER_ID"].ToString();
objLivelihood = new LivelihoodBO();
objLivelihood.ITEMNAME = livelihoodTextBox.Text.ToString();
objLivelihood.Createddate = System.DateTime.Now;
objLivelihood.Isdeleted = "False";
objLivelihood.Createdby = Convert.ToInt32(Session["USER_ID"]);
LivelihoodBLL objLivelihoodBLL = new LivelihoodBLL();
try
{
message = objLivelihoodBLL.AddLivelihood(objLivelihood);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
cleardetails();
}
}
catch (Exception ex)
{
string errorMsg = ex.Message.ToString();
}
finally
{
objLivelihoodBLL = null;
}
return(message);
}
/// <summary>
/// calls method save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
try
{
if (btnSave.Text == "Save")
{
message = Insert();
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
cleardetails();
}
BindGrid(true, true);
}
else
{
string uID = Session["USER_ID"].ToString();
int itemid = Convert.ToInt32(ViewState["ITEMID"]);
objLivelihood = new LivelihoodBO();
objLivelihood.ITEMNAME = livelihoodTextBox.Text.ToString();
objLivelihood.Createdby = Convert.ToInt32(uID);
LivelihoodBLL objLivelihoodBLL = new LivelihoodBLL();
message = objLivelihoodBLL.UpdateLivelihood(objLivelihood, itemid);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
// ClearDetails();
cleardetails();
BindGrid(true, true);
SetUpdateMode(false);
}
//BindGrid(true, true);
//cleardetails();
}
btnSave.Text = "Save";
}
catch (Exception ex)
{
string errorMsg = ex.Message.ToString();
Response.Write(errorMsg);
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
/// <summary>
/// To Update Livelihood
/// </summary>
/// <param name="objLivelihood"></param>
/// <param name="itemid"></param>
/// <returns></returns>
public string UpdateLivelihood(LivelihoodBO objLivelihood, int itemid)
{
LivelihoodDAL objLivelihoodDAL = new LivelihoodDAL();
try
{
return(objLivelihoodDAL.UpdateLivelihood(objLivelihood, itemid));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLivelihood = null;
}
}
/// <summary>
/// To Add Livelihood
/// </summary>
/// <param name="objLivelihood"></param>
/// <returns></returns>
public string AddLivelihood(LivelihoodBO objLivelihood)
{
LivelihoodDAL objLivelihoodDAL = new LivelihoodDAL(); //Data pass -to Database Layer
try
{
return(objLivelihoodDAL.AddLivelihood(objLivelihood));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLivelihoodDAL = null;
}
}
public string AddLivelihood(LivelihoodBO objLivelihood)
{
string returnResult = string.Empty;
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_INSERTLIVELIHOOD", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("L_itemname", objLivelihood.ITEMNAME);
dcmd.Parameters.Add("L_createdby", objLivelihood.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 (Exception ex)
{
throw ex;;
}
finally
{
dcmd.Dispose();
con.Close();
con.Dispose();
}
return(returnResult);
}
