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 Dispose()
{
if (this.DB.Database.Connection.State == System.Data.ConnectionState.Open)
{
this.DB.Database.Connection.Close();
}
this.DB.Dispose();
this.DB = null;
}
public TeamDetailsDataModel DoGetDetailsByID(int ID)
{
TeamDetailsDataModel result = new TeamDetailsDataModel();
using (var db = new RITUAL())
{
TEAM data = db.TEAM.Where(w => w.ID == ID).FirstOrDefault();
PublicMethodRepository.HtmlDecode(data);
result.Data = data;
}
return(result);
}
public override void Action(CommandCaller caller, string input, string[] args)
{
try
{
RITUAL ritual = kRPG.ritualByName[args[0]];
PlayerCharacter character = caller.Player.GetModPlayer <PlayerCharacter>(mod);
character.rituals[ritual] = !character.rituals[ritual];
}
catch (KeyNotFoundException)
{
throw new UsageException("Ritual not found: " + args);
}
}
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);
}
}
}
public List <CityModel> GetCityData()
{
List <CityModel> cities = new List <CityModel>();
using (var db = new RITUAL())
{
var citiesSource = db.CITY.ToDictionary(d => d.ID, d => d.CITY_NM);
foreach (var item in citiesSource)
{
CityModel temp = new CityModel()
{
ID = item.Key, Name = item.Value
};
var area = db.AREA.Where(s => s.MAP_CITY_ID == item.Key)
.ToDictionary(d => d.ID, d => d.AREA_NM);
temp.Area = area;
cities.Add(temp);
}
}
return(cities);
}
public TeamListResultModel DoGetList(TeamListFilterModel filterModel)
{
PublicMethodRepository.FilterXss(filterModel);
TeamListResultModel result = new TeamListResultModel();
List <TEAM> data = new List <TEAM>();
using (var db = new RITUAL())
{
try
{
data = db.TEAM.ToList();
//關鍵字搜尋
if (!string.IsNullOrEmpty(filterModel.QueryString))
{
this.ListFilter(filterModel.QueryString, ref data);
}
if (filterModel.CityID.HasValue)
{
this.ListFilterCity(filterModel.CityID.Value, ref data);
}
if (filterModel.AreaID.HasValue)
{
this.ListFilterArea(filterModel.AreaID.Value, ref data);
}
//發佈日期搜尋
//if (!string.IsNullOrEmpty(filterModel.PublishDate))
//{
// this.ListDateFilter(filterModel.PublishDate, ref data);
//}
//前台顯示
//if (!string.IsNullOrEmpty(filterModel.Disable))
//{
// this.ListStatusFilter(filterModel.Disable, "Display", ref data);
//}
//上下架
//if (!string.IsNullOrEmpty(filterModel.Disable))
//{
// this.ListStatusFilter(filterModel.Disable, "Disable", ref data);
//}
//排序
this.ListSort(filterModel.SortColumn, ref data);
PaginationResult pagination;
//分頁
this.ListPageList(filterModel.CurrentPage, ref data, out pagination, filterModel.DoPagination);
result.Pagination = pagination;
foreach (var d in data)
{
PublicMethodRepository.HtmlDecode(d);
}
result.Data = data;
}
catch (Exception ex)
{
throw ex;
}
}
return(result);
}
