public ResponseRegistroEmpresa insertarEmpresa(ENRegistroEmpresa paramss) { try { string cs = ConfigurationManager.ConnectionStrings["Conexion"].ConnectionString; var lista = new List <ResponseRegistroEmpresa>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_insertarEmpresa", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@razonsocial", paramss.razonsocial)); cmd.Parameters.Add(new SqlParameter("@ruc", paramss.ruc)); cmd.Parameters.Add(new SqlParameter("@email", paramss.email)); cmd.Parameters.Add(new SqlParameter("@idpais", paramss.idpais)); cmd.Parameters.Add(new SqlParameter("@idmoneda", paramss.idmoneda)); cmd.Parameters.Add(new SqlParameter("@direccion", paramss.direccion)); cmd.Parameters.Add(new SqlParameter("@idimpuesto", paramss.idimpuesto)); cmd.Parameters.Add(new SqlParameter("@idporcentaje", paramss.idporcentaje)); cmd.Parameters.Add(new SqlParameter("@vendeimpuestos", paramss.vendeimpuestos)); cmd.Parameters.Add(new SqlParameter("@filename", paramss.filename)); cmd.Parameters.Add(new SqlParameter("@proyecto", paramss.proyecto)); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var resul = new ResponseRegistroEmpresa(); resul.response = Convert.ToString(rdr["response"]); lista.Add(resul); } } } return(lista.FirstOrDefault()); } catch (Exception ex) { throw ex; } }
public ResponseRegistroEmpresa insertarUserAdminEmpresa(ENRegistroEmpresa paramss) { try { string cs = ConfigurationManager.ConnectionStrings["con"].ConnectionString; var lista = new List <ResponseRegistroEmpresa>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_insertarUserAdminEmpresa", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ruc", paramss.ruc)); cmd.Parameters.Add(new SqlParameter("@email", paramss.email)); cmd.Parameters.Add(new SqlParameter("@username", paramss.username)); cmd.Parameters.Add(new SqlParameter("@usuario", paramss.usuario)); cmd.Parameters.Add(new SqlParameter("@contrasena", paramss.contraseƱa)); cmd.Parameters.Add(new SqlParameter("@cargo", paramss.cargo)); cmd.Parameters.Add(new SqlParameter("@cantuser", paramss.cantuser)); cmd.Parameters.Add(new SqlParameter("@proyecto", paramss.proyecto)); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var resul = new ResponseRegistroEmpresa(); resul.response = Convert.ToString(rdr["response"]); lista.Add(resul); } } } return(lista.FirstOrDefault()); } catch (Exception ex) { throw ex; } }
public ResponseRegistroEmpresa activarCuenta(string ruc) { try { string cs = ConfigurationManager.ConnectionStrings["con"].ConnectionString; var lista = new List <ResponseRegistroEmpresa>(); using (SqlConnection conn = new SqlConnection(cs)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_activarCuenta", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ruc", ruc)); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var resul = new ResponseRegistroEmpresa(); resul.response = Convert.ToString(rdr["response"]); lista.Add(resul); } } } return(lista.FirstOrDefault()); } catch (Exception ex) { throw ex; } }