public int Insert(Entities.Setting e)
{
DataLayer.Setting setting = new DataLayer.Setting();
setting.SettingName = e.SettingName;
setting.Title = e.Title;
setting.Value = e.Value;
setting.Display = e.Display;
setting.DisplayState = e.DisplayState;
try
{
Context.Settings.InsertOnSubmit(setting);
Context.SubmitChanges();
return(setting.Id);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.INSERT_ERROR);
}
finally
{
}
}
public int Delete(int entityId)
{
try
{
DataLayer.Setting setting = (from u in Context.Settings
where u.Id == entityId
select u).FirstOrDefault();
Context.Settings.DeleteOnSubmit(setting);
Context.SubmitChanges();
return(entityId);
}
catch (Exception ex)
{
Context.Transaction.Rollback();
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.DELETE_ERROR);
}
}
public int Update(Entities.Setting e)
{
DataLayer.Setting setting = (from u in Context.Settings
where u.Id == e.Id
select u).FirstOrDefault();
setting.Value = e.Value;
setting.DisplayState = e.DisplayState;
try
{
Context.SubmitChanges();
return(e.Id);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.UPDATE_ERROR);
}
}
