public Result DeleteBranch(string id)
{
try
{
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.InBranch.Where(x => x.BranchId.ToString() == id).FirstOrDefault();
data.IsActive = false;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Branch Deleted Successfully ..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Branch Failed ..!"
});
}
}
}
catch (Exception ex)
{
return(new Result {
StatusCode = -1, Message = ex.Message
});
throw ex;
}
}
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 Result DeleteStaff(string Id)
{
try
{
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.InStaff.Where(x => x.StaffId.ToString() == Id.ToString()).FirstOrDefault();
data.IsActive = false;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Staff Added Successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Staff Adding Failed..!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Result DeleteUpload(string Id)
{
try
{
int result = 0;
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.InFileUpload.Where(x => x.UploadId.ToString() == Id).FirstOrDefault();
data.IsActive = false;
result = db.SaveChanges();
}
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "File Deleted Successfully ..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "File Deleting Failed ..!"
});
}
}
catch (Exception ex)
{
return(new Result {
StatusCode = -1, Message = ex.Message
});
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 Result UpdateSubUser(subUserDetails inSubUser)
{
try
{
int?count = 0;
using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context())
{
count = db1.InConfiguration.Where(x => x.ConfId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Select(x => x.Branch).FirstOrDefault();
}
InBranch inBranch1 = new InBranch();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var Bcount = db.InSubUser.Where(x => x.ConfigId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId && x.Id != inSubUser.Id).Count();
if (Bcount < count)
{
var data = db.InSubUser.Where(x => x.Id == inSubUser.Id && x.EmpId == inSubUser.EmpId).FirstOrDefault();
data.ConfigId = inSubUser.ConfigId;
data.SubUserName = inSubUser.SubUserName;
data.EmpId = inSubUser.EmpId;
data.EmailId = inSubUser.EmailId;
data.UpdatedBy = inSubUser.CreatedBy;
data.UpdatedDate = inSubUser.CreatedDate;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Sub User Updated successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Sub User Failed..!"
});
}
}
else
{
return(new Result {
StatusCode = -1, Message = "Sub User count cannot be more than Configuration Count.!"
});
}
}
}
catch (Exception ex)
{
return(new Result {
StatusCode = -1, Message = ex.Message
});
throw ex;
}
}
public Result AddSubUser(subUserDetails inSubUser)
{
try
{
int?count = 0;
using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context())
{
count = db1.InConfiguration.Where(x => x.ConfId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Select(x => x.UserCount).FirstOrDefault();
}
InSubUser inSubUser1 = new InSubUser();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var Bcount = db.InSubUser.Where(x => x.ConfigId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Where(x => x.IsActive == true).Count();
if (Bcount < count)
{
inSubUser1.ConfigId = inSubUser.ConfigId;
inSubUser1.EmpId = inSubUser.EmpId;
inSubUser1.SubUserName = inSubUser.SubUserName;
inSubUser1.CreatedBy = inSubUser.CreatedBy;
inSubUser1.CreatedDate = inSubUser.CreatedDate;
inSubUser1.EmailId = inSubUser.EmailId;
db.InSubUser.Add(inSubUser1);
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Sub User Added successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Sub User Failed..!"
});
}
}
else
{
return(new Result {
StatusCode = -1, Message = "Sub User count cannot be more than Configuration Count.!"
});
}
}
}
catch (Exception ex)
{
return(new Result {
StatusCode = -1, Message = ex.Message
});
throw ex;
}
}
public Result AddStaff(StaffDetails inStaff)
{
try
{
InStaff inStaff1 = new InStaff();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inStaff1.Name = inStaff.Name;
inStaff1.Dob = inStaff.Dob;
inStaff1.Gender = inStaff.Gender;
inStaff1.Address = inStaff.Address;
inStaff1.ContactNumber = inStaff.ContactNumber;
inStaff1.MobileNumber = inStaff.MobileNumber;
inStaff1.HomeContactNumber = inStaff.HomeContactNumber;
inStaff1.ContactPerson = inStaff.ContactPerson;
inStaff1.BloodGroup = inStaff.BloodGroup;
inStaff1.PersonalEmail = inStaff.PersonalEmail;
inStaff1.Designation = inStaff.Designation;
inStaff1.JoiningDate = inStaff.JoiningDate;
inStaff1.Salary = inStaff.Salary;
inStaff1.Experience = inStaff.Experience;
inStaff1.BranchId = inStaff.BranchId;
inStaff1.Department = inStaff.Department;
inStaff1.PreviousCompany = inStaff.PreviousCompany;
inStaff1.UserName = inStaff.UserName;
inStaff1.Password = inStaff.Password;
inStaff1.IdcardType = inStaff.IdcardType;
inStaff1.Idnumber = inStaff.Idnumber;
inStaff1.UploadId = inStaff.UploadId;
inStaff1.CertificateTitle = inStaff.CertificateTitle;
inStaff1.UserRole = inStaff.UserRole;
inStaff1.CreatedBy = inStaff.CreatedBy;
inStaff1.CreatedDate = inStaff.CreatedDate;
db.InStaff.Add(inStaff1);
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Staff Added Successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Staff Adding Failed..!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Result UpdateStaff(StaffDetails inStaff)
{
try
{
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.InStaff.Where(x => x.StaffId == inStaff.StaffId).FirstOrDefault();
data.Name = inStaff.Name;
data.Dob = inStaff.Dob;
data.Gender = inStaff.Gender;
data.Address = inStaff.Address;
data.ContactNumber = inStaff.ContactNumber;
data.MobileNumber = inStaff.MobileNumber;
data.HomeContactNumber = inStaff.HomeContactNumber;
data.ContactPerson = inStaff.ContactPerson;
data.BloodGroup = inStaff.BloodGroup;
data.PersonalEmail = inStaff.PersonalEmail;
data.Designation = inStaff.Designation;
data.JoiningDate = inStaff.JoiningDate;
data.Salary = inStaff.Salary;
data.Experience = inStaff.Experience;
data.BranchId = inStaff.BranchId;
data.Department = inStaff.Department;
data.PreviousCompany = inStaff.PreviousCompany;
data.UserName = inStaff.UserName;
data.Password = inStaff.Password;
data.IdcardType = inStaff.IdcardType;
data.Idnumber = inStaff.Idnumber;
data.UploadId = inStaff.UploadId;
data.CertificateTitle = inStaff.CertificateTitle;
data.UserRole = inStaff.UserRole;
data.UpdatedBy = inStaff.CreatedBy;
data.UpdatedDate = inStaff.CreatedDate;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Staff Added Successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Staff Adding Failed..!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <InFileUpload> EditFileUpload(string Id)
{
try
{
List <InFileUpload> inFileUploads = new List <InFileUpload>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inFileUploads = db.InFileUpload.Where(x => x.UserId.ToString() == Id).Where(x => x.IsActive == true).ToList();
}
return(inFileUploads);
}
catch (Exception ex)
{
throw;
}
}
public List <InDepartment> GetDepartments()
{
try
{
List <InDepartment> inDepartments = new List <InDepartment>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inDepartments = db.InDepartment.Where(x => x.IsActive == true).ToList();
}
return(inDepartments);
}
catch (Exception ex)
{
throw ex;
}
}
public List <InUserRole> GetUserRoles()
{
try
{
List <InUserRole> inUserRoles = new List <InUserRole>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inUserRoles = db.InUserRole.Where(x => x.IsActive == true).ToList();
}
return(inUserRoles);
}
catch (Exception ex)
{
throw ex;
}
}
public List <InState> GetState()
{
try
{
List <InState> inStates = new List <InState>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inStates = db.InState.ToList();
}
return(inStates);
}
catch (Exception ex)
{
throw ex;
}
}
public List <InDesignation> GetInDesignations()
{
try
{
List <InDesignation> inDesignations = new List <InDesignation>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
inDesignations = db.InDesignation.Where(x => x.IsActive == true).ToList();
}
return(inDesignations);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MainCourse> GetMainCourses()
{
try
{
List <MainCourse> mainCourses = new List <MainCourse>();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
mainCourses = db.MainCourse.Where(x => x.IsActive == true).ToList();
}
return(mainCourses);
}
catch (Exception ex)
{
throw ex;
}
}
public Result SaveFileUpload(string key)
{
try
{
int result = 0;
FileUpload obj = JsonConvert.DeserializeObject <FileUpload>(key);
InFileUpload inFileUpload = new InFileUpload();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.InFileUpload.Where(x => x.FileName == obj.FileName && x.FileType == obj.FileType).FirstOrDefault();
if (data == null)
{
inFileUpload.UserId = obj.UserID;
inFileUpload.FileName = obj.FileName;
inFileUpload.FileTitle = obj.FileTitle;
inFileUpload.FileType = obj.FileType;
inFileUpload.CreatedBy = obj.CreatedBy;
db.InFileUpload.Add(inFileUpload);
result = db.SaveChanges();
if (result == 1)
{
return(new Result {
Message = "File Uploaded Successfully..!", StatusCode = 1
});
}
else
{
return(new Result {
Message = "File Uploading Failed..!", StatusCode = -1
});
}
}
else
{
return(new Result {
Message = "File Already Exists..!", StatusCode = -1
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Result DeleteUploadedFile(string Id, string Type)
{
try
{
int result = 0;
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
if (Type == "UploadID")
{
var data = db.StudentIdupload.Where(x => x.StudentUploadId.ToString() == Id).FirstOrDefault();
data.IsActive = false;
result = db.SaveChanges();
}
else
{
var data1 = db.CertificateUpload.Where(x => x.CertificteUploadId.ToString() == Id).FirstOrDefault();
data1.IsActive = false;
result = db.SaveChanges();
}
}
if (result == 1)
{
return(new Result {
Message = "Student File Deleted Successfully..!", StatusCode = 1
});
}
else
{
return(new Result {
Message = "Student File Deleting Failed..!", StatusCode = -1
});
}
}
catch (Exception ex)
{
return(new Result {
Message = ex.Message, StatusCode = -1
});
throw ex;
}
}
public Result AddAdminUser(AdminUserDetails adminUsers)
{
try
{
AdminUsers adminUserDetails = new AdminUsers();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
adminUserDetails.Userid = Guid.NewGuid();
adminUserDetails.Username = adminUsers.Username;
adminUserDetails.Password = adminUsers.Password;
adminUserDetails.EmailId = adminUsers.EmailId;
adminUserDetails.ConfigSettings = adminUsers.ConfigSettings;
adminUserDetails.Status = adminUsers.Status;
adminUserDetails.AccountStatus = adminUsers.AccountStatus;
adminUserDetails.CreatedBy = adminUsers.CreatedBy;
adminUserDetails.CreatedDate = adminUsers.CreatedDate;
adminUserDetails.UpdatedBy = adminUsers.UpdatedBy;
adminUserDetails.UpdatedDate = adminUsers.UpdatedDate;
adminUserDetails.Role = adminUsers.Role;
adminUserDetails.Baseurl = adminUsers.Baseurl;
adminUserDetails.CreatedById = adminUsers.CreatedById;
db.AdminUsers.Add(adminUserDetails);
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Added Successdully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Adding Failed..!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public Result DeleteAdminUser(string Id)
{
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.AdminUsers.Where(x => x.Userid.ToString() == Id).FirstOrDefault();
data.Status = false;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "User Deleted Successfully ..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "User Deleting Failed ..!"
});
}
}
}
public Result DeleteStudent(string ID)
{
try
{
int resutl = 0;
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.StudentDetails.Where(x => x.StudentId.ToString() == ID).FirstOrDefault();
data.IsActive = false;
db.SaveChanges();
var data1 = db.Course.Where(x => x.StudentId == data.StudentId).ToList();
foreach (var item in data1)
{
item.IsActive = false;
resutl = db.SaveChanges();
}
}
if (resutl == 1)
{
return(new Result {
Message = "Student Deleted Successfully..!", StatusCode = 1
});
}
else
{
return(new Result {
Message = "Student Deleting Failed..!", StatusCode = -1
});
}
}
catch (Exception ex)
{
return(new Result {
Message = ex.Message, StatusCode = -1
});
throw ex;
}
}
public Result UpdateAdminUser(AdminUsers adminUsers)
{
try
{
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data = db.AdminUsers.Where(x => x.Userid == adminUsers.Userid).FirstOrDefault();
data.Username = adminUsers.Username;
data.Password = adminUsers.Password;
data.EmailId = adminUsers.EmailId;
data.UpdatedBy = adminUsers.CreatedBy;
data.UpdatedDate = adminUsers.CreatedDate;
data.AccountStatus = adminUsers.AccountStatus;
data.CreatedById = adminUsers.CreatedById;
data.ConfigSettings = adminUsers.ConfigSettings;
data.Baseurl = adminUsers.Baseurl;
data.Role = adminUsers.Role;
var reuslt = db.SaveChanges();
if (data != null)
{
return(new Result {
StatusCode = 1, Message = "Admin user updated successfully ..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Admin user Updating Failed ..!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <studentfile> GetUploadedFile(string Id)
{
try
{
List <studentfile> studentfiles = new List <studentfile>();
List <studentfile> studentfiles1 = new List <studentfile>();
List <studentfile> studentfiles2 = new List <studentfile>();
studentfile studentfiles3 = new studentfile();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
studentfiles1 = db.StudentIdupload.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).Select(x => new studentfile
{
FileID = x.StudentUploadId,
FileName = x.UploadFileName,
FileType = x.UploadFileTitile
}).ToList();
studentfiles.AddRange(studentfiles1);
studentfiles2 = db.CertificateUpload.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).Select(x => new studentfile
{
FileID = x.CertificteUploadId,
FileName = x.UploadFileName,
FileType = x.UploadFileTitile
}).ToList();
studentfiles.AddRange(studentfiles2);
var data = db.StudentDetails.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).FirstOrDefault();
var d = data.StudentPhoto.Split("\\");
studentfiles3 = new studentfile {
FileID = data.StudentId, FileName = d[8], FileType = "UploadPhoto"
};
studentfiles.Add(studentfiles3);
}
return(studentfiles);
}
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 IActionResult UploadFiles([FromForm] IFormFile[] file, string foldername, string subfolder, Guid Id, string user)
{
Result objstatus = new Result();
StudentIdupload studentIdupload = new StudentIdupload();
StudentDetails studentDetails = new StudentDetails();
CertificateUpload certificateUpload = new CertificateUpload();
foreach (var item in file)
{
var filename = Path.GetFileName(item.FileName);
var extention = Path.GetExtension(item.FileName);
var path = "";
if (!string.IsNullOrEmpty(item.FileName))
{
var filepath = Path.Combine(Directory.GetCurrentDirectory(), "UploadFiles", foldername, subfolder);
if (!Directory.Exists(filepath))
{
Directory.CreateDirectory(filepath);
}
path = Path.Combine(Directory.GetCurrentDirectory(), "UploadFiles", foldername, subfolder, item.FileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
using (var stream = new FileStream(path, FileMode.Create))
{
item.CopyTo(stream);
}
}
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
if (subfolder == "UploadID")
{
studentIdupload.StudentId = Id;
studentIdupload.UploadFileType = extention;
studentIdupload.UploadFileTitile = subfolder;
studentIdupload.UploadPath = path;
studentIdupload.UploadFileName = filename;
studentIdupload.CreatedBy = user;
studentIdupload.CreatedDate = DateTime.Now;
db.StudentIdupload.Add(studentIdupload);
db.SaveChanges();
}
else if (subfolder == "UploadPhoto")
{
var data = db.StudentDetails.Where(x => x.StudentId == Id).FirstOrDefault();
data.StudentPhoto = path;
db.SaveChanges();
}
else
{
certificateUpload.StudentId = Id;
certificateUpload.UploadFileType = extention;
certificateUpload.UploadFileTitile = subfolder;
certificateUpload.UploadPath = path;
certificateUpload.UploadFileName = filename;
certificateUpload.CreatedBy = user;
certificateUpload.CreatedDate = DateTime.Now;
db.CertificateUpload.Add(certificateUpload);
db.SaveChanges();
}
}
}
objstatus.StatusCode = 1;
objstatus.Message = "Successfully Uploaded";
return((ActionResult)Ok(objstatus));
}
public Result UpdateBranch(InBranchDetails inBranch)
{
try
{
int?count = 0;
using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context())
{
count = db1.ConfigurationMaster.Where(x => x.ConfigId == inBranch.ConfigId).Select(x => x.NoOfBranches).FirstOrDefault();
}
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var Bcount = db.InBranch.Where(x => x.ConfigId == inBranch.ConfigId && x.EmpId == inBranch.EmpId).Count();
//if (Bcount < count)
//{
var inBranch1 = db.InBranch.Where(x => x.BranchId == inBranch.BranchId && x.EmpId == inBranch.EmpId).FirstOrDefault();
inBranch1.BranchName = inBranch.BranchName;
inBranch1.Location = inBranch.Location;
inBranch1.Address = inBranch.Address;
inBranch1.ContactNumber1 = inBranch.ContactNumber1;
inBranch1.ContactNumber2 = inBranch.ContactNumber2;
inBranch1.Email = inBranch.Email;
inBranch1.ContactPerson = inBranch.ContactPerson;
inBranch1.BranchCode = inBranch.BranchCode;
inBranch1.Gstin = inBranch.Gstin;
inBranch1.State = inBranch.State;
inBranch1.District = inBranch.District;
inBranch1.Smsapiurl = inBranch.Smsapiurl;
inBranch1.Apikey = inBranch.Apikey;
inBranch1.SenderId = inBranch.SenderId;
inBranch1.BranchLogo = inBranch.BranchLogo;
inBranch1.PrintHeaderFile = inBranch.PrintHeaderFile;
inBranch1.PrintFooterFile = inBranch.PrintFooterFile;
inBranch1.UpdatedBy = inBranch.CreatedBy;
inBranch1.UpdatedDate = inBranch.CreatedDate;
inBranch1.EmpId = inBranch.EmpId;
inBranch1.ConfigId = inBranch.ConfigId;
var result = db.SaveChanges();
if (result == 1)
{
return(new Result {
StatusCode = 1, Message = "Branch Updated successfully..!"
});
}
else
{
return(new Result {
StatusCode = -1, Message = "Branch Failed..!"
});
}
//}
//else
//{
// return new Result { StatusCode = -1, Message = "Branch count cannot be more than Configuration Count.!" };
//}
}
}
catch (Exception ex)
{
return(new Result {
StatusCode = -1, Message = ex.Message
});
throw ex;
}
}
public Student GetStudentByID(string Id)
{
try
{
Student student = new Student();
List <studentfile> studentfiles = new List <studentfile>();
List <studentfile> studentfiles1 = new List <studentfile>();
List <studentfile> studentfiles2 = new List <studentfile>();
studentfile studentfiles3 = new studentfile();
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
student = (from s in db.StudentDetails
from c in db.Course
.Where(x => x.StudentId.ToString() == Id && s.IsActive == true).DefaultIfEmpty()
from b in db.InBranch
.Where(x => x.BranchId == s.BranchId).DefaultIfEmpty()
from m in db.MainCourse
.Where(x => x.MainCourseId == s.MainCourseId).DefaultIfEmpty()
from mc in db.MainCourse
.Where(x => x.MainCourseId == c.MainCourseId).DefaultIfEmpty()
select new Student
{
StudentID = s.StudentId,
CourseID = c.CourseId,
CourseName = mc.Name,
mainCourseID = mc.MainCourseId,
FirstName = s.StudentFname,
LastName = s.StudentLname,
MiddleName = s.StudentMname,
DOB = s.Dob,
Gender = s.Gender,
ParentName = s.ParentName,
ParentMobileNo = s.ParentMobile,
Email = s.Email,
UserName = s.UserName,
Password = s.Password,
ContactNo = s.Mobile,
AlternateContactNo = s.AlternateMobile,
Location = s.Location,
City = s.City,
Address = s.Address,
PinCode = s.Pincode,
State = s.State,
Coutry = s.Country,
BranchID = s.BranchId,
BranchName = b.BranchName,
RegistrationDate = c.RegistrationDate,
CourseStartDate = c.CourseStartDate,
Batch = c.Batch,
RegisterNo = c.RegistratioinNumber,
RollNumber = c.RollNo,
DiscountAmount = c.DiscountAmount,
ReferedPerson = c.ReferredPerson,
SourceOfEnquiry = c.SourceOfEnquiry,
FeeDiscountApplicable = c.FeeDiscountApplicable,
TypeofDiscount = c.TypeOfDiscount,
Comments = s.Comments,
IdProofType = c.IdproofType,
IdProofNo = c.IdproofNumber,
IsActive = s.IsActive,
CreatedDate = s.CreatedDate,
UploadedFile = studentfiles
}
).Where(x => x.IsActive == true).OrderByDescending(x => x.CreatedDate).FirstOrDefault();
}
return(student);
}
catch (Exception ex)
{
throw ex;
}
}
public Result UpdateStudent(Student data)
{
try
{
StudentDetails studentDetails = new StudentDetails();
Course course = new Course();
int res = 0;
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var data1 = db.StudentDetails.Where(x => x.StudentId == data.StudentID).FirstOrDefault();
data1.StudentFname = data.FirstName;
data1.StudentLname = data.LastName;
data1.StudentMname = data.MiddleName;
data1.Dob = data.DOB;
data1.Gender = data.Gender;
data1.ParentName = data.ParentName;
data1.ParentMobile = data.ParentMobileNo;
data1.Email = data.Email;
data1.UserName = data.UserName;
data1.Password = data.Password;
data1.Mobile = data.ContactNo;
data1.AlternateMobile = data.AlternateContactNo;
data1.Location = data.Location;
data1.City = data.City;
data1.Address = data.Address;
data1.Pincode = data.PinCode;
data1.State = data.State;
data1.Country = data.Coutry;
data1.BranchId = data.BranchID;
data1.UpdatedBy = data.CreatedBy;
data1.UpdatedDate = data.CreatedDate;
data1.Comments = data.Comments;
var result = db.SaveChanges();
if (result == 1)
{
var data2 = db.Course.Where(x => x.StudentId == data.StudentID).FirstOrDefault();
data2.MainCourseId = data.mainCourseID;
data2.AdditionalCourseId = data.AdditionalCourseID;
data2.RegistrationDate = data.RegistrationDate;
data2.CourseStartDate = data.CourseStartDate;
data2.Batch = data.Batch;
data2.RegistratioinNumber = data.RegisterNo;
data2.RollNo = data.RollNumber;
data2.SourceOfEnquiry = data.SourceOfEnquiry;
data2.FeeDiscountApplicable = data.FeeDiscountApplicable;
data2.DiscountAmount = data.DiscountAmount;
data2.ReferredPerson = data.ReferedPerson;
data2.TypeOfDiscount = data.TypeofDiscount;
data2.IdproofType = data.IdProofType;
data2.IdproofNumber = data.IdProofNo;
data2.UpdatedBy = data.CreatedBy;
data2.UpdatedDate = data.CreatedDate;
res = db.SaveChanges();
}
if (res == 1)
{
return(new Result {
Message = "Student Updated Successfully..!", StatusCode = 1, Id = data.StudentID
});
}
else
{
return(new Result {
Message = "Student Updating Failed..!", StatusCode = -1
});
}
}
}
catch (Exception ex)
{
return(new Result {
Message = ex.Message, StatusCode = -1
});
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 Result AddStudent(Student data)
{
try
{
StudentDetails studentDetails = new StudentDetails();
Course course = new Course();
int res = 0;
using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
{
var guid = Guid.NewGuid();
studentDetails.StudentId = guid;
studentDetails.StudentFname = data.FirstName;
studentDetails.StudentLname = data.LastName;
studentDetails.StudentMname = data.MiddleName;
studentDetails.Dob = data.DOB;
studentDetails.Gender = data.Gender;
studentDetails.ParentName = data.ParentName;
studentDetails.ParentMobile = data.ParentMobileNo;
studentDetails.Email = data.Email;
studentDetails.UserName = data.UserName;
studentDetails.Password = data.Password;
studentDetails.Mobile = data.ContactNo;
studentDetails.AlternateMobile = data.AlternateContactNo;
studentDetails.Location = data.Location;
studentDetails.City = data.City;
studentDetails.Address = data.Address;
studentDetails.Pincode = data.PinCode;
studentDetails.State = data.State;
studentDetails.Country = data.Coutry;
studentDetails.BranchId = data.BranchID;
studentDetails.CreatedBy = data.CreatedBy;
studentDetails.CreatedDate = data.CreatedDate;
studentDetails.Comments = data.Comments;
db.StudentDetails.Add(studentDetails);
var result = db.SaveChanges();
if (result == 1)
{
course.StudentId = guid;
course.MainCourseId = data.mainCourseID;
course.AdditionalCourseId = data.AdditionalCourseID;
course.RegistrationDate = data.RegistrationDate;
course.CourseStartDate = data.CourseStartDate;
course.Batch = data.Batch;
course.RegistratioinNumber = data.RegisterNo;
course.RollNo = data.RollNumber;
course.DiscountAmount = data.DiscountAmount;
course.ReferredPerson = data.ReferedPerson;
course.SourceOfEnquiry = data.SourceOfEnquiry;
course.FeeDiscountApplicable = data.FeeDiscountApplicable;
course.TypeOfDiscount = data.TypeofDiscount;
course.IdproofType = data.IdProofType;
course.IdproofNumber = data.IdProofNo;
course.CreatedBy = data.CreatedBy;
course.CreatedDate = data.CreatedDate;
db.Course.Add(course);
res = db.SaveChanges();
}
if (res == 1)
{
return(new Result {
Message = "Student Registered Successfully..!", StatusCode = 1, Id = guid
});
}
else
{
return(new Result {
Message = "Student Registered Failed..!", StatusCode = -1
});
}
}
}
catch (Exception ex)
{
return(new Result {
Message = ex.Message, StatusCode = -1
});
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;
}
}
