public async Task <IActionResult> Edit(int id, [Bind("ID,StundetId,LastName,FirstName,RoomType,LivingWithReligious,LivingWithSmoker,ReligiousType,HealthCondition,PartnerId1,PartnerId2,PartnerId3,PartnerId4")] ApprovalKit approvalKit) { if (id != approvalKit.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(approvalKit); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApprovalKitExists(approvalKit.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(approvalKit)); }
public async Task <IActionResult> Create([Bind("StundetId,LastName,FirstName,RoomType,LivingWithReligious,LivingWithSmoker,ReligiousType,HealthCondition,PartnerId1,PartnerId2,PartnerId3,PartnerId4")] ApprovalKit approvalKit) { var functions = new functions(); if (functions.Comper(new DateTime(2019, 9, 5))) { string Aut = HttpContext.Session.GetString("Aut"); ViewBag.Aut = Aut; string Id = HttpContext.Session.GetString("User"); var u = await _context.Registrations.SingleOrDefaultAsync(m => m.StundetId.ToString().Equals(Id)); approvalKit.FirstName = u.FirstName; approvalKit.LastName = u.LastName; approvalKit.StundetId = u.StundetId; approvalKit.Gender = u.gender; try { if (ModelState.IsValid) { //u.Authorization = 9; _context.Add(approvalKit); await _context.SaveChangesAsync(); return(RedirectToAction("Wellcome", "Home")); } } catch (DbUpdateException) { ModelState.AddModelError("", "לא היה ניתן לשמור את השינויים, נא נסה שנית במועד מאוחר יותר"); } return(View(approvalKit)); } return(RedirectToAction("NoMore", "Home")); }
public ActionResult Edit(ApprovalKit Approv) { if (ModelState.IsValid) { Context.ApprovalKit.Save(Approv); return(RedirectToAction("index")); } return(View()); }
public async Task <IActionResult> Create([Bind("ID,StundetId,LastName,FirstName,RoomType,LivingWithReligious,LivingWithSmoker,ReligiousType,HealthCondition,PartnerId1,PartnerId2,PartnerId3,PartnerId4")] ApprovalKit approvalKit) { if (ModelState.IsValid) { _context.Add(approvalKit); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(approvalKit)); }
public static void Initialize(MaonotNetContext context) { context.Database.EnsureCreated(); if (context.Users.Any()) { return; } var users = new User[] { new User { StundetId = 302875125, FirstName = "Miki", LastName = "Rotenstain", Password = BCrypt.Net.BCrypt.HashPassword("ABCabc123!"), Email = "*****@*****.**", Authorization = 2 }, new User { StundetId = 308242122, FirstName = "Efrat", LastName = "Cohen", Password = BCrypt.Net.BCrypt.HashPassword("ABCabc123!"), Email = "*****@*****.**", Authorization = 7 }, new User { StundetId = 123456789, FirstName = "מנהל", LastName = "מערכת", Password = BCrypt.Net.BCrypt.HashPassword("ABCabc123!"), Email = "*****@*****.**", Authorization = 1 } }; foreach (User u in users) { context.Users.Add(u); } context.SaveChanges(); var reg = new Registration[] { new Registration { StundetId = users.Single(u => u.StundetId == 302875125).StundetId, FirstName = users.Single(u => u.StundetId == 302875125).FirstName, LastName = users.Single(u => u.StundetId == 302875125).LastName, gender = Gender.זכר, Bday = DateTime.Parse("1989-11-04"), City = "נשר", Adress = "עמוס 18", PhoneNumber = "050-2480441", FieldOfStudy = FieldStudy.מערכות_מידע, SteadyYear = Year.ג, TypeOfService = Service.צבאי, HealthCondition = HealthCondition.ללא_מגבלה, Seniority = Year.ג, ApertmantType = ApertmantType.יחיד }, // new Registration{StundetId= users.Single(u=> u.StundetId == 308242122).StundetId, FirstName= users.Single(u=> u.StundetId == 308242122).FirstName , LastName= users.Single(u=> u.StundetId == 308242122).LastName,gender=Gender.נקבה, Bday= DateTime.Parse("1992-02-14"), City= "להבים", Adress= "גומא 2",PhoneNumber= "054-6814427", // FieldOfStudy=FieldStudy.מערכות_מידע,SteadyYear=Year.ג, TypeOfService=Service.צבאי, HealthCondition=HealthCondition.ללא_מגבלה, Seniority=Year.ג, ApertmantType= ApertmantType.יחיד}, }; foreach (Registration u in reg) { context.Registrations.Add(u); } context.SaveChanges(); var App = new ApprovalKit[] { new ApprovalKit { StundetId = users.Single(u => u.StundetId == 302875125).StundetId, FirstName = users.Single(u => u.StundetId == 302875125).FirstName, LastName = users.Single(u => u.StundetId == 302875125).LastName, RoomType = RoomType.חדר_ליחיד, LivingWithSmoker = Choose.מעוניין, LivingWithReligious = Choose.לא_מעוניין, ReligiousType = Religious.דרוזי, HealthCondition = HealthCondition.ללא_מגבלה, Gender = reg.Single(r => r.StundetId == 302875125).gender } // new ApprovalKit{StundetId= users.Single(u=> u.StundetId == 308242122).StundetId, FirstName= users.Single(u=> u.StundetId == 308242122).FirstName , LastName= users.Single(u=> u.StundetId == 308242122).LastName, RoomType=RoomType.חדר_ליחיד, // LivingWithSmoker = Choose.לא_מעוניין,LivingWithReligious=Choose.מעוניין, ReligiousType=Religious.יהודי, HealthCondition=HealthCondition.ללא_מגבלה} }; foreach (ApprovalKit u in App) { context.ApprovalKits.Add(u); } context.SaveChanges(); var Aut = new Authorization[] { new Authorization { AutName = "מנהל מערכת" }, //1 new Authorization { AutName = "מנהל" }, //2 new Authorization { AutName = "אבות בית" }, //3 new Authorization { AutName = "ועדת משמעת" }, //4 new Authorization { AutName = "ועדת תרבות" }, //5 new Authorization { AutName = "עובד אבטחה" }, //6 new Authorization { AutName = "אורח" }, //7 new Authorization { AutName = "מועמד" }, //8 new Authorization { AutName = "דייר" } //9 }; foreach (Authorization u in Aut) { context.Authorizations.Add(u); } context.SaveChanges(); var Fault = new FaultForm[] { new FaultForm { StundetId = 308242122, Apartment = 927, RoomNum = RoomNum.OneA, FullName = users.Single(u => u.StundetId == 308242122).FirstName + "" + users.Single(u => u.StundetId == 308242122).LastName, PhoneNumber = "050-2480441", Description = "הבוילר לא עובד לי אשמח לעזרתכם" } }; foreach (FaultForm u in Fault) { context.FaultForms.Add(u); } context.SaveChanges(); var Messg = new Message[] { new Message { From = "ענת לוין", MsgTime = DateTime.Now, Addressee = "אפרת כהן", Subject = "משעמם לי בדירה", Content = "לה לה הלה לה" } }; foreach (Message u in Messg) { context.Messages.Add(u); } context.SaveChanges(); var Vlog = new VisitorsLog[] { new VisitorsLog { VistorName = "דני שובבני", StudentFullName = users.Single(u => u.StundetId == 302875125).FullName, ApartmentNum = 927, Room = RoomNum.OneA, EnteryDate = DateTime.Parse("2018-06-22"), VisitorID = 123456789, StudentId = 302875125 , ExitDate = DateTime.Parse("2018-06-24") } }; foreach (VisitorsLog u in Vlog) { context.VisitorsLogs.Add(u); } context.SaveChanges(); var War = new Warning[] { // new Warning{WarningNumber=WarningNumber.ראשונה, StudentId=users.Single(u=> u.StundetId==302875125).StundetId, Date=DateTime.Parse("2018-05-20")} }; foreach (Warning u in War) { context.Warnings.Add(u); } context.SaveChanges(); }
public static void Initializer(MaonotContext context) { context.Database.EnsureCreated(); if (context.Users.Any()) { return; } var users = new User[] { new User { StundetId = 302875125, FirstName = "Miki", LastName = "Rotenstain", Password = "******", Email = "*****@*****.**" }, new User { StundetId = 308242122, FirstName = "Efrat", LastName = "Cohen", Password = "******", Email = "*****@*****.**" } }; foreach (User u in users) { context.Users.Add(u); } context.SaveChanges(); var reg = new Registration[] { new Registration { StundetId = users.Single(u => u.StundetId == 302875125).StundetId, FirstName = users.Single(u => u.StundetId == 302875125).FirstName, LastName = users.Single(u => u.StundetId == 302875125).LastName, gender = Gender.זכר, Bday = DateTime.Parse("1989-11-04"), City = "נשר", Adress = "עמוס 18", PhoneNumber = "050-2480441", FieldOfStudy = FieldStudy.מערכות_מידע, SteadyYear = Year.ג, TypeOfService = Service.צבאי, HealthCondition = HealthCondition.ללא_מגבלה, Seniority = Year.ג, ApertmantType = ApertmantType.יחיד }, new Registration { StundetId = users.Single(u => u.StundetId == 308242122).StundetId, FirstName = users.Single(u => u.StundetId == 308242122).FirstName, LastName = users.Single(u => u.StundetId == 308242122).LastName, gender = Gender.נקבה, Bday = DateTime.Parse("1992-02-14"), City = "להבים", Adress = "גומא 2", PhoneNumber = "054-6814427", FieldOfStudy = FieldStudy.מערכות_מידע, SteadyYear = Year.ג, TypeOfService = Service.צבאי, HealthCondition = HealthCondition.ללא_מגבלה, Seniority = Year.ג, ApertmantType = ApertmantType.יחיד }, }; foreach (Registration u in reg) { context.Registrations.Add(u); } context.SaveChanges(); var App = new ApprovalKit[] { new ApprovalKit { StundetId = users.Single(u => u.StundetId == 302875125).StundetId, FirstName = users.Single(u => u.StundetId == 302875125).FirstName, LastName = users.Single(u => u.StundetId == 302875125).LastName, RoomType = RoomType.חדר_ליחיד, LivingWithSmoker = Choose.אפשרי, LivingWithReligious = Choose.אפשרי, ReligiousType = Religious.דרוזי, HealthCondition = HealthCondition.ללא_מגבלה }, new ApprovalKit { StundetId = users.Single(u => u.StundetId == 308242122).StundetId, FirstName = users.Single(u => u.StundetId == 308242122).FirstName, LastName = users.Single(u => u.StundetId == 308242122).LastName, RoomType = RoomType.חדר_ליחיד, LivingWithSmoker = Choose.לא_מעוניין, LivingWithReligious = Choose.מעוניין, ReligiousType = Religious.יהודי, HealthCondition = HealthCondition.ללא_מגבלה } }; foreach (ApprovalKit u in App) { context.ApprovalKits.Add(u); } context.SaveChanges(); var Fault = new FaultForm[] { new FaultForm { Apartment = 927, RoomNum = 1, FullName = users.Single(u => u.StundetId == 308242122).FirstName + "" + users.Single(u => u.StundetId == 308242122).LastName, PhoneNumber = "050-2480441", Description = "הבוילר לא עובד לי אשמח לעזרתכם" } }; foreach (FaultForm u in Fault) { context.FaultForms.Add(u); } context.SaveChanges(); var Messg = new Message[] { new Message { Addressee = "*****@*****.**", Subject = "ענת השותפות של מציקות לי", Content = "לענת שלום, השותפות שלי מטריפות אותי מה אפשר לעשות" } }; foreach (Message u in Messg) { context.Messages.Add(u); } context.SaveChanges(); var Vlog = new VisitorsLog[] { new VisitorsLog { VistorName = "דני שובבני", StudentFirstName = users.Single(u => u.StundetId == 302875125).FirstName, StudentLasttName = users.Single(u => u.StundetId == 302875125).LastName, ApartmentNum = 927, Room = RoomNum.OneA, EnteryDate = DateTime.Parse("2018-05-22"), VisitorID = 123456789 } }; foreach (VisitorsLog u in Vlog) { context.VisitorsLogs.Add(u); } context.SaveChanges(); var War = new Warning[] { new Warning { WarningNumber = WarningNumber.ראשונה, StudentId = users.Single(u => u.StundetId == 302875125).StundetId, Date = DateTime.Parse("2018-05-20") } }; foreach (Warning u in War) { context.Warnings.Add(u); } context.SaveChanges(); }
//capacity כמה מקום פנוי יש //The function goes through all the Approval kits and assigning the students to the apartments public async Task <IActionResult> Assigning() { //Couples ApprovalKit List <ApprovalKit> Couples = _context.ApprovalKits.Where( a => a.RoomType == RoomType.דירה_זוגית).ToList(); //Single ApprovalKit List <ApprovalKit> Single = _context.ApprovalKits.Where( r => r.RoomType == RoomType.חדר_ליחיד && r.HealthCondition == HealthCondition.ללא_מגבלה ).ToList(); //Accessible ApprovalKit List <ApprovalKit> Accessible = _context.ApprovalKits.Where( r => r.RoomType == RoomType.חדר_ליחיד && ( r.HealthCondition == HealthCondition.מגבלה_פיזית_אחרת || r.HealthCondition == HealthCondition.נכה_צהל || r.HealthCondition == HealthCondition.נכות) ).ToList(); //Couples foreach (ApprovalKit a in Couples) { var asaing = await _context.Assigning.SingleOrDefaultAsync(u => u.StundetId.Value == a.StundetId.Value); if (asaing == null) { //a main student || c main student parnter if (a.PartnerId1 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId.Value == a.PartnerId1.Value); //find the partner of the main student if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value) { //get empty apartment var apartment = await _context.Apartments.FirstOrDefaultAsync(m => m.Type.Equals("Couples") && m.capacity == 2); if (apartment != null) { apartment.capacity = 0; _context.Update(apartment); // the user obj of a var u1 = await _context.Users.SingleOrDefaultAsync(m => m.StundetId == a.StundetId); //the user obj of c var u2 = await _context.Users.SingleOrDefaultAsync(m => m.StundetId == c.StundetId); Assigning p1 = new Assigning { StundetId = a.StundetId.Value, ApartmentNum = apartment.ApartmentNum, Room = 1 }; u1.ApartmentNum = apartment.ApartmentNum; u1.Room = RoomNum.OneA; _context.Update(u1); Assigning p2 = new Assigning { StundetId = c.StundetId.Value, ApartmentNum = apartment.ApartmentNum, Room = 2 }; u2.ApartmentNum = apartment.ApartmentNum; u2.Room = RoomNum.TwoA; _context.Update(u2); _context.Add(p1); _context.Add(p2); await _context.SaveChangesAsync(); } } ; } ; //if there is no partner } } ; } ; //Accessible foreach (ApprovalKit a in Accessible) { var asaing = await _context.Assigning.SingleOrDefaultAsync(u => u.StundetId.Value == a.StundetId.Value); if (asaing == null) { ApprovalKit[] roomies = new ApprovalKit[3]; roomies[0] = a; int size = 1; if (a.PartnerId1 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId.Value == a.PartnerId1.Value && m.Gender == a.Gender); if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value || c.PartnerId2.Value == a.StundetId.Value) { roomies[1] = c; size++; } ; } ; } ; if (a.PartnerId2 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId == a.PartnerId2.Value && m.Gender == a.Gender); if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value || c.PartnerId2.Value == a.StundetId.Value) { roomies[2] = c; size++; } ; } ; } ; //change proprties of apartment var apartment = await _context.Apartments.FirstOrDefaultAsync(m => m.Type.Equals("Accessible") && m.capacity == 3); if (apartment != null) { int c = apartment.capacity.Value; apartment.LivingWithReligious = a.LivingWithReligious; apartment.LivingWithSmoker = a.LivingWithSmoker; apartment.Gender = a.Gender; apartment.capacity = apartment.capacity - size; _context.Update(apartment); await _context.SaveChangesAsync(); // save proprties of roomeis foreach (ApprovalKit u in roomies) { if (u != null) { var user = await _context.Users.SingleOrDefaultAsync(m => m.StundetId == u.StundetId.Value); Assigning r = new Assigning { StundetId = u.StundetId.Value, ApartmentNum = apartment.ApartmentNum, Room = c, }; user.ApartmentNum = apartment.ApartmentNum; if (r.Room == 1) { user.Room = RoomNum.OneA; } else if (r.Room == 2) { user.Room = RoomNum.TwoA; } else if (r.Room == 3) { user.Room = RoomNum.ThreeA; } else { user.Room = RoomNum.FourA; } _context.Update(user); _context.Add(r); await _context.SaveChangesAsync(); c--; } ; } ; } } ; } ; //Single foreach (ApprovalKit a in Single) { var asaing = await _context.Assigning.FirstOrDefaultAsync(x => x.StundetId.Value == a.StundetId.Value); if (asaing == null) { ApprovalKit[] roomies = new ApprovalKit[4]; roomies[0] = a; int size = 1; if (a.PartnerId1 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId.Value == a.PartnerId1.Value && m.Gender == a.Gender); if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value || c.PartnerId2.Value == a.StundetId.Value || c.PartnerId3.Value == a.StundetId.Value) { roomies[1] = c; size++; } ; } ; } ; if (a.PartnerId2 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId.Value == a.PartnerId2.Value && m.Gender == a.Gender); if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value || c.PartnerId2.Value == a.StundetId.Value || c.PartnerId3.Value == a.StundetId.Value) { roomies[2] = c; size++; } } ; } ; if (a.PartnerId3 != null) { var c = await _context.ApprovalKits.SingleOrDefaultAsync(m => m.StundetId == a.PartnerId3.Value && m.Gender == a.Gender); if (c != null) { if (c.PartnerId1.Value == a.StundetId.Value || c.PartnerId2.Value == a.StundetId.Value || c.PartnerId3.Value == a.StundetId.Value) { roomies[3] = c; size++; } } } ; Apartments apartment = await _context.Apartments.FirstOrDefaultAsync(m => m.capacity >= size && m.Type.Equals("Single") && m.LivingWithReligious == a.LivingWithReligious && m.LivingWithSmoker == a.LivingWithSmoker && m.ReligiousType == a.ReligiousType && m.Gender == a.Gender); if (apartment == null) { apartment = _context.Apartments.FirstOrDefault(m => m.capacity >= size && m.Type.Equals("Single")); } ; if (apartment != null) { int c = apartment.capacity.Value; apartment.LivingWithReligious = a.LivingWithReligious; apartment.LivingWithSmoker = a.LivingWithSmoker; apartment.Gender = a.Gender; apartment.capacity = apartment.capacity - size; apartment.ReligiousType = a.ReligiousType; _context.Update(apartment); await _context.SaveChangesAsync(); foreach (ApprovalKit u in roomies) { if (u != null) { var user = await _context.Users.SingleOrDefaultAsync(m => m.StundetId == u.StundetId); Assigning r = new Assigning { StundetId = u.StundetId.Value, ApartmentNum = apartment.ApartmentNum, Room = c, }; user.ApartmentNum = apartment.ApartmentNum; if (r.Room == 1) { user.Room = RoomNum.OneA; } else if (r.Room == 2) { user.Room = RoomNum.TwoA; } else if (r.Room == 3) { user.Room = RoomNum.ThreeA; } else { user.Room = RoomNum.FourA; } _context.Update(user); _context.Add(r); await _context.SaveChangesAsync(); c--; } ; //end if u!=null } ; //end foreach roomies }// apartment!=null } ; //assing==null } ; //foreach approval kit //await _context.SaveChangesAsync(); //ViewBag.NotAssigning = Globals.NotAssigning; return(RedirectToAction("NotAssigning", "Apartments")); }