public ActionResult Delete(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
int UserID = Convert.ToInt32(Session["UserId"]);
//ViewBag.IsConfigMenu = 0;
tbluser tblusers = db.tblusers.Find(id);
tblusers.IsDeleted = 1;
tblusers.ModifiedBy = UserID;
tblusers.ModifiedOn = System.DateTime.Now;
//start Logging
//string CompleteModificationdetail = "Deleted User";
//Action = "Delete";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
db.Entry(tblusers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddOrEdit(UserViewModel uv)
{
tbluser tb = new tbluser();
tb.Username = uv.Username;
tb.Email = uv.Email;
tb.Password = uv.Password;
HttpPostedFileBase fup = Request.Files["Photo"];
if (fup != null)
{
if (fup.FileName != "")
{
tb.Photo = fup.FileName;
fup.SaveAs(Server.MapPath("~/images/" + fup.FileName));
}
}
_db.tblusers.Add(tb);
_db.SaveChanges();
tblUserRole ud = new tblUserRole();
ud.UserId = tb.UserId;
ud.UserRoleId = 1;
_db.tblUserRoles.Add(ud);
_db.SaveChanges();
ViewBag.Message = "User Created Successfully";
return(View());
}
public ActionResult UpdatePassword()
{
if (Session["UserID"] == null)
{
return(RedirectToAction("LogIn", "User"));
}
else
{
string olpass = Request["Opass"].ToString();
string npass = Request["Npass"].ToString();
int uid = Convert.ToInt32(Session["UserID"]);
tbluser u = res.tblusers.Where(t => t.UserID == uid).SingleOrDefault();
if (u.Password.Equals(olpass))
{
u.Password = npass;
res.SaveChanges();
Session.Abandon();
return(RedirectToAction("logIn"));
}
else
{
return(RedirectToAction("Index", new { id = uid }));
}
}
}
public ActionResult Signup(UserViewModel uv)
{
tbluser tbl = db.tblusers.Where(u => u.Username == uv.Username).FirstOrDefault();
if (tbl != null)
{
return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet));
}
else
{
tbluser tb = new tbluser();
tb.Username = uv.Username;
tb.Password = uv.Password;
tb.FullName = uv.FullName;
tb.Email = uv.Email;
db.tblusers.Add(tb);
db.SaveChanges();
tblUserRole ud = new tblUserRole();
ud.UserId = tb.UserId;
ud.RoleId = 2;
db.tblUserRoles.Add(ud);
db.SaveChanges();
return(Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(tbluser obj)
{
try
{
if (ModelState.IsValid)
{
var CustomerMasterlist = repo1.GetAllUsers();
if (CustomerMasterlist.Where(ite => ite.username.ToLower() == obj.username.ToLower()).FirstOrDefault() != null)
{
ViewBag.ErrorMsg = "User already exists";
return(View(obj));
}
obj.passwordHash = vm.Encrypt(obj.passwordHash);
repo1.Update(obj);
ViewBag.SuccessMsg = "Record Updated Successfully";
}
else
{
return(View(obj));
}
}
catch (Exception ex)
{
ViewBag.ErrorMsg = "Sorry Some Problem Occured";
}
return(RedirectToAction("Listing"));
}
public ActionResult Index(tbluser user)
{
if (user.c_username == null || user.c_password == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbluser tbluser = db.tblusers.Where(x => x.c_username == user.c_username && x.c_password == user.c_password).FirstOrDefault();
if (!ModelState.IsValid)
{
return(View(user));
}
if (tbluser != null)
{
FormsAuthentication.SetAuthCookie(tbluser.c_userid.ToString(), false);
var authTicket = new FormsAuthenticationTicket(1, tbluser.c_userid.ToString(), DateTime.Now, DateTime.Now.AddMinutes(20), false, tbluser.c_usertype.ToString());
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
return(RedirectToAction("Index", "Users"));
}
else
{
ViewBag.message = "User name and password not match.";
return(View());
}
}
public ActionResult DeleteConfirmed(long id)
{
tbluser tbluser = db.tblusers.Find(id);
db.tblusers.Remove(tbluser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public tbluser GetEmployee(int userId)
{
tbluser employeeDetails = (from p in svmContext.tbluser
where p.UserId == userId && p.isDeleted == false
select p).FirstOrDefault();
return(employeeDetails);
}
public void DeleteUser(int userId)
{
tbluser employeeDetails = (from p in svmContext.tbluser
where p.UserId == userId && p.isDeleted == false
select p).FirstOrDefault();
employeeDetails.isDeleted = true;
svmContext.SaveChanges();
}
public ActionResult Login()
{
tbluser u = new tbluser();
// tbluser objUserRegistrationVM = new tbluser();
UserRegistrationVM objUserRegistrationVM = new UserRegistrationVM();
return(View(objUserRegistrationVM));
}
public ActionResult Delete(int id)
{
using (KantipurDBEntities db = new KantipurDBEntities())
{
tbluser sm = db.tblusers.Where(x => x.UserId == id).FirstOrDefault();
db.tblusers.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit([Bind(Include = "c_userid,c_username,c_password,c_usertype")] tbluser tbluser)
{
if (ModelState.IsValid)
{
db.Entry(tbluser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbluser));
}
public ActionResult AddStudent(tbluser t)
{
tbluser u = new tbluser();
u.name = t.name;
u.pass = t.pass;
db.tblusers.Add(u);
db.SaveChanges();
return(Json(u, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(tbluser tbluser)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
int UserID = Convert.ToInt32(Session["UserID"]);
int roleid = Convert.ToInt32(Session["RoleID"]);
tbluser.ModifiedBy = UserID;
tbluser.ModifiedOn = System.DateTime.Now;
var dupUserData = db.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == tbluser.UserName && m.UserID != tbluser.UserID).ToList();
if (dupUserData.Count == 0)
{
#region Active Log Code
//tblUser OldData = db.tblUsers.Find(tbluser.UserID);
//IEnumerable<string> FullData = ActiveLog.EnumeratePropertyDifferences<tblUser>(OldData, tbluser);
//ICollection<tblUser> c = FullData as ICollection<tblUser>;
//int Count = c.Count;
//if (Count != 0)
//{
// string CompleteModificationdetail = null;
// for (int i = 0; i < Count; i++)
// {
// CompleteModificationdetail = CompleteModificationdetail + "-" + FullData.Take(i).ToArray();
// }
// Action = "Edit";
// ActiveLogStorage Obj = new ActiveLogStorage();
// Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//}
#endregion //End Active Log
int primaryrole = Convert.ToInt32(tbluser.PrimaryRole);
if (primaryrole != 3)
{
tbluser.MachineID = Convert.ToInt32(System.DBNull.Value);
}
db.Entry(tbluser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "User Name Exists.";
ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.PrimaryRole);
ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.SecondaryRole);
ViewBag.MachineID = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0), "MachineID", "MachineDispName", tbluser.MachineID);
return(View(tbluser));
}
}
public ActionResult Create([Bind(Include = "c_userid,c_username,c_password,c_usertype")] tbluser tbluser)
{
if (ModelState.IsValid)
{
db.tblusers.Add(tbluser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbluser));
}
public bool SaveUserDetails(tbluser user_add) // calling SaveStudentMethod for insert a new record
{
bool result = false;
if (user_add != null)
{
db.tblusers.Add(user_add);
db.SaveChanges();
result = true;
}
return(result);
}
public UserIdentity()
{
long userid = Convert.ToInt64(HttpContext.Current.User.Identity.Name);
tbluser tbluser = db.tblusers.Where(x => x.c_userid == userid).FirstOrDefault();
if (tbluser != null)
{
userid = tbluser.c_userid;
userType = tbluser.c_usertype;
userName = tbluser.c_username;
}
}
public bool UserInsert(tbluser user)
{
try
{
userService.Insert(user);
return(true);
}
catch (System.Exception ex)
{
return(false);
}
}
// GET: Users/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbluser tbluser = db.tblusers.Find(id);
if (tbluser == null)
{
return(HttpNotFound());
}
return(View(tbluser));
}
public ActionResult ForgetPassword(UserViewModel uv)
{
if (ModelState.IsValid)
{
//https://www.google.com/settings/security/lesssecureapps
//Make Access for less secure apps=true
string from = "*****@*****.**";
using (MailMessage mail = new MailMessage(from, uv.Email))
{
try
{
tbluser tb = db.tblusers.Where(u => u.Email == uv.Email).FirstOrDefault();
if (tb != null)
{
mail.Subject = "Password Recovery";
mail.Body = "Your Password is:" + tb.Password;
mail.IsBodyHtml = false;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential networkCredential = new NetworkCredential(from, "basubinod");
smtp.UseDefaultCredentials = false;
smtp.Credentials = networkCredential;
smtp.Port = 587;
smtp.Send(mail);
ViewBag.Message = "Your Password Is Sent to your email";
}
else
{
ViewBag.Message = "email Doesnot Exist in Database";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
}
return(View());
//return RedirectToAction("Index", "Home");
}
public ActionResult logIn(tbluser u)
{
tbluser usr = res.tblusers.Where(t => t.UserName.Equals(u.UserName) && t.Password.Equals(u.Password)).SingleOrDefault();
if (usr != null)
{
Session["UserID"] = usr.UserID;
Session["Username"] = usr.UserName;
Session["Profile"] = usr.ProfilePic;
return(RedirectToAction("Index", "Home"));
}
else
{
return(RedirectToAction("logIn"));
}
}
public tbluser GetuserDet3(int OperatorID)
{
tbluser ddldet = new tbluser();
Repository <tbluser> lista = new Repository <tbluser>();
try
{
string query = "SELECT IsNormalWC from [i_facility_TSAL].[dbo].tbluser WHERE UserID =" + OperatorID + "";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public ActionResult Index(tbluser usr)
{
myshopDBEntities obj = new myshopDBEntities();
var a = obj.tblusers.Where(l => l.uname.Equals(usr.uname) && l.upass.Equals(usr.upass)).ToList();
if (a.Count > 0)
{
Session["uname"] = usr.uname.ToString();
return(RedirectToAction("Dashboard"));
}
else
{
ViewBag.msg = "Invalid Username or Password!";
}
return(View());
}
public tbluser GetuserDet3(int OperatorID)
{
tbluser ddldet = new tbluser();
Repository <tbluser> lista = new Repository <tbluser>();
try
{
string query = "SELECT * from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tblusers WHERE UserID =" + OperatorID + "";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public ActionResult ChangePassword(ChangePasswordViewModel ch)
{
string username = Session["Username"].ToString();
tbluser us = db.tblusers.Where(u => u.Username == username && u.Password == ch.OldPassword).FirstOrDefault();
if (us != null)
{
us.Password = ch.NewPassword;
db.SaveChanges();
}
else
{
return(Json(new { success = false, message = "You Enter Wrong Password" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = true, message = "Password Changed Successfully" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Authorize(tbluser userModel)
{
using (ECommerceEntities2 db = new ECommerceEntities2())
{
var userDetails = db.tblusers.Where(x => x.userid == userModel.userid && x.password == userModel.password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Wrong User Id or Password";
return(View("Index", userModel));
}
else
{
Session["userid"] = userDetails.userid;
return(RedirectToAction("Index", "Home"));
}
}
}
public ActionResult Create(tbluser tbluser)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
int roleid = Convert.ToInt32(Session["RoleID"]);
String Username = Session["Username"].ToString();
//ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc");
//ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleDesc");
tbluser.CreatedBy = roleid;
tbluser.CreatedOn = System.DateTime.Now;
tbluser.IsDeleted = 0;
////ActiveLog Code
//int UserID = Convert.ToInt32(Session["UserId"]);
//string CompleteModificationdetail = "New Creation";
//Action = "Create";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
////End
var dupUserData = db.tblusers.Where(m => m.IsDeleted == 0 && m.UserName == tbluser.UserName).ToList();
if (dupUserData.Count == 0)
{
int primaryrole = Convert.ToInt32(tbluser.PrimaryRole);
if (primaryrole != 3)
{
// tbluser.MachineID = ;
}
db.tblusers.Add(tbluser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = "User Name Exists.";
ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.PrimaryRole);
ViewBag.SecondaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0 && m.Role_ID >= roleid), "Role_ID", "RoleDesc", tbluser.SecondaryRole);
ViewBag.MachineID = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0), "MachineID", "MachineDispName", tbluser.MachineID);
return(View(tbluser));
}
}
public ActionResult SaveUser(tbluser u, HttpPostedFileBase ProfilePic)
{
var fileName = Path.GetFileName(ProfilePic.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Images/User"), fileName);
ProfilePic.SaveAs(path);
u.ProfilePic = fileName;
int cityid = Convert.ToInt32(Request["CityID"]);
byte gen = Convert.ToByte(Request["Gender"]);
u.CityID = cityid;
u.Gender = gen;
res.tblusers.Add(u);
res.SaveChanges();
return(RedirectToAction("logIn"));
}
public ActionResult CreateUser(string username, string password, string fullname)
{
tbluser usr = db.tblusers.Where(x => x.userName.Equals(username)).FirstOrDefault();
if (usr == null)
{
usr = new tbluser { userName = username, userPassword = password, userFullName = fullname };
db.tblusers.Add(usr);
db.SaveChanges();
Session["isLoggedIn"] = usr;
return RedirectToAction("PortfolioEdit");
}
else
{
ViewBag.Message = "User already exist. Try another Username";
return View();
}
//return View();
}
public ActionResult ChangePassword(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
int roleid = Convert.ToInt32(Session["RoleID"]);
String Username = Session["Username"].ToString();
tbluser tbluser = db.tblusers.Find(id);
if (tbluser == null)
{
return(HttpNotFound());
}
return(View(tbluser));
}
public ActionResult AddorEdit(tbluser user)
{
using (ECommerceEntities2 db = new ECommerceEntities2())
{
if (db.tblusers.Any(x => x.userid == user.userid))
{
ViewBag.DuplicateMessage = "User Name Already Exists.";
return(View("AddorEdit", user));
}
else
{
db.tblusers.Add(user);
db.SaveChanges();
}
}
ModelState.Clear();
ViewBag.SuccessMessage = "Registration Successful.";
return(View("AddorEdit", new tbluser()));
}
