// Start is called before the first frame update
private void Start()
{
dorm = dorm != null ? dorm : Dorm.GetDrom;
showDorm = showDorm != null ? showDorm : GetComponentInParent <ShowDorm>();
backBtn.onClick.AddListener(showDorm.ListServants);
kickOutBtn.onClick.AddListener(KickOut);
}
public bool AddDorm(Dorm dorm)
{
var result = false;
var existingProduct = ExistDormName(dorm.Name);
if (!existingProduct)
{
for (int i = 0; i < dorm.NoOfFloors; i++)
{
dorm.Floors.Add(new Floor()
{
NumberOfRooms = dorm.NoOfRoomsPerFloor, FloorNo = i, RoomsAvaible = dorm.NoOfRoomsPerFloor, PlacesAvaible = dorm.NoOfRoomsPerFloor * dorm.RoomCapacity
});
}
for (int i = 1; i <= dorm.NoOfRoomsPerFloor; i++)
{
foreach (var floor in dorm.Floors)
{
floor.Rooms.Add(new Room()
{
RoomNo = floor.FloorNo * 100 + i, IsAvaible = true, Capacity = dorm.RoomCapacity,
});
}
}
dorm.PlacesAvaible = (int)dorm.NoOfRoomsPerFloor * dorm.RoomCapacity * dorm.NoOfFloors;
dorm.RoomsAvaible = (int)dorm.NoOfRoomsPerFloor * dorm.NoOfFloors;
dormRepository.Add(dorm);
unitOfWork.Commit();
result = true;
}
return(result);
}
public static void Load(HomeSave toLoad)
{
MainHouse.Load(toLoad.HouseLevel);
Dorm.Load(toLoad.DormLevel);
Gym.Load(toLoad.GymLevel);
Kitchen.Load(toLoad.KitchenLevel);
}
/// <summary>
/// 新增寝室信息
/// </summary>
/// <param name="webModel">编辑页视图模型</param>
/// <param name="context">数据库上下文对象</param>
/// <returns></returns>
public static async Task <Dorm> InsertAsync(InformationEditViewModel webModel, ApplicationDbContext context)
{
//Get Foreign Key Association Table Information
//
var building = await context.Building.AsNoTracking().Where(i => i.Id == Convert.ToInt64(webModel.BuildingId)).FirstOrDefaultAsync();
var bunk = await context.Bunk.AsNoTracking().Where(i => i.Id == Convert.ToInt64(webModel.BunkId)).FirstOrDefaultAsync();
//return error
if (building == null || bunk == null)
{
return(new Dorm
{
Id = -1
});
}
Dorm model = InsertModel(webModel);
model.BuildingFK = building.BuildingOID;
model.BuildingId = Convert.ToInt64(webModel.BuildingId);
model.BuildingName = building.Name;
model.Type = building.Type;
model.BunkFK = bunk.BunkOID;
model.BunkId = Convert.ToInt64(webModel.BunkId);
model.BunkName = bunk.Name;
await context.Dorm.AddAsync(model);
return(model);
}
protected void SaveBtn_Click(object sender, EventArgs e)
{
if (DormId == -1)
{
return;
}
using (WebhostEntities db = new WebhostEntities())
{
Dorm dorm = db.Dorms.Where(d => d.id == DormId).Single();
dorm.DormHeadId = Convert.ToInt32(DormHeadSelector.SelectedValue);
dorm.DormParents.Clear();
foreach (int id in DormParentSelector.GroupIds)
{
Faculty faculty = db.Faculties.Where(f => f.ID == id).Single();
dorm.DormParents.Add(faculty);
}
dorm.Students.Clear();
foreach (int id in StudentSelector.GroupIds)
{
Student student = db.Students.Where(s => s.ID == id).Single();
dorm.Students.Add(student);
}
db.SaveChanges();
}
}
public Save(PlayerMain player, Dorm theDorm)
{
Player = player;
Pos = player.transform;
dorm = theDorm;
voreChar = player.VoreChar;
}
public void CreateDorm(Dorm model)
{
Dorm dorm = new Dorm();
Room room;
dorm.DormName = model.DormName;
dorm.DormComfort = model.DormComfort;
dorm.DormNoRooms = model.DormNoRooms;
dorm.DormBedsInRoom = model.DormBedsInRoom;
dorm.DormGender = model.DormGender;
dorm.IsDormForRomanians = model.IsDormForRomanians;
for (int i = 0; i < model.DormNoRooms; i++)
{
room = new Room();
room.BedsInRoom = model.DormBedsInRoom;
if (model.DormGender != "Mixt")
{
room.RoomGender = model.DormGender;
}
room.RoomNo = i + 1;
dorm.Rooms.Add(room);
db.Rooms.Add(room);
}
db.Dorms.Add(dorm);
}
public int AddDorm(Dorm dorm)
{
dorm.Status = (int)DormStatus.none;
dorm.DID = Guid.NewGuid().ToString();
context.Dorm.Add(dorm);
return(context.SaveChanges());
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Dorm dorm = await db.Dorm.FindAsync(id);
db.Dorm.Remove(dorm);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public DormActivityOption(string activityAbbrv, Dorm dorm, double thisPriority, Dorm otherDorm, double otherPriority)
{
ThisDorm = dorm;
OtherDorm = otherDorm;
ActivityAbbrv = activityAbbrv;
Priority = (thisPriority + otherPriority) / 2;
ThisPriority = thisPriority;
OtherPriority = otherPriority;
}
public DormActivityOption(string activityAbbrv, Dorm dorm, double priority)
{
ThisDorm = dorm;
OtherDorm = Dorm.None;
ActivityAbbrv = activityAbbrv;
Priority = priority;
OtherPriority = -1;
ThisPriority = priority;
}
public void Delete(int dormId)
{
var dorm = new Dorm()
{
Id = dormId
};
_dorms.Attach(dorm);
_dorms.Remove(dorm);
}
/// <summary>
/// Update Dorm Entity
/// </summary>
/// <param name="webModel"></param>
/// <param name="model"></param>
private static void UpdateModel(InformationEditViewModel webModel, Dorm model)
{
model.Count = webModel.Count;
model.Floor = webModel.Floor;
model.IsEnabled = (int)webModel.IsEnabled == 1;
model.Name = webModel.Name;
model.ModifiedOn = DateTime.Now;
model.ModifiedId = CurrentUser.UserId;
model.ModifiedBy = CurrentUser.UserOID;
model.ModifiedName = CurrentUser.UserName;
}
public List <Dorm> GetDormList()
{
List <Dorm> dorms = new List <Dorm>();
Dorm dorm = new Dorm();
dorm.Name = "MorChor";
dorms.Add(dorm);
dorm = new Dorm();
dorm.Name = "VK";
dorms.Add(dorm);
return(dorms);
}
public void AddAccomodationRequest(AccomodationRequest model, Student student)
{
Student stud = db.Students.FirstOrDefault(item => item.Id == student.Id);
if (stud.AccomodationRequestId == null)
{
AccomodationRequest accReq = new AccomodationRequest();
foreach (Roommate roommate in model.ArRoommates)
{
if (roommate.FirstName != null)
{
Student studentRoommate = db.Students.FirstOrDefault(item => item.FirstName == roommate.FirstName && item.LastName == roommate.LastName && item.Initial == roommate.Initial);
if (studentRoommate != null)
{
roommate.Student = studentRoommate;
roommate.StudentId = studentRoommate.Id;
accReq.ArRoommates.Add(roommate);
}
}
}
foreach (DormsPreferred dorm in model.ArDorm)
{
if (dorm.DormName != null)
{
Dorm d = db.Dorms.FirstOrDefault(item => item.DormName == dorm.DormName);
if (d != null)
{
dorm.Dorm = d;
dorm.DormId = d.Id;
accReq.ArDorm.Add(dorm);
}
}
}
foreach (RoomPreferred room in model.ArRoom)
{
if (room.RoomNo != null)
{
Room d = db.Rooms.FirstOrDefault(item => item.RoomNo.ToString() == room.RoomNo);
if (d != null)
{
room.Room = d;
room.RoomId = d.Id;
accReq.ArRoom.Add(room);
}
}
}
accReq.LastComfortAccepted = model.LastComfortAccepted;
stud.AccomodationRequest = accReq;
stud.AccomodationRequestId = accReq.Id;
db.AccomodationRequests.Add(accReq);
db.Students.Update(stud);
}
}
public void OnEnable()
{
dorm = dorm != null ? dorm : Dorm.GetDrom;
chooseRace = null;
raceDropdown.value = 0;
raceDropdown.RefreshShownValue();
genderDropdown.value = 0;
genderDropdown.RefreshShownValue();
sortBy.value = 0;
sortBy.RefreshShownValue();
ListServants();
}
public IActionResult AddDorm(Dorm model)
{
if (ModelState.IsValid)
{
_repository.CreateDorm(model);
if (_repository.SaveAll())
{
;
}
return(RedirectToAction("HomePageAdmin", "Admin"));
}
return(View());
}
////// GET: Serach
//public async Task<ActionResult> Index()
//{
// var dorm = db.Dorm.Include(d => d.Dorm_Label).Include(d => d.Person).Include(d => d.Dorm_Picture);
// return View(await dorm.ToListAsync());
//}
// GET: Serach/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Dorm dorm = await db.Dorm.FindAsync(id);
if (dorm == null)
{
return(HttpNotFound());
}
return(View(dorm));
}
//send message to all room
public ActionResult CheckAllRoom(MessageHTML m)
{
MessageLayer memlayer = new MessageLayer();
List <Message> mlist = memlayer.GetMessage();
DormLayer layer = new DormLayer();
Dorm dorm = layer.GetDorm(Session["UserName"].ToString());
int sender_dorm = dorm.Dorm_ID;
int mlistid = mlist.Count;
Message mem = new Message();
RoomLayer RoomDB = new RoomLayer();
List <Room> RoomList = RoomDB.GetStatusRoom(); //only room that have person live
foreach (Room r in RoomList)
{
if (r.Dorm_ID == sender_dorm)
{
PersonLayer PL = new PersonLayer();
List <Person> personoomList = PL.GetPerson();
foreach (Person person in personoomList)
{
if (person.Room_ID == r.Room_ID)
{
mem = new Message();
mem.Receiver_Username = person.Username;
mem.Sender_Username = Session["UserName"].ToString();
mem.MessageID = mlistid + 1;
mem.Title = m.Subject;
mem.Text = m.Message;
mem.Isread = 0;
mem.Date = DateTime.Now.ToString("dd-MM-yyyy") + " " +
DateTime.Today.ToString("HH:mm:ss tt"); //Date + Time
db.Message.Add(mem);
db.SaveChanges();
mlistid++;
}
}
}
}
//return mem.Receiver_Username + " " + mem.Sender_Username + " " +
// " " + mem.Date ;
return(RedirectToAction("index", new
{
action = 1
}));
}
public async Task <ActionResult> Edit([Bind(Include = "Dorm_ID,Name,M_username,Lat,Long,information,Line,Facebook,Instagram,Tel,Address,Deposit,W_minimum,W_Per_Unit,Internet,E_Minimum,E_Per_Unit")] Dorm dorm)
{
if (ModelState.IsValid)
{
db.Entry(dorm).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.Dorm_ID = new SelectList(db.Dorm_Label, "Dorm_ID", "Label_text", dorm.Dorm_ID);
ViewBag.M_username = new SelectList(db.Person, "Username", "Password", dorm.M_username);
ViewBag.Dorm_ID = new SelectList(db.Dorm_Picture, "Dorm_ID", "URL_Picture", dorm.Dorm_ID);
return(View(dorm));
}
public DeluxeJsonResult Save(Dorm dorm)
{
int result = 0;
if (string.IsNullOrEmpty(dorm.DID))
{
result = DormDal.Instance.AddDorm(dorm);
}
else
{
result = DormDal.Instance.UpdateDorm(dorm);
}
return(new DeluxeJsonResult(new { Data = result, State = 200 }));
}
protected void DormSelector_SelectedIndexChanged(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
Dorm dorm = db.Dorms.Where(d => d.id == DormId).Single();
DormHeadSelector.ClearSelection();
DormHeadSelector.SelectedValue = Convert.ToString(dorm.DormHeadId);
DormParentSelector.Clear();
DormParentSelector.AddFaculty(dorm.DormParents.Select(f => f.ID).ToList());
StudentSelector.Clear();
StudentSelector.AddStudent(dorm.Students.Select(s => s.ID).ToList());
}
}
public ActionResult Edit(Dorm dorm, int dorm_id)
{
if (Session["Status"] != null && Session["Status"].ToString() == "Owner")
{
dorm.M_username = Session["UserName"].ToString();
dorm.Tel = "000";
dorm.Address = "111";
var edit = db.Dorm.Find(dorm.Dorm_ID);
edit.Name = dorm.Name;
edit.information = dorm.information;
edit.Line = dorm.Line;
edit.Facebook = dorm.Facebook;
edit.Instagram = dorm.Instagram;
edit.Tel = dorm.Tel;
edit.E_Per_Unit = dorm.E_Per_Unit;
edit.W_Per_Unit = dorm.W_Per_Unit;
edit.Deposit = dorm.Deposit;
edit.Internet = dorm.Internet;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
Response.Write("<script>alert('Dorm Edited')</script>");
return(RedirectToAction("Index", "Home"));
}
Response.Write("<script>alert('Error cannot add new Dorm')</script>");
return(View("Edit"));
}
// GET: Serach/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Dorm dorm = await db.Dorm.FindAsync(id);
if (dorm == null)
{
return(HttpNotFound());
}
ViewBag.Dorm_ID = new SelectList(db.Dorm_Label, "Dorm_ID", "Label_text", dorm.Dorm_ID);
ViewBag.M_username = new SelectList(db.Person, "Username", "Password", dorm.M_username);
ViewBag.Dorm_ID = new SelectList(db.Dorm_Picture, "Dorm_ID", "URL_Picture", dorm.Dorm_ID);
return(View(dorm));
}
public int UpdateDorm(Dorm dorm)
{
int result = 0;
Dorm match = context.Dorm.FirstOrDefault(r => r.DID == dorm.DID);
if (match != null)
{
match.DormNo = dorm.DormNo;
match.DormSize = dorm.DormSize;
match.DormType = dorm.DormType;
match.Phone = dorm.Phone;
match.Remark = dorm.Remark;
match.DormName = dorm.DormName;
context.Entry(match).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges();
}
return(result);
}
public ActionResult AddDorm(Dorm dorm)
{
var dor = db.Dorm.Where(d => d.DormNumber == dorm.DormNumber && d.DormitoryID == dorm.DormitoryID).ToList();
if (dor.Count > 0)
{
//添加失败则返回提示并跳转到上一页
string errorMsg = "<script>alert('该宿舍已存在！');history.go(-1);</script>";
return(Content(errorMsg));
}
else
{
//添加成功则返回到楼宇列表
db.Dorm.Add(dorm);
db.SaveChanges();
return(Content("<script>alert('添加成功！');location.href='/Dormitory/Index';</script>"));
}
}
public ActionResult Create(Dorm dorm)
{
var success = false;
if (ModelState.IsValid)
{
var dbModel = new Domain.Entities.Dorm();
dbModel.InjectFrom(dorm);
success = dormServices.AddDorm(dbModel);
}
if (success)
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Dorm is already in database.";
return(View(dorm));
}
}
public ActionResult EditDorm(Dorm dorm)
{
if (ModelState.IsValid)
{
int res = adminsRepository.EditDorm(dorm);
switch (res)
{
case 1:
TempData["success"] = "新增寝室成功";
break;
case 2:
TempData["error"] = "数据库异常";
break;
case 0:
TempData["success"] = "修改寝室成功";
break;
}
return(RedirectToAction("IndexDorm"));
}
return(View());
}
public DormInfo(Dorm dorm, string name, bool isGirl = true)
{
Dorm = dorm;
IsGirl = isGirl;
Name = name;
}
//Get All Dorm By Email Owner
public static List <Dorm> GetAllListDormOwner(string email)
{
Mydatabase.sql = $"select * from {Helpers.tbDorm},{Helpers.tbDormOwner} where {Helpers.colIdDorm} = {Helpers.colIdOwnerDorm} and {Helpers.colEmailOwnerDorm} = @Email";
List <Dorm> listDorm = new List <Dorm>();
try
{
Mydatabase.OpenConnection();
Mydatabase.cmd.CommandType = CommandType.Text;
Mydatabase.cmd.CommandText = Mydatabase.sql;
Mydatabase.cmd.Parameters.Clear();
Mydatabase.cmd.Parameters.AddWithValue("@Email", email);
Mydatabase.rd = Mydatabase.cmd.ExecuteReader();
while (Mydatabase.rd.Read())
{
Dorm dorm = new Dorm();
int id = Mydatabase.rd.GetInt32(0);
string owner = Mydatabase.rd.GetString(1);
string address = Mydatabase.rd.GetString(2);
string description = Mydatabase.rd.GetString(3);
double price = Mydatabase.rd.GetDouble(4);
double sale = Mydatabase.rd.GetDouble(5);
byte[] image;
if (Mydatabase.rd.GetValue(6).ToString().Equals(""))
{
dorm.Image = new System.Windows.Media.Imaging.BitmapImage(new Uri($"../../images/icon_app.ico", UriKind.RelativeOrAbsolute));
}
else
{
image = (byte[])Mydatabase.rd.GetValue(6);
dorm.Image = Helpers.ConvertByteToImageBitmap(image);
}
int count = Mydatabase.rd.GetInt32(7);
int countLike = Mydatabase.rd.GetInt32(8);
byte wifi = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(9));
byte parking = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(10));
byte television = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(11));
byte bathroom = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(12));
byte aircon = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(13));
byte waterheater = Helpers.ConverBoolToByte(Mydatabase.rd.GetBoolean(14));
int quality = Mydatabase.rd.GetInt16(15);
double size = Mydatabase.rd.GetDouble(16);
dorm.Id = id;
dorm.Owner = owner;
dorm.Address = address;
dorm.Description = description;
dorm.Price = price;
dorm.Sale = sale;
dorm.Count = count;
dorm.CountLike = countLike;
dorm.IsWifi = Helpers.ConvertByteToVisibility(wifi);
dorm.IsParking = Helpers.ConvertByteToVisibility(parking);
dorm.IsTelevision = Helpers.ConvertByteToVisibility(television);
dorm.IsBathroom = Helpers.ConvertByteToVisibility(bathroom);
dorm.IsAirCondiditioner = Helpers.ConvertByteToVisibility(aircon);
dorm.IsWaterHeater = Helpers.ConvertByteToVisibility(waterheater);
dorm.Quality = quality;
dorm.Size = size;
listDorm.Add(dorm);
}
}
catch (Exception e)
{
MessageBox.Show("Error loading List Dorm " + e.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
Mydatabase.rd.Close();
Mydatabase.CloseConnection();
}
return(listDorm);
}
