internal void SaveTheExamInformation(ExamTitle aExamTitleObj)
{
try
{
connection.Open();
string selectQuery = @"INSERT INTO [tbl_exam_title_information]
([exti_id]
,[exti_name])
VALUES
('" + aExamTitleObj.Id + "','" + aExamTitleObj.Name + "')";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
public ActionResult DeleteConfirmed(int id)
{
ExamTitle examTitle = db.ExamTitle.Find(id);
db.ExamTitle.Remove(examTitle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(ExamTitle examTitle)
{
if (ModelState.IsValid)
{
db.Entry(examTitle).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EducationLevelId = new SelectList(db.EducationLevel, "Id", "EducationLevelNaame", examTitle.EducationLevelId);
return(View(examTitle));
}
public ActionResult Create(ExamTitle examTitle)
{
if (ModelState.IsValid)
{
db.ExamTitle.Add(examTitle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EducationLevelId = new SelectList(db.EducationLevel, "Id", "EducationLevelNaame", examTitle.EducationLevelId);
return(View(examTitle));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExamTitle examTitle = db.ExamTitle.Find(id);
if (examTitle == null)
{
return(HttpNotFound());
}
return(View(examTitle));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExamTitle examTitle = db.ExamTitle.Find(id);
if (examTitle == null)
{
return(HttpNotFound());
}
ViewBag.EducationLevelId = new SelectList(db.EducationLevel, "Id", "EducationLevelNaame", examTitle.EducationLevelId);
return(View(examTitle));
}
internal List <ExamTitle> GetAllExamTitleInformationForSpecificEmployee(string employeeId)
{
try
{
connection.Open();
string selectQuery = @"SELECT (SELECT [exti_name] FROM [tbl_exam_title_information] WHERE [exti_id]=[edi_exam_title_id])
,[edi_institute_name]
,[edi_gpa]
,[edi_grade]
FROM [tbl_employee_education_info] WHERE [edi_employee_id]='" + employeeId + "'";
SqlCommand command = new SqlCommand(selectQuery, connection);
SqlDataReader reader = command.ExecuteReader();
List <ExamTitle> axamTitlelIST = new List <ExamTitle>();
if (reader.HasRows)
{
while (reader.Read())
{
ExamTitle aExamTitleObj = new ExamTitle();
aExamTitleObj.ExamId = reader[0].ToString();
aExamTitleObj.Inistitute = reader[1].ToString();
aExamTitleObj.GPA = reader[2].ToString();
aExamTitleObj.Grade = reader[3].ToString();
axamTitlelIST.Add(aExamTitleObj);
}
}
return(axamTitlelIST);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
internal void DeleteTheExam(ExamTitle aExamTitleObj)
{
try
{
connection.Open();
string selectQuery = @"DELETE FROM [tbl_exam_title_information] WHERE [exti_id] ='" + aExamTitleObj.Id + "' ";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
internal void UpdateTheOldExamInforation(ExamTitle aExamTitleObj)
{
try
{
connection.Open();
string selectQuery = @"UPDATE [tbl_exam_title_information]
SET[exti_name] ='" + aExamTitleObj.Name + "' WHERE [exti_id] ='" + aExamTitleObj.Id + "' ";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
public void UpdateTheExam(ExamTitle aExamTitleObj)
{
aExamTitleGatewayObj.UpdateTheOldExamInforation(aExamTitleObj);
}
public void DeleteTheExam(ExamTitle aExamTitleObj)
{
aExamTitleGatewayObj.DeleteTheExam(aExamTitleObj);
}
public void SaveTheExamInformation(ExamTitle aExamTitleObj)
{
aExamTitleGatewayObj.SaveTheExamInformation(aExamTitleObj);
}
