internal List <Models.DesgloseCalendario> ObtenerHorasRango(int nIdCal, DateTime dDesde, DateTime dHasta)
{
Models.DesgloseCalendario oDesgloseCalendario = null;
List <Models.DesgloseCalendario> lst = new List <Models.DesgloseCalendario>();
SqlDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[4] {
Param(enumDBFields.nIdCal, nIdCal),
Param(enumDBFields.nAnno, null),
Param(enumDBFields.dDesde, dDesde),
Param(enumDBFields.dHasta, dHasta)
};
dr = cDblib.DataReader("SUP_DESGLOSECALS", dbparams);
while (dr.Read())
{
oDesgloseCalendario = new Models.DesgloseCalendario();
oDesgloseCalendario.t066_idcal = Convert.ToInt32(dr["t066_idcal"]);
oDesgloseCalendario.t067_dia = Convert.ToDateTime(dr["t067_dia"]);
oDesgloseCalendario.t067_horas = Convert.ToSingle(dr["t067_horas"]);
oDesgloseCalendario.t067_festivo = Convert.ToInt32(dr["t067_festivo"]);
lst.Add(oDesgloseCalendario);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
///// <summary>
///// Obtiene todos los DesgloseCalendario
///// </summary>;
internal List <Models.DesgloseCalendario> ObtenerHoras(int nIdCal, int nAnno)
{
Models.DesgloseCalendario oDesgloseCalendario = null;
List <Models.DesgloseCalendario> lst = new List <Models.DesgloseCalendario>();
SqlDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[2] {
Param(enumDBFields.t066_idcal, nIdCal),
Param(enumDBFields.nAnno, nAnno)
};
dr = cDblib.DataReader("SUP_DESGLOSECALENDARIO_IAP30", dbparams);
if (dr.HasRows)
{
while (dr.Read())
{
oDesgloseCalendario = new Models.DesgloseCalendario();
oDesgloseCalendario.t066_idcal = Convert.ToInt32(dr["t066_idcal"]);
oDesgloseCalendario.t067_dia = Convert.ToDateTime(dr["t067_dia"]);
oDesgloseCalendario.t067_horas = Convert.ToSingle(dr["t067_horas"]);
oDesgloseCalendario.t067_horasD = Math.Round(Convert.ToDouble(dr["t067_horas"]), 2);
oDesgloseCalendario.t067_festivo = Convert.ToInt32(dr["t067_festivo"]);
lst.Add(oDesgloseCalendario);
}
}
else
{
/*DateTime objDate = new DateTime(nAnno, 1, 1);
* while (objDate.Year == nAnno)
* {
* oDesgloseCalendario = new Models.DesgloseCalendario();
* oDesgloseCalendario.t066_idcal = nIdCal;
* oDesgloseCalendario.t067_dia = objDate;
* oDesgloseCalendario.t067_horas = 0;
* oDesgloseCalendario.t067_festivo = 0;
*
* lst.Add(oDesgloseCalendario);
* objDate = objDate.AddDays(1);
* }*/
return(null);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
