public ActionResult EditUser(int userID)
{
int userid = Convert.ToInt32(userID);
using (var db = new DataModelContext())
{
tbl_users users = db.tbl_users.Find(userid);
//DropdownList for user Types
var userTypes = db.tbl_userType.ToList();
List<SelectListItem> dropdownUserTypes = new List<SelectListItem>();
SelectList list = new SelectList(userTypes);
foreach (var item in userTypes)
{
dropdownUserTypes.Add(new SelectListItem{ Text=item.typeName, Value=item.typeID.ToString() });
}
//------
if (users == null)
{
return HttpNotFound();
}
ViewBag.UserTypeList = new SelectList(userTypes, "typeID", "typeName");
return PartialView(users);
}
}
public tbl_userType getRole(string RoleName)
{
using(var db=new DataModelContext())
{
tbl_userType role = db.tbl_userType.SingleOrDefault(u => u.typeName == RoleName);
return role;
}
}
public IQueryable<tbl_users> getAllUser()
{
var db = new DataModelContext();
return from u in db.tbl_users
orderby u.userID
select u;
}
public tbl_users getUsers(string username)
{
using(var db=new DataModelContext())
{
tbl_users user = db.tbl_users.SingleOrDefault(u => u.userName == username);
return user;
}
}
public void createNewUser(string username, string password, string email, byte RoleID)
{
tbl_users usersModel = new tbl_users();
using (var db = new DataModelContext())
{
usersModel.userName = username;
usersModel.password = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5");
usersModel.email = email;
usersModel.typeID = RoleID; // Default User Type
db.tbl_users.Add(usersModel);
db.SaveChanges();
}
}
// Delete Role
public ActionResult DeleteRole(Byte typeID)
{
using (var db = new DataModelContext())
{
tbl_userType type = db.tbl_userType.Find(typeID);
if (type == null)
{
return HttpNotFound();
}
db.tbl_userType.Remove(type);
db.SaveChanges();
return RedirectToAction("Roles");
}
}
public override string[] GetRolesForUser(string username)
{
using (var db = new DataModelContext())
{
tbl_users user = db.tbl_users.SingleOrDefault(u => u.userName == username);
if (user == null)
{
return new string[] { string.Empty };
}
tbl_userType role = db.tbl_userType.SingleOrDefault(u => u.typeID == user.typeID);
if (role == null)
{
return new string[] { string.Empty };
}
return new string[] { role.typeName.Trim() };
}
}
public ActionResult UploadImage(UploadModel upload)
{
if (ModelState.IsValid)
{
Bitmap original = null;
var name = "newimagefile";
var errorField = string.Empty;
string foldername = "default";
if (upload.IsUrl)
{
errorField = "Url";
name = GetUrlFileName(upload.Url);
original = GetImageFromUrl(upload.Url);
}
else if (upload.IsFlickr)
{
errorField = "Flickr";
name = GetUrlFileName(upload.Flickr);
original = GetImageFromUrl(upload.Flickr);
}
else if (upload.File != null) // model.IsFile
{
errorField = "File";
name = Path.GetFileNameWithoutExtension(upload.File.FileName);
original = Bitmap.FromStream(upload.File.InputStream) as Bitmap;
foldername = Server.MapPath("~/Content/images/Profile/"+upload.userID.ToString()); // Create Directory /userID
DirectoryInfo directory = new DirectoryInfo(foldername);
if (!Directory.Exists(foldername))
{
directory.Create();
}
}
// User Find And Update
using (var db = new DataModelContext())
{
tbl_userProfile userprofile = db.tbl_userProfile.Find(upload.userID);
if (userprofile != null)
{
userprofile.image = name;
db.Entry(userprofile).State = EntityState.Modified;
db.SaveChanges();
}
}
//If we had success so far
if (original != null)
{
var img = CreateImage(original, upload.X, upload.Y, upload.Width, upload.Height);
//Demo purposes only - save image in the file system
var fn = Server.MapPath(foldername+"\\profile"+".png");
img.Save(fn, System.Drawing.Imaging.ImageFormat.Png);
//Redirect to index
return RedirectToAction("Index");
}
}
return View(upload);
}
// User Profile List
public ActionResult userProfileList()
{
using (var db =new DataModelContext())
{
var profileList = db.tbl_userProfile.ToList();
return View(profileList);
}
}
public ActionResult UsersList()
{
var db = new DataModelContext();
var users = db.tbl_users.ToList();
return View(users);
}
public ActionResult userProfile(tbl_userProfile userprofile)
{
if (ModelState.IsValid)
{
using (var db = new DataModelContext())
{
tbl_userProfile userprof = (from profile in db.tbl_userProfile where profile.userID == userprofile.userID select profile).FirstOrDefault();
if (userprof == null)// user not found in database, insert new data
{
userprofile.createDate = DateTime.Now;
db.tbl_userProfile.Add(userprofile);
db.SaveChanges();
return RedirectToAction("UsersList");
}
else // already has user data Update !
{
userprof.nameSurname = userprofile.nameSurname;
userprof.phone = userprofile.phone;
userprof.adress = userprofile.adress;
userprof.createDate = DateTime.Now;
db.Entry(userprof).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("UsersList");
}
}
}
else
{
ModelState.AddModelError("ProfileAdd", "Do not new user profile!..");
}
return View(userprofile);
}
// Find userProfiles
public ActionResult userProfileEdit(int userID)
{
if (userID == 0)
{
return HttpNotFound();
}
else
{
using (var db = new DataModelContext())
{
var userinfo = db.tbl_userProfile.Find(userID);
if (userinfo == null)
{
ModelState.AddModelError("UserProfile", "User not found..!");
}
else
{
return RedirectToAction("UserList");
}
return View(userinfo);
}
}
}
// Start
public ActionResult userProfile(int userID)
{
if (userID == 0)
{
ModelState.AddModelError("UserInfo", "UserID is not empty!");
return RedirectToAction("UsersList");
}
else
{
ViewBag.UserId = userID;
using (var db = new DataModelContext())
{
tbl_userProfile userprof = (from profile in db.tbl_userProfile where profile.userID == userID select profile).FirstOrDefault();
return View(userprof);
}
}
}
public ActionResult UserDeleteConfirmed(int userID)
{
using (var db = new DataModelContext())
{
tbl_users users = db.tbl_users.Find(userID);
if (users == null)
{
return HttpNotFound();
}
else
{
db.tbl_users.Remove(users);
db.SaveChanges();
}
}
return RedirectToAction("UsersList");
}
public ActionResult EditUser(tbl_users user)
{
if (ModelState.IsValid)
{
using (var db = new DataModelContext())
{
user.typeID = Convert.ToByte(user.typeID);
//Utility cryptor = new Utility(); // Encrypt User Password
//string encrypt = cryptor.CreatePasswordHash(user.password, user.saltPass = cryptor.GenerateSalt(58), "SHA1");
string encrypt = FormsAuthentication.HashPasswordForStoringInConfigFile(user.password, "md5");
user.password = encrypt;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("UsersList");
}
}
else
{
return RedirectToAction("EditUser");
}
}
public ActionResult Roles()
{
using (var db = new DataModelContext())
{
var userTypes = db.tbl_userType.ToList();
if (userTypes == null)
{
ModelState.AddModelError("Role List Error", "Role List is null");
return RedirectToAction("Index");
}
return View(userTypes);
}
}
public ActionResult Roles(tbl_userType usertype)
{
if (ModelState.IsValid)
{
var db = new DataModelContext();
db.tbl_userType.Add(usertype);
db.SaveChanges();
return RedirectToAction("Roles");
}
return View();
}
// User Login Control
public int UserIsValid(string username, string password)
{
// Utility cryptor = new Utility();
using (var db = new DataModelContext())
{
try
{
var salt = db.tbl_users.Single(m => m.userName == username);
// string encrypted = cryptor.CreatePasswordHash(password, salt.saltPass, "SHA1");
string encrypted = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5");
int loggedUserID = db.spLogIn(username, password);
return loggedUserID;
}
catch (Exception)
{
ModelState.AddModelError("DataError", "User not found!");
return -1;
}
}
}
public ActionResult UserDelete(int userID)
{
using (var db = new DataModelContext())
{
tbl_users users = db.tbl_users.Find(userID);
if (users == null)
{
return HttpNotFound();
}
return View(users);
}
}