public ActionResult Create([Bind(Include = "Id,AdminLoginIp,Email,MailPassword")] SafetyModel safetyModel) { if (ModelState.IsValid) { // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "SafetyModel"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(safetyModel); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.SafetyModels.Add(safetyModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(safetyModel)); }
public ActionResult DeleteConfirmed(int id) { RoleMenuMapping roleMenuMapping = db.RoleMenuMappings.Find(id); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleMenuMapping"; logingInfoModel.TypeOfAction = TypeOfAction.Delete; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(roleMenuMapping); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.RoleMenuMappings.Remove(roleMenuMapping); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,RoleId,RoleIdText,MenuInfoId,MenuInfoIdText,CanView,CanCreate,CanEdit,CanDelete,Active")] RoleMenuMapping roleMenuMapping) { if (ModelState.IsValid) { // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleMenuMapping"; logingInfoModel.TypeOfAction = TypeOfAction.Update; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(roleMenuMapping); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.Entry(roleMenuMapping).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(roleMenuMapping)); }
public ActionResult DeleteConfirmed(int id) { var RoleName = db.RoleMasters.Where(w => w.Id == id).FirstOrDefault().Name; var RoleExistedInUser = db.RoleMasters.Where(w => w.Name == RoleName).FirstOrDefault(); if (RoleName == "Admin" || RoleExistedInUser != null) { return(RedirectToAction("Index")); } RoleMaster roleMasterDel = db.RoleMasters.Find(id); var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(db)); var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole(); role = roleManager.FindByName(roleMasterDel.Name); var roleResult = roleManager.DeleteAsync(role); using (var db = new ApplicationDbContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { RoleMaster roleMaster = db.RoleMasters.Find(id); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleMaster"; logingInfoModel.TypeOfAction = TypeOfAction.Delete; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(roleMaster); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.RoleMasters.Remove(roleMaster); if (roleResult.Result.Errors.Count() == 0) { db.SaveChanges(); dbContextTransaction.Commit(); } } catch (Exception ex) { dbContextTransaction.Rollback(); } } } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,UserId,Name,RoleId,Active,UserCell")] UserMaster userMaster) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canEdit = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("UserMasters") && rm.RoleId == roleId select rm.CanEdit).FirstOrDefault(); if (!canEdit) { return(RedirectToAction("Index")); } // to ensure same role single user var roleAlreadyIn = db.UserMasters.Where(w => w.RoleId == userMaster.RoleId).FirstOrDefault(); if (roleAlreadyIn != null) { return(RedirectToAction("Index")); } // to ensure same role single user if (ModelState.IsValid) { // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "UserMaster"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.SysDate = DateTime.Now; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(userMaster); db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.UserMasters.Add(userMaster); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RoleId = new SelectList(db.RoleMasters, "Id", "Name", userMaster.RoleId); return(View(userMaster)); }
public ActionResult Create([Bind(Include = "Id,Name,Active")] RoleMaster roleMaster, string DepartmentName) { roleMaster.Name = roleMaster.Name + " " + DepartmentName; if (db.RoleMasters.Where(w => w.Name == roleMaster.Name).ToList().Count() > 0) { return(RedirectToAction("Index")); } if (ModelState.IsValid) { db.RoleMasters.Add(roleMaster); db.SaveChanges(); var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(db)); var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole(); role.Name = roleMaster.Name; roleManager.Create(role); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleMaster"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(role); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential return(RedirectToAction("Index")); } List <SelectListItem> DepartmentNameList = new List <SelectListItem>(); foreach (var Depart in db.Departments.ToList()) { DepartmentNameList.Add(new SelectListItem() { Text = Depart.DepartmentName.ToString(), Value = Depart.DepartmentName.ToString() }); } ViewBag.DepartmentNameData = new SelectList(DepartmentNameList.Distinct(), "Value", "Text"); return(View(roleMaster)); }
public ActionResult Create([Bind(Include = "Id,Depart,Role,UpperRole")] Organogram organogram) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canCreate = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("Organograms") && rm.RoleId == roleId select rm.CanCreate).FirstOrDefault(); var upperNotExisted = db.Organograms.Where(w => w.Role == organogram.UpperRole).FirstOrDefault(); if (!canCreate || upperNotExisted == null || db.Organograms.Where(w => w.Role == organogram.Role).Count() > 0) { return(RedirectToAction("Index")); } if (ModelState.IsValid) { // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "Organogram"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(organogram); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.Organograms.Add(organogram); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(organogram)); }
public ActionResult Create([Bind(Include = "Id,BankName,BranchName")] BankAndBranch bankAndBranch) { if (ModelState.IsValid) { using (var context = new ApplicationDbContext()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { context.BankAndBranches.Add(bankAndBranch); // context.SaveChanges(); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "BankAndBranches"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.SysDate = DateTime.Now; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(bankAndBranch); context.LoginInfoModels.Add(logingInfoModel); context.SaveChanges(); // Saving Longing Credential dbContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } } return(View(bankAndBranch)); }
public ActionResult Edit([Bind(Include = "Id,DepartmentName")] Department department) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canEdit = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("Departments") && rm.RoleId == roleId select rm.CanEdit).FirstOrDefault(); if (!canEdit) { return(RedirectToAction("Index")); } if (ModelState.IsValid) { // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "Department"; logingInfoModel.TypeOfAction = TypeOfAction.Update; logingInfoModel.SysDate = DateTime.Now; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(department); db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.Entry(department).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(department)); }
public ActionResult DeleteConfirmed(int id) { using (var context = new ApplicationDbContext()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { BankAndBranch bankAndBranch = context.BankAndBranches.Find(id); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "BankAndBranches"; logingInfoModel.TypeOfAction = TypeOfAction.Delete; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(bankAndBranch); logingInfoModel.SysDate = DateTime.Now; context.LoginInfoModels.Add(logingInfoModel); context.BankAndBranches.Remove(bankAndBranch); // Saving Longing Credential context.SaveChanges(); dbContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,MenuName,MenuURL,MenuParentID,MenuParentIDText,CanView,CanCreate,CanEdit,CanDelete,Active")] MenuInfo menuInfo) { if (ModelState.IsValid) { var MenuParent = db.MenuInfoes.Where(w => w.Id == menuInfo.MenuParentID).FirstOrDefault(); menuInfo.MenuParentIDText = MenuParent.MenuName; if (!User.IsInRole("Admin")) { return(RedirectToAction("Login", "Home")); } // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); logingInfoModel.UsedModel = "MenuInfo"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(menuInfo); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.MenuInfoes.Add(menuInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(menuInfo)); }
public ActionResult Edit([Bind(Include = "Id,Depart,Role,UpperRole")] Organogram organogram) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canEdit = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("Organograms") && rm.RoleId == roleId select rm.CanEdit).FirstOrDefault(); if (!canEdit || db.Organograms.Min(o => o.Id) == organogram.Id || db.Organograms.Where(w => w.Id != organogram.Id && w.Role == organogram.Role).Count() > 0) { return(RedirectToAction("Index")); } if (ModelState.IsValid) { using (var context = new ApplicationDbContext()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { var organogramToUpdate = context.Organograms.Where(w => w.Id == organogram.Id).FirstOrDefault(); organogramToUpdate.Depart = organogram.Depart; organogramToUpdate.Role = organogram.Role; organogramToUpdate.UpperRole = organogram.UpperRole; List <LoginInfoModel> logingInfoModelList = new List <LoginInfoModel>(); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "Organogram"; logingInfoModel.TypeOfAction = TypeOfAction.Update; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(organogramToUpdate); logingInfoModel.SysDate = DateTime.Now; logingInfoModelList.Add(logingInfoModel); string PreviousRole = context.Organograms.Where(w => w.Id == organogramToUpdate.Id).FirstOrDefault().Role; foreach (var organogramUpdate in context.Organograms.Where(w => w.UpperRole == PreviousRole).ToList()) { organogramUpdate.UpperRole = organogram.Role; LoginInfoModel logingInfoModelOne = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencialOne = new PopulateLoginInfoCredencial(logingInfoModelOne); logingInfoModelOne = populateLoginInfoCredencialOne.getLoginInfoCredencial(); if (!populateLoginInfoCredencialOne.ValidateIPv4(logingInfoModelOne.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModelOne.UsedModel = "Organogram"; logingInfoModelOne.TypeOfAction = TypeOfAction.Update; logingInfoModelOne.Data = Newtonsoft.Json.JsonConvert.SerializeObject(organogramUpdate); logingInfoModelOne.SysDate = DateTime.Now; logingInfoModelList.Add(logingInfoModelOne); } context.LoginInfoModels.AddRange(logingInfoModelList); context.Entry(organogramToUpdate).State = EntityState.Modified; context.SaveChanges(); dbContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.EntityCommandCompilationException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.UpdateException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Infrastructure.DbUpdateException ex) //DbContext { dbContextTransaction.Rollback(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } } return(View(organogram)); }
public ActionResult DeleteConfirmed(int id) { var RoleId = db.UserMasters.Where(w => w.Id == id).FirstOrDefault().RoleId; var RoleName = db.RoleMasters.Where(w => w.Id == RoleId).FirstOrDefault().Name; if (RoleName == "Admin") { return(RedirectToAction("Index")); } var RoleIdInUse = db.RoleMenuMappings.Where(w => w.RoleId == RoleId).FirstOrDefault(); if (RoleIdInUse != null) { return(RedirectToAction("Index")); } MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var CanDelete = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("UserMasters") && rm.RoleId == roleId select rm.CanDelete).FirstOrDefault(); if (!CanDelete) { return(RedirectToAction("Index")); } using (var db = new ApplicationDbContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { UserMaster userMaster = db.UserMasters.Find(id); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "UserMaster"; logingInfoModel.TypeOfAction = TypeOfAction.Delete; var uMaster = new { Id = userMaster.Id , UserId = userMaster.UserId , UserCell = userMaster.UserCell , Name = userMaster.Name , RoleId = userMaster.RoleId , Active = userMaster.Active }; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(uMaster); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.UserMasters.Remove(userMaster); var UserNameToDel = userMaster.Name; db.SaveChanges(); var manager = new ApplicationUserManager(new UserStore <ApplicationUser>(db)); ApplicationUser userDel = manager.FindByName(UserNameToDel); manager.DeleteAsync(userDel); Task.Delay(2000).Wait(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canDelete = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("Organograms") && rm.RoleId == roleId select rm.CanDelete).FirstOrDefault(); if (!canDelete || db.Organograms.Min(o => o.Id) == id) { return(RedirectToAction("Index")); } using (var context = new ApplicationDbContext()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { Organogram organogram = context.Organograms.Find(id); List <LoginInfoModel> logingInfoModelList = new List <LoginInfoModel>(); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "Organogram"; logingInfoModel.TypeOfAction = TypeOfAction.Delete; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(organogram); logingInfoModel.SysDate = DateTime.Now; logingInfoModelList.Add(logingInfoModel); var DeletedRoleEntity = context.Organograms.Where(w => w.Id == organogram.Id).FirstOrDefault(); var Role = DeletedRoleEntity.Role; var UpperRole = DeletedRoleEntity.UpperRole; foreach (var organogramUpdate in context.Organograms.Where(w => w.UpperRole == Role).ToList()) { organogramUpdate.UpperRole = UpperRole; LoginInfoModel logingInfoModelOne = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencialOne = new PopulateLoginInfoCredencial(logingInfoModelOne); logingInfoModelOne = populateLoginInfoCredencialOne.getLoginInfoCredencial(); if (!populateLoginInfoCredencialOne.ValidateIPv4(logingInfoModelOne.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModelOne.UsedModel = "Organogram"; logingInfoModelOne.TypeOfAction = TypeOfAction.Update; logingInfoModelOne.Data = Newtonsoft.Json.JsonConvert.SerializeObject(organogramUpdate); logingInfoModelOne.SysDate = DateTime.Now; logingInfoModelList.Add(logingInfoModelOne); } context.LoginInfoModels.AddRange(logingInfoModelList); context.Organograms.Remove(organogram); context.SaveChanges(); dbContextTransaction.Commit(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.EntityCommandCompilationException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.UpdateException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Infrastructure.DbUpdateException ex) //DbContext { dbContextTransaction.Rollback(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } Organogram organogramTemp = db.Organograms.Find(id); if (organogramTemp == null) { return(HttpNotFound()); } return(View(organogramTemp)); }
public ActionResult Create(ArtWork artwork, FormCollection collection, HttpPostedFileBase image) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canCreate = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("ArtWorks") && rm.RoleId == roleId select rm.CanCreate).FirstOrDefault(); if (!canCreate) { return(RedirectToAction("Index")); } using (var db = new ApplicationDbContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { StringBuilder sb = new StringBuilder(); sb.Clear(); string CheckList = collection["Departments"]; if (CheckList != null) { string[] vListDepartment = CheckList.Split(','); foreach (var d in vListDepartment) { if (sb.Length > 0) { sb.Append(" , " + d); } else { sb.Append(d); } } } if (image != null) { //attach the uploaded image to the object before saving to Database artwork.ImageMimeType = image.ContentLength; artwork.ImageData = new byte[image.ContentLength]; image.InputStream.Read(artwork.ImageData, 0, image.ContentLength); // To Get the Max Id int countAw = db.ArtWorks.Count(); int maxId = 0; if (countAw > 0) { maxId = db.ArtWorks.Max(m => m.Id) + 1; } else { maxId = 1; } string FileWhole = image.FileName; string[] SplitFileWhole = FileWhole.Split('\\'); int LastPartOfFile = SplitFileWhole.Count() - 1; //Save image to file var filename = maxId.ToString() + "_" + artwork.User + "_" + SplitFileWhole[LastPartOfFile]; artwork.FileAddressInfo = filename; var filePathOriginal = Server.MapPath("~/Content/Uploads/Originals"); var filePathThumbnail = Server.MapPath("~/Content/Uploads/Thumbnails"); string savedFileName = Path.Combine(filePathOriginal, filename); string UploadedfileExtension = Path.GetExtension(image.FileName); if (System.IO.File.Exists(savedFileName)) { System.IO.File.Delete(savedFileName); } image.SaveAs(savedFileName); // back up into external drive try { var ExDrive = db.TestCallls.Select(s => s.value).FirstOrDefault(); string externalLocationAddress = ExDrive + fileStoreCreateFolderName.getFolderName(); bool exists = System.IO.Directory.Exists(externalLocationAddress); if (!exists) { System.IO.Directory.CreateDirectory(externalLocationAddress); } string externalFileName = Path.Combine(externalLocationAddress, filename); bool fileExist = System.IO.File.Exists(externalFileName); if (fileExist) { Random r = new Random(); // Later to be indetified by the sequence which got start in between 900000 to 900100 string ExistExternalFileName = Path.Combine(externalLocationAddress, r.Next(900000, 900100).ToString() + "_" + filename); image.SaveAs(ExistExternalFileName); } else { string ExistExternalFileName = Path.Combine(externalLocationAddress, filename); image.SaveAs(ExistExternalFileName); } } catch (Exception ex) { } // back up into external drive //Read image back from file and create thumbnail from it var imageFile = Path.Combine(Server.MapPath("~/Content/Uploads/Originals"), filename); if (UploadedfileExtension.ToUpper() == ".JPG" || UploadedfileExtension.ToUpper() == ".JPEG" || UploadedfileExtension.ToUpper() == ".PNG" || UploadedfileExtension.ToUpper() == ".GIF") { using (var srcImage = Image.FromFile(imageFile)) using (var newImage = new Bitmap(100, 100)) using (var graphics = Graphics.FromImage(newImage)) using (var stream = new MemoryStream()) { graphics.SmoothingMode = SmoothingMode.AntiAlias; graphics.InterpolationMode = InterpolationMode.HighQualityBicubic; graphics.PixelOffsetMode = PixelOffsetMode.HighQuality; graphics.DrawImage(srcImage, new Rectangle(0, 0, 100, 100)); newImage.Save(stream, ImageFormat.Png); var thumbNew = File(stream.ToArray(), "image/png"); artwork.ArtworkThumbnail = thumbNew.FileContents; } } artwork.CreateTime = DateTime.Now; artwork.User = System.Web.HttpContext.Current.User.Identity.Name; artwork.ValidDepartment = sb.ToString(); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "ArtWork"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(artwork); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); // Saving Longing Credential //Save model object to database db.ArtWorks.Add(artwork); db.SaveChanges(); dbContextTransaction.Commit(); return(RedirectToAction("Index")); } } catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.EntityCommandCompilationException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Core.UpdateException ex) { dbContextTransaction.Rollback(); } catch (System.Data.Entity.Infrastructure.DbUpdateException ex) //DbContext { dbContextTransaction.Rollback(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } return(View(artwork)); }
public ActionResult Create(List <MenuInfo> menuList, string RoleName) { var roleToDel = 0; List <RoleMenuMapping> roleMenuMappings = db.RoleMenuMappings.Where(drm => drm.RoleIdText == RoleName).ToList(); if (roleMenuMappings != null && roleMenuMappings.Count() > 0) { roleToDel = roleMenuMappings[0].RoleId; } foreach (var item in roleMenuMappings) { db.RoleMenuMappings.Remove(item); db.SaveChanges(); } RoleMenuMapping roleMenuMapping = new RoleMenuMapping(); var RoleList = db.RoleMasters.ToList(); var AllMenu = db.MenuInfoes.ToList(); if (ModelState.IsValid) { foreach (var item in menuList) { var MenoInfoIdText = AllMenu.Where(am => am.Id == item.Id).Select(s => s.MenuParentIDText).FirstOrDefault(); if (MenoInfoIdText == null || MenoInfoIdText == "") { MenoInfoIdText = AllMenu.Where(am => am.Id == item.Id).Select(s => s.MenuName).FirstOrDefault(); } var RoleId = RoleList.Where(rl => rl.Name == RoleName).Select(r => r.Id).FirstOrDefault(); roleMenuMapping.MenuInfoId = item.Id; roleMenuMapping.MenuInfoIdText = MenoInfoIdText; roleMenuMapping.CanView = Convert.ToBoolean(item.CanView); roleMenuMapping.CanCreate = Convert.ToBoolean(item.CanCreate); roleMenuMapping.CanEdit = Convert.ToBoolean(item.CanEdit); roleMenuMapping.CanDelete = Convert.ToBoolean(item.CanDelete); roleMenuMapping.CanClose = Convert.ToBoolean(item.CanClose); roleMenuMapping.Active = item.Active; roleMenuMapping.RoleId = RoleId == 0 ? roleToDel : RoleId; roleMenuMapping.RoleIdText = RoleName; db.RoleMenuMappings.Add(roleMenuMapping); // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleMenuMapping"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(roleMenuMapping); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(roleMenuMapping)); }
public ActionResult UserUpdate(string ShowUserId, string ShowEmail, bool ShowActive, bool ShowPasswordReset, string UserCell) { if (string.IsNullOrEmpty(ShowEmail)) { foreach (char singleChar in ShowUserId) { if (Char.IsLetter(singleChar)) { ShowEmail += singleChar.ToString(); } } Random r = new Random(); ShowEmail = ShowEmail + "_" + r.Next(10000, 100000).ToString() + "@silverglobalfashion.com"; } string newPassword = ""; if (ShowPasswordReset) { newPassword = "******"; } using (var db = new ApplicationDbContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { UserMaster userMaster = db.UserMasters.Where(w => w.Name == ShowUserId).FirstOrDefault(); ApplicationUser appUser = db.Users.Where(w => w.UserName == ShowUserId).FirstOrDefault(); if (!string.IsNullOrEmpty(ShowEmail)) { appUser.Email = ShowEmail; } if (!string.IsNullOrEmpty(UserCell)) { userMaster.UserCell = UserCell; } if (ShowPasswordReset) { appUser.PasswordHash = newPassword; } userMaster.Active = ShowActive; UserMaster logUserMaster = new UserMaster(); logUserMaster.Active = userMaster.Active; logUserMaster.Id = userMaster.Id; logUserMaster.Name = userMaster.Name; logUserMaster.RoleId = userMaster.RoleId; logUserMaster.UserId = userMaster.UserId; logUserMaster.UserCell = userMaster.UserCell; // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "UserMaster"; logingInfoModel.TypeOfAction = TypeOfAction.Update; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(logUserMaster); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); LoginInfoModel logingInfoModelOne = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencialOne = new PopulateLoginInfoCredencial(logingInfoModelOne); logingInfoModelOne = populateLoginInfoCredencialOne.getLoginInfoCredencial(); if (!populateLoginInfoCredencialOne.ValidateIPv4(logingInfoModelOne.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModelOne.UsedModel = "ApplicationUser"; logingInfoModelOne.TypeOfAction = TypeOfAction.Update; logingInfoModelOne.Data = Newtonsoft.Json.JsonConvert.SerializeObject(appUser); logingInfoModelOne.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModelOne); db.Entry(userMaster).State = EntityState.Modified; db.Entry(appUser).State = EntityState.Modified; db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } return(RedirectToAction("Index")); }
public ActionResult Create(RoleBasedSignature roleBasedSignature, FormCollection collection, HttpPostedFileBase image) { MembershipHelp mHelp = new MembershipHelp(); var role = mHelp.logingUserRole(User.Identity.Name); var roleId = db.RoleMasters.Where(w => w.Name == role).Select(s => s.Id).FirstOrDefault(); var canCreate = (from m in db.MenuInfoes join rm in db.RoleMenuMappings on m.Id equals rm.MenuInfoId where m.MenuURL.Contains("RoleBasedSignatures") && rm.RoleId == roleId select rm.CanCreate).FirstOrDefault(); if (!canCreate) { return(RedirectToAction("Index")); } var roleBasedSignatueUpdate = db.RoleBasedSignatures.Where(w => w.RoleName == roleBasedSignature.RoleName).ToList(); foreach (var rbsu in roleBasedSignatueUpdate) { rbsu.IsAcive = false; db.Entry(rbsu).State = EntityState.Modified; db.SaveChanges(); } if (image != null) { //attach the uploaded image to the object before saving to Database roleBasedSignature.SignatureMimeType = image.ContentLength; roleBasedSignature.SignatureData = new byte[image.ContentLength]; image.InputStream.Read(roleBasedSignature.SignatureData, 0, image.ContentLength); // To Get the Max Id int countrbs = db.RoleBasedSignatures.Count(); int maxId = 0; if (countrbs > 0) { maxId = db.RoleBasedSignatures.Max(m => m.Id) + 1; } else { maxId = 1; } string FileWhole = image.FileName; string[] SplitFileWhole = FileWhole.Split('\\'); int LastPartOfFile = SplitFileWhole.Count() - 1; //Save image to file var filename = maxId.ToString() + "_" + roleBasedSignature.RoleName + "_" + SplitFileWhole[LastPartOfFile]; roleBasedSignature.FileAddressInfo = filename; var filePathOriginal = Server.MapPath("~/Content/Uploads/Originals"); var filePathThumbnail = Server.MapPath("~/Content/Uploads/Thumbnails"); string savedFileName = Path.Combine(filePathOriginal, filename); string UploadedfileExtension = Path.GetExtension(image.FileName); if (System.IO.File.Exists(savedFileName)) { System.IO.File.Delete(savedFileName); } image.SaveAs(savedFileName); // back up into external drive try { var ExDrive = db.TestCallls.Select(s => s.value).FirstOrDefault(); string externalLocationAddress = ExDrive + fileStoreCreateFolderName.getFolderName(); bool exists = System.IO.Directory.Exists(externalLocationAddress); if (!exists) { System.IO.Directory.CreateDirectory(externalLocationAddress); } string externalFileName = Path.Combine(externalLocationAddress, filename); bool fileExist = System.IO.File.Exists(externalFileName); if (fileExist) { Random r = new Random(); // Later to be indetified by the sequence which got start in between 900000 to 900100 string ExistExternalFileName = Path.Combine(externalLocationAddress, r.Next(900000, 900100).ToString() + "_" + filename); image.SaveAs(ExistExternalFileName); } else { string ExistExternalFileName = Path.Combine(externalLocationAddress, filename); image.SaveAs(ExistExternalFileName); } } catch (Exception ex) { } // back up into external drive roleBasedSignature.CreateTime = DateTime.Now; // Saving Longing Credential LoginInfoModel logingInfoModel = new LoginInfoModel(); PopulateLoginInfoCredencial populateLoginInfoCredencial = new PopulateLoginInfoCredencial(logingInfoModel); logingInfoModel = populateLoginInfoCredencial.getLoginInfoCredencial(); if (!populateLoginInfoCredencial.ValidateIPv4(logingInfoModel.LoginIp)) { return(RedirectToAction("Login", "Account")); } logingInfoModel.UsedModel = "RoleBasedSignature"; logingInfoModel.TypeOfAction = TypeOfAction.Insert; logingInfoModel.Data = Newtonsoft.Json.JsonConvert.SerializeObject(roleBasedSignature); logingInfoModel.SysDate = DateTime.Now; db.LoginInfoModels.Add(logingInfoModel); db.SaveChanges(); // Saving Longing Credential //Save model object to database db.RoleBasedSignatures.Add(roleBasedSignature); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(roleBasedSignature)); }