public int UpdateMeal(MealUpdateModel model)
{
using (var context = new HallAutomationSystemEntities())
{
var meal = context.Meal.FirstOrDefault(x => x.MealId == model.MealId && x.Date == DateTime.Today);
if (meal == null)
{
return(-3);
}
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);
}
int taka = searchOperation.GetMealCost();
int meal_cost = (meal.Dinnar * taka + meal.Lunch * taka);
accountInformation.decreamentAccountBalance((int)meal.StudentId, (-1) * meal_cost);
int New_Meal_Cost = (model.Dinnar * taka + model.Lunch * taka);
Account account = searchOperation.GetAccount((int)meal.StudentId);
if (New_Meal_Cost > account.Balance)
{
return(-2);
}
meal.Lunch = model.Lunch;
meal.Dinnar = model.Dinnar;
context.SaveChanges();
return(meal.MealId);
}
}
// To Add The User Personal Information into Student Table
public int AddStudentPersonalInfo(StudentModel model, string UserName)
{
using (var context = new HallAutomationSystemEntities())
{
int RoomId = GetRoomId(model.RoomNumber);
if (RoomId == 0) /// If Room Number is not valid
{
return(0);
}
RoomInformation roomInformation = new RoomInformation();
roomInformation.UpdateRoom(RoomId, -1);
Student student = new Student()
{
StudentName = model.StudentName,
FatherName = model.FatherName,
MotherName = model.MotherName,
MobileNumber = model.MobileNumber,
RoomId = RoomId,
UserId = GetUserId(UserName)
};
context.Student.Add(student);
context.SaveChanges();
AccountInformation accountInformation = new AccountInformation();
accountInformation.AddAccount(UserName, student.StudentId);
return(student.StudentId);
}
}
public int AddAddress(AddressModel model, string UserName)
{
using (var context = new HallAutomationSystemEntities())
{
int DistId1 = GetDistrictId(model.Permanent_District_Name);
int DistId2 = GetDistrictId(model.Temporary_District_Name);
if (DistId1 == 0 || DistId2 == 0)
{
return(0);
}
Address address = new Address()
{
P_DistrictId = DistId1,
T_DistrictId = DistId2,
P_VillageName = model.Permanent_Village_Name,
P_PostOffice = model.Permanent_Post_Office,
T_VillageName = model.Temporary_Village_Name,
T_PostOffice = model.Temporary_Post_Office,
StudentId = GetStudentId(UserName)
};
context.Address.Add(address);
context.SaveChanges();
return(address.StudentId);
}
}
public void UpdateRoom(int RoomNumber, int flag)
{
using (var context = new HallAutomationSystemEntities())
{
var room = context.Rooms.FirstOrDefault(x => x.RoomId == RoomNumber);
if (room != null)
{
room.EmptySeat = room.EmptySeat + flag;
}
context.SaveChanges();
}
}
public void decreamentAccountBalance(int StudentId, int taka)
{
using (var context = new HallAutomationSystemEntities())
{
var account = context.Account.FirstOrDefault(x => x.StudentId == StudentId);
if (account != null)
{
account.Balance -= taka;
}
context.SaveChanges();
}
}
public int AddDistrict(DistrictModel model)
{
using (var context = new HallAutomationSystemEntities())
{
District district = new District()
{
DistrictName = model.DistrictName
};
context.District.Add(district);
context.SaveChanges();
return(district.DistrictId);
}
}
public int AddMeal(MealModel model, string UserName)
{
var user = searchOperation.GetUser(UserName);
var student = searchOperation.GetStudent(user.UserId);
var room = searchOperation.GetRoom((int)student.RoomId);
using (var context = new HallAutomationSystemEntities())
{
var meal = context.Meal.FirstOrDefault(x => x.StudentId == student.StudentId);
if (meal != null)
{
return(-3);
}
}
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);
}
Account account = searchOperation.GetAccount(student.StudentId);
int taka = searchOperation.GetMealCost();
int meal_cost = (model.Dinnar * taka + model.Lunch * taka);
if (meal_cost > account.Balance)
{
return(-2);
}
else
{
accountInformation.decreamentAccountBalance(student.StudentId, meal_cost);
}
using (var context = new HallAutomationSystemEntities())
{
Meal meal = new Meal()
{
StudentId = student.StudentId,
RoomNo = room.RoomNumber,
Dinnar = model.Dinnar,
Lunch = model.Lunch,
Time = DateTime.Now.TimeOfDay,
Date = DateTime.Today,
StudentName = student.StudentName
};
context.Meal.Add(meal);
context.SaveChanges();
return(meal.MealId);
}
}
public int AddDepartmentName(DepartmentModel model)
{
using (var context = new HallAutomationSystemEntities())
{
Department department = new Department()
{
DeptName = model.DepartmentName
};
context.Department.Add(department);
context.SaveChanges();
return(department.DeptId);
}
}
public int Operation(RegistrationModel model)
{
using (var context = new HallAutomationSystemEntities())
{
Users user = new Users()
{
UserName = model.UserName,
UserEmail = model.UserEmail,
Password = HashFunction(model.Password)
};
context.Users.Add(user);
context.SaveChanges();
return(user.UserId);
}
}
//To add room information
public int AddRoom(RoomModel model)
{
using (var context = new HallAutomationSystemEntities())
{
Room room = new Room()
{
RoomNumber = model.RoomNumber,
TotalSeat = model.TotalSeat,
EmptySeat = model.EmptySeat
};
context.Rooms.Add(room);
context.SaveChanges();
return(room.RoomId);
}
}
public int AddAccount(string UserName, int StudentId)
{
using (var context = new HallAutomationSystemEntities())
{
Account account = new Account()
{
StudentId = StudentId,
Balance = 0,
Due = 0
};
context.Account.Add(account);
context.SaveChanges();
return(account.StudentId);
}
}
//Address Update from UpdateController
public bool UpdateAddress(AdressUpdateModel model)
{
using (var context = new HallAutomationSystemEntities())
{
var address = context.Address.FirstOrDefault(x => x.StudentId == model.StudentId);
if (address != null)
{
address.P_DistrictId = GetDistrictId(model.Permanent_District_Name);
address.P_PostOffice = model.Permanent_Post_Office;
address.P_VillageName = model.Permanent_Village_Name;
address.T_DistrictId = GetDistrictId(model.Temporary_District_Name);
address.T_PostOffice = model.Temporary_Post_Office;
address.T_VillageName = model.Temporary_Village_Name;
}
context.SaveChanges();
return(true);
}
}
// Student data update from UpdateController
public bool UpdateStudent(StudentUpdateModel model)
{
using (var context = new HallAutomationSystemEntities())
{
var student = context.Student.FirstOrDefault(x => x.StudentId == model.StudentId);
RoomInformation roomInformation = new RoomInformation();
roomInformation.UpdateRoom((int)student.RoomId, 1);
if (student != null)
{
student.StudentName = model.StudentName;
student.FatherName = model.FatherName;
student.MotherName = model.MotherName;
student.MobileNumber = model.MobileNumber;
student.RoomId = (int)GetRoomId(model.RoomNumber);
}
roomInformation.UpdateRoom((int)student.RoomId, -1);
context.SaveChanges();
return(true);
}
}
public int AddStudentDepartmentInformation(StudentDepartmentInformationModel model, string UserName)
{
using (var context = new HallAutomationSystemEntities())
{
int Dept_Name = GetDepartmentId(model.Department_name);
if (Dept_Name == 0)
{
return(0);
}
DepartmentInfo departmentInfo = new DepartmentInfo()
{
DepartmentId = Dept_Name,
StudentId = GetStudentId(UserName),
Session = model.Session,
Cgpa = model.Cgpa
};
context.DepartmentInfo.Add(departmentInfo);
context.SaveChanges();
return(departmentInfo.StudentId);
}
}
public bool UpdateAccount(AccountUpdateModel model)
{
using (var context = new HallAutomationSystemEntities())
{
AddressInformation addressInformation = new AddressInformation();
int id = addressInformation.GetStudentId(model.UserName);
var account = context.Account.FirstOrDefault(x => x.StudentId == id);
if (account != null)
{
if (account.Due > 0)
{
int minus = Math.Min((int)account.Due, (int)model.Balance);
model.Balance -= minus;
account.Due -= minus;
}
account.Balance += model.Balance;
}
context.SaveChanges();
return(true);
}
}