/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private string Insert()
{
string AlertMessage = string.Empty;
string message = string.Empty;
string uID = Session["USER_ID"].ToString();
SchoolDropReasonBOobj = new SchoolDropReasonBO();
SchoolDropReasonBOobj.Schooldropreason = txtReasonDropped.Text.ToString();
SchoolDropReasonBOobj.Description = txtDescription.Text.ToString();
SchoolDropReasonBOobj.Createddate = System.DateTime.Now;
SchoolDropReasonBOobj.Isdeleted = false;
SchoolDropReasonBOobj.Createdby = Convert.ToInt32(uID);
SchoolDropBLL SchoolDropBLLObj = new SchoolDropBLL();
try
{
message = SchoolDropBLLObj.Insert(SchoolDropReasonBOobj);
}
catch (Exception ex)
{
string errorMsg = ex.Message.ToString();
Response.Write(errorMsg);
}
finally
{
SchoolDropBLLObj = null;
}
return(message);
}
/// <summary>
/// To Get school Drop Reason
/// </summary>
/// <returns></returns>
public SchoolDropReasonList GetschoolDropReason()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = " USP_MST_GETSCHOOLDROPREASON";
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);
SchoolDropReasonBO objUser = null;
SchoolDropReasonList ReasonList = new SchoolDropReasonList();
while (dr.Read())
{
objUser = new SchoolDropReasonBO();
if (!dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASONID")))
{
objUser.SchooldropreasonID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SCH_DRP_REASONID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASON")))
{
objUser.Schooldropreason = dr.GetString(dr.GetOrdinal("SCH_DRP_REASON"));
}
ReasonList.Add(objUser);
}
dr.Close();
return(ReasonList);
}
/// <summary>
/// calls inser method to save details to 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 (ViewState["SchooldropreasonID"].ToString() == "0")
{
message = Insert();
AlertMessage = "alert('" + message + "');";
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
cleardetails();
}
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('School Drop reason details added successfully');", true);
}
else
{
string uID = Session["USER_ID"].ToString();
int reasonid = Convert.ToInt32(ViewState["SchooldropreasonID"]);
SchoolDropReasonBOobj = new SchoolDropReasonBO();
SchoolDropReasonBOobj.Description = txtDescription.Text.ToString();
SchoolDropReasonBOobj.Schooldropreason = txtReasonDropped.Text.ToString();
SchoolDropReasonBOobj.Createdby = Convert.ToInt32(uID);;
SchoolDropBLL SchoolDropBLLObj = new SchoolDropBLL();
message = SchoolDropBLLObj.Update(SchoolDropReasonBOobj, reasonid);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
cleardetails();
SetUpdateMode(false);
}
//BindGrid(true, true);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('School Drop reason details updated successfully');", true);
//cleardetails();
}
BindGrid();
//btnSave.Text = "Save";
}
catch (Exception ex)
{
string errorMsg = ex.Message.ToString();
Response.Write(errorMsg);
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
///To fetch details from database and assign to textbox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetSchoolDropDetails()
{
SchoolDropBLL SchoolDropBLLObj = new SchoolDropBLL();
int SchooldropreasonID = 0;
if (ViewState["SchooldropreasonID"] != null)
{
SchooldropreasonID = Convert.ToInt32(ViewState["SchooldropreasonID"]);
}
SchoolDropReasonBOobj = new SchoolDropReasonBO();
SchoolDropReasonBOobj = SchoolDropBLLObj.GetschoolDropReasonbyID(SchooldropreasonID);
txtReasonDropped.Text = SchoolDropReasonBOobj.Schooldropreason;
txtDescription.Text = SchoolDropReasonBOobj.Description;
//ConcernIDTextBox.Text = SchoolDropReasonBOobj.SchooldropreasonID.ToString();
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="SchoolDropReasonBOobj"></param>
/// <returns></returns>
public string Insert(SchoolDropReasonBO SchoolDropReasonBOobj)
{
SchoolDropReasonDAL Schooldropobj = new SchoolDropReasonDAL(); //Data pass -to Database Layer
try
{
return(Schooldropobj.Insert(SchoolDropReasonBOobj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Schooldropobj = null;
}
}
/// <summary>
/// To Update
/// </summary>
/// <param name="SchoolDropReasonBOobj"></param>
/// <param name="reasonid"></param>
/// <returns></returns>
public string Update(SchoolDropReasonBO SchoolDropReasonBOobj, int reasonid)
{
SchoolDropReasonDAL Schooldropobj = new SchoolDropReasonDAL();
try
{
return(Schooldropobj.Update(SchoolDropReasonBOobj, reasonid));
}
catch (Exception ex)
{
throw ex;
}
finally
{
Schooldropobj = null;
}
}
/// <summary>
/// To Update
/// </summary>
/// <param name="SchoolDropReasonBOobj"></param>
/// <param name="reasonid"></param>
/// <returns></returns>
public string Update(SchoolDropReasonBO SchoolDropReasonBOobj, int reasonid)
{
string returnResult = string.Empty;
OracleConnection conn = new OracleConnection(AppConfiguration.ConnectionString);
conn.Open();
OracleCommand dCmd = new OracleCommand("USP_MST_UPDATESCHOOLDROP", conn);
dCmd.CommandType = CommandType.StoredProcedure;
try
{
dCmd.Parameters.Add("p_SCH_DRP_REASONID", reasonid);
dCmd.Parameters.Add("p_SCH_DRP_REASON", SchoolDropReasonBOobj.Schooldropreason);
dCmd.Parameters.Add("p_description", SchoolDropReasonBOobj.Description);
dCmd.Parameters.Add("p_CREATEDBY", SchoolDropReasonBOobj.Createdby);
dCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 100).Direction = ParameterDirection.Output;
//return dCmd.ExecuteNonQuery();
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();
conn.Close();
conn.Dispose();
}
return(returnResult);
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="SchoolDropReasonBOobj"></param>
/// <returns></returns>
public string Insert(SchoolDropReasonBO SchoolDropReasonBOobj)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand dcmd = new OracleCommand("usp_MST_INSERTSCHOOLDROP", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("p_SCH_DRP_REASON", SchoolDropReasonBOobj.Schooldropreason);
dcmd.Parameters.Add("p_DESCRIPTION", SchoolDropReasonBOobj.Description);
dcmd.Parameters.Add("p_CREATEDBY", SchoolDropReasonBOobj.Createdby);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 100).Direction = ParameterDirection.Output;
//return dcmd.ExecuteNonQuery();
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 Get school Drop Reason by ID
/// </summary>
/// <param name="SchooldropreasonID"></param>
/// <returns></returns>
public SchoolDropReasonBO GetschoolDropReasonbyID(int SchooldropreasonID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SCHOOLDROPBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("p_SCH_DRP_REASONID", SchooldropreasonID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SchoolDropReasonBO SchoolDropReasonBOobj = null;
SchoolDropReasonList Users = new SchoolDropReasonList();
SchoolDropReasonBOobj = new SchoolDropReasonBO();
while (dr.Read())
{
if (ColumnExists(dr, "SCH_DRP_REASON") && !dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASON")))
{
SchoolDropReasonBOobj.Schooldropreason = dr.GetString(dr.GetOrdinal("SCH_DRP_REASON"));
}
if (ColumnExists(dr, "DESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("DESCRIPTION")))
{
SchoolDropReasonBOobj.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION"));
}
if (ColumnExists(dr, "SCH_DRP_REASONID") && !dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASONID")))
{
SchoolDropReasonBOobj.SchooldropreasonID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SCH_DRP_REASONID")));
}
}
dr.Close();
return(SchoolDropReasonBOobj);
}
