public static void SaveConfiguration(List <Configuration> configurationList)
{
try
{
using (var ctx = new VegaEntities())
{
foreach (var configuration in configurationList)
{
if (configuration.ParameterId == 0)
{
ctx.AppConfigurations.Add(configuration);
ctx.SaveChanges();
continue;
}
ctx.AppConfigurations.Attach(configuration);
var entry = ctx.Entry(configuration);
entry.State = System.Data.Entity.EntityState.Modified;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Logger.Error("ConfigurationManager error: " + ex.Message, ex);
throw;
}
}
public static bool DeleteConfigurationData(Configuration configuration)
{
try
{
using (var ctx = new VegaEntities())
{
ctx.AppConfigurations.Attach(configuration);
var entry = ctx.Entry(configuration);
entry.State = System.Data.Entity.EntityState.Deleted;
ctx.AppConfigurations.Remove(configuration);
var res = ctx.SaveChanges();
if (res <= 0)
{
throw new Exception(string.Format("Row '{0}' didn't deleted!!!!", configuration.Name));
}
return(res > 0);
}
}
catch (Exception ex)
{
Logger.Error("ConfigurationManager error: " + ex.Message, ex);
throw;
}
}