public ActionResult EditAssign(TPR_PROJECT_INSTITUTE project_ins) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; TPR_PROJECT project = db.TPR_PROJECT.Single(p => p.PROJECT_NO == project_ins.PROJECT_NO); foreach (var subject in project_ins.Subjects) { if (subject.TARGET_DATE == null) { subject.TARGET_DATE = project.DEADLINE_DATE; } decimal is_active = subject.IS_ACTIVE ? 1 : 0; db.SET_CLASS_SUB_ASSIGN_UPDATE(project_ins.PROJECT_INS_NO, subject.SUBJECT_NO, is_active, subject.TARGET_DATE, USER_NO, LOGON_NO); } ViewBag.Subjects = db.SET_CLASS_SUBJECT_ASSIGN_GET(project_ins.PROJECT_INS_NO, project.CLASS_NO).ToList(); ViewBag.PROJECT = project; ViewBag.ZONAL_INFO = Session["TPR_ZONAL_INFO"] as USER_INFO_VIEWMODEL; ViewBag.INSTITUTE_INFO = Session["TPR_INS_INFO"] as INSTITUTE_INFO_VIEWMODEL; ViewBag.PROJECT_INSTITITE = project_ins; return(View()); }
public ActionResult Select(TPR_PROJECT_INSTITUTE pr_ins) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; decimal?project_ins_no = db.TPR_PROJECT_INSTITUTE_INSERT(pr_ins.PROJECT_NO, pr_ins.USER_NO, pr_ins.INSTITUTE_NO, pr_ins.IS_ACTIVE, USER_NO, LOGON_NO).FirstOrDefault(); TPR_PROJECT project = db.TPR_PROJECT.Single(p => p.PROJECT_NO == pr_ins.PROJECT_NO); if (project_ins_no.HasValue) { foreach (var subject in pr_ins.Subjects) { if (subject.TARGET_DATE == null) { subject.TARGET_DATE = project.DEADLINE_DATE; } decimal?is_active = subject.IS_ACTIVE ? 1 : 0; db.TPR_INSTITUTE_SUBJECT_INSERT(project_ins_no, subject.SUBJECT_NO, USER_NO, LOGON_NO, subject.TARGET_DATE, is_active); } } return(RedirectToAction("GetAssignments", new { pid = pr_ins.PROJECT_NO, uid = pr_ins.USER_NO })); }
public ActionResult AttachFile(TPR_UPLOAD_LIST upload) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; if (upload.QuestionFile != null && upload.QuestionFile.ContentLength > 0) { int length = upload.QuestionFile.ContentLength; upload.FILE_NAME = upload.QuestionFile.FileName; upload.FILE_TYPE = upload.QuestionFile.ContentType; upload.FILE_EXT = Path.GetExtension(upload.QuestionFile.FileName); if (!System.IO.Directory.Exists(question_upload_url)) { System.IO.Directory.CreateDirectory(question_upload_url); } string file_new_name = Path.GetFileNameWithoutExtension(upload.FILE_NAME) + DateTime.Now.ToString("_yyyy_MM_dd_hh_mm_ss_") + DateTime.Now.Millisecond + Path.GetExtension(upload.FILE_NAME); string fileLocation = question_upload_url + file_new_name; while (System.IO.File.Exists(fileLocation)) { file_new_name = Path.GetFileNameWithoutExtension(upload.FILE_NAME) + DateTime.Now.ToString("_yyyy_MM_dd_hh_mm_ss_") + DateTime.Now.Millisecond + Path.GetExtension(upload.FILE_NAME); fileLocation = question_upload_url + file_new_name; } upload.QuestionFile.SaveAs(fileLocation); db.TPR_UPLOAD_LIST_INSERT(upload.INS_SUBJECT_NO, USER_NO, LOGON_NO, upload.FILE_NAME, upload.FILE_TYPE, upload.FILE_EXT, fileLocation, file_new_name); } TPR_PROJECT_INSTITUTE pro_ins = db.TPR_INSTITUTE_SUBJECT.Include("TPR_PROJECT_INSTITUTE") .Single(i => i.INS_SUBJECT_NO == upload.INS_SUBJECT_NO) .TPR_PROJECT_INSTITUTE; return(RedirectToAction("GetUploadSubjects", new { pid = pro_ins.PROJECT_NO, uid = pro_ins.USER_NO, ins_no = pro_ins.INSTITUTE_NO })); }
public JsonResult DeleteAssign(decimal id = 0) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; TPR_PROJECT_INSTITUTE project_ins = db.TPR_PROJECT_INSTITUTE.Single(t => t.PROJECT_INS_NO == id); if (project_ins == null) { return(Json(new { message = "not found" }, JsonRequestBehavior.AllowGet)); } if (USER_NO.HasValue) { db.TPR_PROJECT_INSTITUTE_UPDATE(project_ins.PROJECT_INS_NO, project_ins.PROJECT_NO, project_ins.USER_NO, project_ins.INSTITUTE_NO, USER_NO, LOGON_NO, 0); return(Json(new { message = "success" }, JsonRequestBehavior.AllowGet)); } return(Json(new { message = "no success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetInstituteAssigned(TPR_PROJECT_INSTITUTE pr_ins) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; USER_INFO_VIEWMODEL zonal_info = (from u in db.SEC_USERS join d in db.SET_DESIGNATION on u.DESIG_NO equals d.DESIG_NO join t in db.SET_THANA on u.THANA_NO equals t.THANA_NO join z in db.SET_ZILLA on t.ZILLA_NO equals z.ZILLA_NO join div in db.SET_DIVISION on z.DIVISION_NO equals div.DIVISION_NO where u.USER_NO == pr_ins.USER_NO select new USER_INFO_VIEWMODEL { userno = u.USER_NO, fullname = u.USER_FULL_NAME, username = u.USER_NAME, hrid = u.HR_EMP_ID, mobile = u.USER_MOBILE, designation = d.DESIG_NAME, thana = t.THANA_NAME, zilla = z.ZILLA_NAME, division = div.DIVISION_NAME }).FirstOrDefault(); decimal?ins_no = pr_ins.INSTITUTE_NO; if (ins_no == 0) { ins_no = null; } var assignments = db.TPR_MONITOR_DETAIL_GET(pr_ins.PROJECT_NO, pr_ins.USER_NO, ins_no, pr_ins.Target_Date, pr_ins.Subject_List, pr_ins.Is_Collected, pr_ins.Is_New, USER_NO).ToList(); ViewBag.ZONAL_INFO = zonal_info; ViewBag.Is_New = pr_ins.Is_New; ViewBag.Is_Collected = pr_ins.Is_Collected; return(PartialView("_GetInstituteAssignments", assignments)); }
public ActionResult MonitorSelect(TPR_PROJECT_INSTITUTE pr_ins) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?user_no = pr_ins.USER_NO; if (user_no == 0) { user_no = null; } decimal?ins_no = pr_ins.INSTITUTE_NO; if (ins_no == 0) { ins_no = null; } List <TPR_ASSIGN_MONITOR_GET_Result> assigned_list = db.TPR_ASSIGN_MONITOR_GET(pr_ins.PROJECT_NO, user_no, ins_no, pr_ins.Target_Date, pr_ins.Subject_List, USER_NO).ToList(); return(PartialView("_GetAssignedList", assigned_list)); }
public ActionResult GetSubjects(decimal?p_ins, string type) { ViewBag.Download_Allowed = false; ViewBag.Reset_Allowed = false; SEC_USERS_LOGIN_Result1 user = Session["sess_sec_users"] as SEC_USERS_LOGIN_Result1; if (user.USER_TYPE_NO == (decimal)EUserTypes.GeneralUser) { List <SET_USER_ACTION> perm_list = Session["sess_PERMISSION_LIST"] as List <SET_USER_ACTION>; foreach (var perm in perm_list) { GEN_CONTROLLER_ACTION controller_action = perm.GEN_CONTROLLER_ACTION; if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Download") { ViewBag.Download_Allowed = true; } if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Reset") { ViewBag.Reset_Allowed = true; } } } else { List <SET_ROLE_ACTION> perm_list = Session["sess_PERMISSION_LIST"] as List <SET_ROLE_ACTION>; foreach (var perm in perm_list) { GEN_CONTROLLER_ACTION controller_action = perm.GEN_CONTROLLER_ACTION; if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Download") { ViewBag.Download_Allowed = true; } if (controller_action.CONTROLLER_NAME == "QuestionMonitor" && controller_action.ACTION_NAME == "Reset") { ViewBag.Reset_Allowed = true; } } } TPR_PROJECT_INSTITUTE pins = db.TPR_PROJECT_INSTITUTE .Single(t => t.PROJECT_INS_NO == p_ins); TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS") .Single(p => p.PROJECT_NO == pins.PROJECT_NO); USER_INFO_VIEWMODEL zonal_info = (from u in db.SEC_USERS join d in db.SET_DESIGNATION on u.DESIG_NO equals d.DESIG_NO join t in db.SET_THANA on u.THANA_NO equals t.THANA_NO join z in db.SET_ZILLA on t.ZILLA_NO equals z.ZILLA_NO join div in db.SET_DIVISION on z.DIVISION_NO equals div.DIVISION_NO where u.USER_NO == pins.USER_NO select new USER_INFO_VIEWMODEL { userno = u.USER_NO, fullname = u.USER_FULL_NAME, username = u.USER_NAME, hrid = u.HR_EMP_ID, mobile = u.USER_MOBILE, designation = d.DESIG_NAME, thana = t.THANA_NAME, zilla = z.ZILLA_NAME, division = div.DIVISION_NAME }).FirstOrDefault(); INSTITUTE_INFO_VIEWMODEL institute_info = (from i in db.SET_INSTITUTE join t in db.SET_THANA on i.THANA_NO equals t.THANA_NO join z in db.SET_ZILLA on t.ZILLA_NO equals z.ZILLA_NO join d in db.SET_DIVISION on z.DIVISION_NO equals d.DIVISION_NO where i.INSTITUTE_NO == pins.INSTITUTE_NO select new INSTITUTE_INFO_VIEWMODEL { insname = i.INSTITUTE_NAME, inscode = i.INSTITUTE_NO, thana = t.THANA_NAME, zilla = z.ZILLA_NAME, division = d.DIVISION_NAME }).FirstOrDefault(); ViewBag.PROJECT = project; ViewBag.ZONAL_INFO = zonal_info; ViewBag.INSTITUTE_INFO = institute_info; ViewBag.PROJECT_INSTITUTE = pins; decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; var subjects = db.TPR_SUBJECTS_GET(p_ins, type, 0, null, USER_NO, LOGON_NO).ToList(); return(PartialView("_GetSubjects", subjects)); }