public static DistrictDTO SampleDistrictDTO(int id = 1)
{
DistrictDTO district = new DistrictDTO();
// int
district.DistrictId = id;
// int?
district.CountryId = 1;
// string
district.Name = "NameTestValue";
// string
district.Code = "CodeTestValue";
// double?
district.Latitude = 1;
// double?
district.Longitude = 1;
// bool
district.Active = false;
// bool
district.IsDeleted = false;
// int?
district.CreateBy = 1;
// System.DateTime?
district.CreateOn = new System.DateTime();
// int?
district.UpdateBy = 1;
// System.DateTime?
district.UpdateOn = new System.DateTime();
return(district);
}
public int AddDistrict(DistrictDTO dto)
{
int id = 0;
try
{
log.Debug(DistrictDTO.FormatDistrictDTO(dto));
R_District t = DistrictDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddDistrict(t);
dto.DistrictId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public void Update(DistrictDTO districtDTO)
{
District district = Mapper.Map <District>(districtDTO);
_unitOfWork.Districts.Update(district);
_unitOfWork.Save();
}
public async Task <OutputResponse> Update(DistrictDTO district)
{
var districtToUpdate = await _context.Districts.FirstOrDefaultAsync(x => x.DistrictCode.Equals(district.DistrictCode));
if (districtToUpdate == null)
{
return(new OutputResponse
{
IsErrorOccured = true,
Message = "District specified does not exist, update cancelled"
});
}
//update District details
districtToUpdate.DistrictName = district.DistrictName;
districtToUpdate.RegionId = district.RegionId;
districtToUpdate.Longitude = district.Longitude;
districtToUpdate.Latitude = district.Latitude;
districtToUpdate.RowAction = "U";
districtToUpdate.ModifiedBy = district.CreatedBy;
districtToUpdate.DateModified = DateTime.UtcNow.AddHours(2);
await _context.SaveChangesAsync();
return(new OutputResponse
{
IsErrorOccured = false,
Message = MessageHelper.UpdateSuccess
});
}
#pragma warning disable 1998
public async Task <IActionResult> DeleteSalesmanFailed(int id)
#pragma warning restore 1998
{
var districtDTO = new DistrictDTO(id);
return(View(districtDTO));
}
public void GetDistricts_Success_Test()
{
// Arrange
R_District district = SampleDistrict(1);
IList <R_District> list = new List <R_District>();
list.Add(district);
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistricts()).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistricts();
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
}
public async Task <OutputResponse> Add(DistrictDTO District)
{
var isFound = await _context.Districts.AnyAsync(x => x.DistrictName.ToLower() == District.DistrictName.ToLower());
if (isFound)
{
return(new OutputResponse
{
IsErrorOccured = true,
Message = "District name already exist, duplicates not allowed"
});
}
var mappedDistrict = new AutoMapperHelper <DistrictDTO, Districts>().MapToObject(District);
mappedDistrict.RowAction = "I";
mappedDistrict.DateCreated = DateTime.UtcNow.AddHours(2);
await _context.Districts.AddAsync(mappedDistrict);
await _context.SaveChangesAsync();
return(new OutputResponse
{
IsErrorOccured = false,
Message = MessageHelper.AddNewSuccess
});
}
public District Insert(DistrictDTO districtDto)
{
var district = new District {
DistrictId = districtDto.DistrictId,
Name = districtDto.Name
};
int newDistrictId;
using (var con = new SqlConnection(_connectionString))
{
string Command = "INSERT INTO District (Name) VALUES (@name);SELECT CAST(scope_identity() AS int)";
var cmd = new SqlCommand(Command, con);
cmd.Parameters.AddWithValue("@name", district.Name);
con.Open();
newDistrictId = (int)cmd.ExecuteScalar();
Command = "INSERT INTO DistrictSalesperson (SPId,DistrictId,Position) VALUES (@SPId,@DistrictId,@Position)";
foreach (var item in districtDto.SalesPersons)
{
cmd = new SqlCommand(Command, con);
cmd.Parameters.AddWithValue("@SPId", item.SPId);
cmd.Parameters.AddWithValue("@DistrictId", newDistrictId);
cmd.Parameters.AddWithValue("@Position", item.Position);
cmd.ExecuteNonQuery();
}
}
return(Get(newDistrictId));
}
private DistrictDTO Create(DistrictViewModel viewModel)
{
try
{
log.Debug(DistrictViewModel.FormatDistrictViewModel(viewModel));
DistrictDTO district = new DistrictDTO();
// copy values
viewModel.UpdateDTO(district, null); //RequestContext.Principal.Identity.GetUserId());
// audit
district.CreateBy = null; //RequestContext.Principal.Identity.GetUserId();
district.CreateOn = DateTime.UtcNow;
// add
log.Debug("_districtService.AddDistrict - " + DistrictDTO.FormatDistrictDTO(district));
int id = _districtService.AddDistrict(district);
district.DistrictId = id;
log.Debug("result: 'success', id: " + id);
return(district);
}
catch (Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void GetDistrictsPaged_Success_Test()
{
// Arrange
string searchTerm = "";
int pageIndex = 0;
int pageSize = 10;
// list
IList <R_District> list = new List <R_District>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleDistrict(i));
}
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistricts(Moq.It.IsAny <string>(), Moq.It.IsAny <int>(), Moq.It.IsAny <int>())).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistricts(searchTerm, pageIndex, pageSize);
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
Assert.AreEqual(10, resultList.Count);
}
public DistrictDTO GetDistrict(int districtId)
{
try
{
//Requires.NotNegative("districtId", districtId);
log.Debug("districtId: " + districtId + " ");
// get
R_District t = Repository.GetDistrict(districtId);
DistrictDTO dto = new DistrictDTO(t);
log.Debug(DistrictDTO.FormatDistrictDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
private void AddEditProperty_BasePost(Connector connector, PropertyDTO property)
{
RegionBLL regionBLL = new RegionBLL(connector);
ProvinceBLL provinceBLL = new ProvinceBLL(connector);
DistrictBLL districtBLL = new DistrictBLL(connector);
CountryDTO country = property.Country;
RegionDTO region = property.Region;
ProvinceDTO province = property.Province;
DistrictDTO district = property.District;
if (country != null)
{
country.Regions = regionBLL.ReadByCountry(country.Id);
if (region != null)
{
region.Country = country;
}
if (province != null)
{
province.Country = country;
}
if (district != null)
{
district.Country = country;
}
}
if (region != null)
{
region.Provinces = provinceBLL.ReadByCountryAndRegion(country.Id, region.Code);
}
if (province != null)
{
province.Districts = districtBLL.ReadByCountryAndRegionAndProvince(country.Id, region.Code, province.Code);
}
}
public ActionResult <Api <DistrictDTO> > AddDistrict(DistrictEntity district)
{
DistrictDTO dto = _districtService.Save(district);
Api <DistrictDTO> result = new Api <DistrictDTO>(200, dto, "Success", null);
return(Ok(result));
}
public DistrictDTO updateDistrict(DistrictDTO District)
{
var selectedDistrict = uow.GetRepository <District>().Get(z => z.Id == District.Id);
selectedDistrict = MapperFactory.CurrentMapper.Map(District, selectedDistrict);
uow.GetRepository <District>().Update(selectedDistrict);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <DistrictDTO>(selectedDistrict));
}
public ActionResult Create([Bind(Include = "Name")] DistrictVM districtVM)
{
if (ModelState.IsValid)
{
DistrictDTO districtDTO = Mapper.Map <DistrictDTO>(districtVM);
DistrictService.Add(districtDTO);
return(RedirectToAction("Index"));
}
return(View());
}
public HttpResponseMessage Get(int Id)
{
DistrictDTO district = service.getDistrict(Id);
if (district == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Id + sysLanguage.DistrictsControllerStrings.id_District));
}
return(Request.CreateResponse(HttpStatusCode.OK, district));
}
public IHttpActionResult Insert(DistrictDTO districtDto)
{
var result = _districtRepo.Insert(districtDto);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public void GetDistrictListAdvancedSearch_Success_Test()
{
// Arrange
int? countryId = null;
string name = null;
string code = null;
double?latitude = null;
double?longitude = null;
bool? active = null;
//int pageIndex = 0;
int pageSize = 10;
// list
IList <R_District> list = new List <R_District>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleDistrict(i));
}
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistrictListAdvancedSearch(
Moq.It.IsAny <int?>() // countryId
, Moq.It.IsAny <string>() // name
, Moq.It.IsAny <string>() // code
, Moq.It.IsAny <double?>() // latitude
, Moq.It.IsAny <double?>() // longitude
, Moq.It.IsAny <bool?>() // active
)).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistrictListAdvancedSearch(
countryId
, name
, code
, latitude
, longitude
, active
);
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
}
public void CreateAPartnerAccountWithAnAlreadyUsedUsername()
{
PartnerBLL partnerBLL = new PartnerBLL(TestApp.Connector);
CountryDTO country = new CountryDTO()
{
Id = "PE"
};
DistrictDTO district = new DistrictDTO()
{
Country = country,
Code = "150106",
Province = new ProvinceDTO()
{
Country = country,
Code = "150100",
Region = new RegionDTO()
{
Country = country,
Code = "150000"
}
}
};
PartnerDTO partner = new PartnerDTO()
{
Username = "******",
Password = new byte[64],
FirstName = "Aldo",
MiddleName = "Alejandro",
LastName = "Astupillo Cáceres",
Gender = new GenderDTO()
{
Id = "M"
},
EmailAddress = "*****@*****.**",
MobileNumber = "+51989637468",
CompanyName = "Hatun Search",
Address = "Av. Larco 322",
Country = country,
District = district,
PhoneNumber = "+5115474849",
Website = "https://hatunsearch.me",
PreferredCurrency = new CurrencyDTO()
{
Id = "PEN"
},
PreferredLanguage = new LanguageDTO()
{
Id = "ES"
}
};
PartnerBLL.SignupResult result = partnerBLL.Signup(partner, "https://partners.hatunsearch.me", "https://partners.hatunsearch.me/es-pe/accounts/signup/verification");
Assert.AreEqual(PartnerBLL.SignupResult.UsernameAlreadyUsed, result);
}
public District ConvertToEF(DistrictDTO DTO)
{
var EF = new District()
{
DistrictId = DTO.DistrictId,
DistrictName = DTO.DistrictName,
DT_CityId = DTO.DT_CityId
};
return(EF);
}
public async Task <IActionResult> Update([FromBody] DistrictDTO district)
{
var outputHandler = await _service.Update(district);
if (outputHandler.IsErrorOccured)
{
return(BadRequest(outputHandler.Message));
}
return(Ok(outputHandler.Message));
}
public async Task <DistrictDTO> GetDistrictAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
var district = new DistrictDTO(await Context.Districts
.FirstOrDefaultAsync(m => m.DistrictID == id));
return(district ?? NotFound());
}
public static List <DistrictDTO> GetListDistrictByProvinceName(string provinceName)
{
List <DistrictDTO> districtDTOs = new List <DistrictDTO>();
string query = string.Format("EXEC dbo.USP_GetListDistrictByProvinceName @PROVINCE_NAME = N'{0}'", provinceName);
DataTable dataTable = DataProvider.ExcuteQuery(query);
foreach (DataRow item in dataTable.Rows)
{
DistrictDTO districtDTO = new DistrictDTO(item);
districtDTOs.Add(districtDTO);
}
return(districtDTOs);
}
public DistrictDTO newDistrict(DistrictDTO District)
{
if (!uow.GetRepository <District>().GetAll().Any(z => z.Id == District.Id))
{
var adedDistrict = MapperFactory.CurrentMapper.Map <District>(District);
adedDistrict = uow.GetRepository <District>().Add(adedDistrict);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <DistrictDTO>(adedDistrict));
}
else
{
return(null);
}
}
public ActionResult Update(DistrictDTO data)
{
District district = _districtService.GetByID(data.ID);
district.ID = data.ID;
district.Ilce = data.Ilce;
district.CityID = data.CityID;
_districtService.Update(district);
return(Redirect("/Admin/Saying/List"));
}
public async Task <bool> EditDistrictAsync(DistrictDTO district)
{
try
{
Context.Update(DistrictDTOToDistrictModelWithID(district));
await Context.SaveChangesAsync();
return(true);
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
public async Task <IActionResult> Create([Bind("DistrictID,DistrictName")] DistrictDTO district,
[Bind("DistrictID, SalesmanID")] SalesmenStatusDTO salesmenStatus)
{
if (!ModelState.IsValid)
{
return(View());
}
await _districtLogic.CreateDistrictAsync(district);
await _salesmenStatusLogic.CreateSalesmanStatusPrimaryAsync(salesmenStatus, district.DistrictName);
return(RedirectToAction(nameof(Index)));
}
public DistrictDTO ConvertToDTO(District EF)
{
var DTO = new DistrictDTO()
{
DistrictId = EF.DistrictId,
DistrictName = EF.DistrictName,
DT_CityId = EF.DT_CityId
};
if (EF.City != null)
{
DTO.CityDTO = new ConvertDataCity().ConvertToDTO(EF.City);
}
return(DTO);
}
public async Task <bool> CreateDistrictAsync(DistrictDTO district)
{
try
{
await Context.Districts.AddAsync(DistrictDTOToDistrictModel(district));
await Context.SaveChangesAsync();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public async Task <IActionResult> Edit(int id, [Bind("DistrictID,DistrictName")] DistrictDTO district)
{
if (id != district.DistrictID)
{
return(NotFound());
}
if (!ModelState.IsValid)
{
return(View(district));
}
await _districtLogic.EditDistrictAsync(district);
return(RedirectToAction(nameof(Index)));
}
public District Map(DistrictDTO dto)
{
if (dto == null) return null;
var district = Mapper.Map<DistrictDTO, District>(dto);
district.Province = _provincesRepository.GetById(dto.ProvinceMasterId);
return district;
}
