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); }