public NDbResult <List <Lane> > GetPlazaGroupLanes([FromBody] PlazaGroup value)
{
NDbResult <List <Lane> > result;
if (null == value)
{
result = new NDbResult <List <Lane> >();
result.ParameterIsNull();
}
else
{
result = Lane.GetPlazaGroupLanes(value);
}
return(result);
}
public NDbResult <PlazaGroup> SavePlazaGroup([FromBody] PlazaGroup value)
{
NDbResult <PlazaGroup> result;
if (null == value)
{
result = new NDbResult <PlazaGroup>();
result.ParameterIsNull();
}
else
{
result = PlazaGroup.Save(value);
}
return(result);
}
public NDbResult <List <PlazaGroup> > GetTSBPlazaGroups([FromBody] TSB value)
{
NDbResult <List <PlazaGroup> > result;
if (null == value)
{
result = new NDbResult <List <PlazaGroup> >();
result.ParameterIsNull();
}
else
{
result = PlazaGroup.GetTSBPlazaGroups(value);
}
return(result);
}
public void Setup(User user, UserShift userShift, PlazaGroup plazaGroup,
UserShiftRevenue plazaRevenue,
List <LaneAttendance> laneActivities,
DateTime entryDate, DateTime revDate,
Models.RevenueEntry revenueEntry)
{
_user = user;
_userShift = userShift;
_plazaGroup = plazaGroup;
_plazaRevenue = plazaRevenue;
_laneActivities = laneActivities;
_entryDate = entryDate;
_revDate = revDate;
_revenueEntry = revenueEntry;
if (null != _revenueEntry)
{
if (_revenueEntry.RevenueId == string.Empty ||
_revenueEntry.EntryDate == DateTime.MinValue ||
_revenueEntry.RevenueDate == DateTime.MinValue)
{
InitNewReport();
}
}
var model = GetReportModel();
if (null == model ||
null == model.DataSources || model.DataSources.Count <= 0 ||
null == model.DataSources[0] || null == model.DataSources[0].Items)
{
DMT.Windows.MessageBoxWindow msg = new DMT.Windows.MessageBoxWindow();
msg.Owner = Application.Current.MainWindow;
msg.Setup("No result found.", "DMT - Tour of Duty");
if (msg.ShowDialog() == true)
{
this.rptViewer.ClearReport();
}
}
else
{
this.rptViewer.LoadReport(model);
}
}
public NRestResult <List <Plaza> > GetPlazaGroupPlazas(PlazaGroup value)
{
NRestResult <List <Plaza> > ret;
NRestClient client = NRestClient.CreateLocalClient();
if (null == client)
{
ret = new NRestResult <List <Plaza> >();
ret.RestInvalidConfig();
return(ret);
}
if (null != value)
{
ret = client.Execute <List <Plaza> >(RouteConsts.TSB.GetPlazaGroupPlazas.Url, value);
}
else
{
ret = new NRestResult <List <Plaza> >();
ret.ParameterIsNull();
}
return(ret);
}
private void InitTSBAndPlazaAndLanes()
{
if (null == Db)
{
return;
}
if (Db.Table <TSB>().Count() > 0)
{
return; // already exists.
}
TSB item;
PlazaGroup plazaGroup;
Plaza plaza;
Lane lane;
#region DIN DAENG
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "311";
item.TSBNameEN = "DIN DAENG";
item.TSBNameTH = "ดินแดง";
item.Active = true;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup DIN DAENG
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "DD",
PlazaGroupNameEN = "DIN DAENG",
PlazaGroupNameTH = "ดินแดง",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza DIN DAENG 1
plaza = new Plaza()
{
PlazaId = "3101",
PlazaNameEN = "DIN DAENG 1",
PlazaNameTH = "ดินแดง 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "DD01",
LaneType = "MTC",
LaneAbbr = "DD01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "DD02",
LaneType = "MTC",
LaneAbbr = "DD02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "DD03",
LaneType = "A/M",
LaneAbbr = "DD03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 4,
LaneId = "DD04",
LaneType = "ETC",
LaneAbbr = "DD04",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#region Plaza DIN DAENG 2
plaza = new Plaza()
{
PlazaId = "3102",
PlazaNameEN = "DIN DAENG 2",
PlazaNameTH = "ดินแดง 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 11,
LaneId = "DD11",
LaneType = "?",
LaneAbbr = "DD11",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 12,
LaneId = "DD12",
LaneType = "?",
LaneAbbr = "DD12",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 13,
LaneId = "DD13",
LaneType = "?",
LaneAbbr = "DD13",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 14,
LaneId = "DD14",
LaneType = "?",
LaneAbbr = "DD14",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 15,
LaneId = "DD15",
LaneType = "?",
LaneAbbr = "DD15",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 16,
LaneId = "DD16",
LaneType = "?",
LaneAbbr = "DD16",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region SUTHISARN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "312";
item.TSBNameEN = "SUTHISARN";
item.TSBNameTH = "สุทธิสาร";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup SUTHISARN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "SS",
PlazaGroupNameEN = "SUTHISARN",
PlazaGroupNameTH = "สุทธิสาร",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza SUTHISARN
plaza = new Plaza()
{
PlazaId = "3103",
PlazaNameEN = "SUTHISARN",
PlazaNameTH = "สุทธิสาร",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "SS01",
LaneType = "?",
LaneAbbr = "SS01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "SS02",
LaneType = "?",
LaneAbbr = "SS02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "SS03",
LaneType = "?",
LaneAbbr = "SS03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region LAD PRAO
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "313";
item.TSBNameEN = "LAD PRAO";
item.TSBNameTH = "ลาดพร้าว";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup LAD PRAO INBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LP-IN",
PlazaGroupNameEN = "LAD PRAO INBOUND",
PlazaGroupNameTH = "ลาดพร้าว ขาเข้า",
Direction = "IN",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAD PRAO INBOUND
plaza = new Plaza()
{
PlazaId = "3104",
PlazaNameEN = "LAD PRAO INBOUND",
PlazaNameTH = "ลาดพร้าว ขาเข้า",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "LP01",
LaneType = "?",
LaneAbbr = "LP01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "LP02",
LaneType = "?",
LaneAbbr = "LP02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "LP03",
LaneType = "?",
LaneAbbr = "LP03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 4,
LaneId = "LP04",
LaneType = "?",
LaneAbbr = "LP04",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#region PlazaGroup LAD PRAO OUTBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LP-OUT",
PlazaGroupNameEN = "LAD PRAO OUTBOUND",
PlazaGroupNameTH = "ลาดพร้าว ขาออก",
Direction = "OUT",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAD PRAO OUTBOUND
plaza = new Plaza()
{
PlazaId = "3105",
PlazaNameEN = "LAD PRAO OUTBOUND",
PlazaNameTH = "ลาดพร้าว ขาออก",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 21,
LaneId = "LP21",
LaneType = "?",
LaneAbbr = "LP21",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 22,
LaneId = "LP22",
LaneType = "?",
LaneAbbr = "LP22",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 23,
LaneId = "LP23",
LaneType = "?",
LaneAbbr = "LP23",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region RATCHADA PHISEK
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "314";
item.TSBNameEN = "RATCHADA PHISEK";
item.TSBNameTH = "รัชดาภิเษก";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup RATCHADA PHISEK
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "RP",
PlazaGroupNameEN = "RATCHADA PHISEK",
PlazaGroupNameTH = "รัชดาภิเษก",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza RATCHADA PHISEK 1
plaza = new Plaza()
{
PlazaId = "3106",
PlazaNameEN = "RATCHADA PHISEK 1",
PlazaNameTH = "รัชดาภิเษก 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza RATCHADA PHISEK 2
plaza = new Plaza()
{
PlazaId = "3107",
PlazaNameEN = "RATCHADA PHISEK 2",
PlazaNameTH = "รัชดาภิเษก 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region BANGKHEN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "315";
item.TSBNameEN = "BANGKHEN";
item.TSBNameTH = "บางเขน";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup BANGKHEN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "BK",
PlazaGroupNameEN = "BANGKHEN",
PlazaGroupNameTH = "บางเขน",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza BANGKHEN
plaza = new Plaza()
{
PlazaId = "3108",
PlazaNameEN = "BANGKHEN",
PlazaNameTH = "บางเขน",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#endregion
#region Lanes (no data)
#endregion
#endregion
#endregion
#region CHANGEWATTANA
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "316";
item.TSBNameEN = "CHANGEWATTANA";
item.TSBNameTH = "แจ้งวัฒนะ";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup CHANGEWATTANA
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "CW",
PlazaGroupNameEN = "CHANGEWATTANA",
PlazaGroupNameTH = "แจ้งวัฒนะ",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza CHANGEWATTANA 1
plaza = new Plaza()
{
PlazaId = "3109",
PlazaNameEN = "CHANGEWATTANA 1",
PlazaNameTH = "แจ้งวัฒนะ 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza CHANGEWATTANA 2
plaza = new Plaza()
{
PlazaId = "3110",
PlazaNameEN = "CHANGEWATTANA 2",
PlazaNameTH = "แจ้งวัฒนะ 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region LAKSI
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "317";
item.TSBNameEN = "LAKSI";
item.TSBNameTH = "หลักสี่";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup LAKSI INBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LS-IN",
PlazaGroupNameEN = "LAKSI INBOUND",
PlazaGroupNameTH = "หลักสี่ ขาเข้า",
Direction = "IN",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAKSI INBOUND
plaza = new Plaza()
{
PlazaId = "3111",
PlazaNameEN = "LAKSI INBOUND",
PlazaNameTH = "หลักสี่ ขาเข้า",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#region PlazaGroup LAKSI OUTBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LS-OUT",
PlazaGroupNameEN = "LAKSI OUTBOUND",
PlazaGroupNameTH = "หลักสี่ ขาออก",
Direction = "OUT",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAKSI OUTBOUND
plaza = new Plaza()
{
PlazaId = "3112",
PlazaNameEN = "LAKSI OUTBOUND",
PlazaNameTH = "หลักสี่ ขาออก",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region DON MUANG
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "318";
item.TSBNameEN = "DON MUANG";
item.TSBNameTH = "ดอนเมือง";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup DON MUANG
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "DM",
PlazaGroupNameEN = "DON MUANG",
PlazaGroupNameTH = "ดอนเมือง",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza DON MUANG 1
plaza = new Plaza()
{
PlazaId = "3113",
PlazaNameEN = "DON MUANG 1",
PlazaNameTH = "ดอนเมือง 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza DON MUANG 2
plaza = new Plaza()
{
PlazaId = "3114",
PlazaNameEN = "DON MUANG 2",
PlazaNameTH = "ดอนเมือง 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region ANUSORN SATHAN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "319";
item.TSBNameEN = "ANUSORN SATHAN";
item.TSBNameTH = "อนุสรน์สถาน";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup ANUSORN SATHAN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "AS",
PlazaGroupNameEN = "ANUSORN SATHAN",
PlazaGroupNameTH = "อนุสรน์สถาน",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza ANUSORN SATHAN 1
plaza = new Plaza()
{
PlazaId = "3115",
PlazaNameEN = "ANUSORN SATHAN 1",
PlazaNameTH = "อนุสรน์สถาน 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza ANUSORN SATHAN 2
plaza = new Plaza()
{
PlazaId = "3116",
PlazaNameEN = "ANUSORN SATHAN 2",
PlazaNameTH = "อนุสรน์สถาน 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
}
