public ActionResult Login(string username = "", string password = "", bool remember = false) { List <User_tbl> user = db.User_tbl.Where(ds => ds.UserName == username && ds.Pass == password).ToList(); if (user.Count > 0) { User_tbl objUser = user.FirstOrDefault(); Session["user"] = objUser; if (objUser.UserType_tbl.UserTypeId == 2) { return(RedirectToAction("IndexUser", "Index")); } else if (objUser.UserType_tbl.UserTypeId == 3) { Session["EmployeeInfo"] = db.EmployeeRoleTables.Where(d => d.UserId == objUser.UserId).ToList().First(); return(RedirectToAction("IndexEmployee", "Index")); } else { return(RedirectToAction("Login", "Login")); } // return RedirectToAction("Index", "User"); //return RedirectToAction() } ViewBag.CustomMessage = "Error"; return(View()); }
public ActionResult Create([Bind(Include = "Id,Name,Password,Type,Contact,EmailAddress")] User_tbl user_tbl) { if (ModelState.IsValid) { if (db.User_tbl.Where(a => a.Name == user_tbl.Name).Count() > 0) { TempData["message"] = "This name has been registered!"; return(View()); } else if (db.User_tbl.Where(a => a.EmailAddress == user_tbl.EmailAddress).Count() > 0) { TempData["message"] = "This email address has been registered!"; return(View()); } else { user_tbl.Type = "Agent"; db.User_tbl.Add(user_tbl); db.SaveChanges(); TempData["message"] = "New Agent Registered!"; return(RedirectToAction("AgentManagement", "Agent")); } } return(View(user_tbl)); }
public ActionResult Create([Bind(Include = "UserName,Pass,FullName,DateOfBirth,NIDNumber")] User_tbl user_tbl, Address_tbl address, int divisionId = 0) { user_tbl.UserTypeId = 2; user_tbl.IsActive = true; var tempUser = db.User_tbl.Where(d => d.UserName == user_tbl.UserName || d.NIDNumber == user_tbl.NIDNumber).ToList(); if (ModelState.IsValid) { if (tempUser.Count <= 0) { db.User_tbl.Add(user_tbl); db.SaveChanges(); } else { ViewBag.CustomMessage = "Error"; } } address.SourceType = "User"; address.SourceId = user_tbl.UserId; db.Address_tbl.Add(address); db.SaveChanges(); ViewBag.UserTypeId = new SelectList(db.UserType_tbl, "UserTypeId", "UserType", user_tbl.UserTypeId); ViewBag.DivisionId = new SelectList(db.Division_tbl, "DivisionId", "DivisionName"); ViewBag.DistrictId = new SelectList(db.District_tbl.Where(dis => dis.DivisionId == divisionId), "DistrictId", "DistrictName"); Session["Registration"] = "true"; return(RedirectToAction("Login", "Login")); }
public ActionResult LoginAction(string email, string password) { if (email == null) { TempData["message"] = "Pls enter your email"; return(RedirectToAction("Index")); } User_tbl usr_tbl = db.User_tbl.Where(a => a.EmailAddress == email).FirstOrDefault(); if (usr_tbl == null) { TempData["message"] = "Invalid email"; return(RedirectToAction("Index")); } else { if (usr_tbl.Password == password) { Session["userId"] = usr_tbl.Id.ToString(); Session["userName"] = usr_tbl.Name.ToString(); Session["userType"] = usr_tbl.Type.ToString(); TempData["message"] = "Login Success"; return(RedirectToAction("Index", "Home")); } else { TempData["message"] = "Incorrect Password!"; return(RedirectToAction("Index")); } } }
public ActionResult IndexUser() { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; return(View()); }
public async Task <ActionResult> DeleteConfirmed(int id) { User_tbl user_tbl = await db.User_tbl.FindAsync(id); db.User_tbl.Remove(user_tbl); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: /Crops/Create public ActionResult Create() { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.UserName; } // ViewBag.CropsCatagoryId = new SelectList(db.CropsCatagory_tbl, "CropsCatagoryId", "CropsCatagoryName"); return(View()); }
// GET: /Index/ public ActionResult IndexEmployee() { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; ViewBag.CompanyName = db.EmployeeRoleTables.FirstOrDefault(er => er.UserId == objUser.UserId).StorageCompany_tbl.CompanyName; return(View()); }
// GET: /Crops/ public ActionResult Index() { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.UserName; var crops_tbl = db.Crops_tbl.Include(c => c.CropsCatagory_tbl); return(View(crops_tbl.ToList())); } return(RedirectToAction("Login", "Login")); }
public async Task <ActionResult> Edit([Bind(Include = "id,ur_firstname,ur_lastname,ur_email,ur_mobile,ur_entity,ur_password,ur_createdby,ur_createdat,ur_updateby,ur_updatedat,ur_isdeleted,ur_role,ur_desg")] User_tbl user_tbl) { if (ModelState.IsValid) { db.Entry(user_tbl).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(user_tbl)); }
//Registration confirm public JsonResult RegConfirm(int regId) { var context = new FoodieEntities1(); User_tbl Data = context.User_tbl.Where(x => x.user_id == regId).FirstOrDefault(); Data.IsValid = true; context.SaveChanges(); string result = "Your Email is successfully verified"; return(Json(result, JsonRequestBehavior.AllowGet)); }
// GET: User/Edit/5 //public ActionResult Edit(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // User_tbl user_tbl = db.User_tbl.Find(id); // if (user_tbl == null) // { // return HttpNotFound(); // } // ViewBag.UserTypeId = new SelectList(db.UserType_tbl, "UserTypeId", "UserType", user_tbl.UserTypeId); // return View(user_tbl); //} // POST: User/Edit/5 // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see http://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Edit([Bind(Include = "UserId,UserName,Pass,FullName,DateOfBirth,AddressId,UserTypeId,IsActive,NIDNumber")] User_tbl user_tbl) //{ // if (ModelState.IsValid) // { // db.Entry(user_tbl).State = EntityState.Modified; // db.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.UserTypeId = new SelectList(db.UserType_tbl, "UserTypeId", "UserType", user_tbl.UserTypeId); // return View(user_tbl); //} // GET: User/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } User_tbl user_tbl = db.User_tbl.Find(id); if (user_tbl == null) { return(HttpNotFound()); } return(View(user_tbl)); }
// GET: User_tbl/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } User_tbl user_tbl = await db.User_tbl.FindAsync(id); if (user_tbl == null) { return(HttpNotFound()); } return(View(user_tbl)); }
// GET: /CropsCatagory/Create public ActionResult Create() { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; ViewBag.CropsId = new SelectList(db.Crops_tbl, "CropsId", "CropsName"); } else { return(RedirectToAction("Login", "Login")); } return(View()); }
public ActionResult ApproveEmployee() { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; EmployeeRoleTable empInfo = (EmployeeRoleTable)Session["EmployeeInfo"]; ViewBag.UserName = objUser.UserName; var employeeList = db.EmployeeRoleTables.Where(e => e.StorageCompanyId == empInfo.StorageCompanyId && e.EmployeeId != empInfo.EmployeeId).ToList(); return(View(employeeList)); } else { return(RedirectToAction("Login", "Login")); } }
public ActionResult Create([Bind(Include = "CropsName,Description")] Crops_tbl crops_tbl) { if (ModelState.IsValid) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; } db.Crops_tbl.Add(crops_tbl); db.SaveChanges(); return(RedirectToAction("Create")); } // ViewBag.CropsCatagoryId = new SelectList(db.CropsCatagory_tbl, "CropsCatagoryId", "CropsCatagoryName", crops_tbl.CropsCatagoryId); return(View(crops_tbl)); }
public ActionResult DeleteConfirmed(int id) { User_tbl user_tbl = db.User_tbl.Find(id); if (db.Booking_tbl.Where(a => a.Agent_Id == id).Count() == 0) { db.User_tbl.Remove(user_tbl); db.SaveChanges(); TempData["message"] = "Agent Deleted!"; return(RedirectToAction("AgentManagement")); } else { TempData["message"] = "Cannot delete agent! This agent is associated with some booking"; return(RedirectToAction("Delete", "Agent", new { id = user_tbl.Id })); } }
public ActionResult ApproveEmployee(List <int> approveList) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; EmployeeRoleTable empInfo = (EmployeeRoleTable)Session["EmployeeInfo"]; ViewBag.UserName = objUser.UserName; var employeeList = db.EmployeeRoleTables.Where(e => e.StorageCompanyId == empInfo.StorageCompanyId && e.EmployeeId != empInfo.EmployeeId).ToList(); foreach (EmployeeRoleTable emp in employeeList) { if (approveList != null) { if (approveList.Contains(emp.EmployeeId)) { if (emp.IsApprove == false) { var item = db.EmployeeRoleTables.FirstOrDefault(d => d.EmployeeId == emp.EmployeeId); item.IsApprove = true; //db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } } else { var item = db.EmployeeRoleTables.FirstOrDefault(d => d.EmployeeId == emp.EmployeeId); item.IsApprove = false; db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } } else { var item = db.EmployeeRoleTables.FirstOrDefault(d => d.EmployeeId == emp.EmployeeId); item.IsApprove = false; db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } } return(View(employeeList)); } else { return(RedirectToAction("Login", "Login")); } }
public frmManageUser() { InitializeComponent(); var userCount = BusinessAccessLayer.GetEntity().User_tbl.Count(); if (userCount <= 0) { var user = new User_tbl(); user.UserID = "Admin"; user.Password = "******"; BusinessAccessLayer.GetEntity().User_tbl.AddObject(user); BusinessAccessLayer.GetEntity().SaveChanges(); } RefreshData(); comboBox1.SelectedValueChanged += comboBox1_SelectedValueChanged; }
// GET: /Crops/Delete/5 public ActionResult Delete(int?id) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Crops_tbl crops_tbl = db.Crops_tbl.Find(id); if (crops_tbl == null) { return(HttpNotFound()); } return(View(crops_tbl)); } return(RedirectToAction("Login", "Login")); }
public ActionResult Edit([Bind(Include = "CropsCatagoryId,CropsCatagoryName,Details")] CropsCatagory_tbl cropscatagory_tbl) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; } else { return(RedirectToAction("Login", "Login")); } if (ModelState.IsValid) { db.Entry(cropscatagory_tbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cropscatagory_tbl)); }
public ActionResult Create([Bind(Include = "CropsCatagoryName,Details,CropsId")] CropsCatagory_tbl cropscatagory_tbl) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; } else { return(RedirectToAction("Login", "Login")); } if (ModelState.IsValid) { db.CropsCatagory_tbl.Add(cropscatagory_tbl); db.SaveChanges(); return(RedirectToAction("Create")); } return(View(cropscatagory_tbl)); }
public ActionResult Edit([Bind(Include = "CropsId,CropsName,Description")] Crops_tbl crops_tbl) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; if (ModelState.IsValid) { db.Entry(crops_tbl).State = EntityState.Modified; db.SaveChanges(); return(View(crops_tbl)); } } else { return(RedirectToAction("Login", "Login")); } // ViewBag.CropsCatagoryId = new SelectList(db.CropsCatagory_tbl, "CropsCatagoryId", "CropsCatagoryName", crops_tbl.CropsCatagoryId); return(View(crops_tbl)); }
// GET: /Crops/Edit/5 public ActionResult Edit(int?id) { if (Session["User"] != null) { User_tbl objUser = (User_tbl)Session["User"]; ViewBag.UserName = objUser.FullName; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Crops_tbl crops_tbl = db.Crops_tbl.Find(id); if (crops_tbl == null) { return(HttpNotFound()); } // ViewBag.CropsCatagoryId = new SelectList(db.CropsCatagory_tbl, "CropsCatagoryId", "CropsCatagoryName", crops_tbl.CropsCatagoryId); return(View(crops_tbl)); } return(RedirectToAction("Login", "Login")); }
public JsonResult Sign(User_tbl model) { using (var context = new FoodieEntities1()) { var active = (from x in context.User_tbl where (x.user_email == model.user_email && x.user_name == model.user_name) select x.IsValid).FirstOrDefault(); if (context.User_tbl.Any(x => x.user_email == model.user_email) && active == true) { return(Json(new { Success = false, LoginError = "This Email is already in use" }, JsonRequestBehavior.AllowGet)); } if (context.User_tbl.Any(x => x.user_name == model.user_name) && active == true) { return(Json(new { Success = false, LoginError = "This Name is already in use" }, JsonRequestBehavior.AllowGet)); } if (context.User_tbl.Any(x => x.user_email == model.user_email) && active == false) { var id = (from s in context.User_tbl where (s.user_email == model.user_email) select s.user_id).FirstOrDefault(); var remove = context.User_tbl.Find(id); context.User_tbl.Remove(remove); context.SaveChanges(); } model.IsValid = false; context.User_tbl.Add(model); context.SaveChanges(); BuildEmailTemplate(model.user_id, model.user_name); return(Json(new { Success = true, msg = "Registration Successful" }, JsonRequestBehavior.AllowGet)); //return Json("Registration Successful", JsonRequestBehavior.AllowGet); } }
public ActionResult Create([Bind(Include = "UserName,Pass,FullName,DateOfBirth,NIDNumber")] User_tbl user_tbl, Address_tbl address, EmployeeRoleTable employeeroletable, int divisionId = 0) { user_tbl.UserTypeId = 3; user_tbl.IsActive = true; var tempUser = db.User_tbl.Where(d => d.UserName == user_tbl.UserName || d.NIDNumber == user_tbl.NIDNumber).ToList(); if (ModelState.IsValid) { if (tempUser.Count <= 0) { db.User_tbl.Add(user_tbl); db.SaveChanges(); } else { ViewBag.CustomMessage = "Error"; } } address.SourceType = "User"; address.SourceId = user_tbl.UserId; db.Address_tbl.Add(address); db.SaveChanges(); employeeroletable.UpdateBy = 0; employeeroletable.UpdateDate = DateTime.Now; employeeroletable.UserId = user_tbl.UserId; employeeroletable.IsApprove = false; db.EmployeeRoleTables.Add(employeeroletable); db.SaveChanges(); ViewBag.EmployeeId = new SelectList(db.StockMasterRecordCrops_tbl, "StockMasterRecordId", "InvoiceNo", employeeroletable.EmployeeId); ViewBag.StorageCompanyId = new SelectList(db.StorageCompany_tbl, "StorageCompanyId", "CompanyName", employeeroletable.StorageCompanyId); ViewBag.UserId = new SelectList(db.User_tbl, "UserId", "UserName", employeeroletable.UserId); Session["Registration"] = "true"; return(RedirectToAction("Login", "Login")); }
public ActionResult Edit([Bind(Include = "Id,Name,Password,Type,Contact,EmailAddress")] User_tbl user_tbl) { if (ModelState.IsValid) { User_tbl targetUser = db.User_tbl.Find(user_tbl.Id); if (db.User_tbl.Where(a => a.EmailAddress == user_tbl.EmailAddress && a.Id != user_tbl.Id).Count() > 0) { TempData["message"] = "This email has been registered!"; return(View(user_tbl.Id)); } if (targetUser.Id.ToString() == Session["userId"].ToString()) { targetUser.Password = user_tbl.Password; } targetUser.Name = user_tbl.Name; targetUser.Contact = user_tbl.Contact; targetUser.EmailAddress = user_tbl.EmailAddress; db.Entry(targetUser).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = "Edit Successful!"; return(RedirectToAction("AgentManagement", "Agent")); } return(View(user_tbl)); }
public ActionResult Login(User_tbl model) { using (var context = new FoodieEntities1()) { bool isValid = context.User_tbl.Any(x => x.user_email == model.user_email && x.user_name == model.user_name && x.user_password == model.user_password); var active = (from x in context.User_tbl where (x.user_email == model.user_email && x.user_name == model.user_name) select x.IsValid).Any(); if (isValid) { if (active == true) { FormsAuthentication.SetAuthCookie(model.user_name, true); var role = (from x in context.User_tbl where (x.user_email == model.user_email && x.user_name == model.user_name) select x.Role_Id).FirstOrDefault(); Session["manager"] = null; Session["admin"] = null; Session["Rest_id"] = null; Session["role"] = role; if (role == 1) { Session["admin"] = "Admin"; } model.user_id = (from x in context.User_tbl where (x.user_email == model.user_email && x.user_name == model.user_name) select x.user_id).FirstOrDefault(); Session["User_id"] = model.user_id; Session["User_name"] = model.user_name; if (role == 2) { Session["manager"] = "manager"; var restId = (from r in context.tbl_restaurent where (r.User_id == model.user_id) select r.Rest_id).FirstOrDefault(); if (context.tbl_restaurent.Any(x => x.User_id == model.user_id)) { Session["Rest_id"] = restId; if (context.tbl_platter.Any(x => x.Rest_id == restId)) { var Code = context.tbl_platter.Where(x => x.Rest_id == restId).Select(x => x.secret_code).FirstOrDefault(); Session["scode"] = Code; return(RedirectToAction("Index", "Platter", new { code = Code })); } else { //Session["Rest_id"] = restId; return(RedirectToAction("Addplatter", "Platter")); } } else { return(RedirectToAction("Restautrant")); } } else { return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("user_name", "Checck your input data"); } } ModelState.AddModelError("user_name", "Please, Registration First or check your data"); return(View()); } }
public ActionResult Login(User_tbl user) { return(View()); }