public int ProgramarActividadesRutinarias(string actividadesR, int AUDI_UsuarioEdita)
{
//Formato de actividadesR = HIAR_Interno|HIAR_Interno|HIAR_Interno
int result = 0;
if (actividadesR != "")
{
ProgramacionActividadesDAO progDAO = new ProgramacionActividadesDAO();
HistorialAR historialAR = null;
string[] IDAct = actividadesR.Split('|');
ControlGrupo CG = new ControlGrupo();
foreach (string IDs in IDAct)
{
historialAR = new HistorialAR();
ActividadRDAO actDAO = new ActividadRDAO();
historialAR.HIAR_Interno = Convert.ToInt32(IDs);
//para el numero de la semana
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar cal = dfi.Calendar;
int anio = DateTime.Now.Year;
// System.Windows.Forms.MessageBox.Show(anio.ToString());
int NumSemana = cal.GetWeekOfYear(DateTime.Now.Date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
//System.Windows.Forms.MessageBox.Show(NumSemana.ToString());
//Obtenemos el Id de la semana de programacion
ProgramaSemanal programa = new ProgramaSemanal();
programa.PERI_NumSemana = NumSemana;
programa.PERI_Anio = anio;
ProgramaDAO progSemDAO = new ProgramaDAO();
int IDprog = progSemDAO.ObtenerIDProgramaSemanal(programa);
if (IDprog > 0)
{
historialAR.PERI_Interno = IDprog;
}
else
{
IDprog = progSemDAO.InsertarProgramaSemanal(programa);
if (IDprog > 0)
{
historialAR.PERI_Interno = IDprog;
}
}
//programamos la actividad rutinaria
int res = progDAO.ProgramarActividadesRutinarias(historialAR, AUDI_UsuarioEdita);
if (res > 0)
{
result++;
}
}
return(result);
}
else
{
return(0);
}
}
public int InsertarProgramaSemanal(ProgramaSemanal programa)
{
List <DbParameter> parametros = new List <DbParameter>();
DbParameter param = dpf.CreateParameter();
param.Direction = System.Data.ParameterDirection.InputOutput;
param.DbType = System.Data.DbType.Int32;
if (programa.PERI_Interno == null)
{
param.Value = System.DBNull.Value;
}
else
{
param.Value = programa.PERI_Interno;
}
param.ParameterName = "PERI_Interno";
parametros.Add(param);
DbParameter param1 = dpf.CreateParameter();
param1.DbType = System.Data.DbType.Int32;
param1.Value = programa.PERI_NumSemana;
param1.ParameterName = "PERI_NumSemana";
parametros.Add(param1);
DbParameter param2 = dpf.CreateParameter();
param2.DbType = System.Data.DbType.Int32;
param2.Value = programa.PERI_Anio;
param2.ParameterName = "PERI_Anio";
parametros.Add(param2);
int result = 0;
DbCommand cmd = dpf.CreateCommand();
try
{
if (Connection.State == System.Data.ConnectionState.Closed)
{
Connection.Open();
}
result = EjecuteNonQueryOutID("PA_InsertarProgramaSemanal", parametros, "PERI_Interno");
}
catch (Exception ex)
{
throw new Exception("Error al insertar el programa", ex);
}
finally
{
if (Connection.State == System.Data.ConnectionState.Open)
{
Connection.Close();
}
}
return(result);
}
public int ObtenerIDProgramaSemanal(ProgramaSemanal programa)
{
List <DbParameter> parametros = new List <DbParameter>();
DbParameter param1 = dpf.CreateParameter();
param1.DbType = System.Data.DbType.Int32;
param1.Value = programa.PERI_NumSemana;
param1.ParameterName = "PERI_NumSemana";
parametros.Add(param1);
DbParameter param2 = dpf.CreateParameter();
param2.DbType = System.Data.DbType.Int32;
param2.Value = programa.PERI_Anio;
param2.ParameterName = "PERI_Anio";
parametros.Add(param2);
int result = 0;
DbCommand cmd = dpf.CreateCommand();
try
{
if (Connection.State == System.Data.ConnectionState.Closed)
{
Connection.Open();
}
result = Convert.ToInt32(EjecuteEscalar("PA_ObtenerIDProgramaSemanal", parametros));
}
catch (Exception ex)
{
throw new Exception("Error al obtener el ID Programa", ex);
}
finally
{
if (Connection.State == System.Data.ConnectionState.Open)
{
Connection.Close();
}
}
return(result);
}
