public static void SetDataFromXls(List <List <SaleInfo> > reports)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <SqlServerEntities, Configuration>());
using (var db = new SqlServerEntities())
{
foreach (var file in reports)
{
foreach (var rep in file)
{
var supermarket = db.Supermarkets.FirstOrDefault(x => x.SupermarketName == rep.Location);
if (supermarket == null)
{
supermarket = new Supermarket {
SupermarketName = rep.Location
};
db.Supermarkets.Add(supermarket);
}
var sale = new Sale
{
ProductId = rep.ProductId,
Supermarket = supermarket,
Date = rep.SaleDate,
Quantity = rep.Quantity,
UnitPrice = rep.UnitPrice,
Sum = rep.Sum
};
db.Sales.Add(sale);
db.SaveChanges();
}
}
}
}
public string updateTareas(Models.clsTareas oClsTareas)
{
try
{
using (var dbContext = new SqlServerEntities())
{
Entidades.tbTareas oTarea = (from q in dbContext.tbTareas
where q.tareCodigo == oClsTareas.inCodigo
select q).FirstOrDefault();
oTarea.tareTitular = oClsTareas.stTitular;
oTarea.tareAsunto = oClsTareas.stAsunto;
oTarea.tareFechaVencimiento = oClsTareas.stFechaVencimiento;
oTarea.tareContacto = oClsTareas.stContacto;
oTarea.tareCuenta = oClsTareas.stCuenta;
oTarea.estaCodigo = oClsTareas.oClsEstado.inEstaCodigo;
oTarea.prioCodigo = oClsTareas.oClsPrioridad.inCodigo;
oTarea.tareEnviarMensaje = oClsTareas.stEnviarMensaje;
oTarea.tareRepetir = oClsTareas.stRepetir;
oTarea.tareDescripcion = oClsTareas.stDescripcion;
dbContext.SaveChanges();
return("Grabación correcta");
}
//using ()
}
catch (Exception ex)
{
throw ex;
}
}
protected List <DTOProdotto> GetByContition(Func <tabProdotti, bool> expression)
{
using (var ctx = new SqlServerEntities())
{
if (!ctx.tabProdotti.Any())
{
var tab = new tabProdotti();
tab.ID = Guid.NewGuid();
tab.Descrizione = "Generico";
tab.DescrizioneBreve = "Generico";
ctx.Entry(tab).State = EntityState.Added;
ctx.SaveChanges();
}
//TODO: linq Kit è più efficente
return(ctx.tabProdotti.Where(x => !x.isDeleted).Where(expression).Select(MapTable).ToList());
}
}
public static void SetData(
List <VendorInformation> vendors,
List <MeasureInformation> measures,
List <ProductInformation> products)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <SqlServerEntities, Configuration>());
using (var db = new SqlServerEntities())
{
foreach (var vend in vendors)
{
db.Vendors.Add(new Vendor
{
VendorId = vend.VendorId,
VendorName = vend.VendorName
});
}
foreach (var meas in measures)
{
db.Measures.Add(new Measure
{
MeasureId = meas.MeasureId,
MeasureName = meas.MeasureName
});
}
foreach (var prod in products)
{
db.Products.Add(new Product
{
ProductName = prod.ProductName,
BasePrice = (decimal)prod.BasePrice,
MeasureId = prod.MeasureId,
VendorId = prod.VendorId
});
}
db.SaveChanges();
}
}
public string deleteTareas(Models.clsTareas oClsTareas)
{
try
{
using (var dbContext = new SqlServerEntities())
{
Entidades.tbTareas oTarea = (from q in dbContext.tbTareas
where q.tareCodigo == oClsTareas.inCodigo
select q).FirstOrDefault();
dbContext.tbTareas.Remove(oTarea);
dbContext.SaveChanges();
return("Grabación correcta");
}
//using ()
}
catch (Exception ex)
{
throw ex;
}
}