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