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