/// Select all details of SubjectT for selected SubjectTID from tbl_Subject_T table
/// Created By : Darshan, 09/12/2014
/// Modified By :
public ApplicationResult SubjectT_Select(SubjectTBO objSubjectTBO)
{
try
{
pSqlParameter = new SqlParameter[3];
pSqlParameter[0] = new SqlParameter("@ClassMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objSubjectTBO.ClassMID;
pSqlParameter[1] = new SqlParameter("@DivisionTID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objSubjectTBO.DivisionTID;
pSqlParameter[2] = new SqlParameter("@SubjectMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objSubjectTBO.SubjectMID;
strStoredProcName = "usp_tbl_Subject_T_Select";
DataSet dsResult = new DataSet();
dsResult = Database.ExecuteDataSet(CommandType.StoredProcedure, strStoredProcName, pSqlParameter);
ApplicationResult objResults = new ApplicationResult(dsResult);
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// To Insert details of SubjectT in tbl_Subject_T table
/// Created By : Darshan, 09/12/2014
/// Modified By :
/// </summary>
/// <param name="objSubjectTBO"></param>
/// <returns></returns>
public ApplicationResult SubjectT_Insert(SubjectTBO objSubjectTBO, string strEmployeeMIDs)
{
try
{
pSqlParameter = new SqlParameter[5];
pSqlParameter[0] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objSubjectTBO.SchoolMID;
pSqlParameter[1] = new SqlParameter("@ClassMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objSubjectTBO.ClassMID;
pSqlParameter[2] = new SqlParameter("@DivisionTID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objSubjectTBO.DivisionTID;
pSqlParameter[3] = new SqlParameter("@SubjectMID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objSubjectTBO.SubjectMID;
pSqlParameter[4] = new SqlParameter("@EmployeeMIDs", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = strEmployeeMIDs;
sSql = "usp_tbl_Subject_T_Insert";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSubjectTBO = null;
}
}
protected void gvTeacher_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "DeleteTeacher")
{
if (ViewState["Mode"].ToString() == "Save")
{
GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
DataTable dtTeacher = (DataTable)ViewState["Teacher"];
dtTeacher.Rows.RemoveAt(row.RowIndex);
dtTeacher.AcceptChanges();
ViewState["Teacher"] = dtTeacher;
gvTeacher.DataSource = (DataTable)ViewState["Teacher"];
gvTeacher.DataBind();
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
SubjectTBO objSubjectTbo = new SubjectTBO();
objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue);
objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue);
objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue);
objSubjectTbo.EmployeeMID = Convert.ToInt32(e.CommandArgument.ToString());
objResult = objSubjectTbl.SubjectT_Delete_Association(objSubjectTbo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo);
ViewState["Teacher"] = objResult.resutlDS.Tables[1];
gvTeacher.DataSource = (DataTable)ViewState["Teacher"];
gvTeacher.DataBind();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record deleted successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('You cannot delete this record because it is in used.');</script>");
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void gvSubjectAssociation_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
SubjectTBO objSubjectTbo = new SubjectTBO();
objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue);
objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue);
objSubjectTbo.SubjectMID = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Edit1")
{
BindSubject(1);
ViewState["Mode"] = "Edit";
objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo);
ddlSubject.SelectedValue =
objResult.resutlDS.Tables[0].Rows[0][SubjectTBO.SUBJECTT_SUBJECTMID].ToString();
ViewState["Teacher"] = objResult.resutlDS.Tables[1];
gvTeacher.DataSource = (DataTable)ViewState["Teacher"];
gvTeacher.DataBind();
PanelVisibility(2);
}
else if (e.CommandName == "Delete1")
{
objResult = objSubjectTbl.SubjectT_Delete(objSubjectTbo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record deleted successfully.');</script>");
BindSubjectAssociation();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('You cannot delete this record because it is in used.');</script>");
}
ClearAll();
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// To Delete details of SubjectT for selected SubjectTID from tbl_Subject_T table
/// Created By : Darshan, 09/12/2014
/// Modified By :
public ApplicationResult SubjectT_Delete_Association(SubjectTBO objSubjectTBO)
{
try
{
pSqlParameter = new SqlParameter[4];
pSqlParameter[0] = new SqlParameter("@ClassMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objSubjectTBO.ClassMID;
pSqlParameter[1] = new SqlParameter("@DivisionTID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objSubjectTBO.DivisionTID;
pSqlParameter[2] = new SqlParameter("@SubjectMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objSubjectTBO.SubjectMID;
pSqlParameter[3] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objSubjectTBO.EmployeeMID;
strStoredProcName = "usp_tbl_Subject_T_Delete_Association";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcName, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
if (ViewState["Count"] != null)
{
if (Convert.ToInt32(ViewState["Count"].ToString()) > 0)
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBO objSubjectTbo = new SubjectTBO();
SubjectTBL objSubjectTbl = new SubjectTBL();
string strEmployeeMIDs = null;
objSubjectTbo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue);
objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue);
objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue);
DataTable dtTeacher = (DataTable)ViewState["Teacher"];
for (int i = 0; i < dtTeacher.Rows.Count; i++)
{
if (strEmployeeMIDs != null)
{
strEmployeeMIDs += "~";
}
strEmployeeMIDs += dtTeacher.Rows[i]["EmployeeMID"].ToString();
}
if (ViewState["Mode"].ToString() == "Save")
{
objResult = objSubjectTbl.SubjectT_Insert(objSubjectTbo, strEmployeeMIDs);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objResult = objSubjectTbl.SubjectT_Update(objSubjectTbo, strEmployeeMIDs);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindSubjectAssociation();
PanelVisibility(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</script>");
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
