public ActionResult Create_Workers(tbl_user user)
{
var autopassword = "";
if (Session["User_Id"] != null)
{
int getstatusID = Convert.ToInt32(Request.Form["Status_hidden"]);
if (getstatusID == 0)
{
getstatusID = 1;
}
using (jugglecontext dbcon = new jugglecontext())
{
try
{
var userId = Convert.ToInt32(Session["User_Id"]);
tbl_user tblusr = new tbl_user();
tblusr.firstName = user.firstName.Trim();
tblusr.lastName = user.lastName.Trim();
tblusr.address = user.address.Trim();
tblusr.phoneno = user.phoneno.Trim();
tblusr.email = user.email.Trim();
tblusr.username = user.username.Trim();
autopassword = dbcon.GeneratePassword(6).Trim();
tblusr.password = dbcon.Encrypt(autopassword.Trim());
tblusr.created_date = DateTime.Now;
tblusr.status = getstatusID;
tblusr.supervisor_id = userId;
tblusr.role_id = 3;
tblusr.user_id = userId;
dbcon.tbl_user.Add(tblusr);
dbcon.SaveChanges();
string Password = autopassword;
string Body = "Your password '" + Password + "' ";
dbcon.SendMail(tblusr.email, "Password", Body, Password);
return(RedirectToAction("ManageWorkers", "Workers"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View(user));
}
}
}
else
{
return(View(user));
}
}
public ActionResult changePassword(changePassword changepass)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
var old_pass = changepass.oldPassword.ToString().Trim();
var new_pass = dbcon.Encrypt(changepass.NewPassword.ToString());
tbl_user user = null;
var user_id = Convert.ToInt32(Session["User_Id"].ToString());
string password_fromdb;
var getuser_pass = dbcon.tbl_user.SingleOrDefault(user_id_db => user_id_db.user_id == user_id);
user = dbcon.tbl_user.Where(s => s.user_id == user_id).FirstOrDefault <tbl_user>();
if (getuser_pass != null)
{
password_fromdb = dbcon.Decrypt(getuser_pass.password.ToString());
if (password_fromdb == old_pass)
{
user.password = Convert.ToString(new_pass);
dbcon.tbl_user.Attach(user);
dbcon.Entry(user).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
ViewBag.message = "Your password has been changed.";
}
else
{
if (string.IsNullOrEmpty(old_pass))
{
ModelState.AddModelError("oldPassword", "Please enter old password.");
}
else
{
ModelState.AddModelError("", "Invalid old password!");
}
}
}
else
{
ViewBag.InvalidUser = "******";
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult Employee_Edit(tbl_employee_info employee)
{
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
string multipleservice = Request.Form["emp_qualifiedservicetypes_multiple"].ToString();
tbl_employee_info empl = new tbl_employee_info();
empl.emp_id = employee.emp_id;
empl.emp_firstname = employee.emp_firstname;
empl.emp_lastname = employee.emp_lastname;
empl.emp_qualifiedservicetypes = multipleservice;
empl.user_id = employee.user_id;
empl.created_date = employee.created_date;
empl.emp_code = autogenerateid();
empl.updated_date = DateTime.Now;
empl.emp_contactinfo = employee.emp_contactinfo;
empl.attribute_id = multipleattribute;
empl.emp_transportion = employee.emp_transportion;
empl.emp_googlecalendarID = employee.emp_googlecalendarID;
empl.emp_note = employee.emp_note;
empl.emp_password = dbcon.Encrypt(employee.emp_password);
dbcon.Entry(empl).State = System.Data.Entity.EntityState.Modified;
dbcon.SaveChanges();
return(RedirectToAction("Employee", "Employee"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult Create_Employee(tbl_employee_info employee)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
string multipleattribute = Request.Form["attribute_id_multiple"].ToString();
string multipleService = Request.Form["emp_qualifiedservicetypes_multiple"].ToString();
var getButton = HttpContext.Request.Form["Create"];
tbl_employee_info empl = new tbl_employee_info();
empl.emp_firstname = employee.emp_firstname.Trim();
empl.emp_lastname = employee.emp_lastname.Trim();
empl.emp_contactinfo = employee.emp_contactinfo.Trim();
empl.emp_qualifiedservicetypes = multipleService;
empl.created_date = DateTime.Now;
empl.user_id = Convert.ToInt32(Session["User_Id"]);
empl.emp_code = autogenerateid();
empl.attribute_id = multipleattribute;
empl.emp_googlecalendarID = employee.emp_googlecalendarID;
empl.emp_note = employee.emp_note;
empl.emp_transportion = employee.emp_transportion;
empl.emp_password = dbcon.Encrypt(employee.emp_password);
dbcon.tbl_employee_info.Add(empl);
dbcon.SaveChanges();
return(RedirectToAction("Employee", "Employee"));
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View(employee));
}
}
}
public ActionResult Login(tbl_user use_acc)
{
try
{
if (!string.IsNullOrEmpty(use_acc.username) && !string.IsNullOrEmpty(use_acc.password))
{
var btnType = Request.Form["Login"];
if (btnType == "Login")
{
var u_Id = "";
var u_Name = "";
var u_Roll_Id = "";
using (jugglecontext dbcon = new jugglecontext())
{
if (use_acc.username == null || string.IsNullOrEmpty(use_acc.username))
{
ModelState.AddModelError("", "User Name is Required.");
}
else if (use_acc.password == null || string.IsNullOrEmpty(use_acc.password))
{
ModelState.AddModelError("", "Password is Required.");
}
else
{
var pass = dbcon.Encrypt(use_acc.password);
var role1 = RoleType.Administrator.GetHashCode();
var getadministrator = dbcon.tbl_user.Where(administrator => administrator.role_id == role1).SingleOrDefault(u => u.username == use_acc.username && (u.password) == pass);
// var getadministrator = dbcon.tbl_user.Where(administrator => administrator.role_id == 4).SingleOrDefault(u => u.username == user.Username && (u.password) == user.Password);
if (getadministrator != null)
{
Session["User_Id"] = getadministrator.user_id.ToString();
Session["profile_pict"] = getadministrator.profile_pict.ToString();
Session["User_Name"] = getadministrator.username.ToString();
Session["firstname"] = getadministrator.firstName.ToString();
Session["User_Roll_Id"] = getadministrator.role_id.ToString();
u_Id = getadministrator.user_id.ToString();
u_Name = getadministrator.username.ToString();
u_Roll_Id = getadministrator.role_id.ToString();
return(RedirectToAction("ManageSupervisors", "Supervisors"));
}
else
{
var role2 = RoleType.Supervisors.GetHashCode();
var getSupervisor = dbcon.tbl_user.Where(Supervisor => Supervisor.role_id == role2 && Supervisor.status == 1).SingleOrDefault(u => u.username == use_acc.username && (u.password) == pass);
if (getSupervisor != null)
{
Session["User_Id"] = getSupervisor.user_id.ToString();
Session["User_Name"] = getSupervisor.username.ToString();
Session["firstname"] = getSupervisor.firstName.ToString();
Session["profile_pict"] = getSupervisor.profile_pict.ToString();
Session["User_Roll_Id"] = getSupervisor.role_id.ToString();
try
{
Session["timezone"] = getSupervisor.timezoneid.ToString();
}
catch
{
Session["timezone"] = "Central Standard Time";
}
HttpCookie cookie = new HttpCookie("Timezone");
cookie.Value = getSupervisor.timezoneid.ToString();
this.ControllerContext.HttpContext.Response.Cookies.Add(cookie);
AccountCookies.Value = "Testing";
this.ControllerContext.HttpContext.Response.Cookies.Add(AccountCookies);
AccountCookies.Expires = DateTime.Now.AddHours(1);
u_Id = getSupervisor.user_id.ToString();
u_Name = getSupervisor.username.ToString();
u_Roll_Id = getSupervisor.role_id.ToString();
return(RedirectToAction("Employee", "Employee"));
}
else
{
var role3 = RoleType.Workers.GetHashCode();
var getuser = dbcon.tbl_user.Where(userlogin => userlogin.role_id == role3 && userlogin.status == 1).SingleOrDefault(u => u.username == use_acc.username && (u.password) == pass);
if (getuser != null)
{
Session["User_Id"] = getuser.user_id.ToString();
Session["User_Name"] = getuser.username.ToString();
Session["firstname"] = getuser.firstName.ToString();
Session["profile_pict"] = getuser.profile_pict.ToString();
Session["User_Roll_Id"] = getuser.role_id.ToString();
u_Id = getuser.user_id.ToString();
u_Name = getuser.username.ToString();
u_Roll_Id = getuser.role_id.ToString();
return(RedirectToAction("Client", "Client"));
}
else
{
ModelState.AddModelError("", "Invalid username or password !");
}
}
}
}
}
}
}
else
{
ModelState.AddModelError("", "Usename and Password Required !");
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
//ModelState.Clear();
return(View());
}
public ActionResult Create_Supervisor(tbl_user user)
{
var autopassword = "";
if (Session["User_Id"] != null)
{
using (jugglecontext dbcon = new jugglecontext())
{
try
{
var getButton = HttpContext.Request.Form["Save"];
if (getButton == "Save")
{
{
int getstatusID = Convert.ToInt32(Request.Form["Status_hidden"]);
if (getstatusID == 0)
{
getstatusID = 1;
}
var status = from p in dbcon.tbl_status
select new { p.status_id, p.status };
var statusname = status.ToList().Select(c => new SelectListItem
{
Text = c.status.ToString(),
Value = c.status_id.ToString(),
}).ToList();
ViewBag.status = statusname;
var userId = Convert.ToInt32(Session["User_Id"]);
tbl_user tblusr = new tbl_user();
tblusr.firstName = user.firstName.Trim();
tblusr.lastName = user.lastName.Trim();
tblusr.address = user.address;
tblusr.phoneno = user.phoneno.Trim();
tblusr.email = user.email.Trim();
tblusr.username = user.username.Trim();
autopassword = dbcon.GeneratePassword(6);
tblusr.password = dbcon.Encrypt(autopassword.Trim());
tblusr.supervisor_id = userId;
tblusr.created_date = DateTime.Now;
tblusr.timezoneid = "Central Standard Time";
tblusr.status = user.status;
tblusr.role_id = 2;
tblusr.user_id = 0;
Session["firstname"] = user.firstName;
Session["profile_pict"] = user.profile_pict;
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Profile_Picture/"), fileName);
file.SaveAs(path);
tblusr.profile_pict = fileName;
}
else
{
tblusr.profile_pict = "Noimage.png";
}
}
dbcon.tbl_user.Add(tblusr);
dbcon.SaveChanges();
string Body = "Hello, \nYour Username: "******" \nPassword: "******" \n\n for login in Juggle Click this Link to login \n " + dbcon.redirectUrl() + "";
dbcon.SendMail(tblusr.email, "Login Credntials for Juggle", Body, tblusr.username, autopassword);
return(RedirectToAction("ManageSupervisors", "Supervisors"));
}
}
else
{
}
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
return(View(user));
}
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
return(View(user));
}