public bool DeleteData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
bool resultDelete = false;
try
{
using (var context = CreateContext())
{
SystemSetting systemSetting = context.SystemSetting.FirstOrDefault(o => o.SystemSettingID == id);
if (systemSetting == null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Cannot found System Setting data!";
return(resultDelete);
}
context.SystemSetting.Remove(systemSetting);
context.SaveChanges();
resultDelete = true;
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
}
return(resultDelete);
}
public bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.SystemSetting2 systemSettingDto = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.SystemSetting2>();
bool resultUpdate = false;
// Check setting key is null.
if (string.IsNullOrEmpty(systemSettingDto.SettingKey.Trim()))
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Please input Setting Key!";
return(resultUpdate);
}
// Check season is null.
if (string.IsNullOrEmpty(systemSettingDto.Season.Trim()))
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Please select Season!";
return(resultUpdate);
}
try
{
using (var context = CreateContext())
{
SystemSetting systemSetting = null;
if (id < 0)
{
// Check setting key exist.
systemSetting = context.SystemSetting.FirstOrDefault(o => o.SettingKey == systemSettingDto.SettingKey && o.Season == systemSettingDto.Season);
if (systemSetting != null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "System Setting already in database!";
return(resultUpdate);
}
else
{
systemSetting = new SystemSetting();
}
context.SystemSetting.Add(systemSetting);
}
else
{
systemSetting = context.SystemSetting.FirstOrDefault(o => o.SystemSettingID == id);
if (systemSetting == null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Cannot found data!";
return(resultUpdate);
}
}
converter.DTO2DB_UpdateData(systemSettingDto, ref systemSetting);
systemSetting.SettingKey = systemSettingDto.SettingKey;
systemSetting.SettingValue = systemSettingDto.SettingValue;
context.SaveChanges();
dtoItem = converter.DB2DTO_SystemSetting(context.SystemSetting2Mng_SystemSetting_View.FirstOrDefault(o => o.SystemSettingID == systemSetting.SystemSettingID));
resultUpdate = true;
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
}
return(resultUpdate);
}
public void DTO2DB_UpdateData(DTO.SystemSetting2 dtoItem, ref SystemSetting dbItem)
{
AutoMapper.Mapper.Map <DTO.SystemSetting2, SystemSetting>(dtoItem, dbItem);
}