public ActionResult Create(TPR_PROJECT project)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?;
if (ModelState.IsValid)
{
try
{
db.TPR_PROJECT_INSERT(USER_NO, LOGON_NO, project.PROJECT_NAME, project.CLASS_NO, project.DEADLINE_DATE);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.InnerException.Message.Contains("unique constraint"))
{
ModelState.AddModelError("PROJECT_NAME", "Unique Constraint Violated. "
+ "Same Porject Name is not allowed for multiple projects.");
}
else
{
ModelState.AddModelError("DEADLINE_DATE", "An error occured while adding collection project.");
}
}
}
ViewBag.CLASS_NO = new SelectList(db.SET_CLASS, "CLASS_NO", "CLASS_NAME", project.CLASS_NO);
return(View(project));
}
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 }));
}
//
// GET: /QuestionProject/Details/5
public ActionResult Details(decimal id = 0)
{
TPR_PROJECT tpr_project = db.TPR_PROJECT.Single(t => t.PROJECT_NO == id);
if (tpr_project == null)
{
return(HttpNotFound());
}
return(View(tpr_project));
}
//
// GET: /QuestionProject/Edit/5
public ActionResult Edit(decimal id = 0)
{
TPR_PROJECT tpr_project = db.TPR_PROJECT.Single(t => t.PROJECT_NO == id);
if (tpr_project == null)
{
return(HttpNotFound());
}
ViewBag.CLASS_NO = new SelectList(db.SET_CLASS, "CLASS_NO", "CLASS_NAME", tpr_project.CLASS_NO);
return(View(tpr_project));
}
public ActionResult Select(decimal id = 0)
{
TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS").Single(t => t.PROJECT_NO == id);
if (project == null)
{
return(HttpNotFound());
}
ViewBag.Project = project;
ViewBag.Subjects = db.SET_CLASS_SUBJECT_GET(project.CLASS_NO).ToList();
return(View());
}
public ActionResult EditAssign(decimal id = 0)
{
var project_ins = db.TPR_PROJECT_INSTITUTE.Single(t => t.PROJECT_INS_NO == id);
TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS").Single(p => p.PROJECT_NO == project_ins.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 == project_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();
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 == project_ins.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.Subjects = db.SET_CLASS_SUBJECT_ASSIGN_GET(id, project.CLASS_NO).ToList();
ViewBag.PROJECT = Session["TPR_PROJECT"] = project;
ViewBag.ZONAL_INFO = Session["TPR_ZONAL_INFO"] = zonal_info;
ViewBag.INSTITUTE_INFO = Session["TPR_INS_INFO"] = institute_info;
ViewBag.PROJECT_INSTITITE = Session["TPR_PROJECT_INS"] = project_ins;
return(View());
}
public ActionResult UploadSelect(decimal id = 0)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS").Single(t => t.PROJECT_NO == id);
if (project == null)
{
return(HttpNotFound());
}
ViewBag.Project = project;
ViewBag.Institutes = db.TPR_PROJECT_ASSIGNMENTS_GET(id, USER_NO, null).ToList();
ViewBag.USER_NO = USER_NO;
return(View());
}
public ActionResult MonitorSelect(decimal id = 0)
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
TPR_PROJECT project = db.TPR_PROJECT.Include("SET_CLASS").Single(t => t.PROJECT_NO == id);
if (project == null)
{
return(HttpNotFound());
}
ViewBag.Assigned_List = db.TPR_ASSIGN_MONITOR_GET(project.PROJECT_NO,
null, null, null, null, USER_NO).ToList();
ViewBag.Project = project;
ViewBag.Subjects = db.SET_CLASS_SUBJECT_GET(project.CLASS_NO).ToList();
return(View());
}
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));
}
