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 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 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 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 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));
}
}
// 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 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));
}
}
//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 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);
}
}
// To Update Meal Rate
public int AddMealRate(MealCost model)
{
using (var context = new JustHallAtumationEntities())
{
var result = context.MealCosts.FirstOrDefault();
if (result == null) // Meal Cost Not Found Add Meal Cost
{
MealCost mealCost = new MealCost()
{
MealCost1 = model.MealCost1
};
context.MealCosts.Add(mealCost);
context.SaveChanges();
return(mealCost.MealCostId);
}
else // OtherWise Update MealCost
{
result.MealCost1 = model.MealCost1;
context.SaveChanges();
return(result.MealCostId);
}
}
}
// 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);
}
}
// To insert Student Department Information
public int InsertUserDepartmentInfo(DepartmentInfoModel model, 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
DepartmentInfo departmentInfo = new DepartmentInfo // One to one relationship with student to deparmentinfo table
{
DepartmentId = model.DepartmentId,
Session = model.Session,
Cgpa = model.Cgpa,
StudentId = student.StudentId
};
context.DepartmentInfoes.Add(departmentInfo);
context.SaveChanges();
return(departmentInfo.StudentId);
}
}
public ActionResult ChanegAdminRegPassword(changePasswordModel 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.currentPassword.Replace(" ", "") == RegPass.Replace(" ", ""))
{
if (regPass == null)
{
AdminRegistrionPassword adminRegistrionPassword = new AdminRegistrionPassword()
{
AdminRegPass = model.newPassword
};
context.AdminRegistrionPasswords.Add(adminRegistrionPassword);
}
else
{
regPass.AdminRegPass = model.newPassword;
}
context.SaveChanges();
ViewBag.Success = "Succesfully Chanegd!";
}
else
{
ViewBag.Success = "Current password don't match with admin registration password!";
}
}
}
return(View());
}
catch (Exception ex)
{
return(View(ex));
}
}
// To Update Meal for individual student
public int Update(Meal Model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
TimeSpan now = DateTime.Now.TimeOfDay;
TimeSpan start = new TimeSpan(00, 0, 0);
TimeSpan End = new TimeSpan(24, 00, 0);
if (!(now >= start && now <= End))
{
return(-1); // Time is over!
}
var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
var student = context.Students.Where(x => x.UserId == user.UserId).FirstOrDefault();
if (student == null)
{
return(-5); // All information must be fill up befor update or add the meals
}
var meal = context.Meals.Where(x => x.Date == DateTime.Today.Date && x.StudentId == student.StudentId).FirstOrDefault(); // Find Meal from database
if (meal == null)
{
return(-2); /// First Add meal
}
int mealRate = context.MealCosts.FirstOrDefault().MealCost1; // To back the money
int backMoney = (meal.Dinnar + meal.Lunch) * mealRate; // Previous cost
int currentCost = (Model.Lunch + Model.Dinnar) * mealRate; // Current Cost
int UserBalance = 0;
var User = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
var UserAccount = context.Accounts.Where(x => x.UserId == User.UserId).FirstOrDefault();
UserBalance = (int)UserAccount.Balance;
if ((backMoney + UserBalance) < currentCost)
{
return(-3); // Insufficient balance
}
UserAccount.Balance = (UserBalance + backMoney - currentCost);
meal.Dinnar = Model.Dinnar;
meal.Lunch = Model.Lunch;
meal.Time = DateTime.Now.TimeOfDay;
meal.Date = DateTime.Today.Date;
context.SaveChanges();
return(meal.MealId);
}
}
public int DepartmentInfoUpdate(DepartMentWithDeptName model)
{
using (var context = new JustHallAtumationEntities())
{
var departmentInfo = context.DepartmentInfoes.Where(x => x.StudentId == (int)model.StudentId).FirstOrDefault();
if (departmentInfo != null)
{
departmentInfo.DepartmentId = model.DepartmentId;
departmentInfo.Cgpa = model.Cgpa;
departmentInfo.Session = model.Session;
}
else
{
return(-1);
}
context.SaveChanges();
return(departmentInfo.StudentId);
}
}
//Insert Address
public int InsertAddress(AddressInfoModel model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
Address address = new Address()
{
StudentId = GetStudentId(UserName),
P_DistrictId = model.P_DistrictId,
P_PostOffice = model.P_PostOffice,
P_VillageName = model.P_VillageName,
T_DistrictId = model.T_DistrictId,
T_PostOffice = model.T_PostOffice,
T_VillageName = model.T_VillageName
};
context.Addresses.Add(address);
context.SaveChanges();
return(address.StudentId);
}
}
public int UserRoleId(string UserName)
{
using (var context = new JustHallAtumationEntities())
{
var user = context.Users.Where(x => x.UserName.Replace(" ", "") == UserName.Replace(" ", "")).FirstOrDefault();
if (user != null)
{
UsersRole usersRole = new UsersRole()
{
Role = "MealAdmin",
UserId = user.UserId
};
context.UsersRoles.Add(usersRole);
context.SaveChanges();
return(usersRole.Id);
}
}
return(-1);
}
// To Insert Student Info in Student Table
public int InsertStudentInfo(StudentInfoModel model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
Student student = new Student()
{
StudentName = model.StudentName,
FatherName = model.FatherName,
MobileNumber = model.MobileNumber,
MotherName = model.MotherName,
RoomId = model.RoomId,
PaymentId = model.PaymentId,
UserId = user.UserId
};
context.Students.Add(student);
context.SaveChanges();
return(student.StudentId);
}
}
//For updating student address
public int AddressInformationUpdate(AddressInfoModel model)
{
using (var context = new JustHallAtumationEntities())
{
var address = context.Addresses.Where(x => x.StudentId == model.StudentId).FirstOrDefault();
if (address != null)
{
address.P_DistrictId = model.P_DistrictId;
address.P_PostOffice = model.P_PostOffice;
address.P_VillageName = model.P_VillageName;
address.T_DistrictId = model.T_DistrictId;
address.T_PostOffice = model.T_PostOffice;
address.T_VillageName = model.T_VillageName;
}
else
{
return(-1);
}
context.SaveChanges();
return(address.StudentId);
}
}
// For updating StudnetInformation
public int StudentInformationUpdate(StudentUpdateModel model)
{
using (var context = new JustHallAtumationEntities())
{
var student = context.Students.Where(x => x.StudentId == model.StudentId).FirstOrDefault();
if (student != null)
{
student.StudentName = model.StudentName;
student.RoomId = model.RoomId;
student.FatherName = model.FatherName;
student.MotherName = model.MotherName;
student.MobileNumber = model.MobileNumber;
student.PaymentId = null;
}
else
{
return(-1);
}
context.SaveChanges();
return(student.StudentId);
}
}
public ActionResult AcceptMealAdmin(int?Id) /// MealAdminRegsId
{
try
{
if (Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var context = new JustHallAtumationEntities())
{
var result = context.MealAdminRegs.Where(x => x.MealAdminRegId == (int)(Id)).FirstOrDefault();
if (result != null)
{
int id = UserRoleId(result.UserName);
if (id == -1)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
result.Flag = 1;
context.SaveChanges();
ViewBag.Success = "Succesfull Accepted!";
}
return(RedirectToAction("AllMealAdminRequest"));
}
else
{
ViewBag.Success = "User is Invalid!";
}
return(RedirectToAction("AllMealAdminRequest"));
}
}
catch (Exception ex)
{
return(View(ex));
}
}
public ActionResult ChangePassword(changePasswordModel model)
{
try
{
if (ModelState.IsValid)
{
using (var context = new JustHallAtumationEntities())
{
string UserName = User.Identity.Name;
var user = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
if (user != null)
{
if (user.Password != loginRegistrationOperation.HashFunction(model.currentPassword))
{
ViewBag.Success = "Current Password doesn't match!";
}
else
{
ViewBag.Success = "Successfull Changed your password!";
user.Password = loginRegistrationOperation.HashFunction(model.newPassword);
context.SaveChanges();
}
}
else
{
ViewBag.Success = "Somethings Wrong!";
}
}
}
return(View());
}
catch (Exception ex)
{
return(View(ex));
}
}
public ActionResult FileUpload(HttpPostedFileBase files, string FileTile)
{
try
{
String FileExt = Path.GetExtension(files.FileName).ToUpper();
if (FileExt == ".PDF")
{
Stream str = files.InputStream;
BinaryReader Br = new BinaryReader(str);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
MyApp.Models.File Fd = new MyApp.Models.File();
Fd.FileTitle = FileTile;
Fd.FileName = files.FileName;
Fd.Date = DateTime.Now.Date;
Fd.FileContent = FileDet;
using (var context = new JustHallAtumationEntities())
{
context.Files.Add(Fd);
context.SaveChanges();
}
return(RedirectToAction("FileUpload"));
}
else
{
ViewBag.FileStatus = "Invalid file format.";
return(View());
}
}
catch (Exception ex)
{
return(View(ex));
}
}
public ActionResult MealAdminRegistraion(MealAdminReg model)
{
try
{
if (ModelState.IsValid)
{
using (var context = new JustHallAtumationEntities())
{
var res = context.MealAdminRegs.Where(x => x.UserName.Replace(" ", "") == User.Identity.Name).FirstOrDefault();
if (res != null)
{
ViewBag.Success = "Already requested!";
}
else
{
MealAdminReg mealAdminReg = new MealAdminReg()
{
UserName = User.Identity.Name,
Name = model.Name,
DepartmentName = model.DepartmentName,
MobileNumber = model.MobileNumber,
Flag = 0
};
context.MealAdminRegs.Add(mealAdminReg);
context.SaveChanges();
ViewBag.Success = "Requeste successfully Submitted!";
}
}
}
return(View());
}
catch (Exception ex)
{
return(View(ex));
}
}
// For Registration Form to verified the user
public int RegistrationFormVerified(RegistrationFormModel model)
{
using (var context = new JustHallAtumationEntities())
{
var user1 = context.RegistrationForms.Where(x => x.UserName == model.UserName.Replace(" ", "") || x.Email == model.Email || x.RollNumber == model.RollNumber).FirstOrDefault();
if (user1 != null)
{
return(-1); // User Name or Email or Roll Number Already Exist
}
RegistrationForm registrationForm = new RegistrationForm
{
UserName = model.UserName,
StudentName = model.StudentName,
DeptName = model.DeptName,
Email = model.Email,
Session = model.Session,
IsVerified = 2, ///still Email Not verified
Password = HashFunction(model.Password.Replace(" ", "")),
RollNumber = model.RollNumber,
Verification = Guid.NewGuid().ToString()
};
string message = "Please Verify Your Email!\n" + "Your Verification Code is : " + registrationForm.Verification + "\n" + " User Name : " + registrationForm.UserName + "\n";
if (SendEmail(model.Email.Replace(" ", ""), "Registration Just Hall", message))
{
context.RegistrationForms.Add(registrationForm);
context.SaveChanges();
return(registrationForm.RegistrationId);
}
else
{
return(-2); /// Email doesn't Exist.
}
}
}
// To Add Meal for Specific User
public int AddMeal(Meal model, string UserName)
{
using (var context = new JustHallAtumationEntities())
{
TimeSpan now = DateTime.Now.TimeOfDay;
TimeSpan start = new TimeSpan(00, 0, 0);
TimeSpan End = new TimeSpan(24, 00, 0);
if (!(now >= start && now <= End))
{
return(-1); // Time is over
}
var mealRate = context.MealCosts.FirstOrDefault();
int MealRate = mealRate.MealCost1;
int UserBalance = 0;
var User = context.Users.Where(x => x.UserName == UserName).FirstOrDefault();
var UserAccount = context.Accounts.Where(x => x.UserId == User.UserId).FirstOrDefault();
UserBalance = (int)UserAccount.Balance;
int TotalMealCost = (model.Dinnar * MealRate) + (model.Lunch * MealRate);
var student = context.Students.Where(x => x.UserId == User.UserId).FirstOrDefault();
if (student == null)
{
return(-5);// Student information must feel up before add meal
}
var room = context.Rooms.Where(x => x.RoomId == student.RoomId).FirstOrDefault();
if (room == null || student == null)
{
return(-5);// Student information must feel up before add meal
}
var meals = context.Meals.Where(x => x.StudentId == student.StudentId && x.Date == DateTime.Today.Date).FirstOrDefault();
if (meals != null)
{
return(-3); // Meal Already Given
}
if (TotalMealCost > UserBalance) // User has not Sufficient Balance
{
return(-2); // Insuffient Balance
}
else
{
UserAccount.Balance = UserAccount.Balance - TotalMealCost;
context.SaveChanges();
}
Meal meal = new Meal()
{
Dinnar = model.Dinnar,
Lunch = model.Lunch,
StudentId = student.StudentId,
StudentName = student.StudentName,
RoomNo = room.RoomNumber,
Time = DateTime.Now.TimeOfDay,
Date = DateTime.Today.Date
};
context.Meals.Add(meal);
context.SaveChanges();
return(meal.MealId);
}
}
