public int Registrataion(RegistrationForm model) // To registration in the site { string Subject = "Activation"; string Message = "Your Account Successfully created!"; using (var context = new JustHallAtumationEntities()) { User user = new User() { UserName = model.UserName, UserEmail = model.Email, Password = model.Password }; context.Users.Add(user); context.SaveChanges(); Account account = new Account // Creat account for New User { UserId = user.UserId, Balance = 0 }; if (SendEmail(model.Email.Replace(" ", ""), Subject, Message)) { context.Accounts.Add(account); context.SaveChanges(); return(user.UserId); } else { return(-1); // Email address is not currect } } }
public ActionResult UpdateAddressInfo(int?id) // Student Id { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AddressInfoModel addressInfoModel = new AddressInfoModel(); addressInfoModel.StudentId = (int)id; using (var context = new JustHallAtumationEntities()) { var address = context.Addresses.Where(x => x.StudentId == (int)id).FirstOrDefault(); addressInfoModel.P_PostOffice = address.P_PostOffice; addressInfoModel.P_VillageName = address.P_VillageName; addressInfoModel.T_PostOffice = address.T_PostOffice; addressInfoModel.T_VillageName = address.T_VillageName; addressInfoModel.districts = context.Districts.ToList(); } return(View(addressInfoModel)); } catch (Exception ex) { return(View(ex)); } }
public List <UserProfiles> GetStudentInformation(string UserName) { using (var context = new JustHallAtumationEntities()) { var profiles = (from u in context.Users join s in context.Students on u.UserId equals s.UserId join r in context.Rooms on s.RoomId equals r.RoomId join depInfo in context.DepartmentInfoes on s.StudentId equals depInfo.StudentId join d in context.Departments on depInfo.DepartmentId equals d.DeptId join add in context.Addresses on s.StudentId equals add.StudentId join dis in context.Districts on add.P_DistrictId equals dis.DistrictId join img in context.UserImages on u.UserId equals img.UserId where (u.UserName == UserName) select new UserProfiles { student = s, userImage = img, user = u, room = r, departmentInfo = depInfo, district = dis, department = d, address = add }).ToList(); if (profiles.Count() > 0) { profiles[0].registrationForm = context.RegistrationForms.Where(x => x.UserName == UserName).FirstOrDefault(); } return(profiles); } }
public ActionResult UpdateStudentInfo(int?Id) // Student Id { try { if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentUpdateModel studentUpdateModel = new StudentUpdateModel(); studentUpdateModel.StudentId = (int)Id; using (var context = new JustHallAtumationEntities()) { var student = context.Students.Where(x => x.StudentId == (int)Id).FirstOrDefault(); studentUpdateModel.StudentName = student.StudentName; studentUpdateModel.FatherName = student.FatherName; studentUpdateModel.MotherName = student.MotherName; studentUpdateModel.MobileNumber = student.MobileNumber; studentUpdateModel.room = context.Rooms.ToList(); } return(View(studentUpdateModel)); } catch (Exception ex) { return(View(ex)); } }
public ActionResult UpdateMeal() { try { string UserName = User.Identity.Name; Meal meal = new Meal(); using (var context = new JustHallAtumationEntities()) { var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault(); var student = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault(); if (student == null) { ViewBag.Success = "All Information must feel before add the meals!"; return(View()); } meal = context.Meals.Where(x => x.Date == DateTime.Today.Date && x.StudentId == student.StudentId).FirstOrDefault(); } return(View(meal)); } catch (Exception ex) { return(View(ex)); } }
public ActionResult InsertAddress() { try { AddressInfoModel addressInfoModel = new AddressInfoModel(); using (var context = new JustHallAtumationEntities()) { var user = context.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault(); var std = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault(); if (std == null) // If student information doesn't given { return(RedirectToAction("InsertStudentInfo", "InsertInformation")); } var dep = context.DepartmentInfoes.Where(x => x.StudentId == std.StudentId).FirstOrDefault(); if (dep == null) /// DepartMent Info doesn't given go insertDepartment info function. { RedirectToAction("InsertUserDepartmentInfo", "InsertInformation"); } var add = context.Addresses.Where(x => x.StudentId == std.StudentId).FirstOrDefault(); if (add != null) /// Go to Profile bcs already given the Address information. { return(RedirectToAction("Contact", "Home")); } addressInfoModel.districts = context.Districts.ToList(); } return(View(addressInfoModel)); } catch (Exception ex) { return(View(ex)); } }
public ActionResult ActivateTheUser(int?Id) { try { using (var context = new JustHallAtumationEntities()) { var result = context.RegistrationForms.Where(x => x.RegistrationId == (int)Id).FirstOrDefault(); int id = loginRegistrationOperation.Registrataion(result); if (id > 0) { UsersRole user = new UsersRole { UserId = id, Role = "Student" }; result.IsVerified = 1; context.UsersRoles.Add(user); context.SaveChanges(); ViewBag.Success = "Successfully Activated The User!"; } else { ViewBag.Success = "Failed to Verified The user!"; } return(RedirectToAction("Notices", "Home")); } } catch (Exception ex) { return(View(ex)); } }
public ActionResult UpdateRegistraionForm(RegistrationForm model) { try { if (ModelState.IsValid) { using (var context = new JustHallAtumationEntities()) { var result = context.RegistrationForms.Where(x => x.RegistrationId == model.RegistrationId).FirstOrDefault(); if (result != null) { result.Email = model.Email; result.Session = model.Session; result.RollNumber = model.RollNumber; result.StudentName = model.StudentName; context.SaveChanges(); ViewBag.Success = "Email Is Updated successfully..."; } string message = "Updated! Please Verify Your Email!\n" + "Your Verification Code is : " + model.Verification + "\n" + " User Name : " + model.UserName + "\n"; loginRegistrationOperation.SendEmail(model.Email, "Updated JUST Hall", message); } ModelState.Clear(); } return(View()); } catch (Exception ex) { return(View(ex)); } }
public ActionResult EmailVerification(EmailVerificationModel model) { try { if (ModelState.IsValid) { using (var context = new JustHallAtumationEntities()) { var registration = context.RegistrationForms.Where(x => x.UserName.Replace(" ", "") == model.UserName.Replace(" ", "") && x.Verification.Replace(" ", "") == model.VerificationCode.Replace(" ", "") && x.IsVerified == 2).FirstOrDefault(); if (registration != null) { registration.IsVerified = 0; /// Eamil Is verified Wait for 1 ( Hall Provost ) context.SaveChanges(); ViewBag.Success = "Successfully Verified Your Email\n Wait For Accepted by Hall Admin...."; } else { ViewBag.Success = "User Name or Verification Code is Wrong...."; } } ModelState.Clear(); } return(View()); } catch (Exception ex) { return(View(ex)); } }
public ActionResult ForgetPassword(string Email) { try { using (var context = new JustHallAtumationEntities()) { var result = context.Users.Where(x => x.UserEmail == Email).FirstOrDefault(); if (result != null) /// Email Address is exist { ViewBag.Success = "Your Password has been sent to your email!"; var resetPassword = Guid.NewGuid().ToString(); int EncryptedPassword = loginRegistrationOperation.HashFunction(resetPassword); result.Password = EncryptedPassword; context.SaveChanges(); loginRegistrationOperation.SendEmail(Email, "Forget Password", resetPassword); } else { ViewBag.Success = "Email is Invalid!"; } } return(View()); } catch (Exception ex) { return(View(ex)); } }
public ActionResult Search() { try { SearchingModel searchingModel = new SearchingModel(); using (var context = new JustHallAtumationEntities()) { var result = (from u in context.Users join s in context.Students on u.UserId equals s.UserId join r in context.Rooms on s.RoomId equals r.RoomId select new Searching { user = u, student = s, room = r }).ToList(); searchingModel.searchings = result; searchingModel.search = context.Searches.ToList(); } return(View(searchingModel)); } catch (Exception ex) { return(View(ex)); } }
// To Add Balance to the user Account public int AddBalance(Account model, string AdedBy) // Admin { using (var context = new JustHallAtumationEntities()) { var result = context.Accounts.Where(x => x.UserId == model.UserId).FirstOrDefault(); if (result != null) { result.Balance += model.Balance; Transaction transaction = new Transaction() { UserId = result.UserId, AddedBy = AdedBy, Balance = model.Balance, Date = DateTime.Now }; context.Transactions.Add(transaction); context.SaveChanges(); } else { return(-1); } return(result.UserId); } }
public ActionResult InsertUserDepartmentInfo() { try { DepartmentInfoModel departmentInfoModel = new DepartmentInfoModel(); using (var context = new JustHallAtumationEntities()) // To get Dropdown list for Department Name or Id { var user = context.Users.Where(x => x.UserName == User.Identity.Name).FirstOrDefault(); var std = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault(); if (std == null) { return(RedirectToAction("InsertStudentInfo", "InsertInformation")); } var add = context.DepartmentInfoes.Where(x => x.StudentId == std.StudentId).FirstOrDefault(); if (add != null) { return(RedirectToAction("InsertAddress")); } departmentInfoModel.department = context.Departments.ToList(); } return(View(departmentInfoModel)); } catch (Exception ex) { return(View(ex)); } }
// To Get The Specific User Account public Account GetUserAccount(int UserId) // User Id { using (var context = new JustHallAtumationEntities()) { var result = context.Accounts.Where(x => x.UserId == UserId).FirstOrDefault(); return(result); } }
// To Get Room of User by StudentId public Room GetRoomOfUser(int StudentId) { using (var context = new JustHallAtumationEntities()) { var student = context.Students.Where(x => x.StudentId == StudentId).FirstOrDefault(); var result = context.Rooms.Where(x => x.RoomId == student.RoomId).FirstOrDefault(); return(result); } }
// To Get Student Id By userName info public int GetStudentId(string UserName) { using (var context = new JustHallAtumationEntities()) { var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault(); // To get userId from UserName var student = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault(); // To get Student Id from UserId return(student.StudentId); } }
private List <MyApp.Models.File> GetFileList() { List <MyApp.Models.File> files = new List <MyApp.Models.File>(); using (var context = new JustHallAtumationEntities()) { files = context.Files.ToList(); } return(files); }
public ActionResult Registraion(AdminRegistraionModel model) { try { if (ModelState.IsValid) { using (var context = new JustHallAtumationEntities()) { var regPass = context.AdminRegistrionPasswords.Where(x => x.AdminRegPass.Length > 0).FirstOrDefault(); string RegPass = "******"; if (regPass != null) { RegPass = regPass.AdminRegPass; } if (model.RegistraionPassword.Replace(" ", "") == RegPass.Replace(" ", "")) { var user1 = context.Users.Where(x => x.UserName.Replace(" ", "") == model.UserName.Replace(" ", "") || x.UserEmail.Replace(" ", "") == model.Email.Replace(" ", "")).FirstOrDefault(); if (user1 == null) { User user = new User() { UserName = model.UserName, UserEmail = model.Email, Password = loginRegistrationOperation.HashFunction(model.Password) }; context.Users.Add(user); UsersRole usersRole = new UsersRole() { Role = "Admin", UserId = user.UserId }; context.UsersRoles.Add(usersRole); context.SaveChanges(); ViewBag.Success = "Registraion Completed!"; } else { ViewBag.Success = "User Name or User Email allready exist"; } } else { ViewBag.Success = "Registraion Password is not currect"; } } } return(View()); } catch (Exception ex) { return(View(ex)); } }
// To Insert DepartMent Name public int InsertDepartmentName(Department model) { using (var context = new JustHallAtumationEntities()) { Department department = new Department() { DeptName = model.DeptName }; context.Departments.Add(department); context.SaveChanges(); return(department.DeptId); } }
//insert district name public int InsertDistrictName(District model) { using (var context = new JustHallAtumationEntities()) { District district = new District() { DistrictName = model.DistrictName }; context.Districts.Add(district); context.SaveChanges(); return(district.DistrictId); } }
// To Get All account of users. public List <AllAccountsModel> GetAllAccount() { using (var context = new JustHallAtumationEntities()) { var result = (from s in context.Students join r in context.Rooms on s.RoomId equals r.RoomId select new AllAccountsModel { student = s, room = r }).ToList(); return(result); } }
public ActionResult UploadImage(ImageUploadModel img, HttpPostedFileBase file) { try { string UserName = User.Identity.Name; if (ModelState.IsValid) { if (file == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (file != null) { string path = Path.Combine(Server.MapPath("~/Content/Images"), Path.GetFileName(file.FileName)); file.SaveAs(path); img.ImagePath = file.FileName; } using (var context = new JustHallAtumationEntities()) { var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault(); var image = context.UserImages.Where(x => x.UserId == user.UserId).FirstOrDefault(); if (image == null) { UserImage userImage = new UserImage { UserId = user.UserId, Image = img.ImagePath }; context.UserImages.Add(userImage); context.SaveChanges(); } else { image.Image = img.ImagePath; context.SaveChanges(); } } return(RedirectToAction("Index", "Home")); } return(View(img)); } catch (Exception ex) { return(View(ex)); } }
public ActionResult AllMealAdminRequest() { try { using (var context = new JustHallAtumationEntities()) { var result = context.MealAdminRegs.ToList(); return(View(result)); } } catch (Exception ex) { return(View(ex)); } }
public ActionResult ShowMealAdmins() { try { using (var context = new JustHallAtumationEntities()) { var result = context.MealAdminRegs.Where(x => x.Flag == 1).ToList(); return(View(result)); } } catch (Exception ex) { return(View(ex)); } }
public ActionResult ShowRegistrationForm() { try { using (var context = new JustHallAtumationEntities()) /// 0 for Email is verified 2 for Email is not Verified { var result = context.RegistrationForms.Where(x => x.IsVerified == 0 || x.IsVerified == 2).ToList().OrderBy(x => x.IsVerified); return(View(result)); } } catch (Exception ex) { return(View(ex)); } }
public ActionResult GroupByRoom() { using (var context = new JustHallAtumationEntities()) { var result = (from st in context.Students join room in context.Rooms on st.RoomId equals room.RoomId select new roomGroup { roomNumber = room.RoomNumber.ToString(), student = st, totolSeat = (int)room.TotalSeat }).ToList(); return(View(result)); } }
public ActionResult ShowMealRate() { try { using (var context = new JustHallAtumationEntities()) { var result = context.MealCosts.FirstOrDefault(); return(View(result)); } } catch (Exception ex) { return(View(ex)); } }
// To insert Room Info in Room Table public int InsertRoomInfo(Room model) { using (var context = new JustHallAtumationEntities()) { Room room = new Room() { RoomNumber = model.RoomNumber, TotalSeat = model.TotalSeat, EmptySeat = model.EmptySeat }; context.Rooms.Add(room); context.SaveChanges(); return(room.RoomId); } }
// Filter By Parmanent District public List <AllAccountsModel> GetSpecificDistrictAllStudent(int DistricId) // District Id { using (var context = new JustHallAtumationEntities()) { var result = (from s in context.Students join a in context.Addresses on s.StudentId equals a.StudentId join r in context.Rooms on s.RoomId equals r.RoomId where (a.P_DistrictId == DistricId) select new AllAccountsModel { student = s, room = r }).ToList(); return(result); } }
public ActionResult Index() { try { List <District> districts = new List <District>(); using (var context = new JustHallAtumationEntities()) { districts = context.Districts.ToList(); } return(View(districts)); } catch (Exception ex) { return(View(ex)); } }