public static ML.Result GetAllEF()
{
ML.Result result = new ML.Result();
try
{
using (DL_EF.ComercioEntities context = new DL_EF.ComercioEntities())
{
var query = context.ProveedorGetAll();
if (query != null)
{
result.Objects = new List <object>();
foreach (var obj in query)
{
ML.Proveedor proveedor = new ML.Proveedor();
proveedor.IdProveedor = obj.IdProveedor;
proveedor.Nombre = obj.Nombre;
result.Objects.Add(proveedor);
}
result.Correct = true;
}
else
{
result.Correct = false;
result.Message = "No se encontraron registros";
}
}
}
catch (Exception e)
{
result.Correct = false;
result.Message = e.Message;
}
return(result);
}
public static ML.Result AddEF(ML.Proveedor proveedor)
{
ML.Result result = new ML.Result();
try
{
using (DL_EF.ComercioEntities context = new DL_EF.ComercioEntities())
{
ObjectParameter idProveedor = new ObjectParameter("IdProveedor", typeof(int));
var query = context.ProveedorAdd(proveedor.Nombre, idProveedor);
if (query >= 1)
{
result.Correct = true;
}
else
{
result.Correct = false;
result.Message = "No se pudo agregar";
}
}
}
catch (Exception e)
{
result.Correct = false;
result.Message = e.Message;
}
return(result);
}
public static ML.Result DeleteEF(ML.Proveedor proveedor)
{
ML.Result result = new ML.Result();
try
{
using (DL_EF.ComercioEntities context = new DL_EF.ComercioEntities())
{
var query = context.ProveedorDelete(proveedor.IdProveedor);
if (query >= 1)
{
result.Correct = true;
}
else
{
result.Correct = false;
result.Message = "No se pudo eliminar";
}
}
}
catch (Exception e)
{
result.Correct = false;
result.Message = e.Message;
}
return(result);
}
public static ML.Result GetByIdEF(ML.Proveedor proveedor)
{
ML.Result result = new ML.Result();
try
{
using (DL_EF.ComercioEntities context = new DL_EF.ComercioEntities())
{
var query = context.ProveedorGetById(proveedor.IdProveedor).FirstOrDefault();
if (query != null)
{
proveedor.Nombre = query.Nombre;
result.Object = proveedor;
result.Correct = true;
}
else
{
result.Correct = false;
result.Message = "No se encontró ningún registro.";
}
}
}
catch (Exception e)
{
result.Correct = false;
result.Message = e.Message;
}
return(result);
}
