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));
}
