/// <summary> /// Permite Actualizar ciudades en maestro de asignación de informes a usuarios. /// 21/10/2010 Magaly Jiménez /// Modificación: se cambia campo de cod_City por cod_Oficina /// 29/10/2010 Magaly jimenez /// </summary> /// <param name="lid_City_UserRepor"></param> /// <param name="iid_userinforme"></param> /// <param name="scod_City"></param> /// <param name="bCity_UserRepor_Status"></param> /// <param name="sCity_UserRepor_ModiBy"></param> /// <param name="tCity_UserRepor_DateModiBy"></param> /// <returns></returns> public ECity_UserReport ActualizarCityUR(int iid_userinforme, long lcod_Oficina, bool bCity_UserRepor_Status, string sCity_UserRepor_ModiBy, DateTime tCity_UserRepor_DateModiBy) { DCity_UserReport odaCityUR = new DCity_UserReport(); ECity_UserReport oeaCityUserR = odaCityUR.Actualizar_CityUserReport(iid_userinforme, lcod_Oficina, bCity_UserRepor_Status, sCity_UserRepor_ModiBy, tCity_UserRepor_DateModiBy); odaCityUR = null; return(oeaCityUserR); }
/// <summary> /// Permite insertar las ciudades que se seleccionan en el maestro de asignación de informes a ususarios. /// 08/10/2010 Magaly Jiménez /// Modificiacón: se cambia tipo de cod_City por cod_Oficina /// 29/10/2010 Magaly Jiménez /// </summary> /// <param name="iid_userinforme"></param> /// <param name="scod_City"></param> /// <param name="bCity_UserRepor_Status"></param> /// <param name="sCity_UserRepor_CreateBy"></param> /// <param name="tCity_UserRepor_DateBy"></param> /// <param name="sCity_UserRepor_ModiBy"></param> /// <param name="tCity_UserRepor_DateModiBy"></param> /// <returns>oeCityUserReport</returns> public ECity_UserReport RegistrarCityUserReport(int iid_userinforme, long lcod_Oficina, bool bCity_UserRepor_Status, string sCity_UserRepor_CreateBy, DateTime tCity_UserRepor_DateBy, string sCity_UserRepor_ModiBy, DateTime tCity_UserRepor_DateModiBy) { DCity_UserReport odrCityUserReport = new DCity_UserReport(); ECity_UserReport oeCityUserReport = odrCityUserReport.RegistrarCityUserReports(iid_userinforme, lcod_Oficina, bCity_UserRepor_Status, sCity_UserRepor_CreateBy, tCity_UserRepor_DateBy, sCity_UserRepor_ModiBy, tCity_UserRepor_DateModiBy); odrCityUserReport = null; return(oeCityUserReport); }
/// <summary> /// Actualiza ciudades para maestro de asignación de informes a usuario. /// 21/10/2010 Magaly Jiménez /// Modificación: se cambia campo de cod_City por cod_Oficina /// 29/10/2010 Magaly jimenez /// </summary> /// <param name="lid_City_UserRepor"></param> /// <param name="iid_userinforme"></param> /// <param name="scod_City"></param> /// <param name="bCity_UserRepor_Status"></param> /// <param name="sCity_UserRepor_ModiBy"></param> /// <param name="tCity_UserRepor_DateModiBy"></param> /// <returns></returns> public ECity_UserReport Actualizar_CityUserReport(int iid_userinforme, long lcod_Oficina, bool bCity_UserRepor_Status, string sCity_UserRepor_ModiBy, DateTime tCity_UserRepor_DateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_ACTUALIZARCLIE_CITY_USERS_REPORTS", iid_userinforme, lcod_Oficina, bCity_UserRepor_Status, sCity_UserRepor_ModiBy, tCity_UserRepor_DateModiBy); ECity_UserReport oeeaCityUR = new ECity_UserReport(); oeeaCityUR.id_userinforme = iid_userinforme; oeeaCityUR.cod_Oficina = lcod_Oficina; oeeaCityUR.City_UserRepor_Status = bCity_UserRepor_Status; oeeaCityUR.City_UserRepor_ModiBy = sCity_UserRepor_ModiBy; oeeaCityUR.City_UserRepor_DateModiBy = tCity_UserRepor_DateModiBy; return(oeeaCityUR); }
/// <summary> /// inserta información en tabla de city_userReport /// 23/10/2010 Magaly jimenez /// Modificación: se cambia campo de cod_City por cod_Oficina /// 29/10/2010 Magaly jimenez /// </summary> /// <param name="iid_userinforme"></param> /// <param name="lcod_Oficina"></param> /// <param name="bCity_UserRepor_Status"></param> /// <param name="sCity_UserRepor_CreateBy"></param> /// <param name="tCity_UserRepor_DateBy"></param> /// <param name="sCity_UserRepor_ModiBy"></param> /// <param name="tCity_UserRepor_DateModiBy"></param> /// <returns></returns> public ECity_UserReport RegistrarCityUserReports(int iid_userinforme, long lcod_Oficina, bool bCity_UserRepor_Status, string sCity_UserRepor_CreateBy, DateTime tCity_UserRepor_DateBy, string sCity_UserRepor_ModiBy, DateTime tCity_UserRepor_DateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_REGISTER_CITYUSERREPORTS", iid_userinforme, lcod_Oficina, bCity_UserRepor_Status, sCity_UserRepor_CreateBy, tCity_UserRepor_DateBy, sCity_UserRepor_ModiBy, tCity_UserRepor_DateModiBy); ECity_UserReport oerCityUserReport = new ECity_UserReport(); oerCityUserReport.id_userinforme = iid_userinforme; oerCityUserReport.cod_Oficina = lcod_Oficina; oerCityUserReport.City_UserRepor_Status = bCity_UserRepor_Status; oerCityUserReport.City_UserRepor_CreateBy = sCity_UserRepor_CreateBy; oerCityUserReport.City_UserRepor_DateBy = tCity_UserRepor_DateBy; oerCityUserReport.City_UserRepor_ModiBy = sCity_UserRepor_ModiBy; oerCityUserReport.City_UserRepor_DateModiBy = tCity_UserRepor_DateModiBy; return(oerCityUserReport); }