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); } }
// 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 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); } }
public List <Meal> GetAllMeals() { using (var context = new HallAutomationSystemEntities()) { var mealList = context.Meal.Where(x => x.Date == DateTime.Today).ToList(); return(mealList); } }
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 GetMealCost(int id = 1) { using (var context = new HallAutomationSystemEntities()) { var mealcost = context.MealCost.FirstOrDefault(x => x.MealCostId == id); if (mealcost != null) { return(mealcost.MealCost1); } else { return(-1); } } }
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); } }
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); } }
// To get the Room Id by using Room Number. public int GetRoomId(int RoomNumber) { using (var context = new HallAutomationSystemEntities()) { var room = context.Rooms.FirstOrDefault(x => x.RoomNumber == RoomNumber); if (room != null) { return(room.RoomId); } else { return(0); } } }
public int GetDepartmentId(string DeptName) { using (var context = new HallAutomationSystemEntities()) { var department = context.Department.FirstOrDefault(x => x.DeptName == DeptName); if (department != null) { return(department.DeptId); } else { return(0); } } }
// To get the User Id by using User Name from Session public int GetUserId(string UserName) { using (var context = new HallAutomationSystemEntities()) { var user = context.Users.FirstOrDefault(x => x.UserName == UserName); if (user != null) { return(user.UserId); } else { return(0); } } }
/// <summary> /// To Get District Id by Using District Name /// </summary> /// <param name="DistrictName"></param> /// <returns>District Id</returns> public int GetDistrictId(string DistrictName) { using (var context = new HallAutomationSystemEntities()) { var district = context.District.FirstOrDefault(x => x.DistrictName == DistrictName); if (district != null) { return(district.DistrictId); } else { return(0); } } }
// Get a row from meal table by using StudentId public Meal GetMeal(int StudentId) { using (var context = new HallAutomationSystemEntities()) { var meal = context.Meal.FirstOrDefault(x => x.StudentId == StudentId && x.Date == DateTime.Today); if (meal != null) { return(meal); } else { //meal.StudentId = -1; return(meal); } } }
// Get a row from Department table by using DepartmentId public Department GetDepartment(int DepartmentId) { using (var context = new HallAutomationSystemEntities()) { var department = context.Department.FirstOrDefault(x => x.DeptId == DepartmentId); if (department != null) { return(department); } else { //department.DeptId = -1; return(department); } } }
public bool LoginOperation(LoginModel model) { using (var context = new HallAutomationSystemEntities()) { var user = context.Users.FirstOrDefault(x => x.UserName == model.UserName); int password = emp.HashFunction(model.Password); if (password == user.Password) { return(true); } else { return(false); } } }
public Account GetAccount(int StudentId) { using (var context = new HallAutomationSystemEntities()) { var account = context.Account.FirstOrDefault(x => x.StudentId == StudentId); if (account != null) { return(account); } else { //meal.StudentId = -1; return(account); } } }
// Get a row from Student table by using UserId public Student GetStudent(int UserId) { using (var context = new HallAutomationSystemEntities()) { var student = context.Student.FirstOrDefault(x => x.UserId == UserId); if (student != null) { return(student); } else { //student.StudentId = -1; return(student); } } }
// Get a row from Address table by using StudentId public Address GetAddress(int StudentId) { using (var context = new HallAutomationSystemEntities()) { var address = context.Address.FirstOrDefault(x => x.StudentId == StudentId); if (address != null) { return(address); } else { //address.StudentId = -1; return(address); } } }
// Get a row from Room table by using RoomId public Room GetRoom(int RoomId) { using (var context = new HallAutomationSystemEntities()) { var room = context.Rooms.FirstOrDefault(x => x.RoomId == RoomId); if (room != null) { return(room); } else { //room.RoomId = -1; return(room); } } }
// Get a row from DepartmentInfo table by using StudentId public DepartmentInfo GetDepartmentInfo(int StudentId) { using (var context = new HallAutomationSystemEntities()) { var departmentinfo = context.DepartmentInfo.FirstOrDefault(x => x.StudentId == StudentId); if (departmentinfo != null) { return(departmentinfo); } else { //departmentinfo.DepartmentId = -1; return(departmentinfo); } } }
// Get a row from District Table by using District Id public District GetDistrict(int Districtid) { using (var context = new HallAutomationSystemEntities()) { var district = context.District.FirstOrDefault(x => x.DistrictId == Districtid); if (district != null) { return(district); } else { //district.DistrictId = -1; return(district); } } }
//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); } }
public int GetStudentId(string UserName) { StudentInformation temp = new StudentInformation(); int UserId = temp.GetUserId(UserName); using (var context = new HallAutomationSystemEntities()) { var student = context.Student.FirstOrDefault(x => x.UserId == UserId); if (student != null) { return(student.StudentId); } else { return(0); } } }
// 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); } }