public static STD_Class GetSTD_ClassByClassID(int ClassID)
{
STD_Class sTD_Class = new STD_Class();
SqlSTD_ClassProvider sqlSTD_ClassProvider = new SqlSTD_ClassProvider();
sTD_Class = sqlSTD_ClassProvider.GetSTD_ClassByClassID(ClassID);
return sTD_Class;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int resutl = 0;
try
{
STD_Class sTD_Class = new STD_Class();
// sTD_Class.ClassID= int.Parse(ddlClassID.SelectedValue);
sTD_Class.ClassName = txtClassName.Text;
sTD_Class.CourseID = int.Parse(ddlCourseID.SelectedValue);
sTD_Class.ClassTypeID = int.Parse(ddlClassTypeID.SelectedValue);
sTD_Class.ClassStatusID = int.Parse(ddlClassStatusID.SelectedValue);
sTD_Class.AddedBy = Profile.card_id;
if (txtStartDate.Text != "")
sTD_Class.AddedDate = DateTime.Parse(txtStartDate.Text);
else
sTD_Class.AddedDate = DateTime.Now;
sTD_Class.UpdatedBy = Profile.card_id;
sTD_Class.UpdateDate = DateTime.Now;
resutl = STD_ClassManager.InsertSTD_Class(sTD_Class);
}
catch (Exception ex) { }
Response.Redirect("ClassSubjectAdd.aspx?ID=" + resutl.ToString()); //loadGrid();
}
public static STD_Class GetSTD_BasicInfoForStudentsAttentdant(int classID, int subjectID, string employeeID)
{
STD_Class sTD_Class = new STD_Class();
SqlSTD_ClassProvider sqlSTD_ClassProvider = new SqlSTD_ClassProvider();
sTD_Class = sqlSTD_ClassProvider.GetSTD_BasicInfoForStudentsAttentdant(classID,subjectID,employeeID);
return sTD_Class;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_Class sTD_Class = new STD_Class ();
sTD_Class.ClassID= int.Parse(Request.QueryString["ID"].ToString());
sTD_Class.ClassName= txtClassName.Text;
sTD_Class.ClassTypeID= int.Parse(ddlClassTypeID.SelectedValue);
sTD_Class.ClassStatusID= int.Parse(ddlClassStatusID.SelectedValue);
sTD_Class.AddedBy= Profile.card_id;
sTD_Class.AddedDate= DateTime.Now;
sTD_Class.UpdatedBy= Profile.card_id;
sTD_Class.UpdateDate = DateTime.Now;
bool resutl =STD_ClassManager.UpdateSTD_Class(sTD_Class);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_Class.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_Class sTD_Class = new STD_Class ();
// sTD_Class.ClassID= int.Parse(ddlClassID.SelectedValue);
sTD_Class.ClassName= txtClassName.Text;
sTD_Class.ClassTypeID= int.Parse(ddlClassTypeID.SelectedValue);
sTD_Class.ClassStatusID= int.Parse(ddlClassStatusID.SelectedValue);
sTD_Class.AddedBy= Profile.card_id;
sTD_Class.AddedDate= DateTime.Now;
sTD_Class.UpdatedBy= Profile.card_id;
sTD_Class.UpdateDate = DateTime.Now;
int resutl =STD_ClassManager.InsertSTD_Class(sTD_Class);
}catch(Exception ex){}Response.Redirect("AdminDisplaySTD_Class.aspx");
}
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_ClassData()
{
STD_Class sTD_Class = new STD_Class();
sTD_Class = STD_ClassManager.GetSTD_ClassByClassID(Int32.Parse(Request.QueryString["ID"]));
txtClassName.Text = sTD_Class.ClassName.ToString();
ddlCourseID.SelectedValue = sTD_Class.CourseID.ToString();
ddlClassTypeID.SelectedValue = sTD_Class.ClassTypeID.ToString();
ddlClassStatusID.SelectedValue = sTD_Class.ClassStatusID.ToString();
if (ddlClassStatusID.SelectedValue == "2")
txtStartDate.Text = sTD_Class.AddedDate.ToString("dd MMM, yyyy");
}
public static bool UpdateSTD_Class(STD_Class sTD_Class)
{
SqlSTD_ClassProvider sqlSTD_ClassProvider = new SqlSTD_ClassProvider();
return sqlSTD_ClassProvider.UpdateSTD_Class(sTD_Class);
}
public static int InsertSTD_Class(STD_Class sTD_Class)
{
SqlSTD_ClassProvider sqlSTD_ClassProvider = new SqlSTD_ClassProvider();
return sqlSTD_ClassProvider.InsertSTD_Class(sTD_Class);
}
public bool UpdateSTD_Class(STD_Class sTD_Class)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_Class", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_Class.ClassID;
cmd.Parameters.Add("@ClassName", SqlDbType.NVarChar).Value = sTD_Class.ClassName;
cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = sTD_Class.CourseID;
cmd.Parameters.Add("@ClassTypeID", SqlDbType.Int).Value = sTD_Class.ClassTypeID;
cmd.Parameters.Add("@ClassStatusID", SqlDbType.Int).Value = sTD_Class.ClassStatusID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_Class.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_Class.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_Class.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_Class.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_Class GetSTD_ClassFromReader1(IDataReader reader)
{
try
{
STD_Class sTD_Class = new STD_Class
(
DataAccessObject.IsNULL<string>(reader["ClassName"]),
DataAccessObject.IsNULL<string>(reader["CourseName"]),
DataAccessObject.IsNULL<string>(reader["SubjectName"]),
DataAccessObject.IsNULL<string>(reader["EmployeeName"])
);
try
{
sTD_Class.ClassID =DataAccessObject.IsNULL<int>(reader["ClassID"]);
}
catch (Exception ex)
{
}
try
{
sTD_Class.CourseID = DataAccessObject.IsNULL<int>(reader["CourseID"]);
}
catch (Exception ex)
{
}
try
{
sTD_Class.SubjectID = DataAccessObject.IsNULL<int>(reader["SubjectID"]);
}
catch (Exception ex)
{
}
try
{
sTD_Class.EmployeeID = (DataAccessObject.IsNULL<Guid>(reader["EmployeeID"])).ToString();
}
catch (Exception ex)
{
}
return sTD_Class;
}
catch (Exception ex)
{
return null;
}
}
public STD_Class GetSTD_ClassFromReader(IDataReader reader)
{
try
{
STD_Class sTD_Class = new STD_Class
(
DataAccessObject.IsNULL<int>(reader["ClassID"]),
DataAccessObject.IsNULL<string>(reader["ClassName"]),
DataAccessObject.IsNULL<int>(reader["CourseID"]),
DataAccessObject.IsNULL<int>(reader["ClassTypeID"]),
DataAccessObject.IsNULL<int>(reader["ClassStatusID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
try
{
sTD_Class.CourseName = DataAccessObject.IsNULL<string>(reader["CourseName"]);
sTD_Class.ClassTypeName = DataAccessObject.IsNULL<string>(reader["ClassTypeName"]);
sTD_Class.ClassStatusName = DataAccessObject.IsNULL<string>(reader["ClassStatusName"]);
}
catch (Exception ex)
{ }
try
{
sTD_Class.RowStatusID = int.Parse(reader["RowStatusID"].ToString());
}
catch (Exception ex)
{ }
return sTD_Class;
}
catch (Exception ex)
{
return null;
}
}
private void showSTD_ClassData()
{
STD_Class sTD_Class = new STD_Class ();
sTD_Class = STD_ClassManager.GetSTD_ClassByClassID(Int32.Parse(Request.QueryString["ID"]));
txtClassName.Text =sTD_Class.ClassName.ToString();
ddlClassTypeID.SelectedValue =sTD_Class.ClassTypeID.ToString();
ddlClassStatusID.SelectedValue =sTD_Class.ClassStatusID.ToString();
}
