/// <summary>
/// To Get Never Attended School By Id
/// </summary>
/// <param name="NASchoolID"></param>
/// <returns></returns>
public NeverAttendedSchoolBO GetNASchoolById(int NASchoolID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETNASCHOOLDETAILSBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("NVRATTSCHREASONID", NASchoolID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NeverAttendedSchoolBO NeverAttendedSchoolBOObj = null;
NeverAttendedSchoolList NASchoolList = new NeverAttendedSchoolList();
NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();
while (dr.Read())
{
if (ColumnExists(dr, "NVR_ATT_SCH_REASON") && !dr.IsDBNull(dr.GetOrdinal("NVR_ATT_SCH_REASON")))
{
NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = dr.GetString(dr.GetOrdinal("NVR_ATT_SCH_REASON"));
}
if (ColumnExists(dr, "description") && !dr.IsDBNull(dr.GetOrdinal("description")))
{
NeverAttendedSchoolBOObj.DESCRIPTION = Convert.ToString(dr.GetValue(dr.GetOrdinal("description")));
}
}
dr.Close();
return(NeverAttendedSchoolBOObj);
}
//public List<NeverAttendedSchoolBO> FetchGridViewDetails()
//{
// try
// {
// NeverAttendedSchoolBO NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();
// List<NeverAttendedSchoolBO> ListNASchoolList = new List<NeverAttendedSchoolBO>();
// //OracleConnection con = new OracleConnection(connStr);
// //con.Open();
// //OracleCommand cmd = new OracleCommand("USP_MST_GETNASCHOOLDETAILS", con);
// //cmd.CommandType = CommandType.StoredProcedure;
// //int count = Convert.ToInt32(cmd.CommandType);
// OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
// OracleCommand cmd;
// string proc = " USP_MST_GETNASCHOOLDETAILS";
// 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);
// while (dr.Read())
// {
// NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("NVR_ATT_SCH_REASONID")));
// NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = dr.GetString(dr.GetOrdinal("NVR_ATT_SCH_REASON"));
// NeverAttendedSchoolBOObj.DESCRIPTION = dr.GetString(dr.GetOrdinal("DESCRIPTION"));
// ListNASchoolList.Add(NeverAttendedSchoolBOObj);
// }
// dr.Close();
// return ListNASchoolList;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
/// <summary>
/// To Fetch Never Attended School
/// </summary>
/// <returns></returns>
public NeverAttendedSchoolList FetchNeverAttendedSchool()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETNASCHOOLDETAILS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NeverAttendedSchoolBO objNeverAttendedSchool = null;
NeverAttendedSchoolList NeverAttendedSchoollist = new NeverAttendedSchoolList();
while (dr.Read())
{
objNeverAttendedSchool = new NeverAttendedSchoolBO();
if (!dr.IsDBNull(dr.GetOrdinal("NVR_ATT_SCH_REASONID")))
{
objNeverAttendedSchool.NVR_ATT_SCH_REASONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("NVR_ATT_SCH_REASONID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("NVR_ATT_SCH_REASON")))
{
objNeverAttendedSchool.NVR_ATT_SCH_REASON = dr.GetString(dr.GetOrdinal("NVR_ATT_SCH_REASON"));
}
NeverAttendedSchoollist.Add(objNeverAttendedSchool);
}
dr.Close();
return(NeverAttendedSchoollist);
}
/// <summary>
/// To update details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private string EditNASchoolDetails()
{
string message = string.Empty;
NeverAttendedSchoolBLL NeverAttendedSchoolBLLObj = new NeverAttendedSchoolBLL();
try
{
NeverAttendedSchoolBO NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();
if (ViewState["NVR_ATT_SCH_REASONID"] != null)
{
NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASONID = Convert.ToInt32(ViewState["NVR_ATT_SCH_REASONID"].ToString());
}
string uID = Session["USER_ID"].ToString();
NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = NeverAttndSchlTextBox.Text.ToString().Trim();
NeverAttendedSchoolBOObj.DESCRIPTION = DescriptionTextBox.Text.ToString().Trim();
NeverAttendedSchoolBOObj.UpdatedBy = Convert.ToInt32(uID);
//BLL.NeverAttendedSchoolBLL NeverAttendedSchoolBLLObj = new BLL.NeverAttendedSchoolBLL();
message = NeverAttendedSchoolBLLObj.EDITNASCHOOL(NeverAttendedSchoolBOObj);
}
catch (Exception ex)
{
throw ex;
}
finally
{
NeverAttendedSchoolBLLObj = null;
}
return(message);
}
/// <summary>
/// To Insert Into Never Attended School
/// </summary>
/// <param name="NeverAttendedSchoolBOObj"></param>
/// <returns></returns>
public string InsertIntoNeverAttendedSchool(NeverAttendedSchoolBO NeverAttendedSchoolBOObj)
{
NeverAttendedSchoolDAL objNeverAttendedSchoolDAL = new NeverAttendedSchoolDAL();
try
{
return(objNeverAttendedSchoolDAL.InsertIntoNeverAttendedSchool(NeverAttendedSchoolBOObj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
objNeverAttendedSchoolDAL = null;
}
}
/// <summary>
/// To EDIT NA SCHOOL
/// </summary>
/// <param name="NeverAttendedSchoolBOObj"></param>
/// <returns></returns>
public string EDITNASCHOOL(NeverAttendedSchoolBO NeverAttendedSchoolBOObj)
{
NeverAttendedSchoolDAL NeverAttendedSchoolDALObj = new NeverAttendedSchoolDAL();
try
{
return(NeverAttendedSchoolDALObj.EDITNASCHOOL(NeverAttendedSchoolBOObj));
}
catch
{
throw;
}
finally
{
NeverAttendedSchoolDALObj = null;
}
}
///<summary>
///To fetch details
///</summary>
private void GetNASchoolDetails()
{
NeverAttendedSchoolBLL NeverAttendedSchoolBLLobj = new NeverAttendedSchoolBLL();
int NVRATTSCHREASONID = 0;
if (ViewState["NVR_ATT_SCH_REASONID"] != null)
{
NVRATTSCHREASONID = Convert.ToInt32(ViewState["NVR_ATT_SCH_REASONID"]);
}
NeverAttendedSchoolBO NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();
NeverAttendedSchoolBOObj = NeverAttendedSchoolBLLobj.GetNASchoolById(NVRATTSCHREASONID);
NeverAttndSchlTextBox.Text = NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON;
DescriptionTextBox.Text = NeverAttendedSchoolBOObj.DESCRIPTION;
//int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID);
}
/// <summary>
/// To Insert Into Never Attended School
/// </summary>
/// <param name="NeverAttendedSchoolBOObj"></param>
/// <returns></returns>
public string InsertIntoNeverAttendedSchool(NeverAttendedSchoolBO NeverAttendedSchoolBOObj)
{
string returnResult = string.Empty;
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_INSERTNSSCHOOL", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
//dcmd.Parameters.AddWithValue("NVR_ATT_SCH_REASONID", NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASONID);
dcmd.Parameters.Add("NVR_ATT_SCH_REASON_", NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON);
dcmd.Parameters.Add("DESCRIPTION_", NeverAttendedSchoolBOObj.DESCRIPTION);
//dcmd.Parameters.AddWithValue("ISDELETED", NeverAttendedSchoolBOObj.IsDeleted);
dcmd.Parameters.Add("CREATEDBY_", NeverAttendedSchoolBOObj.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
{
throw;
}
finally
{
dcmd.Dispose();
con.Close();
con.Dispose();
}
return(returnResult);
}
/// <summary>
/// To EDIT Never Attended SCHOOL
/// </summary>
/// <param name="NeverAttendedSchoolBOObj"></param>
/// <returns></returns>
public string EDITNASCHOOL(NeverAttendedSchoolBO NeverAttendedSchoolBOObj)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPDATENASCHOOL", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("NVRATTSCHREASONID", NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASONID);
dcmd.Parameters.Add("NVRATTSCHREASON", NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON);
dcmd.Parameters.Add("DESCPT", NeverAttendedSchoolBOObj.DESCRIPTION);
dcmd.Parameters.Add("UPDTBY", NeverAttendedSchoolBOObj.UpdatedBy);
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
{
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>
private string SaveNASchoolDetails()
{
string message = string.Empty;
NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();
string NeverAttndSchl = string.Empty;
string Description = string.Empty;
string uID = Session["USER_ID"].ToString();
NeverAttndSchl = NeverAttndSchlTextBox.Text.ToString().Trim();
Description = DescriptionTextBox.Text.ToString().Trim();
NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = NeverAttndSchl;
NeverAttendedSchoolBOObj.DESCRIPTION = Description;
//NeverAttendedSchoolBOObj.IsDeleted = "false";
NeverAttendedSchoolBOObj.CreatedBy = Convert.ToInt32(uID);
NeverAttendedSchoolBLLobj = new NeverAttendedSchoolBLL(); // Data sending to Next layer BAL
try
{
message = NeverAttendedSchoolBLLobj.InsertIntoNeverAttendedSchool(NeverAttendedSchoolBOObj); // Value passing to Next layer
}
catch (Exception ee) // find the Exception
{
throw ee;
}
finally // set the finally class nothing but Empty the object emp_mst_Bal
{
NeverAttendedSchoolBLLobj = null;
}
return(message);
}
