public ResponseAgregarTransportista AgregarTransportista(RequestAgregarTransportista request) { ResponseAgregarTransportista response = new ResponseAgregarTransportista(); TransportistaBL tbl = new TransportistaBL(); response = tbl.AgregarTransportista(request); return(response); }
public ResponseAgregarTransportista AgregarTransportista(RequestAgregarTransportista request) { ResponseAgregarTransportista response = new ResponseAgregarTransportista(); TransportistaDA tda = new TransportistaDA(); response = tda.AgregarTransportista(request); return(response); }
public ResponseAgregarTransportista AgregarTransportista(RequestAgregarTransportista request) { ResponseAgregarTransportista response = new ResponseAgregarTransportista(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxANTP"].ToString()); try { SqlCommand com = new SqlCommand("USP_AGREGAR_TRANSPORTISTA", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@Ruc", SqlDbType.VarChar, 15).Value = request.Ruc; com.Parameters.Add("@RazonSocial", SqlDbType.VarChar, 150).Value = request.RazonSocial; com.Parameters.Add("@Email", SqlDbType.VarChar, 100).Value = request.Email; com.Parameters.Add("@telef1", SqlDbType.VarChar, 25).Value = request.Telefono1; com.Parameters.Add("@telef2", SqlDbType.VarChar, 26).Value = request.Telefono2; com.Parameters.Add("@telef3", SqlDbType.VarChar, 27).Value = request.Telefono3; com.Parameters.Add("@Estado", SqlDbType.Bit).Value = request.Estado; com.Parameters.Add("@UsuarioCreacion", SqlDbType.VarChar, 20).Value = request.UsuarioCreacion; con.Open(); com.ExecuteNonQuery(); response.Estado = true; response.Mensaje = "Exitoso"; } catch (Exception ex) { response.Estado = false; response.Mensaje = ex.Message.ToString(); } finally { con.Close(); } return(response); }