public static Models.Proveedor BuscarProveedor(int pro)
{
try
{
using (var db = new SofiaDb()) {
var proveedor = db.Proveedor.Find(pro);
return(proveedor);
}
}
catch (Exception)
{
throw;
}
}
public static List <Models.Proveedor> Lista()
{
try
{
using (var db = new SofiaDb())
{
var proveedores = db.Proveedor.ToList();
return(proveedores);
}
}
catch (Exception)
{
throw;
}
}
public static bool ActualizarProveedor(Models.Producto pro)
{
try
{
using (var db = new SofiaDb()) {
db.Entry(pro).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
throw;
}
}
public static bool GuardarProveedor(Models.Proveedor pro)
{
try
{
using (var db = new SofiaDb()) {
db.Proveedor.Add(pro);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
throw;
}
}
public SimpleMembershipInitializer()
{
Database.SetInitializer <SofiaDb>(null);
try
{
using (var context = new SofiaDb())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
