// [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);
}
