protected void ddlSubject_OnSelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList ddl1 = (sender as DropDownList);
string strname = ddl1.ID;
string i = strname.Substring(strname.Length - 1, 1);
if (i == "0")
{
i = "10";
}
DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + i.ToString()) as DropDownList;
ddl2.Items.Clear();
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
Controls objControls = new Controls();
objResult = objSubjectTbl.SubjectT_Select_Teacher(Convert.ToInt32(ddlClass.SelectedValue),
Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToInt32(ddl1.SelectedValue));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddl2, "EmployeeFNameENG", "EmployeeMID");
}
}
ddl2.Items.Insert(0, new ListItem("None", "-1"));
}
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 void BindSubject(int intMode)
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
Controls objControl = new Controls();
objResult = objSubjectTbl.Subject_Select_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), intMode, Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlSubject, "NameEng", "SubjectMID");
}
ddlSubject.Items.Insert(0, new ListItem("--Select--", ""));
}
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>");
}
}
public void BindSubjectAssociation()
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
objResult = objSubjectTbl.SubjectT_SelectAll_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue));
if (objResult.resultDT.Rows.Count > 0)
{
gvSubjectAssociation.DataSource = objResult.resultDT;
gvSubjectAssociation.DataBind();
PanelVisibility(1);
}
else
{
BindSubject(2);
PanelVisibility(2);
}
}
public void BindSubject()
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
Controls objControl = new Controls();
int intCount = Convert.ToInt32(hfNoOfPeriod.Value);
objResult = objSubjectTbl.SubjectT_SelectAll_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue));
if (objResult != null)
{
for (int i = 1; i <= intCount; i++)
{
DropDownList ddl = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlSubject" + i.ToString()) as DropDownList;
objControl.BindDropDown_ListBox(objResult.resultDT, ddl, "Subject", "SubjectMID");
}
}
for (int j = 1; j <= intCount; j++)
{
DropDownList ddl1 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlSubject" + j.ToString()) as DropDownList;
DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + j.ToString()) as DropDownList;
ddl1.Items.Insert(0, new ListItem("None", "-1"));
ddl2.Items.Insert(0, new ListItem("None", "-1"));
}
}
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>");
}
}
