protected void btnAdd2_Click(object sender, EventArgs e)
{
try
{
//string ids = getStudentID();
string ids = getStudentIDs(gvStudents);
if (ids != "")
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
sTD_ClassStudent.ClassStudentName = "";
sTD_ClassStudent.StudentID = ids;
sTD_ClassStudent.ClassID = int.Parse("1");
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);
txtStudentIDs.Text = "";
//Response.Redirect("ClassSubjectAddStudent.aspx?ID=" + ddlClassID.SelectedValue);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "Message", "alert('" + ex.Message.ToString() + "');", true);
}
}
public static STD_ClassStudent GetSTD_ClassStudentByClassStudentID(int ClassStudentID)
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
SqlSTD_ClassStudentProvider sqlSTD_ClassStudentProvider = new SqlSTD_ClassStudentProvider();
sTD_ClassStudent = sqlSTD_ClassStudentProvider.GetSTD_ClassStudentByClassStudentID(ClassStudentID);
return sTD_ClassStudent;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent ();
sTD_ClassStudent.ClassStudentID= int.Parse(Request.QueryString["ID"].ToString());
sTD_ClassStudent.ClassStudentName= txtClassStudentName.Text;
sTD_ClassStudent.StudentID= ddlStudentID.SelectedValue;
sTD_ClassStudent.ClassID= int.Parse(ddlClassID.SelectedValue);
sTD_ClassStudent.AddedBy= Profile.card_id;
sTD_ClassStudent.AddedDate= DateTime.Now;
sTD_ClassStudent.UpdatedBy= Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
bool resutl =STD_ClassStudentManager.UpdateSTD_ClassStudent(sTD_ClassStudent);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_ClassStudent.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
// sTD_ClassStudent.ClassStudentID= int.Parse(ddlClassStudentID.SelectedValue);
sTD_ClassStudent.ClassStudentName = txtClassStudentName.Text;
sTD_ClassStudent.StudentID = ddlStudentID.SelectedValue;
sTD_ClassStudent.ClassID = int.Parse(ddlClassID.SelectedValue);
sTD_ClassStudent.AddedBy = Profile.card_id;
sTD_ClassStudent.AddedDate = DateTime.Now;
sTD_ClassStudent.UpdatedBy = Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
sTD_ClassStudent.RowStatusID = 1;
int resutl = STD_ClassStudentManager.InsertSTD_ClassStudent(sTD_ClassStudent);
}
catch (Exception ex)
{
}
Response.Redirect("AdminDisplaySTD_ClassStudent.aspx");
}
public static int InsertSTD_ClassStudent_List_KeepStudentInMultipleClassActive(STD_ClassStudent sTD_ClassStudent)
{
SqlSTD_ClassStudentProvider sqlSTD_ClassStudentProvider = new SqlSTD_ClassStudentProvider();
return sqlSTD_ClassStudentProvider.InsertSTD_ClassStudent_List_KeepStudentInMultipleClassActive(sTD_ClassStudent);
}
public static int InsertSTD_ClassStudent_List(STD_ClassStudent sTD_ClassStudent)
{
SqlSTD_ClassStudentProvider sqlSTD_ClassStudentProvider = new SqlSTD_ClassStudentProvider();
return sqlSTD_ClassStudentProvider.InsertSTD_ClassStudent_List(sTD_ClassStudent);
}
public static STD_ClassStudent GetSTD_StudentByStudentID(string StudentID)
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
SqlSTD_ClassStudentProvider sqlSTD_ClassStudentProvider = new SqlSTD_ClassStudentProvider();
sTD_ClassStudent = sqlSTD_ClassStudentProvider.GetSTD_ClassStudentByStudentID(StudentID);
return sTD_ClassStudent;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string ids = getStudentID();
if (ids != "")
{
string[] words = ids.Split(',');
foreach (string word in words)
{
if (word != "")
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
sTD_ClassStudent.ClassStudentName = ddlSubjectID.SelectedItem.Text;
sTD_ClassStudent.StudentID = word;
sTD_ClassStudent.ClassID = int.Parse(ddlSubjectID.SelectedValue);
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(sTD_ClassStudent);
}
}
}
}
catch (Exception ex) { }
Response.Redirect("ClassSubjectAddStudent.aspx?ID=" + ddlSubjectID.SelectedValue); //loadGrid();
//btnUpdate.Visible = false;
}
protected void btnEnrollment_Click(object sender, EventArgs e)
{
bool isAlreadyAdded= false;
int classSubjectID = 0;
foreach (GridViewRow gvr in gvSTD_Class.Rows)
{
HiddenField hfClassID = (HiddenField)gvr.FindControl("hfClassID");
HiddenField hfIsHistory = (HiddenField)gvr.FindControl("hfIsHistory");
if (!bool.Parse(hfIsHistory.Value) && ddlClassID.SelectedValue == hfClassID.Value)
{
isAlreadyAdded = true;
break;
}
}
if (!isAlreadyAdded)
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
sTD_ClassStudent.ClassStudentName = "";
sTD_ClassStudent.StudentID = hfStudentID.Value;
sTD_ClassStudent.ClassID = int.Parse(ddlClassID.SelectedValue);
sTD_ClassStudent.AddedBy = Profile.card_id;
sTD_ClassStudent.AddedDate = DateTime.Now;
sTD_ClassStudent.UpdatedBy = Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
sTD_ClassStudent.RowStatusID = 1;
classSubjectID = STD_ClassStudentManager.InsertSTD_ClassStudent(sTD_ClassStudent);
}
foreach (GridViewRow item in gvSubjects.Rows)
{
CheckBox chkSubject = (CheckBox)item.FindControl("chkSubject");
//HiddenField hfClassSubjectID = (HiddenField)item.FindControl("hfClassSubjectID");
if (chkSubject.Checked)
{
STD_ClassSubjectStudent sTD_ClassSubjectStudent = new STD_ClassSubjectStudent();
// sTD_ClassSubjectStudent.ClassSubjectStudentID= int.Parse(ddlClassSubjectStudentID.SelectedValue);
sTD_ClassSubjectStudent.ClassSubjectStudentName = "";
sTD_ClassSubjectStudent.StudentID = hfStudentID.Value;
sTD_ClassSubjectStudent.ClassSubjectID = int.Parse(((HiddenField)item.FindControl("hfClassSubjectID")).Value);
sTD_ClassSubjectStudent.AddedBy = Profile.card_id;
sTD_ClassSubjectStudent.AddedDate = DateTime.Now;
sTD_ClassSubjectStudent.UpdatedBy = Profile.card_id;
sTD_ClassSubjectStudent.UpdateDate = DateTime.Now;
sTD_ClassSubjectStudent.RowStatusID = 1;
int resutl = STD_ClassSubjectStudentManager.InsertSTD_ClassSubjectStudent(sTD_ClassSubjectStudent);
}
}
btnVarify_OnClick(this, new EventArgs());
ddlClassID.SelectedIndex=0;
ddlClassID_SelectedIndexChanged(this,new EventArgs());
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Session["id"] != null)
{
string[] id = Session["id"].ToString().Split(',');
for (int i = 0; i < id.Length-1; i++)
{
STD_ClassSubjectStudent sTD_ClassSubjectStudent = STD_ClassSubjectStudentManager.GetSTD_ClassSubjectStudentByClassSubjectStudentID(Convert.ToInt32(id[i]));
sTD_ClassSubjectStudent.RowStatusID = 3;
STD_ClassSubjectStudentManager.UpdateSTD_ClassSubjectStudent(sTD_ClassSubjectStudent);
}
}
//insert the classes which are not assigned for that student
string classIDsNeedtoAddinDataBase = "";
hfclassIDs.Value = "";
DataSet ds = STD_ClassStudentManager.GetSTD_ClassStudentByStudentID(hfStudentID.Value, true);
foreach (DataRow dr in ds.Tables[0].Rows)
{
hfclassIDs.Value += dr["ClassID"].ToString() + "-";
}
if (Session["ClassSubjectStudents"] != null)
{
List<STD_ClassSubjectStudent> ClassSubjectStudents = new List<STD_ClassSubjectStudent>();
ClassSubjectStudents = (List<STD_ClassSubjectStudent>)Session["ClassSubjectStudents"];
foreach (STD_ClassSubjectStudent classSubjectStudent in ClassSubjectStudents)
{
if (!hfclassIDs.Value.Contains(classSubjectStudent.ClassID.ToString()))
{
classIDsNeedtoAddinDataBase += classSubjectStudent.ClassID.ToString() + "-";
}
}
if (classIDsNeedtoAddinDataBase != "")
{
string[] ids = classIDsNeedtoAddinDataBase.Split('-');
foreach (string id in ids)
{
if (id != "" && id != "-")
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
// sTD_ClassStudent.ClassStudentID= int.Parse(ddlClassStudentID.SelectedValue);
sTD_ClassStudent.ClassStudentName = "";
sTD_ClassStudent.StudentID = hfStudentID.Value;
sTD_ClassStudent.ClassID = int.Parse(id);
sTD_ClassStudent.AddedBy = Profile.card_id;
sTD_ClassStudent.AddedDate = DateTime.Now;
sTD_ClassStudent.UpdatedBy = Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
sTD_ClassStudent.RowStatusID = 1;
int resutl = STD_ClassStudentManager.InsertSTD_ClassStudent(sTD_ClassStudent);
}
}
}
//Need to add the ClassSubject Student
//insert the classes which are not assigned for that student
string classSubjectIDsNeedtoAddinDataBase = "";
hfclassIDs.Value = "";
DataSet dsclassSubject = STD_ClassSubjectStudentManager.GetSTD_ClassSubjectStudentByStudentID(hfStudentID.Value);
foreach (DataRow dr in dsclassSubject.Tables[0].Rows)
{
hfclassSubjectIDs.Value += dr["ClassSubjectID"].ToString() + "-";
}
foreach (STD_ClassSubjectStudent classSubjectStudent in ClassSubjectStudents)
{
if (!hfclassSubjectIDs.Value.Contains(classSubjectStudent.ClassSubjectID.ToString()))
{
classSubjectIDsNeedtoAddinDataBase += classSubjectStudent.ClassSubjectID.ToString() + "-";
}
}
if (classSubjectIDsNeedtoAddinDataBase != "")
{
string[] ids = classSubjectIDsNeedtoAddinDataBase.Split('-');
foreach (string id in ids)
{
if (id != "" && id != "-")
{
STD_ClassSubjectStudent sTD_ClassSubjectStudent = new STD_ClassSubjectStudent();
// sTD_ClassSubjectStudent.ClassSubjectStudentID= int.Parse(ddlClassSubjectStudentID.SelectedValue);
sTD_ClassSubjectStudent.ClassSubjectStudentName = "";
sTD_ClassSubjectStudent.StudentID = hfStudentID.Value;
sTD_ClassSubjectStudent.ClassSubjectID = int.Parse(id);
sTD_ClassSubjectStudent.AddedBy = Profile.card_id;
sTD_ClassSubjectStudent.AddedDate = DateTime.Now;
sTD_ClassSubjectStudent.UpdatedBy = Profile.card_id;
sTD_ClassSubjectStudent.UpdateDate = DateTime.Now;
sTD_ClassSubjectStudent.RowStatusID = 1;
int resutl = STD_ClassSubjectStudentManager.InsertSTD_ClassSubjectStudent(sTD_ClassSubjectStudent);
}
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Save successfully.')", true);
}
else
{
foreach (STD_ClassSubjectStudent classSubjectStudent in ClassSubjectStudents)
{
classSubjectStudent.RowStatusID = 1;
STD_ClassSubjectStudentManager.UpdateSTD_ClassSubjectStudent(classSubjectStudent);
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Save successfully.')", true);
}
}
}
catch (Exception ex)
{
}
}
public int InsertSTD_ClassStudent_List_KeepStudentInMultipleClassActive(STD_ClassStudent sTD_ClassStudent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertSTD_ClassStudent_List_KeepStudentInMultipleClassActive", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Count", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@StudentIDs", SqlDbType.NVarChar).Value = sTD_ClassStudent.StudentID;
cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_ClassStudent.ClassID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_ClassStudent.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_ClassStudent.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ClassStudent.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ClassStudent.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@Count"].Value;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
//insert the classes which are not assigned for that student
string classIDsNeedtoAddinDataBase = "";
hfclassIDs.Value = "";
DataSet ds = STD_ClassStudentManager.GetSTD_ClassStudentByStudentID(hfStudentID.Value, true);
foreach (DataRow dr in ds.Tables[0].Rows)
{
hfclassIDs.Value += dr["ClassID"].ToString() + "-";
}
List<STD_ClassSubjectStudent> ClassSubjectStudents = new List<STD_ClassSubjectStudent>();
ClassSubjectStudents = (List<STD_ClassSubjectStudent>)Session["ClassSubjectStudents"];
foreach (STD_ClassSubjectStudent classSubjectStudent in ClassSubjectStudents)
{
if (!hfclassIDs.Value.Contains(classSubjectStudent.ClassID.ToString()))
{
classIDsNeedtoAddinDataBase += classSubjectStudent.ClassID.ToString() + "-";
}
}
if (classIDsNeedtoAddinDataBase != "")
{
string[] ids = classIDsNeedtoAddinDataBase.Split('-');
foreach (string id in ids)
{
if (id != "" && id != "-")
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent();
// sTD_ClassStudent.ClassStudentID= int.Parse(ddlClassStudentID.SelectedValue);
sTD_ClassStudent.ClassStudentName = "";
sTD_ClassStudent.StudentID = hfStudentID.Value;
sTD_ClassStudent.ClassID = int.Parse(id);
sTD_ClassStudent.AddedBy = Profile.card_id;
sTD_ClassStudent.AddedDate = DateTime.Now;
sTD_ClassStudent.UpdatedBy = Profile.card_id;
sTD_ClassStudent.UpdateDate = DateTime.Now;
sTD_ClassStudent.RowStatusID = 1;
int resutl = STD_ClassStudentManager.InsertSTD_ClassStudent(sTD_ClassStudent);
}
}
}
//Need to add the ClassSubject Student
//insert the classes which are not assigned for that student
string classSubjectIDsNeedtoAddinDataBase = "";
hfclassIDs.Value = "";
DataSet dsclassSubject = STD_ClassSubjectStudentManager.GetSTD_ClassSubjectStudentByStudentID(hfStudentID.Value);
foreach (DataRow dr in dsclassSubject.Tables[0].Rows)
{
hfclassSubjectIDs.Value += dr["ClassSubjectID"].ToString() + "-";
}
foreach (STD_ClassSubjectStudent classSubjectStudent in ClassSubjectStudents)
{
if (!hfclassSubjectIDs.Value.Contains(classSubjectStudent.ClassSubjectID.ToString()))
{
classSubjectIDsNeedtoAddinDataBase += classSubjectStudent.ClassSubjectID.ToString() + "-";
}
}
if (classSubjectIDsNeedtoAddinDataBase != "")
{
string[] ids = classSubjectIDsNeedtoAddinDataBase.Split('-');
foreach (string id in ids)
{
if (id != "" && id != "-")
{
STD_ClassSubjectStudent sTD_ClassSubjectStudent = new STD_ClassSubjectStudent();
// sTD_ClassSubjectStudent.ClassSubjectStudentID= int.Parse(ddlClassSubjectStudentID.SelectedValue);
sTD_ClassSubjectStudent.ClassSubjectStudentName = "";
sTD_ClassSubjectStudent.StudentID = hfStudentID.Value;
sTD_ClassSubjectStudent.ClassSubjectID = int.Parse(id);
sTD_ClassSubjectStudent.AddedBy = Profile.card_id;
sTD_ClassSubjectStudent.AddedDate = DateTime.Now;
sTD_ClassSubjectStudent.UpdatedBy = Profile.card_id;
sTD_ClassSubjectStudent.UpdateDate = DateTime.Now;
sTD_ClassSubjectStudent.RowStatusID = 1;
int resutl = STD_ClassSubjectStudentManager.InsertSTD_ClassSubjectStudent(sTD_ClassSubjectStudent);
}
}
}
}
catch (Exception ex)
{
}
}
private void showSTD_ClassStudentData()
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent ();
sTD_ClassStudent = STD_ClassStudentManager.GetSTD_ClassStudentByClassStudentID(Int32.Parse(Request.QueryString["ID"]));
txtClassStudentName.Text =sTD_ClassStudent.ClassStudentName.ToString();
ddlStudentID.SelectedValue =sTD_ClassStudent.StudentID.ToString();
ddlClassID.SelectedValue =sTD_ClassStudent.ClassID.ToString();
}
public bool UpdateSTD_ClassStudent(STD_ClassStudent sTD_ClassStudent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_ClassStudent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClassStudentID", SqlDbType.Int).Value = sTD_ClassStudent.ClassStudentID;
cmd.Parameters.Add("@ClassStudentName", SqlDbType.NVarChar).Value = sTD_ClassStudent.ClassStudentName;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ClassStudent.StudentID;
cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_ClassStudent.ClassID;
//cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_ClassStudent.ClassID;
//cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_ClassStudent.ClassID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ClassStudent.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ClassStudent.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ClassStudent.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static bool UpdateSTD_ClassStudent(STD_ClassStudent sTD_ClassStudent)
{
SqlSTD_ClassStudentProvider sqlSTD_ClassStudentProvider = new SqlSTD_ClassStudentProvider();
return sqlSTD_ClassStudentProvider.UpdateSTD_ClassStudent(sTD_ClassStudent);
}
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..");
}
public STD_ClassStudent GetSTD_ClassStudentFromReader(IDataReader reader)
{
try
{
STD_ClassStudent sTD_ClassStudent = new STD_ClassStudent
(
DataAccessObject.IsNULL<int>(reader["ClassStudentID"]),
DataAccessObject.IsNULL<string>(reader["ClassStudentName"]),
DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()),
DataAccessObject.IsNULL<int>(reader["ClassID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return sTD_ClassStudent;
}
catch(Exception ex)
{
return null;
}
}
