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));
}
}
