public static STD_ExamDetailsStudent GetSTD_StudentByStudentID(string StudentID)
{
STD_ExamDetailsStudent sTD_ExamDetailsStudent = new STD_ExamDetailsStudent();
SqlSTD_ExamDetailsStudentProvider sqlSTD_ExamDetailsStudentProvider = new SqlSTD_ExamDetailsStudentProvider();
sTD_ExamDetailsStudent = sqlSTD_ExamDetailsStudentProvider.GetSTD_ExamDetailsStudentByStudentID(StudentID);
return sTD_ExamDetailsStudent;
}
protected void btnOk_OnClick(object sender, EventArgs e)
{
STD_Student student = new STD_Student();
if (Profile.IsStudent)
{
student.StudentID = Profile.card_id;
}
else
{
student = STD_StudentManager.GetHR_StudnetByStudentCode(txtStudentCode.Text);
}
List<STD_ExamDetailsStudent> results = new List<STD_ExamDetailsStudent>();
DataSet tblResults = STD_ExamDetailsStudentManager.GetSTD_ExamResultByStudentID(student.StudentID);
foreach (DataTable tblResult in tblResults.Tables)
{
foreach (DataRow dr in tblResult.Rows)
{
STD_ExamDetailsStudent result = new STD_ExamDetailsStudent();
result.TotalMark = dr["TotalMarks"].ToString();
result.ObtainedMark = decimal.Parse(dr["ObtainedMark"].ToString());
result.ExamName = dr["ExamName"].ToString();
result.ExamID = int.Parse(dr["ExamID"].ToString());
result.StudentID = student.StudentID;
results.Add(result);
}
}
gvSTD_ExamDetails.DataSource = results;
gvSTD_ExamDetails.DataBind();
}
public static STD_ExamDetailsStudent GetSTD_RowStatusByRowStatusID(int RowStatusID)
{
STD_ExamDetailsStudent sTD_ExamDetailsStudent = new STD_ExamDetailsStudent();
SqlSTD_ExamDetailsStudentProvider sqlSTD_ExamDetailsStudentProvider = new SqlSTD_ExamDetailsStudentProvider();
sTD_ExamDetailsStudent = sqlSTD_ExamDetailsStudentProvider.GetSTD_ExamDetailsStudentByRowStatusID(RowStatusID);
return sTD_ExamDetailsStudent;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
STD_ExamDetailsStudent sTD_ExamDetailsStudent = new STD_ExamDetailsStudent();
// sTD_ExamDetailsStudent.ExamDetailsStudentID= int.Parse(ddlExamDetailsStudentID.SelectedValue);
DataSet ds = STD_StudentManager.GetSTD_ExamStudentsByExamDetailsID(Convert.ToInt32(ddlExamDetailsID.SelectedValue));
int i = 0;
foreach (GridViewRow row in gvSTD_Exam.Rows)
{
Label lblSID = (Label)row.FindControl("lblSID");
TextBox txtObtainMark = (TextBox)row.FindControl("txtObtainMark");
string mark = ds.Tables[0].Rows[i]["ObtainedMark"].ToString();
if (mark == "")
{
if (txtObtainMark.Text != "")
{
sTD_ExamDetailsStudent.ExamDetailsStudentName = "Exam Student";
sTD_ExamDetailsStudent.ExamDetailsID = int.Parse(ddlExamDetailsID.SelectedValue);
sTD_ExamDetailsStudent.StudentID = lblSID.Text;
sTD_ExamDetailsStudent.ObtainedMark = txtObtainMark.Text != "" ? decimal.Parse(txtObtainMark.Text) : 0;
sTD_ExamDetailsStudent.ExtraField1 = "";
sTD_ExamDetailsStudent.ExtraField2 = "";
sTD_ExamDetailsStudent.ExtraField3 = "";
sTD_ExamDetailsStudent.ExtraField4 = "";
sTD_ExamDetailsStudent.ExtraField5 = "";
sTD_ExamDetailsStudent.AddedBy = Profile.card_id;
sTD_ExamDetailsStudent.AddedDate = DateTime.Now;
sTD_ExamDetailsStudent.UpdatedBy = Profile.card_id;
sTD_ExamDetailsStudent.UpdatedDate = DateTime.Now;
sTD_ExamDetailsStudent.RowStatusID = 1;
int resutl = STD_ExamDetailsStudentManager.InsertSTD_ExamDetailsStudent(sTD_ExamDetailsStudent);
}
i++;
}
else
{
string id = ds.Tables[0].Rows[i]["ExamDetailsStudentID"].ToString();
STD_ExamDetailsStudent sTDUpdate_ExamDetailsStudent = STD_ExamDetailsStudentManager.GetSTD_ExamDetailsStudentByExamDetailsStudentID(int.Parse(id));
sTDUpdate_ExamDetailsStudent.ExamDetailsStudentName = "Exam Student";
sTDUpdate_ExamDetailsStudent.ExamDetailsID = int.Parse(ddlExamDetailsID.SelectedValue);
sTDUpdate_ExamDetailsStudent.StudentID = lblSID.Text;
sTDUpdate_ExamDetailsStudent.ObtainedMark = txtObtainMark.Text != "" ? decimal.Parse(txtObtainMark.Text) : 0;
bool resutl = STD_ExamDetailsStudentManager.UpdateSTD_ExamDetailsStudent(sTDUpdate_ExamDetailsStudent);
i++;
}
}
Response.Redirect("AdminDisplaySTD_ExamDetailsStudent.aspx");
}
public bool UpdateSTD_ExamDetailsStudent(STD_ExamDetailsStudent sTD_ExamDetailsStudent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_ExamDetailsStudent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ExamDetailsStudentID", SqlDbType.Int).Value = sTD_ExamDetailsStudent.ExamDetailsStudentID;
cmd.Parameters.Add("@ExamDetailsStudentName", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExamDetailsStudentName;
cmd.Parameters.Add("@ExamDetailsID", SqlDbType.Int).Value = sTD_ExamDetailsStudent.ExamDetailsID;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.StudentID;
cmd.Parameters.Add("@ObtainedMark", SqlDbType.Decimal).Value = sTD_ExamDetailsStudent.ObtainedMark;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.ExtraField5;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ExamDetailsStudent.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = sTD_ExamDetailsStudent.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ExamDetailsStudent.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_ExamDetailsStudent GetSTD_ExamDetailsStudentFromReader(IDataReader reader)
{
try
{
STD_ExamDetailsStudent sTD_ExamDetailsStudent = new STD_ExamDetailsStudent
(
DataAccessObject.IsNULL<int>(reader["ExamDetailsStudentID"]),
DataAccessObject.IsNULL<string>(reader["ExamDetailsStudentName"]),
DataAccessObject.IsNULL<int>(reader["ExamDetailsID"]),
DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()),
DataAccessObject.IsNULL<decimal>(reader["ObtainedMark"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return sTD_ExamDetailsStudent;
}
catch(Exception ex)
{
return null;
}
}
public static int InsertSTD_ExamDetailsStudent(STD_ExamDetailsStudent sTD_ExamDetailsStudent)
{
SqlSTD_ExamDetailsStudentProvider sqlSTD_ExamDetailsStudentProvider = new SqlSTD_ExamDetailsStudentProvider();
return sqlSTD_ExamDetailsStudentProvider.InsertSTD_ExamDetailsStudent(sTD_ExamDetailsStudent);
}
public static bool UpdateSTD_ExamDetailsStudent(STD_ExamDetailsStudent sTD_ExamDetailsStudent)
{
SqlSTD_ExamDetailsStudentProvider sqlSTD_ExamDetailsStudentProvider = new SqlSTD_ExamDetailsStudentProvider();
return sqlSTD_ExamDetailsStudentProvider.UpdateSTD_ExamDetailsStudent(sTD_ExamDetailsStudent);
}
