public List <Familia> GetFamilias()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
return(db.Familia.ToList());
}
}
public List <Costos> GetCostos()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
return((List <Costos>)db.Costos.ToList().OrderByDescending(c => c.Categoria).ThenBy(c => c.Id).ToList());
}
}
public List <ReglasFamilia> GetReglasFamilia()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
return(db.ReglasFamilia.ToList());
}
}
public List <Unidades> GetUnidades()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
return(db.Unidades.ToList());
}
}
public List <Propiedades> GetPropiedades()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
return((List <Propiedades>)db.Propiedades.ToList().OrderBy(c => c.Codigo).ToList());
}
}
public DataTable VerificarRutPass(string RutUser, string Pass)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
List <SP_VerifyUserPass_Result> result = db.SP_VerifyUserPass(RutUser, Pass).ToList();
return(new DataTable().ListToDataTable(result));
}
}
public List <ItemCosto> GetItemCostos()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
return(db.ItemCosto.ToList());
}
}
public List <TipoItem> GetTipoItems()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
return(db.TipoItem.ToList());
}
}
public DataTable GetItemsDespendencias(int?idItem)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
List <SP_GetItemDependeceID_Result> result = db.SP_GetItemDependeceID(idItem).ToList();
return(new DataTable().ListToDataTable(result));
}
}
public List <Item> GetItemId(int idItem)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
return((List <Item>)db.Item.ToList()
.Where(c => c.Id == idItem)
.ToList());
}
}
public DataTable ListadoItemsTipoCostoFactorRES(string TipoItem)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
List <SP_ListadoItemTipoCostoFactorRES_Result> result = db.SP_ListadoItemTipoCostoFactorRES(TipoItem).ToList();
return(new DataTable().ListToDataTable(result));
}
}
public List <Item> GetItems()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
return((List <Item>)db.Item.ToList()
.OrderBy(c => c.Codigo)
.ToList());
}
}
public DataTable ListadoItemsResumen()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
List <SP_ListadoItemsResumen_Result> result = db.SP_ListadoItemsResumen().ToList();
return(new DataTable().ListToDataTable(result));
}
}
public DataTable GetItemCostosId(int IdItem)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
List <SP_GetItemCostoID_Result> result = db.SP_GetItemCostoID(IdItem).ToList();
return(new DataTable().ListToDataTable(result));
}
}
public void InsertFamilia(Familia Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
db.Familia.Add(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
public void InsertPropiedad(Propiedades Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
db.Propiedades.Add(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
public void UpdateFamilia(Familia Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
Familia Entidad = (from n in db.Familia
where n.id == Obj.id
select n).FirstOrDefault();
db.Entry(Entidad).CurrentValues.SetValues(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
public DataTable ListadoItemsCostoDetallado()
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
DataTable dt = new DataTable();
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "[dbo].[SP_ListadoItemsCostosDetallado]";
cmd.CommandType = CommandType.StoredProcedure;
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
dt.Load(cmd.ExecuteReader());
return(dt);
}
}
public void InsertCostos(Costos Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
db.Costos.Add(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
public Item InsertItem(Item Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
db.Item.Add(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
return(Obj);
}
}
public void UpdateItemCostoID(int CostoID)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "[dbo].[SP_ActualizarCostosItems]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdCosto", CostoID));
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
cmd.ExecuteNonQuery();
}
}
public void UpdateCostos(Costos Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
Costos Entidad = (from n in db.Costos
where n.Id == Obj.Id
select n).FirstOrDefault();
db.Entry(Entidad).CurrentValues.SetValues(Obj);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
public void DeleteItemCosto(ItemCosto Obj)
{
using (DB_AUTOMATIZACIONEntities db = new DB_AUTOMATIZACIONEntities())
{
try
{
if (db.Database.Connection.State == ConnectionState.Closed)
{
db.Database.Connection.Open();
}
ItemCosto Entidad = (from n in db.ItemCosto
where n.Id == Obj.Id
select n).FirstOrDefault();
db.ItemCosto.Remove(Entidad);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
EntityExceptionError.CatchError(ex);
}
}
}
