public ActionResult Create([Bind(Include = "ID,DEPT_NAME,DEPT_ID,IsActive")] departmant departmantModel)
{
var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]);
if (SessionControl != 5)
{
return(RedirectToAction("Index", "Home"));
}
//departmant dbDept = new departmant();
try {
if (db.departmant.Any(x => x.DEPT_ID == departmantModel.DEPT_ID))
{
TempData["info"] = departmantModel.DEPT_ID + " " + "Department already created!";
return(RedirectToAction("Create", "Departmants"));
}
if (ModelState.IsValid)
{
db.departmant.Add(departmantModel);
db.SaveChanges();
TempData["info"] = "Department Created Succesfull";
return(RedirectToAction("Index", "Location"));
}
}
catch (Exception ex)
{
TempData["info"] = "Problem Occured: " + " " + ex.Message;
return(RedirectToAction("Index", "Location"));
}
return(View(departmantModel));
}
public ActionResult Add(UserVM model, int?LocationID)
{
var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]);
if (SessionControl != 5)
{
return(RedirectToAction("Index", "Home"));
}
SetRoleList();
ViewBag.DepartmentList = new SelectList(GetDepartmentList(), "ID", "DEPT_NAME");
try
{
// if Model does not have any validation error
if (model != null)
{
// Set role List to dropdown list.
var userexist = _userRepository.UserFind(model.UNI_ID);
if (userexist != null)
{
return(Json(new ResultJson {
Success = false, Message = userexist.UNI_ID + " User Already Registered!"
}));
}
if (string.Compare(model.PASSWORD.Trim().ToUpper(), model.ComparePassword.Trim().ToUpper()) != 0)
{
return(Json(new ResultJson {
Success = false, Message = " Password should match with compare password field!"
}));
}
// Fill as user view model user object from the reguested model and match the value to configure them.
user Userdb = new user();
Userdb.UNI_ID = model.UNI_ID.Trim().ToUpper();
Userdb.FIRST_NAME = model.FIRST_NAME;
Userdb.LAST_NAME = model.LAST_NAME.ToUpper();
Userdb.EMAIL = model.EMAIL;
Userdb.FK_LOCATION_ID = LocationID;
Userdb.FK_PRIVILEGE_ID = model.FK_PRIVILEGE_ID;
Userdb.IsActive = model.IsActive;
Userdb.PHONE = model.PHONE;
Userdb.PASSWORD = CustomEncrypt.passwordEncrypt(model.PASSWORD.Trim(), EncryptionKey);
Userdb.CREATED_DATE = DateTime.Now;
Userdb.UPDATED_DATE = DateTime.Now;
Userdb.TITLE = model.TITLE;
db.user.Add(Userdb);
db.SaveChanges();
return(Json(new ResultJson {
Success = true, Message = "User Added Successfully"
}));
}
return(View(model));
}
catch (Exception ex)
{
return(Json(new ResultJson {
Success = false, Message = "Error Occured while adding User!"
}));
}
}
public ActionResult Login(LoginViewModel model, string ReturnUrl = "")
{
string EncryptionKey = "SHA512";
string message = "";
if (ModelState.IsValid)
{
using (EastMedDB db = new EastMedDB())
{
var userexist = db.user.Where(a => a.UNI_ID == model.UNI_ID && a.IsActive == true).FirstOrDefault();
if (userexist != null)
{
if (string.Compare((model.Password.Trim()), CustomDecrypt.passwordDecrypt(userexist.PASSWORD, EncryptionKey)) == 0)
{
// In here 2 method has been used to save user login atraction to specific pages
// Sessions and cookies give as to control menus and specification for each user.
// Cookies to used authorized the application and protect to anonymous enter
// Cookies are encrypted in client site the avoid from the cookie attacks.
Session["RoleID"] = userexist.FK_PRIVILEGE_ID;
Session["UserName"] = userexist.FIRST_NAME + " " + userexist.LAST_NAME;
Session["UserID"] = userexist.UNI_ID;
Session["UserDatabaseID"] = userexist.ID;
int timeout = model.RememberMe ? 525600 : 30; // 30 min to expire the cookie.
var ticket = new FormsAuthenticationTicket(model.UNI_ID, model.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
userexist.LAST_LOGINDATE = DateTime.Now;
db.user.Attach(userexist);
var entry = db.Entry(userexist);
entry.Property(x => x.LAST_LOGINDATE).IsModified = true;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
}
ViewBag.Message = message;
return(View());
}
// GET: Complaint/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
complaint complaint = db.complaint.Find(id);
var queryComplaint = (from comp in db.complaint
join u in db.user on comp.FK_USER_ID equals u.ID
join cate in db.category on comp.FK_CATEGORY_ID equals cate.ID
join loc in db.location on comp.FK_Location_ID equals loc.ID
join i in db.item on comp.FK_ITEM_ID equals i.ID
join it in db.itemtype on i.ID equals it.ID
orderby(cate.CATEGORY_NAME)
where comp.ID == id
select new ComplaintModel
{
STATUS = comp.STATUS,
COMMENT = comp.COMMENT,
UserName = u.FIRST_NAME + " " + u.LAST_NAME,
ITEM_ID = comp.ITEM_ID,
IsActive = comp.IsActive,
ComplaintId = comp.ID,
CategoryName = cate.CATEGORY_NAME,
PRIORITY = comp.PRIORITY,
STARTDATE = comp.START_DATE,
itemName = i.ITEM_NAME,
RoomNo = loc.ROOM_ID,
ImgUrl = comp.ImgURL
});
if (queryComplaint == null)
{
return(HttpNotFound());
}
var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]);
if (complaint.STATUS.Trim().ToUpper() == "NEW" & SessionControl == 7)
{
complaint.STATUS = "SEEN".Trim().ToUpper();
db.complaint.Attach(complaint);
var entry = db.Entry(complaint);
entry.Property(x => x.STATUS).IsModified = true;
db.SaveChanges();
}
return(View(complaint)); //Instead of using single return value it is faster and reliable to use it "singleordefault".
}
public ActionResult Create([Bind(Include = "ID,CATEGORY_NAME,DESCRIPTION,FK_USER_ID,IsActive")] category category)
{
try
{
if (ModelState.IsValid)
{
db.category.Add(category);
db.SaveChanges();
TempData["info"] = "Adding category Succesful";
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
TempData["error"] = ex.Message;
}
ViewBag.FK_USER_ID = new SelectList(db.user.Where(x => x.IsActive == true && x.FK_PRIVILEGE_ID == 7), "ID", "FIRST_NAME", "LAST_NAME", category.FK_USER_ID);
return(View(category));
}
public ActionResult Edit([Bind(Include = "ID,COMMENT,STATUS,START_DATE,PRIORITY,FK_USER_ID,FK_CATEGORY_ID,IsActive,FK_Location_ID,FK_ITEM_ID,ITEM_ID")] complaint complaint)
{
if (ModelState.IsValid)
{
db.complaint.Attach(complaint);
var entry = db.Entry(complaint);
entry.Property(x => x.COMMENT).IsModified = true;
entry.Property(x => x.START_DATE).IsModified = true;
entry.Property(x => x.PRIORITY).IsModified = true;
entry.Property(x => x.FK_USER_ID).IsModified = true;
entry.Property(x => x.IsActive).IsModified = true;
entry.Property(x => x.FK_Location_ID).IsModified = true;
entry.Property(x => x.FK_ITEM_ID).IsModified = true;
entry.Property(x => x.ITEM_ID).IsModified = true;
db.Entry(complaint).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
SetCategory();
//ViewBag.Itemlist = new SelectList(GetItemType(), "ID", "Item_Type");
ViewBag.DepartmentList = new SelectList(GetDepartmentList(), "ID", "DEPT_NAME");
return(View(complaint));
}
public ActionResult Create([Bind(Include = "ID,ROOM_ID,TYPE,FK_DEPT_ID,CREATED_DATE,UPDATED_DATE,IsActive")] location location)
{
var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]);
if (SessionControl != 5)
{
return(HttpNotFound());
}
try
{
if (db.location.Any(x => x.ROOM_ID.Trim().ToUpper() == location.ROOM_ID.Trim().ToUpper()))
{
TempData["info"] = location.ROOM_ID + " " + " Location already created!";
return(RedirectToAction("Create", "Location"));
}
if (ModelState.IsValid)
{
location.ROOM_ID = location.ROOM_ID.Trim().ToUpper();
location.TYPE = location.TYPE.Trim().ToLower();
location.CREATED_DATE = DateTime.Now;
location.UPDATED_DATE = DateTime.Now;
db.location.Add(location);
db.SaveChanges();
TempData["Msg"] = location.ROOM_ID + " " + "Location has been saved succeessfully";
return(RedirectToAction("Index"));
}
}
catch (DataException ex) // or use DataException
{
//Log the error (uncomment dex variable name and add a line here to write a log.)
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
TempData["info"] = "Error Occured : " + " " + ex.Message;
return(RedirectToAction("Create", "Location"));
}
ViewBag.FK_DEPT_ID = new SelectList(db.departmant, "ID", "DEPT_NAME", location.FK_DEPT_ID);
return(View(location));
}
public ActionResult Edit(UserVM User, int?id)
{
try
{
ViewBag.Role = db.user.Where(x => x.ID == id).Include(x => x.privilege).SingleOrDefault().privilege.ROLE;
if (ModelState.IsValid)
{
var dbUser = db.user.Where(x => x.ID == id).SingleOrDefault();
dbUser.UPDATED_DATE = DateTime.Now;
dbUser.PASSWORD = CustomEncrypt.passwordEncrypt(User.PASSWORD, EncryptionKey);
dbUser.PHONE = User.PHONE;
dbUser.EMAIL = User.EMAIL;
db.user.Attach(dbUser);
var entry = db.Entry(dbUser);
entry.Property(x => x.UPDATED_DATE).IsModified = true;
entry.Property(x => x.PASSWORD).IsModified = true;
entry.Property(x => x.PHONE).IsModified = true;
entry.Property(x => x.EMAIL).IsModified = true;
db.SaveChanges();
TempData["info"] = "Profile Edit Succesfully";
return(Json(new ResultJson {
Success = false, Message = "Edit User Succesfull!"
}));
}
else
{
//ModelState.AddModelError()
return(Json(new ResultJson {
Success = false, Message = "User Does not find!"
}));
}
}
catch (Exception ex)
{
return(Json(new ResultJson {
Success = false, Message = "Error Occured while Editing User!"
}));
}
}
public void Save()
{
_context.SaveChanges();
}
public ActionResult Create(ComplaintHistoryModel model, int?id)
{
// complaint status
string statusc = "";
int sessionControl = Convert.ToInt32(HttpContext.Session["UserDatabaseID"]);
complaint_history comphist = new complaint_history();
int quote = (int)id;
complaint complaint = db.complaint.Find(id);
if (model != null)
{
try
{
if (Convert.ToInt32(model.Status) == 0)
{
comphist.STATUS = statusc = "On Progress".Trim().ToUpper();
}
if (Convert.ToInt32(model.Status) == 1)
{
comphist.STATUS = statusc = "SOLVED".Trim().ToUpper();
}
else if (Convert.ToInt32(model.Status) == 2)
{
comphist.STATUS = statusc = "UNSOLVED".Trim().ToUpper();
}
comphist.MODIFIED_TIME = DateTime.Now;
comphist.COMMENT = model.Comment;
comphist.FK_CATEGORYUSER_ID = sessionControl;
comphist.FK_COMPLAINT_ID = quote;
comphist.FK_CATEGORY_ID = model.CategoryID;
db.complaint_history.Add(comphist);
db.SaveChanges();
if (Convert.ToInt32(model.Status) == 0)
{
complaint.STATUS = statusc = "ON PROGRESS".Trim().ToUpper();
}
if (Convert.ToInt32(model.Status) == 1)
{
complaint.STATUS = statusc = "SOLVED".Trim().ToUpper();
}
else if (Convert.ToInt32(model.Status) == 2)
{
complaint.STATUS = statusc = "UNSOLVED".Trim().ToUpper();
}
db.complaint.Attach(complaint);
var entry = db.Entry(complaint);
entry.Property(x => x.STATUS).IsModified = true;
db.SaveChanges();
TempData["Info"] = "Complaint " + comphist.ID + " of status successfuly changed to " + comphist.STATUS;
return(RedirectToAction("Index"));
}
catch
{
TempData["error"] = "Error occured while modifying complaint";
return(View(model));
}
}
var types = new List <ComplaintHistoryStatus>();
types.Add(new ComplaintHistoryStatus()
{
Id = 0, ComplaintStatus = "On Progress"
});
types.Add(new ComplaintHistoryStatus()
{
Id = 1, ComplaintStatus = "Solved"
});
types.Add(new ComplaintHistoryStatus()
{
Id = 2, ComplaintStatus = "UnSolved"
});
ViewBag.PartialTypes = types;
ViewBag.FK_CATEGORY_ID = new SelectList(db.category, "ID", "CATEGORY_NAME", complaint.FK_CATEGORY_ID);
return(View(model));
}
