public IHttpActionResult AddNewTax(RealEstateManagement.Models.PostMunicipality postMunicipality) { DataAccessLayer dataAccessLayer = new DataAccessLayer(); var result = dataAccessLayer.PostMunicipalityTax(postMunicipality); return(Ok(result)); }
public string PostMunicipalityTax(RealEstateManagement.Models.PostMunicipality postMunicipality) { Entities _context = new Entities(); var data = new Municipality(); data = _context.Municipalities.Where(i => i.MunicipalityName == postMunicipality.MunicipalityName).FirstOrDefault(); if (data != null) { var checkData = _context.MunicipalityTaxes.Where(i => i.MunicipalityId == data.Id && i.TaxDate == postMunicipality.TaxDate).FirstOrDefault(); if (checkData == null) { var t = new MunicipalityTax() { MunicipalityId = data.Id, TaxType = postMunicipality.TaxType, TaxDate = postMunicipality.TaxDate, Tax = postMunicipality.Tax }; _context.MunicipalityTaxes.Add(t); _context.SaveChanges(); } else { checkData.Tax = postMunicipality.Tax; checkData.TaxType = postMunicipality.TaxType; _context.SaveChanges(); return("Record updated successfully;"); } } else { return("No Municipality found in the given name"); } return("New Record inserted successfully;"); }