public List <InSubUserDetails> GetSubUser() { try { List <InSubUserDetails> inSubUserDetails = new List <InSubUserDetails>(); List <InSubUser> inSubUsers = new DB_A3E3FF_scampus2020Context().InSubUser.ToList(); List <InUsers> inUsers = new DB_A3E3FF_scampusMaster2020Context().InUsers.ToList(); List <InConfiguration> inConfigurations = new DB_A3E3FF_scampusMaster2020Context().InConfiguration.ToList(); //using (DB_A3E3FF_scampus2020Context db = DB_A3E3FF_scampus2020Context()) //{ inSubUserDetails = (from b in inSubUsers from e in inUsers .Where(x => x.Id == b.EmpId).DefaultIfEmpty() from c in inConfigurations .Where(x => x.ConfId == b.ConfigId).DefaultIfEmpty() select new InSubUserDetails { Id = b.Id, ConfigId = b.ConfigId, ConfigName = c.Name, EmpName = e.Username, EmpId = b.EmpId, SubUserName = b.SubUserName, CreatedBy = b.CreatedBy, CreatedDate = b.CreatedDate, IsActive = b.IsActive }).Where(x => x.IsActive == true).OrderByDescending(x => x.CreatedDate).ToList(); return(inSubUserDetails); //} } catch (Exception ex) { throw ex; } }
public List <InBranchDetails> GetBranch() { try { List <InBranchDetails> inBranchDetails = new List <InBranchDetails>(); List <InBranch> inBranches = new DB_A3E3FF_scampus2020Context().InBranch.ToList(); List <user> inUsers = new DB_A3E3FF_scampusMaster2020Context().InUsers.Where(x => x.IsActive == true).Select(x => new user { EmpId = x.Id, EmpName = x.Username }).ToList(); List <user> inusers1 = new DB_A3E3FF_scampus2020Context().AdminUsers.Where(x => x.Status == true).Select(x => new user { EmpId = x.Userid, EmpName = x.Username }).ToList(); inUsers.AddRange(inusers1); List <ConfigurationMaster> inConfigurations = new DB_A3E3FF_scampusMaster2020Context().ConfigurationMaster.ToList(); //using (DB_A3E3FF_scampus2020Context db = DB_A3E3FF_scampus2020Context()) //{ inBranchDetails = (from b in inBranches from e in inUsers .Where(x => x.EmpId == b.EmpId).DefaultIfEmpty() from c in inConfigurations .Where(x => x.ConfigId == b.ConfigId).DefaultIfEmpty() select new InBranchDetails { BranchId = b.BranchId, BranchName = b.BranchName, Location = b.Location, Address = b.Address, ContactNumber1 = b.ContactNumber1, ContactNumber2 = b.ContactNumber2, Email = b.Email, ContactPerson = b.ContactPerson, BranchCode = b.BranchCode, Gstin = b.Gstin, State = b.State, District = b.District, Smsapiurl = b.Smsapiurl, Apikey = b.Apikey, SenderId = b.SenderId, BranchLogo = b.BranchLogo, PrintHeaderFile = b.PrintHeaderFile, PrintFooterFile = b.PrintFooterFile, ConfigId = b.ConfigId, EmpName = e.EmpName, EmpId = b.EmpId, ConfigName = c.ConfigName, CreatedBy = b.CreatedBy, CreatedDate = b.CreatedDate, IsActive = b.IsActive }).Where(x => x.IsActive == true).OrderByDescending(x => x.CreatedDate).ToList(); return(inBranchDetails); //} } catch (Exception ex) { throw ex; } }
public UserCred Authenticate(UserCred userCred) { try { UserCred users = new UserCred(); if (userCred.IsSuperAdmin == true) { using (DB_A3E3FF_scampusMaster2020Context db = new DB_A3E3FF_scampusMaster2020Context()) { var user = db.InUsers.Where(x => x.Username == userCred.Username && x.Password == userCred.Password && x.IsActive == true).FirstOrDefault(); //if user not found if (user == null) { return(null); } else { //if user found var confdata = db.ConfigurationMaster.Where(x => x.ConfigId.ToString() == user.Configuration.ToString() && x.BaseUrl == userCred.BaseUrl && x.IsActive == true).FirstOrDefault(); if (confdata != null) { var tokenHandler = new JwtSecurityTokenHandler(); var key = Encoding.ASCII.GetBytes(_appSettings.Key); var tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, user.Username), new Claim(ClaimTypes.Role, user.Role), new Claim(ClaimTypes.Version, "3.1") }), Expires = DateTime.UtcNow.AddMinutes(15), SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; var token = tokenHandler.CreateToken(tokenDescriptor); users.Token = tokenHandler.WriteToken(token); users.Role = user.Role; users.userId = user.Id; users.ConfigId = user.Configuration; users.BaseUrl = user.BaseUrl; } else { return(null); } } } } else { List <ConfigurationMaster> configurationMaster = new DB_A3E3FF_scampusMaster2020Context().ConfigurationMaster.Where(x => x.IsActive == true).ToList(); using (DB_A3E3FF_scampus2020Context db1 = new DB_A3E3FF_scampus2020Context()) { var user = db1.AdminUsers.Where(x => x.Username == userCred.Username && x.Password == userCred.Password && x.Status == true).FirstOrDefault(); //if user not found if (user == null) { return(null); } else { var confiData = configurationMaster.Where(x => x.ConfigId == user.ConfigSettings && x.BaseUrl == userCred.BaseUrl && x.IsActive == true).FirstOrDefault(); //if user found if (confiData != null) { var tokenHandler = new JwtSecurityTokenHandler(); var key = Encoding.ASCII.GetBytes(_appSettings.Key); var tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, user.Username), new Claim(ClaimTypes.Role, user.Role), new Claim(ClaimTypes.Version, "3.1") }), Expires = DateTime.UtcNow.AddMinutes(15), SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; var token = tokenHandler.CreateToken(tokenDescriptor); users.Token = tokenHandler.WriteToken(token); users.Role = user.Role; users.userId = user.Userid; users.BaseUrl = user.Baseurl; users.ConfigId = user.ConfigSettings; } else { return(null); } } return(users); } } return(users); } catch (Exception ex) { throw ex; } }
public Result Login(string username, string password, bool?Role, string baseusrl) { try { if (Role == true) { using (DB_A3E3FF_scampusMaster2020Context db = new DB_A3E3FF_scampusMaster2020Context()) { var data = db.InUsers.Where(x => x.Username == username && x.Password == password && x.BaseUrl == baseusrl && x.IsActive == true).FirstOrDefault(); if (data != null) { var confdata = db.ConfigurationMaster.Where(x => x.ConfigId.ToString() == data.Configuration.ToString() && x.IsActive == true).FirstOrDefault(); if (confdata != null) { return(new Result { StatusCode = 1, Message = "Login success ..!" }); } else { return(new Result { StatusCode = -1, Message = "Login Failed" }); } } else { return(new Result { StatusCode = -1, Message = "Login Failed" }); } } } else { List <ConfigurationMaster> configurationMaster = new DB_A3E3FF_scampusMaster2020Context().ConfigurationMaster.Where(x => x.IsActive == true).ToList(); using (DB_A3E3FF_scampus2020Context db1 = new DB_A3E3FF_scampus2020Context()) { var data = db1.AdminUsers.Where(x => x.Username == username && x.Password == password && x.Baseurl == baseusrl && x.Status == true).FirstOrDefault(); if (data != null) { var confdata = configurationMaster.Where(x => x.ConfigId.ToString() == data.ConfigSettings.ToString() && x.IsActive == true).FirstOrDefault(); if (confdata != null) { return(new Result { StatusCode = 1, Message = "Login success ..!" }); } else { return(new Result { StatusCode = -1, Message = "Login Failed" }); } } else { return(new Result { StatusCode = -1, Message = "Login Failed" }); } } } } catch (Exception ex) { return(new Result { StatusCode = -1, Message = ex.Message }); throw ex; } }
public List <AdminUserDetails> GetAdminUsers(string role) { try { List <AdminUserDetails> adminUsers = new List <AdminUserDetails>(); List <ConfigurationMaster> configurationMasters = new DB_A3E3FF_scampusMaster2020Context().ConfigurationMaster.Where(x => x.IsActive == true).ToList(); List <AdminUsers> adminUsers1 = new DB_A3E3FF_scampus2020Context().AdminUsers.Where(x => x.Status == true).ToList(); List <InUsers> inUsers = new DB_A3E3FF_scampusMaster2020Context().InUsers.Where(x => x.IsActive == true).ToList(); List <AdminUserDetails> user = new List <AdminUserDetails>(); //DB_A3E3FF_scampus2020Context().AdminUsers.Where(x => x.Role == "Admin" && x.Status == true).ToList(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { user = (from a in adminUsers1 from c in configurationMasters .Where(x => x.ConfigId == a.ConfigSettings).DefaultIfEmpty() select new AdminUserDetails { Userid = a.Userid, Username = a.Username, Password = a.Password, EmailId = a.EmailId, ConfigSettings = a.ConfigSettings, ConfigName = c.ConfigName, Role = a.Role, Status = a.Status, AccountStatus = a.AccountStatus, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate }).Where(x => x.Status == true && x.Role == "Admin").ToList(); } if (role == "Super Admin") { adminUsers = (from a in inUsers from c in configurationMasters .Where(x => x.ConfigId == a.Configuration).DefaultIfEmpty() select new AdminUserDetails { Userid = a.Id, Username = a.Username, Password = a.Password, EmailId = a.EmailId, ConfigSettings = a.Configuration, ConfigName = c.ConfigName, Status = a.IsActive, Role = a.Role, Baseurl = a.BaseUrl, AccountStatus = a.AccountStatus, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate }).OrderByDescending(x => x.CreatedDate).Where(x => x.Status == true).ToList(); adminUsers.AddRange(user); } else if (role == "Admin") { adminUsers = (from a in adminUsers1 from c in configurationMasters .Where(x => x.ConfigId == a.ConfigSettings).DefaultIfEmpty() select new AdminUserDetails { Userid = a.Userid, Username = a.Username, Password = a.Password, EmailId = a.EmailId, ConfigSettings = a.ConfigSettings, ConfigName = c.ConfigName, Status = a.Status, Role = a.Role, Baseurl = a.Baseurl, AccountStatus = a.AccountStatus, CreatedBy = a.CreatedBy, CreatedDate = a.CreatedDate }).OrderByDescending(x => x.CreatedDate).Where(x => x.Status == true).ToList(); } //adminUsers = (from a in adminUsers1 // from c in configurationMasters // .Where(x => x.ConfigId == a.ConfigSettings).DefaultIfEmpty() // select new AdminUserDetails // { // Userid = a.Userid, // Username = a.Username, // Password = a.Password, // EmailId = a.EmailId, // ConfigSettings = a.ConfigSettings, // ConfigName = c.ConfigName, // Status = a.Status, // AccountStatus = a.AccountStatus, // CreatedBy = a.CreatedBy, // CreatedDate = a.CreatedDate // }).OrderByDescending(x => x.CreatedDate).Where(x => x.Status == true).ToList(); // } return(adminUsers); } catch (Exception ex) { throw ex; } }