public async Task <IEnumerable <AcademicInstituteModel> > GetAcademicInstitutions() { using (var db = new HeznekServiceDbEntities()) { var data = await db.Academic_Institut.ToListAsync(); if (data.Count == 0) { return(new List <AcademicInstituteModel>() { new AcademicInstituteModel() { sn = 0 } }); } var result = new List <AcademicInstituteModel>(); data.ForEach(el => { result.Add(new AcademicInstituteModel() { sn = el.sn, User_Profile = el.User_Profile, City = el.City, nameOfInstitut = el.nameOfInstitut, placeOfInstitute = el.placeOfInstitute }); }); return(result); } }
public async Task <IEnumerable <StudentVolunteerModel> > GetStudentVolunteer() { using (var db = new HeznekServiceDbEntities()) { var data = await db.Student_Volunteer.ToListAsync(); if (data.Count == 0) { return(new List <StudentVolunteerModel>() { new StudentVolunteerModel() { id = "0" } }); } var result = new List <StudentVolunteerModel>(); data.ForEach(el => { result.Add(new StudentVolunteerModel() { id = el.id, Scholarship = el.Scholarship, User_Profile = el.User_Profile, dateOfVolunteer = el.dateOfVolunteer, finishHour = el.finishHour, scholarshipSn = el.scholarshipSn, semester = el.semester, startHour = el.startHour }); }); return(result); } }
public async Task <IEnumerable <BankModel> > GetBankInformation() { using (var db = new HeznekServiceDbEntities()) { var data = await db.Banks.ToListAsync(); if (data.Count == 0) { return(new List <BankModel>() { new BankModel() { sn = 0 } }); } var result = new List <BankModel>(); data.ForEach(el => { result.Add(new BankModel() { sn = el.sn, Scholarship_Student_Bank = el.Scholarship_Student_Bank, name = el.name }); }); return(result); } }
public async Task <User_Profile> GetUserProfile(string userId) { using (var db = new HeznekServiceDbEntities()) { return(await db.User_Profile.FirstOrDefaultAsync(p => p.id == userId)); } }
public async Task UpdateUserProfile(User_Profile profile) { using (var db = new HeznekServiceDbEntities()) { db.User_Profile.AddOrUpdate(profile); await db.SaveChangesAsync(); } }
public async Task CreateUser(UserRegistrationViewModel profile) { using (var db = new HeznekServiceDbEntities()) { db.User_Profile.Add(this.MapUserProfile(profile)); await db.SaveChangesAsync(); } }
public async Task <IEnumerable <ScholarshipModel> > GetScholarships() { using (var db = new HeznekServiceDbEntities()) { var data = await db.Scholarships.ToListAsync(); if (data.Count == 0) { return(new List <ScholarshipModel>() { new ScholarshipModel() { sn = 0 } }); } var result = new List <ScholarshipModel>(); data.ForEach(el => { result.Add(new ScholarshipModel() { sn = el.sn, scholarshipName = el.scholarshipName, budgetScholarship = el.budgetScholarship, admission = el.admission, status = el.status, Student_Volunteer = el.Student_Volunteer, Deposits_scholarship = el.Deposits_scholarship, Students_Scholarship = el.Students_Scholarship }); }); return(result); } }