public ActionResult Create([Bind(Include = "ID,NAME,CRS_ID,START_DATE,END_DATE,IS_DEL,EMP_ID")] BATCH bATCH) { if (ModelState.IsValid) { bATCH.IS_DEL = "N"; bATCH.EMP_ID = Convert.ToInt32(this.Session["UserId"]); db.BATCHes.Add(bATCH); db.SaveChanges(); return(RedirectToAction("ManageBatches")); } ViewBag.CRS_ID = new SelectList(db.COURSEs, "ID", "CRS_NAME", bATCH.CRS_ID); return(View(bATCH)); }
public ActionResult add(NewsDetails news) { if (ModelState.IsValid) { int commitCount = 0; NEWS n = new NEWS(); n.TIL = news.newsTitle; n.CNTNT = news.newsContent; n.AUTH_ID = Convert.ToInt32(this.Session["UserId"]); n.CREATED_AT = System.DateTime.Now; try { db.NEWS.Add(n); commitCount = db.SaveChanges(); if (commitCount > 0) { //To Do... Implement Logic to send SMS to all students who has send SMS is enabled //SMS_SETTING s = new SMS_SETTING(); } } catch (Exception ex) { ViewBag.ErrorMessage = ex; } return(RedirectToAction("view", "News", new { id = n.ID })); } else { ViewBag.ErrorMessage = "Model is not valid.."; return(RedirectToAction("add")); } }
public ActionResult Create([Bind(Include = "ID,CRS_NAME,CODE,SECTN_NAME,IS_DEL,CREATED_AT,UPDATED_AT,GRADING_TYPE")] COURSE cOURSE, string BATCH_NAME, DateTime ReturnDate, DateTime ReturnDate2) { if (ModelState.IsValid) { cOURSE.IS_DEL = "N"; cOURSE.CREATED_AT = System.DateTime.Now; cOURSE.UPDATED_AT = System.DateTime.Now; db.COURSEs.Add(cOURSE); db.SaveChanges(); BATCH bATCH = new BATCH(); bATCH.NAME = BATCH_NAME; bATCH.START_DATE = ReturnDate; bATCH.END_DATE = ReturnDate2; bATCH.CRS_ID = cOURSE.ID; bATCH.IS_DEL = "N"; db.BATCHes.Add(bATCH); db.SaveChanges(); ViewBag.Message = "Course created successfully!"; DateTime PDate = Convert.ToDateTime(ReturnDate); ViewBag.ReturnDate = PDate.ToShortDateString(); DateTime PDate2 = Convert.ToDateTime(ReturnDate2); ViewBag.ReturnDate2 = PDate2.ToShortDateString(); ViewBag.BATCH_NAME = BATCH_NAME; var GradingLevelList = new SelectList(new[] { new { ID = "Normal", Name = "Normal" }, new { ID = "GPA", Name = "GPA" }, new { ID = "CWA", Name = "CWA" }, new { ID = "CCE", Name = "CCE" }, new { ID = "ICSE", Name = "ICSE" }, }, "ID", "Name", "Normal"); ViewData["GRADING_TYPE"] = GradingLevelList; return(View()); } ViewBag.Message = "There is some issue adding course."; return(View(cOURSE)); }
public ActionResult Create([Bind(Include = "PRODUCT_ID,NAME,CATEGORY_ID,BRAND,TOTAL_UNIT,TOTAL_COST,COST_PER_UNIT,SELL_PRICE_PER_UNIT,PURCHASED_ON,PURCHASED_THROUGH,PAID_BY,UNIT_LEFT,IS_ACT,IS_DEL,CREATED_AT,UPDATED_AT")] STORE_PRODUCTS sTORE_PRODUCTS) { if (ModelState.IsValid) { sTORE_PRODUCTS.IS_DEL = "N"; sTORE_PRODUCTS.CREATED_AT = DateTime.Now; sTORE_PRODUCTS.UPDATED_AT = DateTime.Now; db.STORE_PRODUCTS.Add(sTORE_PRODUCTS); db.SaveChanges(); return(RedirectToAction("ViewAll")); } ViewBag.CATEGORY_ID = new SelectList(db.STORE_CATEGORY, "ID", "NAME", sTORE_PRODUCTS.CATEGORY_ID); return(View(sTORE_PRODUCTS)); }
public ActionResult Create([Bind(Include = "ID,USRNAME,FIRST_NAME,LAST_NAME,EML,ADMIN_IND,STDNT_IND,EMP_IND,HASHED_PSWRD,SALT,RST_PSWRD_CODE,RST_PSWRD_CODE_UNTL,CREATED_AT,UPDATED_AT,PARNT_IND")] USER uSER) { if (ModelState.IsValid) { db.USERS.Add(uSER); db.SaveChanges(); if (uSER.ADMIN_IND.Equals("Y")) { foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(1)).ToList()) { var UserAccess = new USERS_ACCESS() { USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE }; db.USERS_ACCESS.Add(UserAccess); db.SaveChanges(); } } else if (uSER.EMP_IND.Equals("Y")) { foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(2)).ToList()) { var UserAccess = new USERS_ACCESS() { USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE }; db.USERS_ACCESS.Add(UserAccess); db.SaveChanges(); } } else if (uSER.STDNT_IND.Equals("Y")) { foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(4)).ToList()) { var UserAccess = new USERS_ACCESS() { USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE }; db.USERS_ACCESS.Add(UserAccess); db.SaveChanges(); } } else if (uSER.PARNT_IND.Equals("Y")) { foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList()) { var UserAccess = new USERS_ACCESS() { USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE }; db.USERS_ACCESS.Add(UserAccess); db.SaveChanges(); } } else { foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList()) { var UserAccess = new USERS_ACCESS() { USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE }; db.USERS_ACCESS.Add(UserAccess); db.SaveChanges(); } } return(RedirectToAction("Edit_Privilege", "USERs", new { id = uSER.ID })); } return(View(uSER)); }