// [HttpGet] // public PartialViewResult EditUser(string id) // { // Guid guid = new Guid(id); // User userDetails = objDb.EditUser(guid); // List<Role> lstRoles = objDb.GetallRoles(); // ViewBag.Roles = new SelectList(lstRoles, "RoleId", "Role1"); // return PartialView ("_FillUser",userDetails); // } // [HttpPost] // public void EditUser(User user) // { // objDb.UpdateEditUSer(user); // List<Role> lstRoles = objDb.GetallRoles(); // ViewBag.Roles = new SelectList(lstRoles, "RoleId", "Role1"); // } // public ActionResult GetAllApplicationDetails() // { // List<Application> lstapplidata = objDb.GetAllApplicationnData(); // return View(lstapplidata); // } // //For Application User Details Edit // public ActionResult Editapplication(int id) // { // //Guid guid = new Guid(id); // Application userDetails = objDb.EditAppliactionData(id); // List<Role> lstRoles = objDb.GetallRoles(); // CommonDBOperations objCommDbOper = new CommonDBOperations(); // ViewBag.Banks = new SelectList(objCommDbOper.GetAllBanks(), "BankId", "BankName"); // ViewBag.Locations = new SelectList(objCommDbOper.GetAllLocations(), "LocationId", "Location1"); // ViewBag.Branches = new SelectList(objCommDbOper.GetAllBranches(), "BranchId", "BranchName"); // ViewBag.Products = new SelectList(objCommDbOper.GetAllProducts(), "ProductId", "Product1"); // ViewBag.Roles = new SelectList(lstRoles, "RoleId", "Role1"); // return View(userDetails); // } // //For Conform Edited Application User Details // [HttpPost] // public ActionResult EditaApplicationUser(Application appuser) // { // objDb.SaveEditApplicationUser(appuser); // return RedirectToAction("GetAllApplicationDetails"); // } // public ActionResult DeleteApplicationUser(int id) // { // objDb.DeleteApplicationUser(id); // return RedirectToAction("GetAllApplicationDetails"); // } // public ActionResult DetailsApplicationUser(int id) // { // Application userDetails = objDb.EditAppliactionData(id); // return View(userDetails); // } public ActionResult StatusPage(string name) { SathishLayoutEntities1 dbContext = new SathishLayoutEntities1(); UserInfo singleUser = dbContext.UserInfoes.Where(u => u.UserName == name).FirstOrDefault(); return(View(singleUser)); }
public Guid IsValidUser(string userName, string pwd) { UserInfo user = new UserInfo(); try { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { user = db.UserInfoes.Where(u => u.UserName.ToLower() == userName.ToLower()).Where(u => u.Password == pwd).FirstOrDefault(); } } catch (Exception ex) { Library.WriteLog("At IsValidUser UserName- " + userName, ex); return(Guid.Empty); } if (user != null) { return(user.UserId); } else { return(Guid.Empty); } }
//public List<Bank> GetAllBanks() //{ // using(ConsultancyEntities objEntity = new ConsultancyEntities()) // { // return objEntity.Banks.ToList(); // } //} //public void Adduser(User user) //{ // try // { // using (ConsultancyEntities db = new ConsultancyEntities()) // { // user.UserId = Guid.NewGuid(); // db.Users.Add(user); // db.SaveChanges(); // } // } // catch(Exception ex) // { // } //} //public List<Role> GetallRoles() //{ // //try // //{ // using (ConsultancyEntities db = new ConsultancyEntities()) // { // return db.Roles.ToList(); // } // // } // //catch(Exception ex) // //{ // // //for display error // //} //} public List <UserInfo> GetAllUserDetails() { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { List <UserInfo> lstUSer = db.UserInfoes.ToList(); return(lstUSer); } }
public ActionResult AdminPlotDetails(string userName) { SathishLayoutEntities1 dbContext = new SathishLayoutEntities1(); //UserInfo singleUser = dbContext.UserInfoes.Where(u => u.UserName == userName).FirstOrDefault(); List <PlotDetailsInfo> plotDetaisl = dbContext.PlotDetailsInfoes.Where(s => s.UserName == userName).ToList(); ViewBag.userName = userName; return(View(plotDetaisl)); }
public ActionResult PartialViewDisplay(string userName) { SathishLayoutEntities1 dbContext = new SathishLayoutEntities1(); //UserInfo singleUser = dbContext.UserInfoes.Where(u => u.UserName == userName).FirstOrDefault(); List <PlotDetailsInfo> Singleplot = dbContext.PlotDetailsInfoes.Where(s => s.UserName == userName).ToList(); ViewBag.userName = userName; return(View(Singleplot)); }
//public User EditUser(Guid id) //{ // // Guid editedGuid = new Guid(id); // using (ConsultancyEntities db = new ConsultancyEntities()) // { // return db.Users.Find(id); // } //} //public void UpdateEditUSer(User user) //{ // using (ConsultancyEntities db = new ConsultancyEntities()) // { // //User updateuser=db.Users.Find() // db.Entry(user).State = EntityState.Modified; // db.SaveChanges(); // // return db.Users // } //} //public List<Application> GetAllApplicationnData() //{ // using (ConsultancyEntities db = new ConsultancyEntities()) // { // List<Application> lstAppUserData = db.Applications.ToList(); // return (lstAppUserData); // } //} //public Application EditAppliactionData(int id) //{ // // Guid editedGuid = new Guid(id); // using (ConsultancyEntities db = new ConsultancyEntities()) // { // return db.Applications.Find(id); // } //} //public void SaveEditApplicationUser(Application appuser) //{ // using (ConsultancyEntities db = new ConsultancyEntities()) // { // db.Entry(appuser).State = EntityState.Modified; // db.SaveChanges(); // } //} public void DeleteApplicationUser(int id) { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { // Application userapp= db.Applications.Find(id); // db.Applications.Remove(userapp); // db.SaveChanges(); } }
public ActionResult UserDetails(string userName) { SathishLayoutEntities1 dbContext = new SathishLayoutEntities1(); UserData userData = new UserData(); UserInfo user = dbContext.UserInfoes.Where(u => u.UserName == userName).FirstOrDefault(); List <PlotDetailsInfo> plotsInfo = dbContext.PlotDetailsInfoes.Where(s => s.UserName == userName).ToList(); userData.UserInfo = user; userData.PlotsInfo = plotsInfo; ViewBag.userName = userName; return(View(userData)); }
public ActionResult Register(UserInfo userRegistration, HttpPostedFileBase postedFile, FormCollection coll) { SathishLayoutEntities1 entities = new SathishLayoutEntities1(); string indexColl = coll["PlotColl.index"]; string[] plotIndexColl = indexColl.Split(','); string path = Server.MapPath("~/UploadImages/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } foreach (string index in plotIndexColl) { PlotDetailsInfo plotInfo = new PlotDetailsInfo(); plotInfo.UserName = userRegistration.UserName; plotInfo.PlotNumber = coll["PlotColl[" + index + "]" + ".PlotNumber"]; plotInfo.Area = coll["PlotColl[" + index + "]" + ".Area"]; plotInfo.DocumentNumber = Convert.ToInt32(coll["PlotColl[" + index + "]" + ".DocumentNumber"]); plotInfo.YearOfRegistration = Convert.ToInt32(coll["PlotColl[" + index + "]" + ".YearOfRegistration"]); plotInfo.RegistrationOffice = coll["PlotColl[" + index + "]" + ".RegistrationOffice"]; plotInfo.Nominee = coll["PlotColl[" + index + "]" + ".Nominee"]; plotInfo.PlotDocumentPhoto = coll["PlotColl[" + index + "]" + ".PlotDocumentPhoto"]; entities.PlotDetailsInfoes.Add(plotInfo); } // if (Request.Files.Count > 0) // { string fileName = System.IO.Path.GetFileName(postedFile.FileName); string filePath = "~/UploadImages/" + fileName; postedFile.SaveAs(path + postedFile.FileName); userRegistration.Attachments = filePath; userRegistration.UserId = Guid.NewGuid(); userRegistration.Status = "In progress"; userRegistration.PlotNumber = null; entities.UserInfoes.Add(userRegistration); entities.SaveChanges(); // } return(RedirectToAction("RegisterSuccess")); }
public string[] GetRoelsForUser(string userName) { string[] roleColl = new string[1]; try { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { UserInfo user = db.UserInfoes.Where(u => u.UserName.ToLower() == userName.ToLower()).FirstOrDefault(); roleColl[0] = user.Role.Role1; } } catch (Exception ex) { Library.WriteLog("At IsValidUser UserName- " + userName, ex); return(roleColl); } return(roleColl); }
public UserInfo GetUser(Guid id) { try { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { UserInfo user = db.UserInfoes.Find(id); if (user != null) { return(user); } } } catch (Exception ex) { Library.WriteLog("At Get User", ex); } return(null); }
// [HttpPost] public ActionResult UpdateStatus(string name, string status) { SathishLayoutEntities1 dbContext = new SathishLayoutEntities1(); UserInfo singleUser1 = dbContext.UserInfoes.Where(u => u.UserName == name).FirstOrDefault(); if (status == "Approved") { Random generator = new Random(); int r = generator.Next(100000, 999999); var memberShipGeneratedId = "MS" + r; singleUser1.MemberShipId = memberShipGeneratedId; } singleUser1.Status = status; dbContext.Entry(singleUser1).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); return(RedirectToAction("GetUsers")); }
public bool IsUserInRole(string userName, string role) { bool isUserInRole = false; try { using (SathishLayoutEntities1 db = new SathishLayoutEntities1()) { UserInfo user = db.UserInfoes.Where(u => u.UserName.ToLower() == userName.ToLower()). Where(u => u.Role.Role1 == role).FirstOrDefault(); if (user != null) { isUserInRole = true; } } } catch (Exception ex) { Library.WriteLog("At IsUserInRole UserName- " + userName, ex); return(false); } return(isUserInRole); }