public int InsertOrganizationSubscription(OrganizationSubscription OrganizationSubscription) { //context.OrganizationSubscriptions.Add(OrganizationSubscription); SqlParameter[] Param = new SqlParameter[9]; Param[0] = new SqlParameter("@pOrganizationSubscriptionGUID", SqlDbType.UniqueIdentifier); Param[0].Value = OrganizationSubscription.OrganizationSubscriptionGUID; Param[1] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier); Param[1].Value = OrganizationSubscription.OrganizationGUID; Param[2] = new SqlParameter("@pVersion", SqlDbType.Int); Param[2].Value = OrganizationSubscription.Version; Param[3] = new SqlParameter("@pIsActive", SqlDbType.Bit); Param[3].Value = OrganizationSubscription.IsActive; Param[4] = new SqlParameter("@pSubscriptionPurchased", SqlDbType.Int); Param[4].Value = OrganizationSubscription.SubscriptionPurchased; Param[5] = new SqlParameter("@pSubscriptionConsumed", SqlDbType.Int); Param[5].Value = OrganizationSubscription.SubscriptionConsumed; Param[6] = new SqlParameter("@pStartDate", SqlDbType.DateTime); Param[6].Value = (object)OrganizationSubscription.StartDate ?? DBNull.Value; Param[7] = new SqlParameter("@pExpiryDate", SqlDbType.DateTime); Param[7].Value = (object)OrganizationSubscription.ExpiryDate ?? DBNull.Value; Param[8] = new SqlParameter("@pCreatedDate", SqlDbType.DateTime); Param[8].Value = (object)OrganizationSubscription.CreatedDate ?? DBNull.Value; return context.Database.ExecuteSqlCommand("insert into OrganizationSubscriptions(OrganizationSubscriptionGUID,OrganizationGUID,Version,IsActive,SubscriptionPurchased," + "SubscriptionConsumed,StartDate,ExpiryDate,CreatedDate)values(@pOrganizationSubscriptionGUID,@pOrganizationGUID,@pVersion,@pIsActive,@pSubscriptionPurchased," + "@pSubscriptionConsumed,@pStartDate,@pExpiryDate,@pCreatedDate)", Param); }
public ActionResult Edit(OrganizationSubscriptionView organizationSubscriptionView) { Logger.Debug("Inside Organization Subscription Controller- Edit HttpPost"); try { if (Session["OrganizationGUID"] != null) { OrganizationSubscription organizationSubscription = new OrganizationSubscription(); organizationSubscription.OrganizationSubscriptionGUID = new Guid(organizationSubscriptionView.OrganizationSubscriptionGUID); organizationSubscription.OrganizationGUID = new Guid(organizationSubscriptionView.OrganizationGUID); organizationSubscription.IsActive = organizationSubscriptionView.IsActive; organizationSubscription.Version = organizationSubscriptionView.Version; organizationSubscription.SubscriptionPurchased = organizationSubscriptionView.SubscriptionPurchased; organizationSubscription.SubscriptionConsumed = organizationSubscriptionView.SubscriptionConsumed; // organizationSubscription.StartDate = organizationSubscriptionView.StartDate; organizationSubscription.ExpiryDate = Convert.ToDateTime(organizationSubscriptionView.ExpiryDate); //organizationSubscription.CreatedDate = organizationSubscriptionView.CreatedDate; int result = _IOrganizationSubscriptionRepository.UpdateOrganizationSubscription(organizationSubscription); //int result = _IOrganizationSubscriptionRepository.Save(); if (result > 0) return RedirectToAction("../Organization/Index"); else return View(); } else { return RedirectToAction("SessionTimeOut", "User"); } } catch (Exception ex) { Logger.Error(ex.Message); return RedirectToAction("../User/Login"); } }
public ActionResult Create(OrganizationView organization) { Logger.Debug("Inside Organization Controller- Create HttpPost"); try { if (ModelState.IsValid) { if (_IOrganizationRepository.GetOrganizationByID(organization.OrganizationGUID) == null) { Organization Organization = new Organization(); Organization.OrganizationFullName = organization.OrganizationFullName; Organization.OrganizationName = organization.OrganizationFullName.Trim(); Organization.OrganizationGUID = Guid.NewGuid(); Organization.Website = organization.Website; Organization.Phone = organization.Phone; Organization.AddressLine1 = organization.AddressLine1; Organization.AddressLine2 = organization.AddressLine2; Organization.City = organization.City; Organization.Country = organization.Country; Organization.ZipCode = organization.ZipCode; LatLong latLong = new LatLong(); latLong = GetLatLngCode(Organization.AddressLine1, Organization.AddressLine2, Organization.City, Organization.State, Organization.Country, Organization.ZipCode); Organization.TimeZone = Convert.ToDouble(getTimeZone(latLong.Latitude, latLong.Longitude)); Organization.Latitude = latLong.Latitude; Organization.Longitude = latLong.Longitude; Organization.EmailID = organization.EmailID; Organization.State = organization.State; Organization.IsActive = false; Organization.IsDeleted = false; Organization.AllowContractors = true; Organization.ImageURL = organization.ImageURL; Organization.CreateDate = DateTime.UtcNow; if (Session["UserGUID"] != null) Organization.CreateBy = new Guid(Session["UserGUID"].ToString()); Organization.LastModifiedDate = DateTime.UtcNow; if (Session["UserGUID"] != null) Organization.LastModifiedBy = new Guid(Session["UserGUID"].ToString()); //Group Group = new Group(); //Group.GroupGUID = Guid.NewGuid(); //Group.Name = "Default"; //Group.Description = "Default"; //Group.OrganizationGUID = Organization.OrganizationGUID; //Group.IsDefault = false; Region Region = new Region(); Region.RegionGUID = Guid.NewGuid(); Region.Name = "Default"; Region.Description = "Default"; if (Organization.OrganizationGUID != Guid.Empty) { Region.OrganizationGUID = Organization.OrganizationGUID; } else { Region.OrganizationGUID = null; } Region.IsDefault = false; Territory Territory = new Territory(); Territory.TerritoryGUID = Guid.NewGuid(); if (Territory.RegionGUID != Guid.Empty) { Territory.RegionGUID = Territory.RegionGUID; } else { Territory.RegionGUID = null; } Territory.Name = "Default"; Territory.Description = "Default"; if (Organization.OrganizationGUID != Guid.Empty) { Territory.OrganizationGUID = Organization.OrganizationGUID; } else { Territory.OrganizationGUID = null; } Territory.IsDefault = false; GlobalUser globalUser = new GlobalUser(); globalUser.UserGUID = Guid.NewGuid(); globalUser.USERID = organization.UserID; globalUser.UserName = organization.UserName; globalUser.Password = _IUserRepository.EncodeTo64(organization.Password); globalUser.IsActive = true; globalUser.IsDelete = false; globalUser.Latitude = latLong.Latitude; globalUser.Longitude = latLong.Longitude; globalUser.Role_Id = _IGlobalUserRepository.GetOrganizationAdminRoleID(); globalUser.CreateDate = DateTime.UtcNow; if (Session["UserGUID"] != null) globalUser.CreateBy = new Guid(Session["UserGUID"].ToString()); globalUser.LastModifiedDate = DateTime.UtcNow; if (Session["UserGUID"] != null) globalUser.LastModifiedBy = new Guid(Session["UserGUID"].ToString()); UserProfile userprofile = new UserProfile(); userprofile.ProfileGUID = Guid.NewGuid(); userprofile.UserGUID = globalUser.UserGUID; userprofile.CompanyName = Organization.OrganizationFullName; userprofile.FirstName = organization.FirstName; userprofile.LastName = organization.LastName; userprofile.MobilePhone = ""; userprofile.BusinessPhone = organization.Phone; userprofile.HomePhone = ""; userprofile.EmailID = organization.EmailID; userprofile.AddressLine1 = organization.AddressLine1; userprofile.AddressLine2 = organization.AddressLine2; userprofile.City = organization.City; userprofile.State = organization.State; userprofile.Country = organization.Country; userprofile.Latitude = latLong.Latitude; userprofile.Longitude = latLong.Longitude; userprofile.ZipCode = organization.ZipCode; userprofile.IsDeleted = false; userprofile.PicFileURL = Organization.ImageURL; userprofile.LastModifiedDate = DateTime.UtcNow; if (Session["UserGUID"] != null) userprofile.LastModifiedBy = new Guid(Session["UserGUID"].ToString()); userprofile.CompanyName = Organization.OrganizationName; AspNetUser aspnetuser = new AspNetUser(); aspnetuser.Id = globalUser.UserGUID.ToString(); aspnetuser.UserName = organization.UserName; aspnetuser.FirstName = organization.FirstName; aspnetuser.LastName = organization.LastName; aspnetuser.PasswordHash = _IUserRepository.EncodeTo64(organization.Password); aspnetuser.PhoneNumber = organization.Phone; aspnetuser.EmailID = organization.EmailID; if (Organization.OrganizationGUID != Guid.Empty) { aspnetuser.OrganizationGUID = Organization.OrganizationGUID; } else { aspnetuser.OrganizationGUID = null; } aspnetuser.SecurityStamp = ""; aspnetuser.Discriminator = ""; OrganizationSubscription organizationSubscription = new OrganizationSubscription(); organizationSubscription.OrganizationSubscriptionGUID = Guid.NewGuid(); organizationSubscription.OrganizationGUID = Organization.OrganizationGUID; organizationSubscription.IsActive = true; organizationSubscription.Version = 1; organizationSubscription.SubscriptionPurchased = 100; organizationSubscription.SubscriptionConsumed = 1; organizationSubscription.StartDate = DateTime.UtcNow; organizationSubscription.ExpiryDate = DateTime.UtcNow.AddDays(30); organizationSubscription.CreatedDate = DateTime.UtcNow; UserSubscription userSubscription = new UserSubscription(); userSubscription.UserSubscriptionGUID = Guid.NewGuid(); userSubscription.UserGUID = globalUser.UserGUID; if (organizationSubscription.OrganizationSubscriptionGUID != Guid.Empty) { userSubscription.OrganizationSubscriptionGUID = organizationSubscription.OrganizationSubscriptionGUID; } else { userSubscription.OrganizationSubscriptionGUID = null; } userSubscription.IsActive = true; userSubscription.CreatedDate = DateTime.UtcNow; Market Market = new Market(); Market.MarketGUID = Guid.NewGuid(); Market.IsDefault = true; if (globalUser.UserGUID != Guid.Empty) { Market.UserGUID = globalUser.UserGUID; } else { Market.UserGUID = null; } Market.EntityType = 0; if (Organization.OrganizationGUID != Guid.Empty) { Market.OrganizationGUID = Organization.OrganizationGUID; } else { Market.OrganizationGUID = null; } if (Organization.OrganizationGUID != Guid.Empty) { Market.OwnerGUID = Organization.OrganizationGUID; } else { Market.OwnerGUID = null; } Market.MarketName = Organization.OrganizationFullName; if (Region.RegionGUID != Guid.Empty) { Market.RegionGUID = Region.RegionGUID; } else { Market.RegionGUID = null; } if (Territory.TerritoryGUID != Guid.Empty) { Market.TerritoryGUID = Territory.TerritoryGUID; } else { Market.TerritoryGUID = null; } if (globalUser.UserGUID != Guid.Empty) { Market.PrimaryContactGUID = globalUser.UserGUID; } else { Market.PrimaryContactGUID = null; } Market.FirstName = organization.FirstName; Market.LastName = organization.LastName; Market.MobilePhone = ""; Market.MarketPhone = organization.Phone; Market.HomePhone = ""; Market.Emails = organization.EmailID; Market.TimeZone = Organization.TimeZone.ToString(); Market.AddressLine1 = organization.AddressLine1; Market.AddressLine2 = organization.AddressLine2; Market.City = organization.City; Market.State = organization.State; Market.Country = organization.Country; Market.ZipCode = organization.ZipCode; Market.Latitude = latLong.Latitude; Market.Longitude = latLong.Longitude; Market.ImageURL = organization.ImageURL; Market.IsDeleted = false; Market.CreateDate = DateTime.UtcNow; Market.UpdatedDate = DateTime.UtcNow; OrganizationUsersMap organizationUserMap = new OrganizationUsersMap(); organizationUserMap.OrganizationUserMapGUID = Guid.NewGuid(); organizationUserMap.OrganizationGUID = Organization.OrganizationGUID; organizationUserMap.UserGUID = globalUser.UserGUID; organizationUserMap.IsContractor = false; organizationUserMap.IsActive = true; organizationUserMap.Status = 0; if (Region.RegionGUID != Guid.Empty) { organizationUserMap.RegionGUID = Region.RegionGUID; } else { organizationUserMap.RegionGUID = null; } if (Territory.TerritoryGUID != Guid.Empty) { organizationUserMap.TerritoryGUID = Territory.TerritoryGUID; } else { organizationUserMap.TerritoryGUID = null; } organizationUserMap.UserType = "ENT_A"; organizationUserMap.CreateDate = DateTime.UtcNow; if (Session["UserGUID"] != null) organizationUserMap.CreateBy = new Guid(Session["UserGUID"].ToString()); organizationUserMap.LastModifiedDate = DateTime.UtcNow; if (Session["UserGUID"] != null) organizationUserMap.LastModifiedBy = new Guid(Session["UserGUID"].ToString()); int result = _IOrganizationRepository.InsertOrganization(Organization); // int result = _IOrganizationRepository.Save(); if (result > 0) { _IOrganizationSubscriptionRepository.InsertOrganizationSubscription(organizationSubscription); //_IOrganizationSubscriptionRepository.Save(); //_IGroupRepository.InsertGroup(Group); //_IGroupRepository.Save(); _IRegionRepository.InsertRegion(Region); //_IRegionRepository.Save(); _ITerritoryRepository.InsertTerritory(Territory); // _ITerritoryRepository.Save(); int userresult = _IUserRepository.InsertUser(aspnetuser); // int userresult = _IUserRepository.Save(); if (userresult > 0) { int guresult = _IGlobalUserRepository.InsertGlobalUser(globalUser); //int guresult = _IGlobalUserRepository.Save(); if (guresult > 0) { int OrgUserMap = _IOrganizationRepository.InsertOrganizationUserMap(organizationUserMap); //int OrgUserMap = _IOrganizationRepository.Save(); if (OrgUserMap > 0) { int usrresult = _IUserProfileRepository.InsertUserProfile(userprofile); //int usrresult = _IUserProfileRepository.Save(); if (usrresult > 0) { int usubresult = _IUserSubscriptionRepository.InsertUserSubscription(userSubscription); //int usubresult = _IUserSubscriptionRepository.Save(); if (usubresult > 0) { int marketresult = _IMarketRepository.InsertMarket(Market); //int marketresult = _IMarketRepository.Save(); if (marketresult > 0) { if (Session["UserType"] != null && Session["UserType"].ToString() == "WIM_A") { TempData["msg"] = "<script>ModalPopupsAlert('Workers-In-Motion','Organization Created Successfully');</script>"; return RedirectToAction("Index", "Organization"); } else { TempData["msg"] = "<script>ModalPopupsAlert('Workers-In-Motion','Organization Created Successfully');</script>"; return RedirectToAction("../User/Login"); } } else { _IUserSubscriptionRepository.DeleteUserSubscription(userSubscription.UserSubscriptionGUID); //_IUserSubscriptionRepository.Save(); //_IGroupRepository.DeleteGroup(Group.GroupGUID); //_IGroupRepository.Save(); _ITerritoryRepository.DeleteTerritoryByRegionGUID(Region.RegionGUID); //_ITerritoryRepository.Save(); _IRegionRepository.DeleteRegion(Region.RegionGUID); //_IRegionRepository.Save(); _IUserSubscriptionRepository.DeleteUserSubscription(userSubscription.UserSubscriptionGUID); //_IUserSubscriptionRepository.Save(); _IUserProfileRepository.DeleteUserProfile(userprofile.ProfileGUID); //_IUserProfileRepository.Save(); _IGlobalUserRepository.DeleteGlobalUser(globalUser.UserGUID); //_IGlobalUserRepository.Save(); _IUserRepository.DeleteUser(aspnetuser.Id); // _IUserRepository.Save(); } } else { //_IGroupRepository.DeleteGroup(Group.GroupGUID); //_IGroupRepository.Save(); _ITerritoryRepository.DeleteTerritoryByRegionGUID(Region.RegionGUID); //_ITerritoryRepository.Save(); _IRegionRepository.DeleteRegion(Region.RegionGUID); // _IRegionRepository.Save(); _IUserSubscriptionRepository.DeleteUserSubscription(userSubscription.UserSubscriptionGUID); //_IUserSubscriptionRepository.Save(); _IUserProfileRepository.DeleteUserProfile(userprofile.ProfileGUID); //_IUserProfileRepository.Save(); _IGlobalUserRepository.DeleteGlobalUser(globalUser.UserGUID); //_IGlobalUserRepository.Save(); _IUserRepository.DeleteUser(aspnetuser.Id); //_IUserRepository.Save(); _IOrganizationSubscriptionRepository.DeleteOrganizationSubscription(organizationSubscription.OrganizationSubscriptionGUID); //_IOrganizationSubscriptionRepository.Save(); //_IUserSubscriptionRepository.Save(); _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); //_IOrganizationRepository.Save(); } } else { _IOrganizationRepository.DeleteOrganizationUserMap(organizationUserMap.OrganizationUserMapGUID); //_IOrganizationRepository.Save(); _ITerritoryRepository.DeleteTerritoryByRegionGUID(Region.RegionGUID); //_ITerritoryRepository.Save(); _IRegionRepository.DeleteRegion(Region.RegionGUID); //_IRegionRepository.Save(); _IUserSubscriptionRepository.DeleteUserSubscription(userSubscription.UserSubscriptionGUID); //_IUserSubscriptionRepository.Save(); _IUserProfileRepository.DeleteUserProfile(userprofile.ProfileGUID); //_IUserProfileRepository.Save(); _IGlobalUserRepository.DeleteGlobalUser(globalUser.UserGUID); //_IGlobalUserRepository.Save(); _IUserRepository.DeleteUser(aspnetuser.Id); //_IUserRepository.Save(); _IOrganizationSubscriptionRepository.DeleteOrganizationSubscription(organizationSubscription.OrganizationSubscriptionGUID); //_IOrganizationSubscriptionRepository.Save(); //_IUserSubscriptionRepository.Save(); _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); //_IOrganizationRepository.Save(); } } else { //_IGroupRepository.DeleteGroup(Group.GroupGUID); //_IGroupRepository.Save(); _ITerritoryRepository.DeleteTerritoryByRegionGUID(Region.RegionGUID); //_ITerritoryRepository.Save(); _IRegionRepository.DeleteRegion(Region.RegionGUID); // _IRegionRepository.Save(); _IUserSubscriptionRepository.DeleteUserSubscription(userSubscription.UserSubscriptionGUID); //_IUserSubscriptionRepository.Save(); _IUserProfileRepository.DeleteUserProfile(userprofile.ProfileGUID); // _IUserProfileRepository.Save(); _IGlobalUserRepository.DeleteGlobalUser(globalUser.UserGUID); //_IGlobalUserRepository.Save(); _IUserRepository.DeleteUser(aspnetuser.Id); //_IUserRepository.Save(); _IOrganizationSubscriptionRepository.DeleteOrganizationSubscription(organizationSubscription.OrganizationSubscriptionGUID); //_IOrganizationSubscriptionRepository.Save(); //_IUserSubscriptionRepository.Save(); _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); //_IOrganizationRepository.Save(); } } else { _IGlobalUserRepository.DeleteGlobalUser(globalUser.UserGUID); //_IGlobalUserRepository.Save(); _IUserRepository.DeleteUser(aspnetuser.Id); // _IUserRepository.Save(); _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); //_IOrganizationRepository.Save(); } } else { _IUserRepository.DeleteUser(aspnetuser.Id); // _IUserRepository.Save(); _IOrganizationSubscriptionRepository.DeleteOrganizationSubscription(organizationSubscription.OrganizationSubscriptionGUID); //_IOrganizationSubscriptionRepository.Save(); _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); // _IOrganizationRepository.Save(); } } else { _IOrganizationRepository.DeleteOrganization(Organization.OrganizationGUID); //_IOrganizationRepository.Save(); } } else { //UserName already exists TempData["msg"] = "<script>ModalPopupsAlert('Workers-In-Motion','Organization Name is Aleady Exists');</script>"; } } return View(organization); } catch (Exception ex) { Logger.Error(ex.Message); return View(organization); } }
public ActionResult Index(string id = "") { Logger.Debug("Inside User Controller- Index"); try { if (Session["OrganizationGUID"] != null) { var userList = new AspNetUserViewModel(); userList.Users = new List<AspUser>(); var appUser = new List<UserProfile>(); if (string.IsNullOrEmpty(id)) { appUser = _IUserProfileRepository.GetUserProfilesbyOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).OrderBy(sort => sort.FirstName).ToList(); } else { appUser = _IUserProfileRepository.GetUserProfilesbyOrganizationGUID(new Guid(id)).OrderBy(sort => sort.FirstName).ToList(); } foreach (var user in appUser.ToList()) { UserSubscription userSubscription = _IUserSubscriptionRepository.GetUserSubscriptionByUserID(user.UserGUID); GlobalUser _globalUser = _IGlobalUserRepository.GetGlobalUserByID(user.UserGUID); string Regionname = string.Empty; string Territoryname = string.Empty; string Groupname = string.Empty; string userType = string.Empty; if (_globalUser != null) { OrganizationUsersMap _orgUserMap = _IOrganizationRepository.GetOrganizationUserMapByUserGUID(user.UserGUID); if (_orgUserMap != null && _orgUserMap.RegionGUID != null) { Regionname = _IRegionRepository.GetRegionNameByRegionGUID(new Guid(_orgUserMap.RegionGUID.ToString())); } else { Regionname = ""; } if (_orgUserMap != null && _orgUserMap.TerritoryGUID != null) { Territoryname = _ITerritoryRepository.GetTerritoryNameByTerritoryGUID(new Guid(_orgUserMap.TerritoryGUID.ToString())); } else { Territoryname = ""; } // Groupname = _IGroupRepository.GetGroupNameByGroupGUID(new Guid(_globalUser.GroupGUID.ToString())); userType = _IGlobalUserRepository.GetUserTypeByRoleID(_globalUser.Role_Id); } string UserTypeName = _IGlobalUserRepository.GetUserRoleName(user.UserGUID); if (userSubscription != null) userList.Users.Add(new AspUser { UserTypeName = UserTypeName, RegionName = Regionname, TerritoryName = Territoryname, GroupName = Groupname, OrganizationSubscriptionGUID = userSubscription.OrganizationSubscriptionGUID.ToString(), UserType = userType, IsActive = userSubscription.IsActive, SubscriptionGUID = userSubscription.UserSubscriptionGUID.ToString(), FirstName = user.FirstName, LastName = user.LastName, Id = user.UserGUID.ToString(), EmailID = user.EmailID, MobilePhone = user.MobilePhone, City = user.City, State = user.State, Country = user.Country }); } userList.Users = userList.Users.OrderBy(sort => sort.FirstName).ToList(); DropdownValues(); OrganizationSubscription orgSubscription = new OrganizationSubscription(); if (Session["UserType"] != null && Session["UserType"].ToString() != "WIM_A") { if (string.IsNullOrEmpty(id)) { orgSubscription = _IOrganizationSubscriptionRepository.GetOrganizationSubscriptionByOrgID(new Guid(Session["OrganizationGUID"].ToString())); } else { orgSubscription = _IOrganizationSubscriptionRepository.GetOrganizationSubscriptionByOrgID(new Guid(id)); } if (orgSubscription != null) { ViewBag.EnableCreateUserButton = "true"; } //if (orgSubscription != null && orgSubscription.SubscriptionPurchased > orgSubscription.SubscriptionConsumed) //{ // ViewBag.EnableCreateUserButton = "true"; //} //else //{ // ViewBag.EnableCreateUserButton = "false"; //} } else { ViewBag.EnableCreateUserButton = "false"; } return View(userList.Users.AsEnumerable()); } else { return RedirectToAction("SessionTimeOut", "User"); } } catch (Exception ex) { Logger.Error(ex.Message); return RedirectToAction("Login", "User"); } }
//public UserController(WorkersInMotionJobContext context) //{ // // this._IJobRepository = new JobRepository(context); //} #endregion public ActionResult Index(string id = "", string regionguid = "", string selection = "") { Logger.Debug("Inside User Controller- Index"); try { if (Session["OrganizationGUID"] != null) { if (!string.IsNullOrEmpty(id)) { TempData["TabName"] = id; } else { TempData["TabName"] = "Details"; } mycompany pmycompany = new mycompany(); pmycompany.OrganizationEditView = new OrganizationEditView(); pmycompany.AspNetUserViewModel = new AspNetUserViewModel(); pmycompany.TerritoryViewModel = new TerritoryViewModel(); pmycompany.RegionViewModel = new RegionViewModel(); //switch (id) //{ // case "Users": // ViewBag.TabName = "Users"; var userList = new AspNetUserViewModel(); userList.Users = new List<AspUser>(); var appUser = new List<UserProfile>(); appUser = _IUserProfileRepository.GetUserProfilesbyOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).OrderBy(sort => sort.FirstName).ToList(); foreach (var user in appUser.ToList()) { UserSubscription userSubscription = _IUserSubscriptionRepository.GetUserSubscriptionByUserID(user.UserGUID); GlobalUser _globalUser = _IGlobalUserRepository.GetGlobalUserByID(user.UserGUID); string Regionname = string.Empty; string Territoryname = string.Empty; string Groupname = string.Empty; string userType = string.Empty; if (_globalUser != null) { OrganizationUsersMap _orgUserMap = _IOrganizationRepository.GetOrganizationUserMapByUserGUID(user.UserGUID); if (_orgUserMap != null && _orgUserMap.RegionGUID != null) { Regionname = _IRegionRepository.GetRegionNameByRegionGUID(new Guid(_orgUserMap.RegionGUID.ToString())); } else { Regionname = ""; } if (_orgUserMap != null && _orgUserMap.TerritoryGUID != null) { Territoryname = _ITerritoryRepository.GetTerritoryNameByTerritoryGUID(new Guid(_orgUserMap.TerritoryGUID.ToString())); } else { Territoryname = ""; } // Groupname = _IGroupRepository.GetGroupNameByGroupGUID(new Guid(_globalUser.GroupGUID.ToString())); userType = _IGlobalUserRepository.GetUserTypeByRoleID(_globalUser.Role_Id); } string UserTypeName = _IGlobalUserRepository.GetUserRoleName(user.UserGUID); if (userSubscription != null) userList.Users.Add(new AspUser { UserTypeName = UserTypeName, RegionName = Regionname, TerritoryName = Territoryname, GroupName = Groupname, OrganizationSubscriptionGUID = userSubscription.OrganizationSubscriptionGUID.ToString(), UserType = userType, IsActive = userSubscription.IsActive, SubscriptionGUID = userSubscription.UserSubscriptionGUID.ToString(), FirstName = user.FirstName, LastName = user.LastName, Id = user.UserGUID.ToString(), EmailID = user.EmailID, MobilePhone = user.MobilePhone, City = user.City, State = user.State, Country = user.Country }); } OrganizationSubscription orgSubscription = new OrganizationSubscription(); if (Session["UserType"] != null && Session["UserType"].ToString() != "WIM_A") { orgSubscription = _IOrganizationSubscriptionRepository.GetOrganizationSubscriptionByOrgID(new Guid(Session["OrganizationGUID"].ToString())); if (orgSubscription != null) { ViewBag.EnableCreateUserButton = "true"; } else { ViewBag.EnableCreateUserButton = "false"; } //if (orgSubscription != null && orgSubscription.SubscriptionPurchased > orgSubscription.SubscriptionConsumed) //{ // ViewBag.EnableCreateUserButton = "true"; //} //else //{ // ViewBag.EnableCreateUserButton = "false"; //} } else { ViewBag.EnableCreateUserButton = "false"; } pmycompany.AspNetUserViewModel = userList; // break; //case "Region": // ViewBag.TabName = "Regions"; var territoryList = new TerritoryViewModel(); territoryList.Territory = new List<TerritoryModel>(); List<Territory> appTerritory = new List<Territory>(); if (!string.IsNullOrEmpty(regionguid) && regionguid != Guid.Empty.ToString()) { appTerritory = _ITerritoryRepository.GetTerritoryByRegionGUID(new Guid(regionguid)).ToList(); TempData["TabName"] = "Markets"; ViewBag.AddTerritory = "true"; ViewBag.Id = regionguid; } else { appTerritory = _ITerritoryRepository.GetTerritoryByOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).ToList(); } foreach (var territory in appTerritory.ToList()) { territoryList.Territory.Add(new TerritoryModel { Name = territory.Name, TerritoryGUID = territory.TerritoryGUID.ToString(), RegionGUID = territory.RegionGUID != null ? territory.RegionGUID.ToString() : Guid.Empty.ToString(), Description = territory.Description, OrganizationGUID = territory.OrganizationGUID != null ? territory.OrganizationGUID.ToString() : Guid.Empty.ToString() }); } StringBuilder sb = new StringBuilder(); sb.Append("<div class='actions'>"); sb.Append("<div class='btn-group'>"); if (!string.IsNullOrEmpty(regionguid) && regionguid != Guid.Empty.ToString()) { sb.Append("<a href='#' id='ulaworkergroup' class='btn green' data-toggle='dropdown'><i class='icon-map-marker'></i> " + _IRegionRepository.GetRegionNameByRegionGUID(new Guid(regionguid)) + " <i class='icon-angle-down'></i></a>"); } else { if (!string.IsNullOrEmpty(selection) && selection == "All") { sb.Append("<a href='#' id='ulaworkergroup' class='btn green' data-toggle='dropdown'><i class='icon-map-marker'></i>All<i class='icon-angle-down'></i></a>"); } else { sb.Append("<a href='#' id='ulaworkergroup' class='btn green' data-toggle='dropdown'><i class='icon-map-marker'></i> Select Region <i class='icon-angle-down'></i></a>"); } } sb.Append("<ul id='ulworkgroup' style='height:100px;overflow-y:scroll' class='dropdown-menu pull-right'>"); if (string.IsNullOrEmpty(selection) || selection != "All") { sb.Append("<li><a href=" + Url.Action("Index", "MyCompany", new { id = "Markets", selection = "All" }) + ">All</a></li>"); } List<Region> RegList = _IRegionRepository.GetRegionByOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).ToList(); foreach (Region item in RegList) { sb.Append("<li><a href=" + Url.Action("Index", "MyCompany", new { regionguid = item.RegionGUID.ToString() }) + " data-groupguid=" + item.RegionGUID + ">" + item.Name + "</a></li>"); } sb.Append("</ul>"); sb.Append("</div>"); sb.Append("</div>"); ViewBag.RegionList = sb.ToString(); pmycompany.TerritoryViewModel = territoryList; // break; //case "Territory": // ViewBag.TabName = "Territories"; var regionList = new RegionViewModel(); regionList.Region = new List<RegionModel>(); var appRegion = _IRegionRepository.GetRegionByOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).ToList(); foreach (var region in appRegion.ToList()) { regionList.Region.Add(new RegionModel { Name = region.Name, RegionGUID = region.RegionGUID.ToString(), Description = region.Description, OrganizationGUID = region.OrganizationGUID != null ? region.OrganizationGUID.ToString() : Guid.Empty.ToString() }); } pmycompany.RegionViewModel = regionList; // break; //case "Organization": // ViewBag.TabName = "Details"; OrganizationEditView organization = new OrganizationEditView(); organization.OrganizationGUID = new Guid(Session["OrganizationGUID"].ToString()); Organization Organization = _IOrganizationRepository.GetOrganizationByID(organization.OrganizationGUID); if (organization != null) { organization.OrganizationFullName = Organization.OrganizationFullName; organization.OrganizationName = Organization.OrganizationFullName.Trim(); organization.OrganizationGUID = Organization.OrganizationGUID; organization.Website = Organization.Website; organization.Phone = Organization.Phone; organization.TimeZone = Organization.TimeZone.ToString(); organization.AddressLine1 = Organization.AddressLine1; organization.AddressLine2 = Organization.AddressLine2; organization.ImageURL = Organization.ImageURL; organization.City = Organization.City; organization.Country = Organization.Country; organization.State = Organization.State; organization.ZipCode = Organization.ZipCode; organization.EmailID = Organization.EmailID; organization.IsActive = Organization.IsActive; organization.IsDeleted = Organization.IsDeleted; organization.CreatedDate = Organization.CreateDate; organization.CreateBy = Organization.CreateBy; pmycompany.OrganizationEditView = organization; } // break; //default: // ViewBag.TabName = "Details"; // OrganizationEditView porganization = new OrganizationEditView(); // porganization.OrganizationGUID = new Guid(Session["OrganizationGUID"].ToString()); // Organization pOrganization = _IOrganizationRepository.GetOrganizationByID(porganization.OrganizationGUID); // if (porganization != null) // { // porganization.OrganizationFullName = pOrganization.OrganizationFullName; // porganization.OrganizationName = pOrganization.OrganizationFullName.Trim(); // porganization.OrganizationGUID = pOrganization.OrganizationGUID; // porganization.Website = pOrganization.Website; // porganization.Phone = pOrganization.Phone; // porganization.TimeZone = pOrganization.TimeZone.ToString(); // porganization.AddressLine1 = pOrganization.AddressLine1; // porganization.AddressLine2 = pOrganization.AddressLine2; // porganization.ImageURL = pOrganization.ImageURL; // porganization.City = pOrganization.City; // porganization.Country = pOrganization.Country; // porganization.State = pOrganization.State; // porganization.ZipCode = pOrganization.ZipCode; // porganization.EmailID = pOrganization.EmailID; // porganization.IsActive = pOrganization.IsActive; // porganization.IsDeleted = pOrganization.IsDeleted; // porganization.CreatedDate = pOrganization.CreateDate; // porganization.CreateBy = pOrganization.CreateBy; // pmycompany.OrganizationEditView.Add(porganization); // } // break; // } return View(pmycompany); } else { return RedirectToAction("SessionTimeOut", "User"); } } catch (Exception ex) { Logger.Error(ex.Message); return RedirectToAction("Login", "User"); } }
private AspNetUserViewModel UserDetails() { #region UserDetails try { var userList = new AspNetUserViewModel(); userList.Users = new List<AspUser>(); var appUser = new List<UserProfile>(); appUser = _IUserProfileRepository.GetUserProfilesbyOrganizationGUID(new Guid(Session["OrganizationGUID"].ToString())).OrderBy(sort => sort.FirstName).ToList(); foreach (var user in appUser.ToList()) { UserSubscription userSubscription = _IUserSubscriptionRepository.GetUserSubscriptionByUserID(user.UserGUID); GlobalUser _globalUser = _IGlobalUserRepository.GetGlobalUserByID(user.UserGUID); string Regionname = string.Empty; string Territoryname = string.Empty; string Groupname = string.Empty; string userType = string.Empty; if (_globalUser != null) { OrganizationUsersMap _orgUserMap = _IOrganizationRepository.GetOrganizationUserMapByUserGUID(user.UserGUID); if (_orgUserMap != null && _orgUserMap.RegionGUID != null) { Regionname = _IRegionRepository.GetRegionNameByRegionGUID(new Guid(_orgUserMap.RegionGUID.ToString())); } else { Regionname = ""; } if (_orgUserMap != null && _orgUserMap.TerritoryGUID != null) { Territoryname = _ITerritoryRepository.GetTerritoryNameByTerritoryGUID(new Guid(_orgUserMap.TerritoryGUID.ToString())); } else { Territoryname = ""; } //Regionname = _IRegionRepository.GetRegionNameByRegionGUID(new Guid(_IOrganizationRepository.GetOrganizationUserMapByUserGUID(user.UserGUID).RegionGUID.ToString())); //Territoryname = _ITerritoryRepository.GetTerritoryNameByTerritoryGUID(new Guid(_IOrganizationRepository.GetOrganizationUserMapByUserGUID(user.UserGUID).TerritoryGUID.ToString())); userType = _IGlobalUserRepository.GetUserTypeByRoleID(_globalUser.Role_Id); } string UserTypeName = _IGlobalUserRepository.GetUserRoleName(user.UserGUID); if (userSubscription != null) userList.Users.Add(new AspUser { UserTypeName = UserTypeName, RegionName = Regionname, TerritoryName = Territoryname, GroupName = Groupname, OrganizationSubscriptionGUID = userSubscription.OrganizationSubscriptionGUID.ToString(), UserType = userType, IsActive = userSubscription.IsActive, SubscriptionGUID = userSubscription.UserSubscriptionGUID.ToString(), FirstName = user.FirstName, LastName = user.LastName, Id = user.UserGUID.ToString(), EmailID = user.EmailID, MobilePhone = user.MobilePhone, City = user.City, State = user.State, Country = user.Country }); } OrganizationSubscription orgSubscription = new OrganizationSubscription(); if (Session["UserType"] != null && Session["UserType"].ToString() != "WIM_A") { orgSubscription = _IOrganizationSubscriptionRepository.GetOrganizationSubscriptionByOrgID(new Guid(Session["OrganizationGUID"].ToString())); if (orgSubscription != null) { ViewBag.EnableCreateUserButton = "true"; } else { ViewBag.EnableCreateUserButton = "false"; } //if (orgSubscription != null && orgSubscription.SubscriptionPurchased > orgSubscription.SubscriptionConsumed) //{ // ViewBag.EnableCreateUserButton = "true"; //} //else //{ // ViewBag.EnableCreateUserButton = "false"; //} } else { ViewBag.EnableCreateUserButton = "false"; } return userList; } catch (Exception ex) { Logger.Error(ex.Message); return null; } #endregion }
public int UpdateOrganizationSubscriptionCount(OrganizationSubscription OrganizationSubscription) { //using (var dataContext = new WorkersInMotionDB()) //{ // var qry = from p in dataContext.OrganizationSubscriptions where p.OrganizationSubscriptionGUID == OrganizationSubscription.OrganizationSubscriptionGUID select p; // var item = qry.Single(); // item.SubscriptionConsumed = item.SubscriptionConsumed + 1; // return dataContext.SaveChanges(); //} SqlParameter[] Param = new SqlParameter[2]; Param[0] = new SqlParameter("@pSubscriptionConsumed", SqlDbType.Int); Param[0].Value = OrganizationSubscription.SubscriptionConsumed + 1; Param[1] = new SqlParameter("@pOrganizationSubscriptionGUID", SqlDbType.UniqueIdentifier); Param[1].Value = OrganizationSubscription.OrganizationSubscriptionGUID; return context.Database.ExecuteSqlCommand("Update OrganizationSubscriptions set SubscriptionConsumed=@pSubscriptionConsumed where OrganizationSubscriptionGUID=@pOrganizationSubscriptionGUID", Param); }
public int UpdateOrganizationSubscription(OrganizationSubscription OrganizationSubscription) { // context.Entry(OrganizationSubscription).State = EntityState.Modified; SqlParameter[] Param = new SqlParameter[9]; Param[0] = new SqlParameter("@pOrganizationSubscriptionGUID", SqlDbType.UniqueIdentifier); Param[0].Value = OrganizationSubscription.OrganizationSubscriptionGUID; Param[1] = new SqlParameter("@pOrganizationGUID", SqlDbType.UniqueIdentifier); Param[1].Value = OrganizationSubscription.OrganizationGUID; Param[2] = new SqlParameter("@pVersion", SqlDbType.Int); Param[2].Value = OrganizationSubscription.Version; Param[3] = new SqlParameter("@pIsActive", SqlDbType.Bit); Param[3].Value = OrganizationSubscription.IsActive; Param[4] = new SqlParameter("@pSubscriptionPurchased", SqlDbType.Int); Param[4].Value = OrganizationSubscription.SubscriptionPurchased; Param[5] = new SqlParameter("@pSubscriptionConsumed", SqlDbType.Int); Param[5].Value = OrganizationSubscription.SubscriptionConsumed; Param[6] = new SqlParameter("@pStartDate", SqlDbType.DateTime); Param[6].Value = (object)OrganizationSubscription.StartDate ?? DBNull.Value; Param[7] = new SqlParameter("@pExpiryDate", SqlDbType.DateTime); Param[7].Value = (object)OrganizationSubscription.ExpiryDate ?? DBNull.Value; Param[8] = new SqlParameter("@pCreatedDate", SqlDbType.DateTime); Param[8].Value = (object)OrganizationSubscription.CreatedDate ?? DBNull.Value; return context.Database.ExecuteSqlCommand("update OrganizationSubscriptions set OrganizationGUID=@pOrganizationGUID,Version=@pVersion,IsActive=@pIsActive,SubscriptionPurchased=@pSubscriptionPurchased," + "SubscriptionConsumed=@pSubscriptionConsumed,StartDate=@pStartDate,ExpiryDate=@pExpiryDate,CreatedDate=@pCreatedDate where OrganizationSubscriptionGUID=@pOrganizationSubscriptionGUID", Param); }