//Process received messages from PLC S7-1500 and save in SQL Building table
static void writeToBuildingTable(string s)
{
var a = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(s);
long ID = a["BD"];
int FP7count = (int)a["FP7Count"];
string FP7status = a["FP7Status"];
int sumAvai = (int)a["SumAvai"];
using (CarParkingLotEntities data = new CarParkingLotEntities())
{
var item = data.Buildings.Where(p => p.ID == ID).FirstOrDefault();
if (item != null)
{
item.FP7Count = FP7count;
item.FP7Status = FP7status;
item.SumAvail = sumAvai;
data.SaveChanges();
Console.OutputEncoding = System.Text.Encoding.UTF8;
Console.WriteLine("Đã lưu vào CSDL");
}
else
{
Console.OutputEncoding = System.Text.Encoding.UTF8;
Console.WriteLine("Không tìm thấy thông tin Building");
}
}
}
//Check the current status of Building table and update to CarParkingLayout table if necessary
static void UpdateCarParkingLayoutTable(int BuildingID)
{
using (CarParkingLotEntities data = new CarParkingLotEntities())
{
var BuildingTable = data.Buildings.Where(p => p.ID == BuildingID).FirstOrDefault();
if (BuildingTable != null)
{
for (int i = 1; i <= BuildingTable.FP7Count; i++) //Block size
{
var posIndex = 1;
var blockStatus = SplitBlock(BuildingTable.FP7Status, 12).ToList();
foreach (var item in blockStatus[i - 1])
{
int currentStatus = 0;
if (item == '1')
{
currentStatus = 1;
}
else if (item == '2')
{
currentStatus = 2;
}
else if (item == '3')
{
currentStatus = 3;
}
else if (item == '4')
{
currentStatus = 4;
}
var layoutTable = data.CarParkingLayouts.Where(p => p.BuildingID == BuildingID && p.BlockID == i && p.PositionID == posIndex).FirstOrDefault();
if (currentStatus >= 1 && currentStatus <= 4)
{
if (currentStatus != layoutTable.StatusID)
{
if (currentStatus != 1)
{
layoutTable.UserID = null;
layoutTable.LicensePlate = null;
layoutTable.ReservedTime = null;
layoutTable.ArrivalTime = null;
}
}
layoutTable.StatusID = currentStatus;
}
data.SaveChanges();
posIndex++;
}
}
}
}
}
//{“Reserves”:”true”,“BD”:2,“ID”:”0123456727”,”CarCount”:2,”NP”:”59A-99999/67A-77777”,”T”:”1”}
static void writeReservationToCarParkingLayoutTable(string s)
{
var json2dict = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(s);
int buildingID = (int)json2dict["BD"];
string userID = json2dict["ID"];
int numberOfCar = (int)json2dict["CarCount"];
double expiredTime = (double)json2dict["T"];
List <string> licensePlates = new List <string>(); //Used in case numberOfCar > 1
List <CarParkingLayout> reservedCarList = new List <CarParkingLayout>();
string tempStr = json2dict["NP"];
var tempList = tempStr.Split('/').ToList();
foreach (var item in tempList)
{
licensePlates.Add(item);
}
foreach (var item in licensePlates)
{
using (CarParkingLotEntities data = new CarParkingLotEntities())
{
var blackList = data.BlackLists.Where(p => p.LicensePlate == item && p.PhoneNumber == userID).ToList();
var currentAvailable = data.CarParkingLayouts.Where(p => p.BuildingID == buildingID && p.StatusID == 1).FirstOrDefault();
if (currentAvailable != null && blackList.Count == 0)
{
currentAvailable.StatusID = 2;
var searchUserID = data.Users.Where(p => p.Username == userID).FirstOrDefault();
if (searchUserID != null)
{
currentAvailable.UserID = searchUserID.ID;
}
currentAvailable.LicensePlate = item;
currentAvailable.ReservedTime = DateTime.Now;
data.SaveChanges();
//Notify that reservation request is accepted
Console.OutputEncoding = System.Text.Encoding.UTF8;
Console.WriteLine("Đặt chỗ thành công. Số xe {0}. Tài khoản {1}", item, userID);
}
else
{
Console.OutputEncoding = System.Text.Encoding.UTF8;
Console.WriteLine("Đã hết chỗ hoặc tài khoản bị chặn. Số xe {0}. Tài khoản {1}", item, userID);
}
}
}
}