public List <ReporteEppBE> ListadoConsumoResumen(DateTime FechaDesde, DateTime FechaHasta)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoResumen");
db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde);
db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>();
ReporteEppBE ReporteEpp;
while (reader.Read())
{
ReporteEpp = new ReporteEppBE();
ReporteEpp.DescNegocio = reader["DescNegocio"].ToString();
ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString();
ReporteEpp.Logo = (byte[])reader["Logo"];
ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString();
ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString());
ReporteEpplist.Add(ReporteEpp);
}
reader.Close();
reader.Dispose();
return(ReporteEpplist);
}
public List <ReporteEppBE> ListadoConsumoMensualSectorResponsable(int Periodo, int IdEmpresaResponsable, int IdUnidadMineraResponsable, int IdAreaResponsable)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoMensualSectorResponsable");
db.AddInParameter(dbCommand, "pPeriodo", DbType.Int32, Periodo);
db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable);
db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable);
db.AddInParameter(dbCommand, "pIdAreaResponsable", DbType.Int32, IdAreaResponsable);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>();
ReporteEppBE ReporteEpp;
while (reader.Read())
{
ReporteEpp = new ReporteEppBE();
ReporteEpp.Periodo = reader["Periodo"].ToString();
ReporteEpp.Mes = reader["Mes"].ToString();
ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString();
ReporteEpp.Logo = (byte[])reader["Logo"];
ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString();
ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString();
ReporteEpp.SectorResponsable = reader["SectorResponsable"].ToString();
ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString());
ReporteEpplist.Add(ReporteEpp);
}
reader.Close();
reader.Dispose();
return(ReporteEpplist);
}
public List <ReporteEppBE> ListadoRegistroEntrega(int IdEmpresaResponsable, int IdUnidadMineraResponsable, DateTime FechaDesde, DateTime FechaHasta)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppRegistroEntrega");
db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable);
db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable);
db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde);
db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>();
ReporteEppBE ReporteEpp;
while (reader.Read())
{
ReporteEpp = new ReporteEppBE();
ReporteEpp.NumeroSolicitud = reader["NumeroSolicitud"].ToString();
ReporteEpp.Numero = reader["Numero"].ToString();
ReporteEpp.Responsable = reader["Responsable"].ToString();
ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString();
ReporteEpp.Logo = (byte[])reader["Logo"];
ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString();
ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString();
ReporteEpp.Cargo = reader["Cargo"].ToString();
ReporteEpp.Fecha = reader["Fecha"].ToString().Substring(0, 10);
ReporteEpp.Cantidad = Int32.Parse(reader["Cantidad"].ToString());
ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString());
ReporteEpplist.Add(ReporteEpp);
}
reader.Close();
reader.Dispose();
return(ReporteEpplist);
}
public List <ReporteEppBE> ListadoPorPersona(int IdEmpresaResponsable, int IdUnidadMineraResponsable, int IdAreaResponsable, int IdPersona, DateTime FechaDesde, DateTime FechaHasta)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppPersona");
db.AddInParameter(dbCommand, "pIdEmpresaResponsable", DbType.Int32, IdEmpresaResponsable);
db.AddInParameter(dbCommand, "pIdUnidadMineraResponsable", DbType.Int32, IdUnidadMineraResponsable);
db.AddInParameter(dbCommand, "pIdAreaResponsable", DbType.Int32, IdAreaResponsable);
db.AddInParameter(dbCommand, "pIdPersonaResponsable", DbType.Int32, IdPersona);
db.AddInParameter(dbCommand, "pFechaDesde", DbType.DateTime, FechaDesde);
db.AddInParameter(dbCommand, "pFechaHasta", DbType.DateTime, FechaHasta);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>();
ReporteEppBE ReporteEpp;
while (reader.Read())
{
ReporteEpp = new ReporteEppBE();
ReporteEpp.RazonSocial = reader["RazonSocial"].ToString();
ReporteEpp.Logo = (byte[])reader["Logo"];
ReporteEpp.DescUnidadMinera = reader["DescUnidadMinera"].ToString();
ReporteEpp.DescArea = reader["DescArea"].ToString();
ReporteEpp.NumeroSolicitud = reader["NumeroSolicitud"].ToString();
ReporteEpp.Numero = reader["Numero"].ToString();
ReporteEpp.Responsable = reader["Responsable"].ToString();
ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString();
ReporteEpp.UnidadMineraResponsable = reader["UnidadMineraResponsable"].ToString();
ReporteEpp.AreaResponsable = reader["AreaResponsable"].ToString();
ReporteEpp.Cargo = reader["Cargo"].ToString();
ReporteEpp.Fecha = reader["Fecha"].ToString().Substring(0, 10);
ReporteEpp.Observacion = reader["Observacion"].ToString();
ReporteEpp.Item = Int32.Parse(reader["Item"].ToString());
ReporteEpp.Codigo = reader["Codigo"].ToString();
ReporteEpp.DescEquipo = reader["DescEquipo"].ToString();
ReporteEpp.FechaVencimiento = reader["FechaVencimiento"].ToString().Substring(0, 10);
ReporteEpp.Cantidad = Int32.Parse(reader["Cantidad"].ToString());
ReporteEpp.Precio = Decimal.Parse(reader["Precio"].ToString());
ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString());
ReporteEpp.DescTipoEntrega = reader["DescTipoEntrega"].ToString();
ReporteEpplist.Add(ReporteEpp);
}
reader.Close();
reader.Dispose();
return(ReporteEpplist);
}
public List <ReporteEppBE> ListadoConsumoMensualEmpresaResponsable(int Periodo)
{
try
{
List <EmpresaBE> lstEmpresa;
List <ReporteEppBE> lstConsumoMensualEmpresa;
lstEmpresa = new EmpresaDL().ListaCombo(Parametros.intTECorporativo);
lstConsumoMensualEmpresa = new ReporteEppDL().ListadoConsumoMensualEmpresaResponsable(Periodo);
List <string> lstMes = new List <string>();
foreach (var item in lstConsumoMensualEmpresa)
{
var Buscar = lstMes.Where(x => x.Contains(item.Mes)).ToList();
if (Buscar.Count == 0)
{
lstMes.Add(item.Mes);
}
}
foreach (string strMes in lstMes)
{
foreach (var ItemEmpresa in lstEmpresa)
{
var Buscar = lstConsumoMensualEmpresa.Where(oB => oB.Mes == strMes && oB.EmpresaResponsable == ItemEmpresa.RazonSocial).ToList();
if (Buscar.Count == 0)
{
ReporteEppBE objE_ReporteEpp = new ReporteEppBE();
objE_ReporteEpp.Periodo = Periodo.ToString();
objE_ReporteEpp.Mes = strMes;
objE_ReporteEpp.EmpresaResponsable = ItemEmpresa.RazonSocial;
objE_ReporteEpp.Total = 0;
lstConsumoMensualEmpresa.Add(objE_ReporteEpp);
}
}
}
return(lstConsumoMensualEmpresa);
}
catch (Exception ex)
{ throw ex; }
}
public List <ReporteEppBE> ListadoConsumoAnualEmpresaResponsable()
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptEppConsumoAnualEmpresaResponsable");
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteEppBE> ReporteEpplist = new List <ReporteEppBE>();
ReporteEppBE ReporteEpp;
while (reader.Read())
{
ReporteEpp = new ReporteEppBE();
ReporteEpp.Periodo = reader["Periodo"].ToString();
ReporteEpp.EmpresaResponsable = reader["EmpresaResponsable"].ToString();
ReporteEpp.Logo = (byte[])reader["Logo"];
ReporteEpp.Total = Decimal.Parse(reader["Total"].ToString());
ReporteEpplist.Add(ReporteEpp);
}
reader.Close();
reader.Dispose();
return(ReporteEpplist);
}
