public bool addAdminServices(AdminServices_Entity adminServices) { bool response = false; try { sqlConnection.Open(); sqlCommand = new SqlCommand("add_admin_service", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter p_client_business = new SqlParameter(); p_client_business.ParameterName = "@idClientBusiness"; p_client_business.SqlDbType = SqlDbType.Int; p_client_business.Value = adminServices.clientBusiness.id_client_business; sqlCommand.Parameters.Add(p_client_business); sqlCommand.ExecuteNonQuery(); response = true; } catch (Exception e) { throw; } return(response); }
public int returnIdAdminServices() { int idAdminServices = 0; try { sqlConnection.Open(); sqlCommand = new SqlCommand("return_id_adminServices", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); AdminServices_Entity adminServices = new AdminServices_Entity(); while (sqlDataReader.Read()) { adminServices.id_admin_services = Convert.ToInt32(sqlDataReader["Identificador"]); } idAdminServices = adminServices.id_admin_services; sqlConnection.Close(); } catch (Exception e) { throw; } return(idAdminServices); }
public ActionResult AddAdminServices(string cbxClientBusiness) { AdminServices_Entity admin_services = new AdminServices_Entity(); admin_services.clientBusiness.id_client_business = Convert.ToInt32(cbxClientBusiness); string script = ""; if (contact_Logic.addAdminServices(admin_services)) { script = "<script languaje = 'javascript' > " + "alert('Se registró correctamente');" + "</script>"; } else { script = "<script languaje='javascript'>" + "alert('Administrador NO se pudo agregar');" + "</script>"; } return(Content(script)); }
public bool addAdminServices(AdminServices_Entity adminServices) { return(contact_Data.addAdminServices(adminServices)); }