public Boolean ReporteSupervisionNew(ReporteSupervisionBE rsBE) { con.ConnectionString = conection.GetCon(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DOCUMENTO.ReporteSupervisionNew"; bool success; try { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@id_proyecto", rsBE.Id_proyecto); cmd.Parameters.AddWithValue("@id_supervisor", rsBE.Id_supervisor); cmd.Parameters.AddWithValue("@fecha_reporte", rsBE.Fecha_reporte); cmd.Parameters.AddWithValue("@detalles_reporte", rsBE.Detalles_reporte); cmd.Parameters.AddWithValue("@path_scan_reporte", rsBE.Path_scan_reporte); con.Open(); cmd.ExecuteNonQuery(); success = true; } catch (SqlException x) { success = false; throw new Exception(x.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } cmd.Parameters.Clear(); } return(success); }
public ReporteSupervisionBE ListarReporteSupervisionPorId(int idDocumento) { ReporteSupervisionBE rpBE = new ReporteSupervisionBE(); try { con.ConnectionString = conection.GetCon(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DOCUMENTO.ListarReporteSupervisionPorId"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@id_documento", idDocumento); con.Open(); SqlDataReader dtr = cmd.ExecuteReader(); if (dtr.HasRows == true) { dtr.Read(); rpBE.Id_documento = int.Parse(dtr["id_documento"].ToString()); rpBE.Id_proyecto = int.Parse(dtr["id_proyecto"].ToString()); rpBE.Id_supervisor = int.Parse(dtr["id_supervisor"].ToString()); rpBE.Fecha_reporte = Convert.ToDateTime(dtr["fecha_reporte"]); rpBE.Detalles_reporte = dtr["detalles_reporte"].ToString(); rpBE.Path_scan_reporte = dtr["path_scan_reporte"].ToString(); } else { throw new Exception("Error al buscar el documento."); } dtr.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } cmd.Parameters.Clear(); } return(rpBE); }
public Boolean ModificarReporteSupervision(ReporteSupervisionBE rsBE) { return(rsupADO.ModificarReporteSupervision(rsBE)); }
public Boolean ReporteSupervisionNew(ReporteSupervisionBE rsBE) { return(rsupADO.ReporteSupervisionNew(rsBE)); }