public void PostPersonaxSucursal([FromBody] PersonaxSucursal personaxSucursal) { System.Data.SqlClient.SqlConnection conn; SqlCommand command; conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True"); conn.Open(); SqlParameter IdCedula = new SqlParameter("@IdCedula", System.Data.SqlDbType.Int); IdCedula.Value = personaxSucursal.IdCedula; SqlParameter IdSucursal = new SqlParameter("@IdSucursal", System.Data.SqlDbType.Int); IdSucursal.Value = personaxSucursal.IdSucursal; SqlParameter SalarioHora = new SqlParameter("@SalarioHora", System.Data.SqlDbType.Int); SalarioHora.Value = personaxSucursal.SalarioHora; command = new SqlCommand("insert into PersonaxSucursal(IdCedula,IdSucursal,SalarioHora) VALUES (@IdCedula,@IdSucursal,@SalarioHora)", conn); command.Parameters.Add(IdCedula); command.Parameters.Add(IdSucursal); command.Parameters.Add(SalarioHora); command.ExecuteNonQuery(); conn.Close(); }
public List <PersonaxSucursal> GetAllPersonasxSucursal() { System.Data.SqlClient.SqlConnection conn; SqlCommand command; SqlDataReader read; conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True"); conn.Open(); command = new SqlCommand("SELECT * from PersonaxSucursal where LogicDelete = 0", conn); read = command.ExecuteReader(); List <PersonaxSucursal> ListPersonaxSucursal = new List <PersonaxSucursal>(); while (read.Read()) { PersonaxSucursal personaxSucursal = new PersonaxSucursal(); personaxSucursal.IdCedula = Convert.ToInt32(read["IdCedula"]); personaxSucursal.IdSucursal = Convert.ToInt32(read["IdSucursal"]); personaxSucursal.SalarioHora = Convert.ToInt32(read["SalarioHora"]); personaxSucursal.LogicDelete = Convert.ToBoolean(read["LogicDelete"]); ListPersonaxSucursal.Add(personaxSucursal); } read.Close(); conn.Close(); return(ListPersonaxSucursal); }
public void UpdatePersonaxSucursal([FromBody] PersonaxSucursal rol) { System.Data.SqlClient.SqlConnection conn; SqlCommand command; conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True"); conn.Open(); String comm = "Update PersonaxSucursal SET SalarioHora=" + rol.SalarioHora + " WHERE IdCedula=" + rol.IdCedula; command = new SqlCommand(comm, conn); command.ExecuteNonQuery(); conn.Close(); }
public PersonaxSucursal GetPersonaxSucursal(int id) { System.Data.SqlClient.SqlConnection conn; SqlCommand command; SqlDataReader read; conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True"); conn.Open(); command = new SqlCommand("SELECT * from PersonaxSucursal where LogicDelete = 0 and IdCedula=" + id.ToString(), conn); read = command.ExecuteReader(); PersonaxSucursal persona = new PersonaxSucursal(); while (read.Read()) { persona.IdCedula = Convert.ToInt32(read["IdCedula"]); persona.SalarioHora = Convert.ToInt32(read["SalarioHora"]); persona.LogicDelete = Convert.ToBoolean(read["LogicDelete"]); } read.Close(); conn.Close(); return(persona); }
public void UpdatePersonaxSucursal([FromBody] PersonaxSucursal pxs) { PersonaxSucursalService con = new PersonaxSucursalService(); con.UpdatePersonaxSucursal(pxs); }
public void PostMedicamento([FromBody] PersonaxSucursal pxs) { PersonaxSucursalService con = new PersonaxSucursalService(); con.PostPersonaxSucursal(pxs); }