public static STD_ExamDetails GetSTD_ExamTypeByExamTypeID(int ExamTypeID)
{
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails();
SqlSTD_ExamDetailsProvider sqlSTD_ExamDetailsProvider = new SqlSTD_ExamDetailsProvider();
sTD_ExamDetails = sqlSTD_ExamDetailsProvider.GetSTD_ExamDetailsByExamTypeID(ExamTypeID);
return sTD_ExamDetails;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails();
sTD_ExamDetails.ExamDetailsID = int.Parse(Request.QueryString["ID"].ToString());
sTD_ExamDetails.ExamID = int.Parse(ddlExamID.SelectedValue);
sTD_ExamDetails.ExamTypeID = 0;
sTD_ExamDetails.ExamDetailsName = txtExamDetailsName.Text;
sTD_ExamDetails.ExtraField1 = "";
sTD_ExamDetails.ExtraField2 = "";
sTD_ExamDetails.ExtraField3 = "";
sTD_ExamDetails.ExtraField4 = "";
sTD_ExamDetails.ExtraField5 = "";
sTD_ExamDetails.AddedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_ExamDetails.AddedDate = DateTime.Now;
sTD_ExamDetails.UpdatedBy = "530038e1-cf38-4ddb-84a4-99b6974b4f9d";
sTD_ExamDetails.UpdatedDate = DateTime.Now;
sTD_ExamDetails.RowStatusID = 1;
sTD_ExamDetails.TotalMarks = decimal.Parse(txtTotalMark.Text);
bool resutl = STD_ExamDetailsManager.UpdateSTD_ExamDetails(sTD_ExamDetails);
DataSet ds = STD_ExamDetailsManager.GetSTD_ExamDetailsMarksByExamID(int.Parse(ddlExamID.SelectedValue));
decimal totalMark = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
string mark = row["TotalMarks"].ToString();
totalMark = totalMark + decimal.Parse(mark);
}
STD_Exam exam = STD_ExamManager.GetSTD_ExamByExamID(int.Parse(ddlExamID.SelectedValue));
exam.TotalMarks = totalMark;
STD_ExamManager.UpdateSTD_Exam(exam);
Response.Redirect("AdminDisplaySTD_ExamDetails.aspx");
}
catch (Exception ex)
{
}
}
private void showSTD_ExamDetailsData()
{
try
{
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails();
sTD_ExamDetails = STD_ExamDetailsManager.GetSTD_ExamDetailsByExamDetailsID(Int32.Parse(Request.QueryString["ID"]));
ddlExamID.SelectedValue = sTD_ExamDetails.ExamID.ToString();
txtExamDetailsName.Text = sTD_ExamDetails.ExamDetailsName.ToString();
txtTotalMark.Text = sTD_ExamDetails.TotalMarks.ToString();
}
catch (Exception ex)
{
}
}
public bool UpdateSTD_ExamDetails(STD_ExamDetails sTD_ExamDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_ExamDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ExamDetailsID", SqlDbType.Int).Value = sTD_ExamDetails.ExamDetailsID;
cmd.Parameters.Add("@ExamID", SqlDbType.Int).Value = sTD_ExamDetails.ExamID;
cmd.Parameters.Add("@ExamTypeID", SqlDbType.Int).Value = sTD_ExamDetails.ExamTypeID;
cmd.Parameters.Add("@ExamDetailsName", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExamDetailsName;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_ExamDetails.ExtraField5;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ExamDetails.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = sTD_ExamDetails.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ExamDetails.RowStatusID;
cmd.Parameters.Add("@TotalMarks", SqlDbType.Decimal).Value = sTD_ExamDetails.TotalMarks;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_ExamDetails GetSTD_ExamDetailsFromReader(IDataReader reader)
{
try
{
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails
(
DataAccessObject.IsNULL<int>(reader["ExamDetailsID"]),
DataAccessObject.IsNULL<int>(reader["ExamID"]),
DataAccessObject.IsNULL<int>(reader["ExamTypeID"]),
DataAccessObject.IsNULL<string>(reader["ExamDetailsName"]),
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"]),
DataAccessObject.IsNULL<decimal>(reader["TotalMarks"])
);
return sTD_ExamDetails;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
//add Std_ExamDetails
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails();
sTD_ExamDetails.ExamID = int.Parse(ddlSTDExamID.SelectedValue);
sTD_ExamDetails.ExamTypeID = 0;
sTD_ExamDetails.ExamDetailsName = "Online Quiz "+ ddlClassID.SelectedItem.Text +" for "+ddlSubjectID.SelectedItem.Text;
sTD_ExamDetails.ExtraField1 = "";
sTD_ExamDetails.ExtraField2 = "";
sTD_ExamDetails.ExtraField3 = "";
sTD_ExamDetails.ExtraField4 = "";
sTD_ExamDetails.ExtraField5 = "";
sTD_ExamDetails.AddedBy = Profile.card_id;
sTD_ExamDetails.AddedDate = DateTime.Now;
sTD_ExamDetails.UpdatedBy = Profile.card_id;
sTD_ExamDetails.UpdatedDate = DateTime.Now;
sTD_ExamDetails.RowStatusID = 1;
sTD_ExamDetails.TotalMarks = decimal.Parse(ddlQuizExamID.SelectedItem.Text.Split('(')[1].Split('=')[1].Split(' ')[0]);//CAT - MA 2 - Set-1 (Marks=4 )
sTD_ExamDetails.ExamDetailsID = STD_ExamDetailsManager.InsertSTD_ExamDetails(sTD_ExamDetails);
foreach (GridViewRow gvr in gvStudents.Rows)
{
HiddenField hfStudentID = (HiddenField)gvr.FindControl("hfStudentID");
int QuizExamID = int.Parse(ddlQuizExamID.SelectedValue);
string ExamStudentName = ddlQuizExamID.SelectedItem.Text;
if (!chkAllStudentSameExam.Checked)
{
DropDownList ddlStudentQuizExamID = (DropDownList)gvr.FindControl("ddlStudentQuizExamID");
if (ddlStudentQuizExamID.SelectedIndex == 0)//jodi ddl selected na theke then o e student er nam e exam hobe na
{
continue;
}
QuizExamID = int.Parse(ddlStudentQuizExamID.SelectedValue);
ExamStudentName = ddlStudentQuizExamID.SelectedItem.Text;
}
Quiz_ExamStudent quiz_ExamStudent = new Quiz_ExamStudent();
// quiz_ExamStudent.ExamStudentID= int.Parse(ddlExamStudentID.SelectedValue);
quiz_ExamStudent.ExamStudentName = ExamStudentName;
quiz_ExamStudent.StudentID = hfStudentID.Value;
quiz_ExamStudent.ClassSubjectID = int.Parse(ddlSubjectID.SelectedValue);
quiz_ExamStudent.STDExamDetailsID = sTD_ExamDetails.ExamDetailsID;
quiz_ExamStudent.QuizExamID = QuizExamID;
quiz_ExamStudent.ExtraField1 = "";
quiz_ExamStudent.ExtraField2 = "";
quiz_ExamStudent.ExtraField3 = "";
quiz_ExamStudent.ExtraField4 = "";
quiz_ExamStudent.ExtraField5 = "";
quiz_ExamStudent.AddedBy = Profile.card_id;
quiz_ExamStudent.AddedDate = DateTime.Now;
quiz_ExamStudent.UpdatedBy = Profile.card_id;
quiz_ExamStudent.UpdateDate = DateTime.Now;
quiz_ExamStudent.RowStatusID = 1;
quiz_ExamStudent.ExamStudentID = Quiz_ExamStudentManager.InsertQuiz_ExamStudent(quiz_ExamStudent);
}
}
catch(Exception ex)
{
}
}
public static int InsertSTD_ExamDetails(STD_ExamDetails sTD_ExamDetails)
{
SqlSTD_ExamDetailsProvider sqlSTD_ExamDetailsProvider = new SqlSTD_ExamDetailsProvider();
return sqlSTD_ExamDetailsProvider.InsertSTD_ExamDetails(sTD_ExamDetails);
}
public static STD_ExamDetails GetSTD_RowStatusByRowStatusID(int RowStatusID)
{
STD_ExamDetails sTD_ExamDetails = new STD_ExamDetails();
SqlSTD_ExamDetailsProvider sqlSTD_ExamDetailsProvider = new SqlSTD_ExamDetailsProvider();
sTD_ExamDetails = sqlSTD_ExamDetailsProvider.GetSTD_ExamDetailsByRowStatusID(RowStatusID);
return sTD_ExamDetails;
}
public static bool UpdateSTD_ExamDetails(STD_ExamDetails sTD_ExamDetails)
{
SqlSTD_ExamDetailsProvider sqlSTD_ExamDetailsProvider = new SqlSTD_ExamDetailsProvider();
return sqlSTD_ExamDetailsProvider.UpdateSTD_ExamDetails(sTD_ExamDetails);
}
