/// <summary> /// AGREGAR REPORTE /// </summary> /// <param name="oBe"></param> public void P0009SHPR_REPO(BESHMC_REPO oBe) { try { oDa.P0009SHPR_REPO(oBe); } catch (Exception ex) { throw new ArgumentException(ex.Message); } }
public HttpResponseMessage P0009SHPR_REPO(BESHMC_REPO oBe) { var oBr = new BRSHMC_REPO(); try { oBr.P0009SHPR_REPO(oBe); return(Request.CreateResponse(HttpStatusCode.OK, oBe)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
/// <summary> /// GENERAR REPORTE /// </summary> /// <param name="oBe"></param> public void P0009SHPR_REPO(BESHMC_REPO oBe) { try { oDb = oDg.getDataBase(); oCon = oDg.getConnection(); if (oCon.State == ConnectionState.Closed) { oCon.Open(); } using (var obts = oCon.BeginTransaction()) { try { using (var ocmd = oDb.GetStoredProcCommand("P0009SHPR_REPO", oBe.COD_REPO, oBe.COD_VISI, oBe.FEC_REPO, oBe.ALF_REPO, oBe.COD_USUA_CREA, oBe.NUM_ACCI)) { ocmd.CommandTimeout = 2000; oDb.ExecuteNonQuery(ocmd, obts); oBe.COD_REPO = Convert.ToInt32(oDb.GetParameterValue(ocmd, "@P0009COD_REPO")); obts.Commit(); } } catch (Exception ex) { obts.Rollback(); throw new ArgumentException(ex.Message); } } } catch (Exception ex) { throw new ArgumentException(ex.Message); } finally { oCon.Close(); } }