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); }