public static STD_ClassSubjectEmployee GetSTD_ClassSubjectEmployeeByClassSubjectEmployeeID(int ClassSubjectEmployeeID)
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee();
SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider();
sTD_ClassSubjectEmployee = sqlSTD_ClassSubjectEmployeeProvider.GetSTD_ClassSubjectEmployeeByClassSubjectEmployeeID(ClassSubjectEmployeeID);
return sTD_ClassSubjectEmployee;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
//delete all the rows for the
STD_ClassSubjectEmployeeManager.DeleteSTD_ClassSubjectEmployeeByClassSubjectID(int.Parse(ddlClassSubjectID.SelectedValue));
string ids = getSubjectID();
if (ids != "")
{
string[] words = ids.Split(',');
foreach (string word in words)
{
if (word != "")
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee();
// sTD_ClassSubjectEmployee.ClassSubjectEmployeeID= int.Parse(ddlClassSubjectEmployeeID.SelectedValue);
sTD_ClassSubjectEmployee.ClassSubjectEmployeeName = "Need to fix later";
sTD_ClassSubjectEmployee.EmployeeID = word;
sTD_ClassSubjectEmployee.ClassSubjectID = int.Parse(ddlClassSubjectID.SelectedValue);
sTD_ClassSubjectEmployee.AddedBy = Profile.card_id;
sTD_ClassSubjectEmployee.AddedDate = DateTime.Now;
sTD_ClassSubjectEmployee.UpdatedBy = Profile.card_id;
sTD_ClassSubjectEmployee.UpdateDate = DateTime.Now;
int resutl = STD_ClassSubjectEmployeeManager.InsertSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}
}
}
}
catch (Exception ex) { }
loadGrid();
btnUpdate.Visible = false;
}
public static STD_ClassSubjectEmployee GetHR_EmployeeByEmployeeID(string EmployeeID)
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee();
SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider();
sTD_ClassSubjectEmployee = sqlSTD_ClassSubjectEmployeeProvider.GetSTD_ClassSubjectEmployeeByEmployeeID(EmployeeID);
return sTD_ClassSubjectEmployee;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee ();
sTD_ClassSubjectEmployee.ClassSubjectEmployeeID= int.Parse(Request.QueryString["ID"].ToString());
sTD_ClassSubjectEmployee.ClassSubjectEmployeeName= txtClassSubjectEmployeeName.Text;
sTD_ClassSubjectEmployee.EmployeeID= ddlEmployeeID.SelectedValue;
sTD_ClassSubjectEmployee.ClassSubjectID= int.Parse(ddlClassSubjectID.SelectedValue);
sTD_ClassSubjectEmployee.AddedBy= Profile.card_id;
sTD_ClassSubjectEmployee.AddedDate= DateTime.Now;
sTD_ClassSubjectEmployee.UpdatedBy= Profile.card_id;
sTD_ClassSubjectEmployee.UpdateDate = DateTime.Now;
bool resutl =STD_ClassSubjectEmployeeManager.UpdateSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_ClassSubjectEmployee.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
//delete all the rows for the
STD_ClassSubjectEmployeeManager.DeleteSTD_ClassSubjectEmployeeByClassID(int.Parse(ddlClassID.SelectedValue));
string ids = getSubjectID();
if (ids != "")
{
string[] words = ids.Split(',');
foreach (string word in words)
{
if (word != "")
{
string[] id = word.Split(' ');
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee();
// sTD_ClassSubjectEmployee.ClassSubjectEmployeeID= int.Parse(ddlClassSubjectEmployeeID.SelectedValue);
sTD_ClassSubjectEmployee.ClassSubjectEmployeeName = "Need to fix later";
sTD_ClassSubjectEmployee.EmployeeID = id[0];
sTD_ClassSubjectEmployee.ClassSubjectID = int.Parse(id[1]);
sTD_ClassSubjectEmployee.AddedBy = Profile.card_id;
sTD_ClassSubjectEmployee.AddedDate = DateTime.Now;
sTD_ClassSubjectEmployee.UpdatedBy = Profile.card_id;
sTD_ClassSubjectEmployee.UpdateDate = DateTime.Now;
int resutl = STD_ClassSubjectEmployeeManager.InsertSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}
}
}
}
catch (Exception ex) { }
Response.Redirect("ClassStudentAdd.aspx?ID=" + ddlClassID.SelectedValue); //loadGrid();
}
public static int InsertSTD_ClassSubjectEmployee(STD_ClassSubjectEmployee sTD_ClassSubjectEmployee)
{
SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider();
return sqlSTD_ClassSubjectEmployeeProvider.InsertSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}
public static bool UpdateSTD_ClassSubjectEmployee(STD_ClassSubjectEmployee sTD_ClassSubjectEmployee)
{
SqlSTD_ClassSubjectEmployeeProvider sqlSTD_ClassSubjectEmployeeProvider = new SqlSTD_ClassSubjectEmployeeProvider();
return sqlSTD_ClassSubjectEmployeeProvider.UpdateSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}
protected void btnSave_Click(object sender, EventArgs e)
{
//add Subject
STD_Class sTD_Class = new STD_Class();
try
{
// sTD_Class.ClassID= int.Parse(ddlClassID.SelectedValue);
sTD_Class.ClassName = txtClassName.Text;
sTD_Class.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_Class.ClassTypeID = 2;
sTD_Class.ClassStatusID = 1;
sTD_Class.AddedBy = Profile.card_id;
sTD_Class.AddedDate = DateTime.Now;
sTD_Class.UpdatedBy = Profile.card_id;
sTD_Class.UpdateDate = DateTime.Now;
sTD_Class.ClassID = STD_ClassManager.InsertSTD_Class(sTD_Class);
}
catch (Exception ex) { }
//Add Student
try {
string ids = getStudentIDs(gvStudents);
if (ids != "")
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
sTD_ClassStudent.ClassStudentName = "";
sTD_ClassStudent.StudentID = ids;
sTD_ClassStudent.ClassID = sTD_Class.ClassID;
sTD_ClassStudent.AddedBy = Profile.card_id;
sTD_ClassStudent.AddedDate = DateTime.Now;
sTD_ClassStudent.UpdatedBy = Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
int resutl = STD_ClassStudentManager.InsertSTD_ClassStudent_List_KeepStudentInMultipleClassActive(sTD_ClassStudent);
//string message = resutl + " New Entry Created";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Message", "alert('" + message + "');", true);
}
}
catch (Exception ex) { }
//Class Subject
try
{
//delete all the rows for the
STD_ClassSubjectManager.DeleteSTD_ClassSubjectByClassID(sTD_Class.ClassID);
foreach (GridViewRow gr in gvSubject.Rows)
{
CheckBox chkSelect = (CheckBox)gr.FindControl("chkSelect");
HiddenField hfSubjectID = (HiddenField)gr.FindControl("hfSubjectID");
DropDownList ddlTeacherID = (DropDownList)gr.FindControl("ddlTeacherID");
TextBox txtStartDate = (TextBox)gr.FindControl("txtStartDate");
TextBox txtEndDate = (TextBox)gr.FindControl("txtEndDate");
if (chkSelect.Checked)
{
STD_ClassSubject sTD_ClassSubject = new STD_ClassSubject();
sTD_ClassSubject.ClassSubjectName = "1";
sTD_ClassSubject.SubjectID = int.Parse(hfSubjectID.Value);
sTD_ClassSubject.ClassID = sTD_Class.ClassID;
sTD_ClassSubject.ExtraField1 = txtStartDate.Text;
sTD_ClassSubject.ExtraField2 = txtEndDate.Text;
sTD_ClassSubject.ExtraField3 = "";
sTD_ClassSubject.ExtraField4 = "";
sTD_ClassSubject.ExtraField5 = "";
sTD_ClassSubject.AddedBy = Profile.card_id;
sTD_ClassSubject.AddedDate = DateTime.Now;
sTD_ClassSubject.UpdatedBy = Profile.card_id;
sTD_ClassSubject.UpdateDate = DateTime.Now;
sTD_ClassSubject.ClassSubjectID = STD_ClassSubjectManager.InsertSTD_ClassSubject(sTD_ClassSubject);
if (ddlTeacherID.SelectedIndex != 0)
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee();
// sTD_ClassSubjectEmployee.ClassSubjectEmployeeID= int.Parse(ddlClassSubjectEmployeeID.SelectedValue);
sTD_ClassSubjectEmployee.ClassSubjectEmployeeName = "Need to fix later";
sTD_ClassSubjectEmployee.EmployeeID = ddlTeacherID.SelectedValue;
sTD_ClassSubjectEmployee.ClassSubjectID = sTD_ClassSubject.ClassSubjectID;
sTD_ClassSubjectEmployee.AddedBy = Profile.card_id;
sTD_ClassSubjectEmployee.AddedDate = DateTime.Now;
sTD_ClassSubjectEmployee.UpdatedBy = Profile.card_id;
sTD_ClassSubjectEmployee.UpdateDate = DateTime.Now;
sTD_ClassSubjectEmployee.ClassSubjectEmployeeID = STD_ClassSubjectEmployeeManager.InsertSTD_ClassSubjectEmployee(sTD_ClassSubjectEmployee);
}
//Add Student
try
{
string ids = getStudentIDs(gvStudents);
if (ids != "")
{
STD_ClassSubjectStudent sTD_ClassSubjectStudent = new STD_ClassSubjectStudent();
sTD_ClassSubjectStudent.ClassSubjectStudentName = "Need to fix later";
sTD_ClassSubjectStudent.StudentID = ids;
sTD_ClassSubjectStudent.ClassSubjectID = sTD_ClassSubject.ClassSubjectID;
sTD_ClassSubjectStudent.AddedBy = Profile.card_id;
sTD_ClassSubjectStudent.AddedDate = DateTime.Now;
sTD_ClassSubjectStudent.UpdatedBy = Profile.card_id;
sTD_ClassSubjectStudent.UpdateDate = DateTime.Now;
int resutl = STD_ClassSubjectStudentManager.InsertSTD_ClassSubjectStudent_List_KeepStudentInMultipleClassActive(sTD_ClassSubjectStudent);
}
}
catch (Exception ex) { }
}
}
}
catch (Exception ex) { }
Response.Redirect("Enrollment.aspx?Message=Saved succfully..");
}
private void showSTD_ClassSubjectEmployeeData()
{
STD_ClassSubjectEmployee sTD_ClassSubjectEmployee = new STD_ClassSubjectEmployee ();
sTD_ClassSubjectEmployee = STD_ClassSubjectEmployeeManager.GetSTD_ClassSubjectEmployeeByClassSubjectEmployeeID(Int32.Parse(Request.QueryString["ID"]));
txtClassSubjectEmployeeName.Text =sTD_ClassSubjectEmployee.ClassSubjectEmployeeName.ToString();
ddlEmployeeID.SelectedValue =sTD_ClassSubjectEmployee.EmployeeID.ToString();
ddlClassSubjectID.SelectedValue =sTD_ClassSubjectEmployee.ClassSubjectID.ToString();
}
