public ActionResult CreateUser(User obj) { // HttpPostedFileBase file = Request.Files["ImageData"]; if (ModelState.IsValid) { ref_Users user = new ref_Users(); user.DepartmentId = obj.DepartmentId; user.Email = obj.Email; user.FirstName = obj.FirstName; user.LastName = obj.LastName; user.UserRole = (int)obj.RoleId; var fileName = Path.GetFileName(obj.ImagePath.FileName); var path = Path.Combine(Server.MapPath("~/Content/Upload/"), fileName); obj.ImagePath.SaveAs(path); user.ImagePath = fileName; user.Password = obj.FirstName; user.ActiveStatus = false; ViewBag.Message = "File has been uploaded successfully"; db.ref_Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index", "Admin")); } else { return(Content("Error")); } }
public ActionResult Delete(ref_Users user) { ref_Users UserToDelete = db.ref_Users.Where(a => a.Id == user.Id && a.DepartmentId == user.DepartmentId).FirstOrDefault(); db.ref_Users.Remove(UserToDelete); db.SaveChanges(); ViewBag.UserList = db.ref_Users.ToList(); return(RedirectToAction("CreateUser")); }
public ActionResult EditUser(int id) { string Email = Session["UserName"].ToString(); ref_Users obj = db.ref_Users.Where(a => a.Id == id).FirstOrDefault(); var User = new User { Id = obj.Id, DepartmentId = obj.DepartmentId, FirstName = obj.FirstName, LastName = obj.LastName, Email = obj.Email, RoleId = obj.UserRole }; var AdminDeptList = db.ref_Users.Where(a => a.Email == Email).Select(a => a.DepartmentId).ToList(); ViewBag.Userlist = db.ref_Users.Where(a => AdminDeptList.Contains(a.DepartmentId)).ToList(); var DeptList = db.ref_department.Where(a => AdminDeptList.Contains(a.DeptId)).ToList(); var RoleList = db.ref_roles.Where(a => a.RoleId != 4).ToList(); ViewBag.DeptLists = new SelectList(DeptList, "DeptId", "DeptName"); ViewBag.RoleList = new SelectList(RoleList, "RoleId", "RoleName"); ViewBag.Image = obj.ImagePath; User.ActiveStatus = (bool)obj.ActiveStatus; return(PartialView("EditUser2", User)); }
public ActionResult EditUser(User user) { if (ModelState.IsValid) { ref_Users obj = db.ref_Users.Where(a => a.Id == user.Id).FirstOrDefault(); obj.DepartmentId = user.DepartmentId; obj.FirstName = user.FirstName; obj.LastName = user.LastName; obj.UserRole = (int)user.RoleId; obj.ActiveStatus = user.ActiveStatus; if (user.ImagePath != null) { var fileName = Path.GetFileName(user.ImagePath.FileName); var path = Path.Combine(Server.MapPath("~/Content/Upload/"), fileName); user.ImagePath.SaveAs(path); obj.ImagePath = fileName; } db.SaveChanges(); } return(RedirectToAction("Index", "Admin")); }
public ActionResult BulkUserUpload(HttpPostedFileBase file) { DataSet ds = new DataSet(); if (Request.Files["file"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["file"].FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { //string fileLocation = Server.MapPath("~/UserFiles/") + Request.Files["file"].FileName; System.IO.Directory.CreateDirectory(Server.MapPath("~/UserFiles/" + DateTime.Now.DayOfWeek + "_" + Session["UserName"].ToString())); string fileLocation = Server.MapPath("~/UserFiles/" + DateTime.Now.DayOfWeek + "_" + Session["UserName"].ToString() + "/") + Request.Files["file"].FileName; Request.Files["file"].SaveAs(fileLocation); string excelConnectionString = string.Empty; excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=No;IMEX=2\""; //connection String for xls file format. if (fileExtension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=2\""; } //connection String for xlsx file format. else if (fileExtension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; } //Create Connection to Excel work book and add oledb namespace OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); DataTable dt = new DataTable(); dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dt == null) { return(null); } String[] excelSheets = new String[dt.Rows.Count]; int t = 0; //excel data saves in temp file here. foreach (DataRow row in dt.Rows) { excelSheets[t] = row["TABLE_NAME"].ToString(); t++; } OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString); string query = string.Format("Select * from [{0}]", excelSheets[0]); excelConnection.Close(); using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1)) { dataAdapter.Fill(ds); } } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ref_Users obj = new ref_Users(); obj.Email = ds.Tables[0].Rows[i][0].ToString(); if (ds.Tables[0].Rows[i][1].ToString() == "") { obj.DepartmentId = 2;// Set default value for blank DepartmentId } else { obj.DepartmentId = int.Parse(ds.Tables[0].Rows[i][1].ToString()); } obj.Password = obj.Email.Substring(0, 4);// ds.Tables[0].Rows[i][2].ToString(); obj.FirstName = ds.Tables[0].Rows[i][2].ToString(); obj.LastName = ds.Tables[0].Rows[i][3].ToString(); obj.ImagePath = "a.jpg"; obj.ActiveStatus = false;// Convert.ToBoolean(ds.Tables[0].Rows[i][3].ToString()); switch (ds.Tables[0].Rows[i][4].ToString()) { case "Admin": obj.UserRole = 1; break; case "Manager": obj.UserRole = 2; break; case "Learner": obj.UserRole = 3; break; } if (db.ref_Users.Where(a => a.Email == obj.Email && a.DepartmentId == obj.DepartmentId && a.UserRole == obj.UserRole).Count() == 0) { //obj.UserRole = int.Parse(ds.Tables[0].Rows[i][4].ToString()); db.ref_Users.Add(obj); } } db.SaveChanges(); } return(RedirectToAction("Index", "Admin")); }
public ActionResult DeleteUser(int id) { ref_Users objdept = db.ref_Users.Where(a => a.Id == id).FirstOrDefault(); return(PartialView("DeleteUser", objdept)); }