public int AddRentOutBoats(RentOutBoat rentOutBoat) { var res = 0; string connectionString = _Configuration["ConnectionStrings:DefaultConnection"]; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("RentOutBoat_Add", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BoatName", rentOutBoat.BoatName); cmd.Parameters.AddWithValue("@CustomerName", rentOutBoat.CustomerName); con.Open(); res = cmd.ExecuteNonQuery(); con.Close(); } return(res); }
public IEnumerable <RentOutBoat> GetAllRentOutBoats() { List <RentOutBoat> lstCustomer = new List <RentOutBoat>(); string connectionString = _Configuration["ConnectionStrings:DefaultConnection"]; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("RentOutBoat_FetchAll", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { RentOutBoat Customer = new RentOutBoat(); Customer.BoatName = sdr["BoatName"].ToString(); Customer.CustomerName = sdr["CustomerName"].ToString(); //Customer.RegisterId = sdr["RegisterId"].ToString(); lstCustomer.Add(Customer); } con.Close(); } return(lstCustomer); }