public ApiServiceResponse <string> DeleteSalesPersonsToDistrict([FromBody] RemoveSalesPersonToDistrict rsptd)
{
var message = "";
if (rsptd.DistrictId == 0)
{
message = "DistrictId cannot be 0";
return(new ApiServiceResponse <string>(HttpStatusCode.BadRequest, message));
}
if (!rsptd.SalesPersonIds.Any())
{
message = "SalesPersonId list cannot be empty";
return(new ApiServiceResponse <string>(HttpStatusCode.BadRequest, message));
}
if (rsptd.SalesPersonIds.Contains(0))
{
message = "SalesPersonIds list cannot contain 0s";
return(new ApiServiceResponse <string>(HttpStatusCode.BadRequest, message));
}
message = _dmSalesPersonToDistrict.DeleteSalesPersonsToDistrict(rsptd);
if (string.IsNullOrWhiteSpace(message))
{
return(new ApiServiceResponse <string>(HttpStatusCode.OK));
}
return(new ApiServiceResponse <string>(HttpStatusCode.BadRequest, message));
}
public bool DeleteSalesPersonsToDistrict(RemoveSalesPersonToDistrict rsptd)
{
string stmt = @"DELETE FROM SalesPersonsToDistrict WHERE SalesPersonIdSPTDFK = @0 AND DistrictIdSPTDFK = @1";
try
{
_con.BeginTransaction();
foreach (var salesPersonId in rsptd.SalesPersonIds)
{
using (var cmd = new SqlCommand(stmt, _con.GetConnection(), _con.GetTransaction()))
{
cmd.Parameters.AddWithValue("@0", salesPersonId);
cmd.Parameters.AddWithValue("@1", rsptd.DistrictId);
cmd.ExecuteNonQuery();
}
}
_con.GetTransaction().Commit();
return(true);
}
catch (SqlException)
{
_con.GetTransaction().Rollback();
return(false);
}
}
public string DeleteSalesPersonsToDistrict(RemoveSalesPersonToDistrict rsptd)
{
var district = _dbDistrict.GetDistrictDetails(rsptd.DistrictId);
if (district == null)
{
return("District not found");
}
foreach (var salesPersonId in rsptd.SalesPersonIds)
{
var salesPerson = _dbSalesPerson.GetSalesPersonById(salesPersonId);
if (salesPerson == null)
{
return($"SalesPerson with id:{salesPersonId} not found");
}
}
var response = _dbSalesPersonToDistrict.DeleteSalesPersonsToDistrict(rsptd);
if (response)
{
return("");
}
return("Something went wrong");
}
public async Task <ApiServiceResponse <string> > RemoveSalesPersonsFromDistrict(List <int> salesPersonIds, int districtId)
{
var removeSalesPersonToDistrict = new RemoveSalesPersonToDistrict
{
DistrictId = districtId,
SalesPersonIds = salesPersonIds
};
string json = JsonConvert.SerializeObject(removeSalesPersonToDistrict);
var content = new StringContent(json, UnicodeEncoding.UTF8, "application/json");
var response = await _httpClient.GetClient().PostAsync("/district/RemoveSalesPersonsFromDistrict", content);
var jsonString = await response.Content.ReadAsStringAsync();
var actualResult = JsonConvert.DeserializeObject <ApiServiceResponse <string> >(jsonString);
return(actualResult);
}
[TestCase(1, new[] { 1, 2 }, HttpStatusCode.OK)] //success
public async Task RemoveSalesPersonFromDistrict(int districtId, int[] salesPersonIds, HttpStatusCode expectedResult)
{
//arrange
var removeSalesPersonToDistrict = new RemoveSalesPersonToDistrict
{
DistrictId = districtId,
SalesPersonIds = salesPersonIds.ToList()
};
string json = JsonConvert.SerializeObject(removeSalesPersonToDistrict);
var content = new StringContent(json, UnicodeEncoding.UTF8, "application/json");
//act
var response = await _internalClient.PostAsync("/district/RemoveSalesPersonsFromDistrict", content);
var jsonString = await response.Content.ReadAsStringAsync();
var actualResult = JsonConvert.DeserializeObject <ApiServiceResponse <string> >(jsonString);
//assert
Assert.AreEqual(expectedResult, actualResult.HttpResponse);
}
