public void AddLocationToAllCitizen()
{
var rand = new Random();
int rangeMuncipality = (int)client.Municipalities.CountDocuments(m => m.MunicipalityId >= 0);
var citizens = client.Citizens.Find(c => c.CitizenId > 0).ToList();
Municipality municipality = new Municipality();
Location location = new Location();
foreach (var citizen in citizens)
{
for (int i = 0; i < 3; i++)
{
municipality = municipalityService.FindMunicipality(rand.Next(0, rangeMuncipality));
int rangeList = (int)municipality.Location_id.Count();
if (rangeList != 0)
{
int takeThis = rand.Next(0, rangeList);
int locationIdInMunicipaltyList = (int)municipality.Location_id[takeThis];
location = FindLocation(locationIdInMunicipaltyList);
AddLocation(citizen.CitizenId, location.Address, location.Zip, municipality.Name);
}
}
}
}
public static async Task GetTaxDetails(string municipalityName, string date)
{
string URL = string.Format("{0}{1}", Contants.URL, "/api/Tax/GetTaxDetails");
var obj = new Municipality
{
Name = municipalityName,
Date = Convert.ToDateTime(date)
};
string result = await POST <Municipality>(URL, obj);
if (!string.IsNullOrEmpty(result))
{
Console.WriteLine(result);
Console.WriteLine("Completed Fetching Tax Details");
}
else
{
Console.WriteLine("Not able to Fecth TaxInformation. Please check the Log File");
}
}
public static async Task SaveTaxDetails(string municipalityName, string date, string frequency, string tax)
{
string URL = string.Format("{0}{1}", Contants.URL, "/api/Tax/Save");
var taxDetails = new Municipality
{
Name = municipalityName,
Date = Convert.ToDateTime(date),
Frequency = frequency,
Tax = tax
};
string result = await POST <Municipality>(URL, taxDetails);
if (result == "true")
{
Console.WriteLine("Saved TaxInformation Successfully");
}
else
{
Console.WriteLine("Not able to Save TaxInformation. Please check the Log File");
}
}
private void SeedMunicipality(AdirContext context)
{
var tarlacProvince = context.Provinces.FirstOrDefault(r => r.Name == "Tarlac");
var gerona = new Municipality()
{
Name = "Gerona",
Abbreviation = "Gerona",
IsActive = true,
CreatedOn = DateTime.Now,
Province = tarlacProvince
};
var tarlacCity = new Municipality()
{
Name = "Tarlac City",
Abbreviation = "Tarlac",
IsActive = true,
CreatedOn = DateTime.Now,
Province = tarlacProvince
};
context.Municipalities.AddOrUpdate(m => m.Name, gerona);
context.Municipalities.AddOrUpdate(m => m.Name, tarlacCity);
context.SaveChanges();
}
public ICounty GetByMunicipalityId(int municipalityId)
{
string strId = string.Format("{0:D4}", municipalityId);
Municipality municipality = _dbContext.Set <Municipality>().Where(m => m.Active > 0 && m.Number == strId).FirstOrDefault();
return(municipality.County);
}
public Municipality CreateMunicipality(CreateMunicipalityRequest request)
{
if (_context.Municipalities.Any(m => m.Name.ToLower().Equals(request.Name.ToLower())))
{
throw new BadRequestException("A municipality with name: " + request.Name + " already exists.");
}
Municipality municipality = new Municipality(request.Name, new List <Tax>(), new List <Tax>(), new List <Tax>(), new List <Tax>());
foreach (var item in request.YearlyTaxes)
{
municipality.YearlyTaxes = InsertTaxIntoList(municipality.YearlyTaxes, item);
}
foreach (var item in request.MonthlyTaxes)
{
municipality.MonthlyTaxes = InsertTaxIntoList(municipality.MonthlyTaxes, item);
}
foreach (var item in request.WeeklyTaxes)
{
municipality.WeeklyTaxes = InsertTaxIntoList(municipality.WeeklyTaxes, item);
}
foreach (var item in request.DailyTaxes)
{
municipality.DailyTaxes = InsertTaxIntoList(municipality.DailyTaxes, item);
}
_context.Municipalities.Add(municipality);
_context.SaveChanges();
return(municipality);
}
public static bool GetMunicipality(Municipality municipality)
{
var connectionString = "Data source=.;Initial Catalog=Challenge;Integrated Security=True";
var query = "SELECT Names FROM Municipality";
query = query.Replace("@Names", municipality.Names);
SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
command.Dispose();
connection.Close();
return(true);
}
catch
{
//throw;
return(false);
}
}
public ActionResult Create(Municipality obj)
{
if (ModelState.IsValid)
{
if (!dataManager.Municipalities.GetAll()
.Where(m => m.DistrictId == obj.DistrictId)
.Any(o => o.Name == obj.Name))
{
dataManager.Municipalities.Save(obj);
return(RedirectToAction("Show", new { Id = obj.Id }));
}
else
{
ModelState.AddModelError("Name",
"МТУ с названием \"" + obj.Name + "\" уже существует!");
}
}
ViewBag.Districts = from d in dataManager.Districts.GetAll()
select new SelectListItem
{
Text = d.Name,
Value = d.Id.ToString(),
Selected = obj.DistrictId.HasValue ? obj.DistrictId.Value == d.Id : false
};
return(View(obj));
}
public static int Save(Municipality municipality)
{
var a = new Municipality
{
MunicipalityNo = municipality.MunicipalityNo,
MunicipalityName = municipality.MunicipalityName,
MunicipalityPostalCode = municipality.MunicipalityPostalCode,
ProvinceNo = municipality.ProvinceNo,
IsActive = municipality.IsActive,
datemodified = municipality.datemodified
};
using (_d = new DataRepository <Municipality>())
{
if (municipality.MunicipalityNo > 0)
{
_d.Update(a);
}
else
{
_d.Add(a);
}
_d.SaveChanges();
}
return(a.MunicipalityNo);
}
public static Municipality ConvertToMunicipality(this MunicipalityViewModel municipalityViewModel)
{
Municipality municipality = new Municipality()
{
Id = municipalityViewModel.Id,
Identifier = municipalityViewModel.Identifier,
Code = municipalityViewModel.Code,
MunicipalityCode = municipalityViewModel.MunicipalityCode,
Name = municipalityViewModel.Name,
CountryId = municipalityViewModel.Country?.Id ?? null,
RegionId = municipalityViewModel.Region?.Id ?? null,
Active = municipalityViewModel.IsActive,
CreatedById = municipalityViewModel.CreatedBy?.Id ?? null,
CompanyId = municipalityViewModel.Company?.Id ?? null,
CreatedAt = municipalityViewModel.CreatedAt,
UpdatedAt = municipalityViewModel.UpdatedAt
};
return(municipality);
}
public static MunicipalityViewModel ConvertToMunicipalityViewModel(this Municipality municipality)
{
MunicipalityViewModel municipalityViewModel = new MunicipalityViewModel()
{
Id = municipality.Id,
Identifier = municipality.Identifier,
Code = municipality.Code,
MunicipalityCode = municipality.MunicipalityCode,
Name = municipality.Name,
Country = municipality.Country?.ConvertToCountryViewModelLite(),
Region = municipality.Region?.ConvertToRegionViewModelLite(),
IsActive = municipality.Active,
CreatedBy = municipality.CreatedBy?.ConvertToUserViewModelLite(),
Company = municipality.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = municipality.UpdatedAt,
CreatedAt = municipality.CreatedAt
};
return(municipalityViewModel);
}
public static string CreateRelativeUrl(Municipality municipality)
{
var district = municipality.DistrictName.ToUrlSegment();
var name = municipality.Name.ToUrlSegment();
return($"/{district}/{name}/{municipality.MunicipalityId}");
}
public ActionResult Edit([Bind(Include = "MunicipalityId,DepartmentId,Name")] Municipality municipality)
{
if (ModelState.IsValid)
{
db.Entry(municipality).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un registro con el mismo nombre");
}
else
{
ModelState.AddModelError(string.Empty, ex.Message);
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", municipality.DepartmentId);
return(View(municipality));
}
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", municipality.DepartmentId);
return(View(municipality));
}
public ActionResult Create([Bind(Include = "MunicipalityId,DepartmentId,Name")] Municipality municipality)
{
if (ModelState.IsValid)
{
db.Municipalities.Add(municipality);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null && ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("index"))
{
ModelState.AddModelError(string.Empty, "There are a record with the same description.");
}
else
{
ModelState.AddModelError(string.Empty, ex.Message);
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", municipality.DepartmentId);
return(View(municipality));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", municipality.DepartmentId);
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", municipality.DepartmentId);
return(View(municipality));
}
public void Index_SpecificMunicipalityTest()
{
var municipality = new Municipality
{
MunicipalityId = "19",
DistrictName = "Český Krumlov",
Name = "Křemže"
};
var populationProgress = CreatePopulationProgress(municipality).ToArray();
var municipalityRepository = Substitute.For <IMunicipalityRepository>();
var populationFrameRepository = Substitute.For <IPopulationFrameRepository>();
municipalityRepository.GetByCode("19").Returns(municipality);
populationFrameRepository
.FindAll(Arg.Is <QueryPopulationFrameByMunicipalityCode>(q => q.Code == "19"))
.Returns(populationProgress);
var controller = new HomeController(municipalityRepository, populationFrameRepository);
var result = controller.Index(null, null, "19");
Assert.IsType <MunicipalityPopulationProgressModel>(result.Model);
var model = (MunicipalityPopulationProgressModel)result.Model;
Assert.Equal("19", model.Municipality.MunicipalityId);
}
public async Task <Municipality> Add(Municipality municipality)
{
_context.Municipalities.Add(municipality);
await _context.SaveChangesAsync();
return(municipality);
}
public (float, string) CalculateTaxFor(Municipality municipality, DateTime date)
{
var rules = municipality.TaxRules
.OrderByDescending(t => t.Priority);
var taxDate = date.Date;
foreach (var rule in rules)
{
if (rule.Periods == null)
{
continue;
}
foreach (var period in rule.Periods)
{
if (period.From.Date <= taxDate && period.To.Date.AddDays(1) > taxDate)
{
return(rule.Percentage, null);
}
}
}
return(int.MinValue, Messages.NoTaxRuleForDate);
}
public async Task <IActionResult> PutMunicipality([FromRoute] int id, [FromBody] Municipality municipality)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != municipality.Id)
{
return(BadRequest());
}
_context.Entry(municipality).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MunicipalityExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok(_context.Municipalities.Find(id)));
}
private async void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "Add")
{
if (IsValid())
{
Municipality municipality = new Municipality();
municipality.MunicipalityName = txtMunicipality.Text.Trim();
municipality.District = district;
await repository.Create(municipality);
frmSettings setting = (frmSettings)Application.OpenForms["frmSettings"];
await setting.LoadMunicipality();
this.Close();
}
}
if (btnAdd.Text == "Update")
{
if (IsValidUpdate())
{
Municipality municipality = await repository.Get(frmSettings.MunID);
municipality.MunicipalityName = txtMunicipality.Text.Trim();
municipality.District = district;
await repository.Update(municipality);
frmSettings setting = (frmSettings)Application.OpenForms["frmSettings"];
await setting.LoadMunicipality();
this.Close();
}
}
}
public async Task <bool> EditMunicipality(Municipality municipality)
{
_context.Set <Municipality>().AddOrUpdate(municipality);
await _context.SaveChangesAsync();
return(true);
}
public async void Returns_taxes_between_dates(DateTime dt, decimal expected)
{
using (var ctx = new TaxesDbContext()) {
var municipality = new Municipality("Vilnius");
var yearly = new Tax("Vilnius", new DateTime(2016, 1, 1), new DateTime(2016, 12, 31), (decimal)0.2);
var mothly = new Tax("Vilnius", new DateTime(2016, 5, 1), new DateTime(2016, 5, 31), (decimal)0.4);
var daily1 = new Tax("Vilnius", new DateTime(2016, 1, 1), (decimal)0.1);
var daily2 = new Tax("Vilnius", new DateTime(2016, 12, 25), (decimal)0.1);
municipality.AddTax(yearly);
municipality.AddTax(mothly);
municipality.AddTax(daily1);
municipality.AddTax(daily2);
ctx.Municipalities.Add(municipality);
await ctx.SaveChangesAsync();
using (var controller = new TaxesController(ctx)) {
var result = await controller.Get("Vilnius", dt);
Assert.IsType <OkNegotiatedContentResult <ViewModel.TaxGet> >(result);
var okResult = result as OkNegotiatedContentResult <ViewModel.TaxGet>;
Assert.Equal(okResult.Content.Rate, expected);
}
}
}
private static void GenerateData(UnitOfWork uw)
{
var vilnius = new Municipality()
{
Name = "Vilnius"
};
uw.MunicipalityRepository.Add(vilnius);
var frederiksberg = new Municipality()
{
Name = "Taastrup"
};
uw.MunicipalityRepository.Add(frederiksberg);
uw.TaxRepository.Add(new Tax()
{
Municipality = vilnius, TaxType = TaxTypeEnum.Daily, StartDate = new DateTime(2016, 1, 1), Amount = 0.1f
});
uw.TaxRepository.Add(new Tax()
{
Municipality = vilnius, TaxType = TaxTypeEnum.Daily, StartDate = new DateTime(2016, 12, 25), Amount = 0.1f
});
uw.TaxRepository.Add(new Tax()
{
Municipality = vilnius, TaxType = TaxTypeEnum.Monthly, StartDate = new DateTime(2016, 5, 1),
EndDate = new DateTime(2016, 5, 31), Amount = 0.4f
});
uw.TaxRepository.Add(new Tax()
{
Municipality = vilnius, TaxType = TaxTypeEnum.Yearly, StartDate = new DateTime(2016, 1, 1),
EndDate = new DateTime(2016, 12, 31), Amount = 0.2f
});
uw.SaveChanges();
}
private static void Municipality(object vPreviousColumn, object v1)
{
if (v1 != null && !string.IsNullOrWhiteSpace(v1.ToString()))
{
using (mydbContext context = new mydbContext())
{
Regionalunity regType = new Regionalunity();
regType = context.Regionalunity.FirstOrDefault(x => x.RegionalUnityDescr.Equals(vPreviousColumn.ToString().Trim()));
if (regType == default(Regionalunity))
{
regType = new Regionalunity();
int?maxID = context.Regionalunity.Count().Equals(0) ? default(int?) : context.Regionalunity.Max(x => x.RegionalUnityId);
regType.RegionalUnityId = maxID.HasValue ? maxID.Value + 1 : 1;
regType.RegionalUnityDescr = vPreviousColumn.ToString().Trim();
context.Regionalunity.Add(regType);
context.SaveChanges();
}
Municipality rType = new Municipality();
rType = context.Municipality.FirstOrDefault(x => x.MunicipalityDescr.Equals(v1.ToString().Trim()));
if (rType == default(Municipality))
{
rType = new Municipality();
int?maxID = context.Municipality.Count().Equals(0) ? default(int?) : context.Municipality.Max(x => x.MunicipalityId);
rType.MunicipalityId = maxID.HasValue ? maxID.Value + 1 : 1;
rType.MunicipalityDescr = v1.ToString().Trim();
rType.RegionalUnityRegionalUnityId = regType.RegionalUnityId;
context.Municipality.Add(rType);
context.SaveChanges();
}
selectedBusiness.MunicipalityMunicipalityId = rType.MunicipalityId;
}
}
}
public void AddMunicipalities(List <MunicipalityDto> municipalitiesDto)
{
foreach (var municipalityDto in municipalitiesDto)
{
try
{
var municipality = _municipalitiesRepository.Query(o => o.Name == municipalityDto.Name).FirstOrDefault();
if (municipality != null)
{
foreach (var municipalityTaxDto in municipalityDto.Taxes)
{
municipality.AddMunicipalityTax(new MunicipalityTax(municipality.Id, municipalityTaxDto.StartDate, municipalityTaxDto.EndDate, municipalityTaxDto.Value));
}
_municipalitiesRepository.Update(municipality);
}
else
{
var newMunicipality = new Municipality(municipalityDto.Name);
foreach (var municipalityTaxDto in municipalityDto.Taxes)
{
newMunicipality.AddMunicipalityTax(new MunicipalityTax(municipality.Id, municipalityTaxDto.StartDate, municipalityTaxDto.EndDate, municipalityTaxDto.Value));
}
_municipalitiesRepository.Insert(newMunicipality);
}
}
catch (Exception)
{
// TOOD: Record results which caused exceptions
}
}
}
public ActionResult AddMunicipality(Municipality view)
{
if (ModelState.IsValid)
{
db.Municipalities.Add(view);
try
{
db.SaveChanges();
}
catch (Exception exception)
{
if (exception.InnerException != null &&
exception.InnerException.InnerException != null &&
exception.InnerException.InnerException.Message.Contains("Index"))
{
ModelState.AddModelError(string.Empty, "There are a record with the same descripction");
}
else
{
ModelState.AddModelError(string.Empty, exception.Message);
}
return(View(view));
}
return(RedirectToAction($"Details/{view.DepartmentId}"));
}
return(View(view));
}
public ActionResult AddMunicipality(Municipality view)
{
if (ModelState.IsValid)
{
db.Municipalities.Add(view);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("Index"))
{
ModelState.AddModelError(string.Empty, "El campo ya se encuentra registrado");
}
else
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(View(view));
}
return(RedirectToAction(string.Format("Details/{0}", view.DepartmentId)));
}
return(View(view));
}
public MunicipalityTax Create(string name, DateTime date, Period period, decimal tax)
{
var municipality = _municipalitiesRepository.GetAllItems().FirstOrDefault(a => a.Name == name);
if (municipality == default(Municipality))
{
municipality = new Municipality
{
Name = name
};
}
var municipalityTax = new MunicipalityTax
{
TaxPeriod = new TaxPeriod
{
DateFrom = date.Date,
DateTo = date.AddPeriod(period),
Period = period
},
Municipality = municipality,
Tax = tax
};
return(_taxesRepository.AddOrUpdate(municipalityTax));
}
/// <summary>
/// Saves the address.
/// </summary>
/// <param name="country"></param>
/// <param name="municipality"></param>
/// <param name="city"></param>
/// <returns>The city id</returns>
public int?SaveAddress(string country, string municipality, string city)
{
country = country.ToTitleCase();
municipality = municipality.ToTitleCase();
city = city.ToTitleCase();
City cty = null;
using (var session = usersSessionFactory.CreateContext(true))
{
var cntry = session.Countries.SingleOrDefault(c => c.Name == country);
if (cntry == null)
{
cntry = new Country
{
Name = country
};
session.Countries.Add(cntry);
}
if (!string.IsNullOrEmpty(municipality))
{
Municipality mnc = null;
if (cntry.Id > 0)
{
mnc = session.Municipalities.SingleOrDefault(m => m.CountryId == cntry.Id && m.Name == municipality);
}
if (mnc == null)
{
mnc = new Municipality()
{
Name = municipality
};
cntry.Municipalities.Add(mnc);
}
if (!string.IsNullOrEmpty(city))
{
if (mnc.Id > 0)
{
cty = session.Cities.SingleOrDefault(c => c.MunicipalityId == mnc.Id && c.Name == city);
}
if (cty == null)
{
cty = new City
{
Name = city
};
mnc.Cities.Add(cty);
}
}
}
CacheManager.Current.Expire("municipalities" + cntry.Id);
}
if (cty == null)
{
return(null);
}
return(cty.Id);
}
public ActionResult DeleteConfirmed(int id)
{
Municipality municipality = db.Municipalities.Find(id);
db.Municipalities.Remove(municipality);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null && ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
ModelState.AddModelError(string.Empty, "The record can't be delete because has related record.");
}
else
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(View(municipality));
}
return(RedirectToAction("Index"));
}
public async Task <bool> SaveMunicipality(Municipality municipality)
{
_context.Municipality.Add(municipality);
await _context.SaveChangesAsync();
return(true);
}
public void Seed(HomeGrownBulgariaDbContext context)
{
if (context.Municipalities.Any())
{
return;
}
var municipalitiesAsString = "Благоевградска,Бургаска,Варненска,Великотърновска,Видинска,Врачанска,Габровска,Добричка,Кърджалийска,Кюстендилска,Ловешка,Монтанска,Пазарджишка,Пернишка,Плевенска,Пловдивска,Разградска,Русенска,Силистренска,Сливенска,Смолянска,София-град,Софийска,Старозагорска,Търговищка,Хасковска,Шуменска,Ямболска";
var municipalitiesAsList = municipalitiesAsString.Trim().Split(',').ToList();
foreach (var municipalityName in municipalitiesAsList)
{
var municipality = new Municipality() { Name = municipalityName };
context.Municipalities.Add(municipality);
}
context.SaveChanges();
}
public static void SaveData(Municipality[] municipalitites)
{
System.Data.DataRow dr = null;
string strSQL = string.Format("SELECT * FROM {0} WHERE (1=2) ", "__Gemeinden");
using (System.Data.DataTable dt = SQL.GetDataTable(strSQL))
{
foreach (Municipality municipalitiy in municipalitites)
{
dr = dt.NewRow();
dr["MUN_Id"] = municipalitiy.id;
dr["MUN_Name"] = municipalitiy.name;
dt.Rows.Add(dr);
} // Next file
SQL.UpdateDataTable(dt, strSQL);
System.Console.WriteLine(dt.Rows.Count); // 34'409
} // End Using dt
}
