public bool AddSalesPerson(DistrictSalesPerson districtSalesPerson) { using (var con = new SqlConnection(_connectionString)) { string Command = "INSERT INTO DistrictSalesPerson (SPId,DistrictId) VALUES (@spId,@districtId)"; var cmd = new SqlCommand(Command, con); cmd.Parameters.AddWithValue("@spId", districtSalesPerson.SPId); cmd.Parameters.AddWithValue("@districtId", districtSalesPerson.DistrictId); con.Open(); bool result = false; if (cmd.ExecuteNonQuery() > 0) { result = true; } return(result); } }
public IHttpActionResult AddSalesPerson(DistrictSalesPerson districtSalesPerson) { var result = _districtRepo.AddSalesPerson(districtSalesPerson); return(Ok(result)); }