public int DoSaveData(FormCollection form, int?ID = null)
{
int identityId = 0;
TEAM saveModel;
using (var db = new RITUAL())
{
if (ID == 0)
{
saveModel = new TEAM();
saveModel.BUD_ID = UserProvider.Instance.User.ID;
saveModel.BUD_DT = DateTime.UtcNow.AddHours(8);
}
else
{
saveModel = db.TEAM.Where(s => s.ID == ID).FirstOrDefault();
}
bool tryStatus = false;
bool status = true;
if (bool.TryParse(form["fSt"], out tryStatus))
{
status = Convert.ToBoolean(form["fSt"]);
}
saveModel.MAP_AREA_ID = Convert.ToInt32(form["area"]);
saveModel.MAP_CITY_ID = Convert.ToInt32(form["city"]);
saveModel.COMPANY_NM = form["companyName"];
saveModel.ADDR = form["addr"];
saveModel.CONTACT = form["contact"];
saveModel.PHONE = form["phone"];
saveModel.SQ = Convert.ToInt32(form["sq"]);
saveModel.DISABLED = status;
saveModel.UP_DT = DateTime.UtcNow.AddHours(8);
saveModel.UP_ID = UserProvider.Instance.User.ID;
PublicMethodRepository.FilterXss(saveModel);
if (ID == 0)
{
db.TEAM.Add(saveModel);
}
else
{
db.Entry(saveModel).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
identityId = (int)saveModel.ID;
}
return(identityId);
}
public void DoDeleteByID(int ID)
{
using (var db = new RITUAL())
{
var data = db.TEAM.Where(s => s.ID == ID).FirstOrDefault();
if (data == null)
{
throw new Exception("[刪除護服務團隊] 查無此訊息，可能已被移除");
}
try
{
db.TEAM.Remove(data);
db.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("[刪除護服務團隊]" + ex.Message);
}
}
}
