public void Add(Rank entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Ranks VALUES (@RankName)")) { cmd.Parameters.AddWithValue("RankName", entity.RankName); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Employee entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Employees where Id = @Id")) { cmd.Parameters.AddWithValue("Id", entity.Id); VTYS.SqlExecuteNonQuery(cmd); } }
public void Delete(Rank entity) { using (SqlCommand cmd = new SqlCommand("DELETE FROM Ranks where RankId = @RankId")) { cmd.Parameters.AddWithValue("Id", entity.RankId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Rank entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Ranks set RankId = @RankId, RankName = @RankName, where RankId = @RankId")) { cmd.Parameters.AddWithValue("RankId", entity.RankId); cmd.Parameters.AddWithValue("RankName", entity.RankName); VTYS.SqlExecuteNonQuery(cmd); } }
public void Add(Employee entity) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Employees (FirstName,LastName,Salary, RankId) VALUES (@FirstName,@LastName,@salary, @RankIdd)")) { cmd.Parameters.AddWithValue("FirstName", entity.FirstName); cmd.Parameters.AddWithValue("LastName", entity.LastName); cmd.Parameters.AddWithValue("Salary", entity.Salary); cmd.Parameters.AddWithValue("RankId", entity.RankId); VTYS.SqlExecuteNonQuery(cmd); } }
public void Update(Employee entity) { using (SqlCommand cmd = new SqlCommand("UPDATE Employees set FirstName = @FirstName, LastName = @LastName, Salary = @Salary, RankId = @RankId, where Id = @Id")) { cmd.Parameters.AddWithValue("Id", entity.Id); cmd.Parameters.AddWithValue("FirstName", entity.FirstName); cmd.Parameters.AddWithValue("LastName", entity.LastName); cmd.Parameters.AddWithValue("Salary", entity.Salary); cmd.Parameters.AddWithValue("RankId", entity.RankId); VTYS.SqlExecuteNonQuery(cmd); } }
public List <Rank> GetAll() { var categoryList = new List <Rank>(); SqlCommand cmd = new SqlCommand("Select * from Ranks"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Rank category = new Rank() { RankId = Convert.ToInt32(reader[0]), RankName = reader[1].ToString(), }; categoryList.Add(category); } return(categoryList); }
public Rank Get(int id) { SqlCommand cmd = new SqlCommand("Select * from Ranks where Id = @RankId"); cmd.Parameters.AddWithValue("RankId", id); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Rank category = new Rank() { RankId = Convert.ToInt32(reader[0]), RankName = reader[1].ToString(), }; return(category); } return(null); }
public List <Employee> GetAll() { var empList = new List <Employee>(); SqlCommand cmd = new SqlCommand("Select * from Employees"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Employee emp = new Employee { Id = Convert.ToInt32(reader[0]), FirstName = reader[1].ToString(), LastName = reader[2].ToString(), Salary = Convert.ToDecimal(reader[3]), RankId = Convert.ToInt32(reader[4]), }; empList.Add(emp); } return(empList); }
public Employee Get(int id) { SqlCommand cmd = new SqlCommand("Select * from Employees where Id = @Id"); cmd.Parameters.AddWithValue("Id", id); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Employee emp = new Employee { Id = Convert.ToInt32(reader[0]), FirstName = reader[1].ToString(), LastName = reader[2].ToString(), Salary = Convert.ToDecimal(reader[3]), RankId = Convert.ToInt32(reader[4]), }; return(emp); } return(null); }