private void ShowWorkDetails(TB_Work work)
{
var html = "";
if (null == work || work.TB_WorkDetail.Count < 1)
{
html = "<tr><td colspan=\"8\">No equipment(s) exist.</td></tr>";
}
else
{
var cnt = 0;
var n = (int?)null;
foreach (var obj in work.TB_WorkDetail)
{
cnt++;
html += "<tr>" +
"<td style=\"text-align: center;\">" + cnt + "</td>" +
"<td>" + (n == obj.Equipment ? "-" : EquipmentInstance.GetFullNumber(obj.TB_Equipment)) + "</td>" +
"<td class=\"textoverflow\">" + WorkDetailInstance.GetWorkType(obj.Type.Value) + "</td>" +
"<td>" + (n == obj.BookedTerminal ? "-" : obj.TB_Terminal.Number) + "</td>" +
"<td>" + (n == obj.BookedTerminal ? "-" : obj.TB_Terminal.Sim) + "</td>" +
"<td>" + (n == obj.BookedTerminal ? "-" : (n == obj.TB_Terminal.Satellite ? "-" : obj.TB_Terminal.TB_Satellite.CardNo)) + "</td>" +
"<td style=\"text-align: left;\">" + obj.Details + "</td>" +
"<td></td>" +
"</tr>";
}
}
tbodyBody.InnerHtml = html;
}
public PluginCoreConfigure(ProgSettings settings)
{
InitializeComponent();
settings_ = settings;
TB_Work.Text = "" + settings.WorkSeconds;
TB_Play.Text = "" + settings.PlaySeconds;
CB_PlaySounds.IsChecked = settings.Sound;
CB_PauseMusic.IsChecked = settings.PauseMusic;
TB_Work.Focus();
}
public SysModalGlobal.CResutlWebMethod SavetoDB([FromBody] lstSavedata data)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
var result = new SysModalGlobal.CResutlWebMethod();
try
{
var Work = db.TB_Work.ToList();
var WorkMaterials = db.TB_Work_Material.ToList();
var duplicate = (from a in db.TB_Work
where !a.IsDel && a.sName.Trim().ToLower() == data.sName.Trim().ToLower() && a.nWorkID != data.nWorkID
select a).FirstOrDefault();
if (duplicate != null)
{
// result.sStatus = SysGlobal.SysFunc.process_Duplicate;
result.sStatus = STFunction.process_Warning();
result.sMsg = "ลักษณะงานนี้มีในระบบอยู่แล้ว";
return(result);
}
var nWorkID = (Work.Any() ? Work.Max(m => m.nWorkID) : 0) + 1;
if (data.nWorkID == 0)
{
TB_Work a = new TB_Work()
{
sName = data.sName,
nReasonID = data.nReasonID,
sDetail = data.sDetail,
IsActive = data.IsActive,
IsDel = false,
dCreate = DateTime.Now,
sCreateBy = data.sCreateBy,
dUpdate = DateTime.Now,
sUpdateBy = data.sUpdateBy,
};
db.TB_Work.Add(a);
db.SaveChanges();
db = new PTTGSP_DWSContext();
foreach (var per in data.lstWorkMaterial)
{
//data.lstWorkMaterial.Remove(per);
if (per.nWorkID == 0)
{
TB_Work_Material s = new TB_Work_Material();
s.nWorkID = nWorkID;
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
else
{
var edit = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (edit != null)
{
edit.nMaterialID = per.nMaterialID;
edit.nAmount = per.nAmount;
edit.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
}
else
{
var oldnID = (from a in db.TB_Work
where a.nWorkID == data.nWorkID
select a).FirstOrDefault();
if (oldnID != null)
{
oldnID.sName = data.sName;
oldnID.nReasonID = data.nReasonID;
oldnID.sDetail = data.sDetail;
oldnID.IsActive = data.IsActive;
oldnID.IsDel = false;
oldnID.dUpdate = DateTime.Now;
oldnID.sUpdateBy = data.sUpdateBy;
db.SaveChanges();
}
foreach (var per in data.lstWorkMaterial)
{
if (nWorkID != 0)
{
var editdata = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (editdata != null)
{
db.TB_Work_Material.Remove(editdata);
editdata.nAmount = per.nAmount;
editdata.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
foreach (var per in data.lstWorkMaterial)
{
TB_Work_Material s = new TB_Work_Material();
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
db.SaveChanges();
}
result.sStatus = SysFunc.process_Success;
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
