public static string Update(string temp)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(temp);
string msg;
Models.Apartment apartment = new Models.Apartment((int)jo["id"], jo["num"].ToString(), jo["name"].ToString(), jo["note"].ToString());
return(Models.BLL.ApartManage.Update(apartment, out msg) ? JsonConvert.SerializeObject(new Packet(200, "修改成功")) : JsonConvert.SerializeObject(new Packet(202, msg)));
}
public static string AddRecord(string apt)
{
string[] strArray = apt.Split(';');
string msg;
Models.Apartment apartment1 = new Models.Apartment(strArray[2], strArray[3], strArray[4]);
return(Models.BLL.ApartManage.Add(apartment1, out msg) ? JsonConvert.SerializeObject(new Packet(200, "插入成功")) : JsonConvert.SerializeObject(new Packet(203, msg)));
}
public static void fillApartments()
{
using (var addData = new ApartmentDB())
{
//Add apartments to table
var apartment = new Models.Apartment
{
ID = 1,
Apartmentnumber = "0101",
IDDoor = 1
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 2,
Apartmentnumber = "0102",
IDDoor = 3
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 3,
Apartmentnumber = "0103",
IDDoor = 5
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 4,
Apartmentnumber = "0201",
IDDoor = 7
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 5,
Apartmentnumber = "0202",
IDDoor = 9
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 6,
Apartmentnumber = "0301",
IDDoor = 11
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 7,
Apartmentnumber = "0302",
IDDoor = 13
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 8,
Apartmentnumber = "Entrance",
IDDoor = 15
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 9,
Apartmentnumber = "Garbageroom",
IDDoor = 16
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 10,
Apartmentnumber = "Laundryroom",
IDDoor = 17
};
addData.Apartments.Add(apartment);
apartment = new Models.Apartment
{
ID = 11,
Apartmentnumber = "Janitor",
IDDoor = 18
};
addData.Apartments.Add(apartment);
addData.SaveChanges();
//Apartments added to table
}
}