protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DivisionTBL objDivisionTbl = new DivisionTBL();
objResult = objDivisionTbl.DivisionT_SelectAll_For_Exam(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
if (objResult.resultDT.Rows.Count > 0)
{
//DivisionTID = Convert.ToInt32(objResult.resultDT.Rows[0]["DivisionTID"].ToString());
//ViewState["DivisionTID"] = DivisionTID;
}
}
}
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>");
}
}
public static string LoadDivision(int intClassMID, int intSchoolMID)
{
try
{
#region Bind Division
DataTable dtDivision = new DataTable();
DivisionTBL objDivisionBL = new DivisionTBL();
DivisionTBO objDivisionBO = new DivisionTBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objDivisionBL.Division_SelectAll_ClassWise_ForDropDown(intClassMID, intSchoolMID);
if (objResultSection != null)
{
dtDivision = objResultSection.resultDT;
if (dtDivision.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(dtDivision);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveClass_T()
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
DataTable dtTask = (DataTable)ViewState["Division"];
for (int i = 0; i < dtTask.Rows.Count; i++)
{
objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString();
objResults = objDivisionBl.DivisionT_Insert(objDivisionBo);
}
//if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
//{
//ClearAll();
//ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class updated successfully.');</script>");
//GridDataBind();
//PanelGrid_VisibilityMode(1);
//}
}
private DataTable FetchDivision(int intClassMID, int intSchoolMID)
{
//DataTable dtDivision = new DataTable();
DivisionTBL objDivisionBL = new DivisionTBL();
ApplicationResult objResults = new ApplicationResult();
objResults = objDivisionBL.Division_SelectAll_ClassWise_ForDropDown(intClassMID, intSchoolMID);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0)
{
}
return(objResults.resultDT);
}
public void BindDivision(int intClassMID)
{
ApplicationResult objResult = new ApplicationResult();
DivisionTBL objDivisionTbl = new DivisionTBL();
Controls objControl = new Controls();
objResult = objDivisionTbl.DivisionT_Select_By_Class(intClassMID);
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
}
ddlDivision.Items.Insert(0, new ListItem("--Select--", ""));
}
protected void ddlClass_SelectedIndexChanged1(object sender, EventArgs e)
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DivisionTBL objDivisionTbl = new DivisionTBL();
objResult = objDivisionTbl.DivisionT_SelectAll_For_Exam(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult != null)
{
//objControls.BindDropDown_ListBox(objResult.resultDT, ddlDesignation, "DesignationNameENG", "DesignationID");
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
if (objResult.resultDT.Rows.Count > 0)
{
}
//ddlDesignation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
public void getDivisionName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DivisionTBL objDivisionBl = new DivisionTBL();
objResult = objDivisionBl.Division_SelectAll_ClassWise_ForDropDown(Convert.ToInt32(ddlclass.SelectedValue), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlDivision.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
}
}
protected void gvClass_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int intClassMID = Convert.ToInt32(e.Row.Cells[0].Text);
GridView gvChild = (GridView)e.Row.FindControl("gvChild");
DivisionTBL objDivisionTbl = new DivisionTBL();
ApplicationResult objResult = new ApplicationResult();
objResult = objDivisionTbl.Division_SelectAll_ClassWise(intClassMID,
Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
gvChild.DataSource = objResult.resultDT;
gvChild.DataBind();
}
}
}
protected void gvStudent_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
DivisionTBL objDivisionBL = new DivisionTBL();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList ddlgridDivision = (DropDownList)e.Row.FindControl("ddlGridDivision");
objResults = objDivisionBL.Division_SelectAll_ClassWise(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlgridDivision, "DivisionName", "DivisionTID");
}
ddlgridDivision.Items.Insert(0, new ListItem("-Select-", ""));
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
DropDownList ddlDivisionHeader = (DropDownList)e.Row.FindControl("ddlDivisionHeader");
objResults = objDivisionBL.Division_SelectAll_ClassWise(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlDivisionHeader, "DivisionName", "DivisionTID");
}
ddlDivisionHeader.Items.Insert(0, new ListItem("-Select-", ""));
}
}
}
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 ddlClassName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DivisionTBL objDivisionTbl = new DivisionTBL();
objResult = objDivisionTbl.Division_SelectAll_ClassWise_ForDropDown(Convert.ToInt32(ddlClassName.SelectedValue), Convert.ToInt32(ddlSchoolName.SelectedValue));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivisionName, "DivisionName", "DivisionTID");
}
ddlDivisionName.Items.Insert(0, new ListItem("--Select--", ""));
}
}
catch (Exception)
{
throw;
}
}
protected void gvDivision_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionTBL = new DivisionTBL();
ViewState["DivisionTID"] = e.CommandArgument.ToString();
Controls objControls = new Controls();
try
{
if (e.CommandName.ToString() == "EditDivision")
{
if (ViewState["Mode"].ToString() == "Save")
{
// GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
DataTable dtTaskTemp = (DataTable)ViewState["Division"];
//txtDivisionName.Text= dtTaskTemp.Rows[0][1].ToString();
//txtDivisionName.Text = Convert.ToString(row.RowIndex);
ViewState["DivisionDatatableTID"] = e.CommandArgument.ToString();
string strFilter = "DivisionTID = '" + e.CommandArgument.ToString() + "'";
DataRow[] results = dtTaskTemp.Select(strFilter);
if (results.CopyToDataTable().Rows.Count > 0)
{
txtDivisionName.Text = results.CopyToDataTable().Rows[0][1].ToString();
}
ViewState["DivisionMode"] = "Edit";
}
else
{
objResults = objDivisionTBL.DivisionT_Select_By_DivisionTID(Convert.ToInt32(ViewState["DivisionTID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtDivisionName.Text = objResults.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString();
ViewState["DivisionMode"] = "Edit";
}
}
}
}
else if (e.CommandName == "DeleteDivision")
{
if (ViewState["Mode"].ToString() == "Save")
{
GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
DataTable dtTaskTemp = (DataTable)ViewState["Division"];
dtTaskTemp.Rows.RemoveAt(row.RowIndex);
dtTaskTemp.AcceptChanges();
ViewState["Division"] = dtTaskTemp;
gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataBind();
}
else
{
objResults = objDivisionTBL.DivisionT_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResults != null)
{
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Division Deleted Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Division(s) associated with this Student. To delete this Divisions you need to delete Student(s) first.');</script>");
}
}
objResults = objDivisionTBL.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
}
}
}
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 gvClass_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ViewState["ClassMID"] = e.CommandArgument.ToString();
Controls objControls = new Controls();
ClassBL objClasstBl = new ClassBL();
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
if (e.CommandName.ToString() == "Edit1")
{
objResults = objClasstBl.Class_Select(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ddlSection.SelectedValue = objResults.resultDT.Rows[0][ClassBO.CLASS_SECTIONTID].ToString();
txtClassName.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
txtApprovalNo.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_APPROVALNO].ToString();
txtApprovalDate.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_APPROVALDATE].ToString();
txtNoOfPeriod.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_NOOFPERIOD].ToString();
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
ViewState["Mode"] = "Edit";
PanelGrid_VisibilityMode(2);
}
}
}
if (e.CommandName.ToString() == "Delete1")
{
//objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
//ApplicationResult objDelete = new ApplicationResult();
//objDelete = objClasstBl.Validate_Class_Delete(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ViewState["DivisionName"].ToString());
//if (objDelete != null)
//{
// if (objDelete.resultDT.Rows.Count > 0)
// {
// if (Convert.ToInt32(objDelete.resultDT.Rows[0]["CurrentClassID"]) == Convert.ToInt32(ViewState["ClassMID"].ToString()))
// {
// ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Student(s) associated with this Class. To delete this Section you need to delete Student(s) first.');</script>");
// }
// }
// else
// {
// objResults = objClasstBl.Class_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ViewState["DivisionName"].ToString());
// if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
// {
// ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class deleted successfully.');</script>");
// ClearAll();
// GridDataBind();
// PanelGrid_VisibilityMode(1);
// }
// }
//}
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
objResult = objClassBl.Class_Delete(Convert.ToInt32(ViewState["ClassMID"].ToString()),
Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class deleted successfully.');</script>");
GridDataBind();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Student(s) associated with this Class. To delete this Section you need to delete Student(s) 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>");
}
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
try
{
int intflagsave = 0;
int intflagedit = 0;
DataTable dtTask = new DataTable();
dtTask = (DataTable)ViewState["Division"];
if (ViewState["DivisionMode"].ToString() == "Save")
{
if (dtTask.Rows.Count > 0)
{
string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'";
DataRow[] results = dtTask.Select(strFilter);
if (results.Length > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>");
intflagsave = 1;
}
}
if (intflagsave == 0)
{
if (ViewState["Mode"].ToString() == "Save")
{
int i = 0;
if (dtTask.Rows.Count > 0)
{
i = dtTask.Rows.Count;
}
i = i + 1;
dtTask.Rows.Add(i, txtDivisionName.Text);
ViewState["Division"] = dtTask;
gvDivision.DataSource = dtTask;
gvDivision.DataBind();
txtDivisionName.Text = "";
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.DivisionName = txtDivisionName.Text;
objResults = objDivisionBl.DivisionT_Insert(objDivisionBo);
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
}
}
}
if (ViewState["DivisionMode"].ToString() == "Edit")
{
if (dtTask.Rows.Count > 0)
{
string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'";
DataRow[] results = dtTask.Select(strFilter);
if (results.Length > 1)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>");
intflagedit = 1;
}
}
if (intflagedit == 0)
{
if (ViewState["Mode"].ToString() == "Save")
{
DataTable dtTaskTemp = (DataTable)ViewState["Division"];
foreach (DataRow dr in dtTaskTemp.Rows) // search whole table
{
if (Convert.ToInt32(dr["DivisionTID"].ToString()) == Convert.ToInt32(ViewState["DivisionDatatableTID"].ToString())) // if id==2
{
dr["DivisionName"] = txtDivisionName.Text; //change the name
//break; break or not depending on you
}
ViewState["Division"] = dtTask;
gvDivision.DataSource = dtTask;
gvDivision.DataBind();
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.DivisionTID = Convert.ToInt32(ViewState["DivisionTID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.DivisionName = txtDivisionName.Text;
objResults = objDivisionBl.DivisionT_Update(objDivisionBo);
ViewState["Mode"] = "Edit";
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
}
}
}
}
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 btnSaveClass_Click(object sender, EventArgs e)
{
try
{
ClassBL objClasstBl = new ClassBL();
ClassBO objClassBo = new ClassBO();
DivisionTBO objDivisionBo = new DivisionTBO();
DivisionTBL objDivisionBl = new DivisionTBL();
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
if (ValidateName() == true)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " And Divsion " + txtDivisionName.Text + " already Exists.');</script>");
goto Exit;
}
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objClassBo.SectionTID = Convert.ToInt32(ddlSection.SelectedValue);
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objClassBo.ClassName = txtClassName.Text;
objClassBo.NoOfPeriod = Convert.ToInt32(txtNoOfPeriod.Text);
objClassBo.ApprovalNo = txtApprovalNo.Text;
objClassBo.ApprovalDate = txtApprovalDate.Text;
objClassBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objClassBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
if (ViewState["Mode"].ToString() == "Save")
{
//objResults = objClasstBl.Class_ValidateName(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
//if (objResults != null)
//{
// if (objResults.resultDT.Rows.Count > 0)
// {
// ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
// SaveClass_T();
// }
// else
// {
objResults = objClasstBl.Class_Insert(objClassBo);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
SaveClass_T();
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record saved successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
// }
//}
}
else
{
objClassBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objResults = objClasstBl.Class_Update(objClassBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
//ApplicationResult objResultsDivisionUpdate = new ApplicationResult();
//objResultsDivisionUpdate =
// objDivisionBl.DivisionT_Delete_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
//DataTable dtTask = (DataTable)ViewState["Division"];
//for (int i = 0; i < dtTask.Rows.Count; i++)
//{
// objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString();
// objResultsDivisionUpdate = objDivisionBl.DivisionT_Insert(objDivisionBo);
//}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record updated successfully.');</script>");
ClearAll();
GridDataBind();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
DatabaseTransaction.CommitTransation();
#endregion
Exit :;
}
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 gvStudent_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
btnSave.Enabled = true;
btnSave.Attributes.Add("bgcolor", "#848484");
Controls objControls = new Controls();
StudentBL objStudentBL = new StudentBL();
ApplicationResult objResults = new ApplicationResult();
if (e.CommandName.ToString() == "Edit1")
{
ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString());
objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString();
#region Find DivisionName
DivisionTBL objDivision = new DivisionTBL();
ApplicationResult objResultsDivision = new ApplicationResult();
objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString()));
if (objResultsDivision != null)
{
if (objResultsDivision.resultDT.Rows.Count > 0)
{
ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString();
}
}
#endregion
#region Find SectionName
SectionBL objSection = new SectionBL();
ApplicationResult objResultsSection = new ApplicationResult();
objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString()));
if (objResultsSection != null)
{
if (objResultsSection.resultDT.Rows.Count > 0)
{
ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString();
}
}
#endregion
#region Find Class
ClassBL objClass = new ClassBL();
ApplicationResult objResultsClass = new ApplicationResult();
objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString()));
if (objResultsClass != null)
{
if (objResultsClass.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSMID].ToString();
ViewState["ClassName"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
}
}
#endregion
ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
}
}
}
}
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 gvStudent_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
Controls objControls = new Controls();
StudentBL objStudentBL = new StudentBL();
ApplicationResult objResults = new ApplicationResult();
if (e.CommandName.ToString() == "Edit1")
{
ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString());
divStudentPanel.Visible = true;
objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0);
divStudentPanel.Visible = true;
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString();
#region Find DivisionName
DivisionTBL objDivision = new DivisionTBL();
ApplicationResult objResultsDivision = new ApplicationResult();
objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString()));
if (objResultsDivision != null)
{
if (objResultsDivision.resultDT.Rows.Count > 0)
{
ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString();
}
}
#endregion
#region Find SectionName
SectionBL objSection = new SectionBL();
ApplicationResult objResultsSection = new ApplicationResult();
objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString()));
if (objResultsSection != null)
{
if (objResultsSection.resultDT.Rows.Count > 0)
{
ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString();
}
}
#endregion
#region Find Class
ClassBL objClass = new ClassBL();
ApplicationResult objResultsClass = new ApplicationResult();
objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString()));
if (objResultsClass != null)
{
if (objResultsClass.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
}
}
#endregion
lblAdmissionNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_ADMISSIONNO].ToString();
lblCurrentGrNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTGRNO].ToString();
lblStudentNameEng.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTLASTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTFIRSTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTMIDDLENAMEENG].ToString();
lblClassDivision.Text = ViewState["ClassMID"].ToString() + "-" + ViewState["Division"].ToString();
lblCurrentSection.Text = ViewState["SectionName"].ToString();
lblAcademicYear.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
}
}
GridDataBind();
}
}
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>");
}
}
