//Calculating Marks on the basis of Checklist public ActionResult ChecklistCalculation(PrevisitProcess model) { if (!ModelState.IsValid) return RedirectToAction("ApplicationAdminDetail", "AffiliationAdminSide"); int marks = calculate_marks(model); int gainedMarks = (marks * 100) / 16; int id = 0; var result = db.BI_pop_insertion_ID_from_Affi_Admin_Appli_Form_Result(); foreach (var res in result) { id = Convert.ToInt16(res.Value.ToString()); break; }; for (int i = 1; i <= 16; i++) { db.BI_Affi_Insert_Admin_Appli_Form_Result_dtail(Convert.ToInt16(AffiliationAdminDetail.Application_id), id, Convert.ToInt16(AffiliationAdminDetail.Inst_Id_for_Admin), i, "Get Value From Table", Serial_result[i - 1]); } db.BI_Insert_affi_Admin_Appli_Form_marks_and_remarks(Convert.ToInt16(AffiliationAdminDetail.Application_id), gainedMarks, model.remarksApp); if (model.isAcceptedApp) { db.BI_Affi_Insert_Admin_Appli_Form_Result(Convert.ToInt16(AffiliationAdminDetail.Inst_Id_for_Admin), Convert.ToInt16(AffiliationAdminDetail.Application_id), true, true); //show accepetion message } else { db.BI_Affi_Insert_Admin_Appli_Form_Result(Convert.ToInt16(AffiliationAdminDetail.Inst_Id_for_Admin), Convert.ToInt16(AffiliationAdminDetail.Application_id), false, false); } return RedirectToAction("/ApplicationForm"); }