/// <summary>
/// To Get Literacy Status
/// </summary>
/// <returns></returns>
public LiteracyStatusList GetLiteracyStatus()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = " USP_MST_GETLITERACYSTATUS";
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);
LiteracyStatusBO LiteracyStatusBOobj = null;
LiteracyStatusList LiteracyStatusListobj = new LiteracyStatusList();
while (dr.Read())
{
LiteracyStatusBOobj = new LiteracyStatusBO();
if (!dr.IsDBNull(dr.GetOrdinal("LTR_STATUSID")))
{
LiteracyStatusBOobj.LTR_STATUSID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LTR_STATUSID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("LTR_STATUS")))
{
LiteracyStatusBOobj.LTR_STATUS = dr.GetString(dr.GetOrdinal("LTR_STATUS"));
}
LiteracyStatusListobj.Add(LiteracyStatusBOobj);
}
dr.Close();
return(LiteracyStatusListobj);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private string InsertLitStatusDetail()
{
string message = string.Empty;
string uID = Session["USER_ID"].ToString();
LitStatusBoobj = new LiteracyStatusBO();
//Assignement of Data
LitStatusBoobj.LTR_STATUS = txtLiteracyStatus.Text.Trim();
LitStatusBoobj.DESCRIPTION = txtDescription.Text.Trim();
LitStatusBoobj.ISDELETED = "False";
LitStatusBoobj.CREATEDBY = Convert.ToInt32(uID);//By Default Admin
LitStatusBoobj.CREATEDDATE = DateTime.Now;
LiteracyStatusBLL LitStatusBLL = new LiteracyStatusBLL();
try
{
message = LitStatusBLL.Insert(LitStatusBoobj);
}
catch (Exception ee)
{
throw ee;
}
finally
{
LitStatusBLL = null;
}
return(message);
// BindGrid(true, true);
// ClearDetails();
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('LiteracyStatus details added successfully');", true);
}
/// <summary>
/// To call insert method
/// </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;
LiteracyStatusBLL LiteracyStatusBLLobj = null;
try
{
if (btnSave.Text == "Save")
{
message = InsertLitStatusDetail();
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
ClearDetails();
}
BindGrid(true, true);
}
else
{
int litStatusID = Convert.ToInt32(ViewState["LitStatusID"]);
LitStatusBoobj = new LiteracyStatusBO();
LitStatusBoobj.LTR_STATUS = txtLiteracyStatus.Text.ToString();
LitStatusBoobj.DESCRIPTION = txtDescription.Text.ToString();
LitStatusBoobj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
LiteracyStatusBLLobj = new LiteracyStatusBLL();
message = LiteracyStatusBLLobj.Update(LitStatusBoobj, litStatusID);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
btnSave.Text = "Save";
ClearDetails();
SetUpdateMode(false);
}
catch (Exception ee)
{
throw ee;
}
finally
{
LiteracyStatusBLLobj = null;
}
BindGrid(true, false);
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
/// TO Update in Database
/// </summary>
/// <param name="LitStatusBoobj"></param>
/// <param name="litStatusID"></param>
/// <returns></returns>
public string Update(LiteracyStatusBO LitStatusBoobj, int litStatusID)
{
LiteracyStatusDAL LiteracyStatusDALobj = new LiteracyStatusDAL(); //Data pass -to Database Layer
try
{
return(LiteracyStatusDALobj.Update(LitStatusBoobj, litStatusID));
}
catch (Exception ex)
{
throw ex;
}
finally
{
LiteracyStatusDALobj = null;
}
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="LiteracyStatusBOobj"></param>
/// <returns></returns>
public string Insert(LiteracyStatusBO LiteracyStatusBOobj)
{
LiteracyStatusDAL LiteracyStatusDAL = new LiteracyStatusDAL(); //Data pass -to Database Layer
try
{
return(LiteracyStatusDAL.Insert(LiteracyStatusBOobj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
LiteracyStatusDAL = null;
}
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="LiteracyStatusBoobj"></param>
/// <returns></returns>
public string Insert(LiteracyStatusBO LiteracyStatusBoobj)
{
string returnResult = string.Empty;
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_INSERTLITERACYSTATUS", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("LTR_STATUS", LiteracyStatusBoobj.LTR_STATUS);
dcmd.Parameters.Add("DESCRIPTION", LiteracyStatusBoobj.DESCRIPTION);
dcmd.Parameters.Add("createdby", LiteracyStatusBoobj.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);
}
/// <summary>
/// To Update
/// </summary>
/// <param name="LitStatusBoobj"></param>
/// <param name="litStatusID"></param>
/// <returns></returns>
public string Update(LiteracyStatusBO LitStatusBoobj, int litStatusID)
{
string returnResult = string.Empty;
OracleConnection conn = new OracleConnection(AppConfiguration.ConnectionString);
conn.Open();
OracleCommand dCmd = new OracleCommand("USP_MST_UPDATELITERACYSTATUS", conn);
dCmd.CommandType = CommandType.StoredProcedure;
try
{
dCmd.Parameters.Add("L_LTR_STATUSID", litStatusID);
dCmd.Parameters.Add("L_LTR_STATUS", LitStatusBoobj.LTR_STATUS);
dCmd.Parameters.Add("L_DESCRIPTION", LitStatusBoobj.DESCRIPTION);
dCmd.Parameters.Add("L_CREATEDBY", LitStatusBoobj.CREATEDBY);
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;
}
//return dCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
dCmd.Dispose();
conn.Close();
conn.Dispose();
}
return(returnResult);
}
