public ActionResult ForgotPassword(juggle.Models.Forgotpassword_Model Fpss)
{
var female = Fpss.Email.ToString();
using (jugglecontext dbcon = new jugglecontext())
{
var getPass = dbcon.tbl_user.Where(useremail => useremail.email == female).SingleOrDefault();
if (getPass != null)
{
var Password = dbcon.Decrypt(getPass.password.ToString());
var UseraName = getPass.username.ToString();
try
{
string Body = "Your Username : '******' and password :'******'";
dbcon.SendMail(Fpss.Email, "Forgot Password - Juggle", Body, Password, UseraName);
ViewBag.Isokay = "auth";
}
catch
{
ModelState.AddModelError("", "Invalid user!");
}
}
else
{
}
}
return(View());
}
public ActionResult Employee_Edit(Int32 emp_id)
{
int userid = Convert.ToInt32(Session["User_Id"]);
using (jugglecontext dbcon = new jugglecontext())
{
jugglecontext dbcon1 = new jugglecontext();
var content = from p in dbcon.tbl_worktype
where p.user_id == userid
select new { p.work_id, p.name };
var attribute = from p in dbcon.tbl_attribute_data
where p.user_id == userid
select new { p.attribute_id, p.attribute_name };
var getmultipledata = (from a in dbcon.tbl_employee_info
where a.emp_id == emp_id
select a
).ToList();
string multipleattribute = getmultipledata[0].attribute_id.ToString();
string multipleservicetype = getmultipledata[0].emp_qualifiedservicetypes.ToString();
tbl_employee_info employee = dbcon.tbl_employee_info.Where(x => x.emp_id == emp_id).FirstOrDefault();
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 = employee.emp_qualifiedservicetypes;
empl.emp_contactinfo = employee.emp_contactinfo;
empl.emp_code = autogenerateid();
empl.user_id = employee.user_id;
empl.emp_transportion = employee.emp_transportion;
empl.created_date = employee.created_date;
empl.emp_note = employee.emp_note;
empl.attribute_id = employee.attribute_id;
empl.emp_googlecalendarID = employee.emp_googlecalendarID;
empl.emp_note = employee.emp_note;
empl.emp_password = dbcon.Decrypt(employee.emp_password);
var emp_list = content.ToList().Select(c => new SelectListItem
{
Text = c.name.ToString(),
Value = c.work_id.ToString(),
}).ToList();
ViewBag.emp_qualifiedservicetypeslist = emp_list;
var attri = attribute.ToList().Select(c => new SelectListItem
{
Text = c.attribute_name.ToString(),
Value = c.attribute_id.ToString(),
}).ToList();
ViewBag.attributelist = attri;
return(View(empl));
}
}
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());
}
