public ActionResult Create(HouseTaxViewModel model) { db.HouseTaxHistories.Add(model.HouseTax); var citizenHouse = db.CitizenHouses.First(c => c.Id == model.HouseTax.CitizenHouseId); db.SaveChanges(); //Move to land calculations var citizenLand = db.CitizenLands.First(c => c.CitizenId == citizenHouse.CitizenId); var landTaxViewModel = new LandTaxViewModel { CitizenLand = db.CitizenLands.First(c => c.CitizenId == citizenHouse.CitizenId), LandTaxHistory = new LandTaxHistory { CitizenId = citizenHouse.CitizenId, ValuationArea = citizenLand.ValuationArea, CitizenLandId = citizenLand.Id, HouseTaxHistoryId = model.HouseTax.Id }, CitizenLands = db.CitizenLands.ToList(), Citizens = db.Citizens.ToList() }; return(View("~/Views/LandTax/LandTaxCalculationForm.cshtml", landTaxViewModel)); }
public ActionResult Save(HouseValuation model) { if (!ModelState.IsValid) { var invalidModel = model; return(View("HouseValuationForm", invalidModel)); } if (model.Id == 0) { db.HouseValuations.Add(model); } else { var houseValuationInDB = db.HouseValuations.Single(h => h.Id == model.Id); houseValuationInDB.Description = model.Description; houseValuationInDB.CostPerArea = model.CostPerArea; houseValuationInDB.DepreciationRate = model.DepreciationRate; houseValuationInDB.DepreciationPeriod = model.DepreciationPeriod; } db.SaveChanges(); return(RedirectToAction("Index", "HouseValuation")); }
public void AddCitizen(string name, string surname, string patronym) { if (!(string.IsNullOrEmpty(name) && string.IsNullOrWhiteSpace(name)) && !(string.IsNullOrEmpty(surname) && string.IsNullOrWhiteSpace(surname)) && !(string.IsNullOrEmpty(patronym) && string.IsNullOrWhiteSpace(patronym))) { Citizen ctz = new Citizen() { Name = name, Surname = surname, Patronym = patronym }; using (var db = new CitizenDbContext()) { db.Citizens.Add(ctz); db.SaveChanges(); } } else { throw new System.InvalidOperationException("Fields are empty"); } }
public ActionResult Save(CitizenViewModel viewModel) { if (!ModelState.IsValid) { var invalidViewModel = new CitizenViewModel { Citizen = viewModel.Citizen, Zones = db.Zones.ToList() }; return(View("CitizenForm", invalidViewModel)); } if (viewModel.Citizen.CitizenId == 0) { db.Citizens.Add(viewModel.Citizen); } else { var citizenInDB = db.Citizens.Single(c => c.CitizenId == viewModel.Citizen.CitizenId); citizenInDB.FirstName = viewModel.Citizen.FirstName; citizenInDB.LastName = viewModel.Citizen.LastName; citizenInDB.StreetName = viewModel.Citizen.StreetName; citizenInDB.District = viewModel.Citizen.District; citizenInDB.ZoneId = viewModel.Citizen.ZoneId; citizenInDB.Wardno = viewModel.Citizen.Wardno; citizenInDB.CitizenshipNo = viewModel.Citizen.CitizenshipNo; citizenInDB.Municipality = viewModel.Citizen.Municipality; } db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public ActionResult Save(LandFormViewModel viewModel) { if (!ModelState.IsValid) { var invalidViewModel = new LandFormViewModel { CitizenLand = viewModel.CitizenLand, Citizens = db.Citizens.ToList() }; return(View("CitizenLandForm", invalidViewModel)); } if (viewModel.CitizenLand.Id == 0) { db.CitizenLands.Add(viewModel.CitizenLand); } else { var citizenLandInDB = db.CitizenLands.Single(c => c.Id == viewModel.CitizenLand.Id); citizenLandInDB.VDC = viewModel.CitizenLand.VDC; citizenLandInDB.WardNo = viewModel.CitizenLand.WardNo; citizenLandInDB.SheetNo = viewModel.CitizenLand.SheetNo; citizenLandInDB.KittaNo = viewModel.CitizenLand.KittaNo; citizenLandInDB.ValuationArea = viewModel.CitizenLand.ValuationArea; citizenLandInDB.CitizenId = viewModel.CitizenLand.CitizenId; } db.SaveChanges(); return(RedirectToAction("Index", "CitizenLand")); }
public ActionResult Save(HouseFormViewModel viewModel) { if (!ModelState.IsValid) { var invalidViewModel = new HouseFormViewModel { CitizenHouse = viewModel.CitizenHouse, Citizens = db.Citizens.ToList() }; return(View("CitizenHouseForm", invalidViewModel)); } if (viewModel.CitizenHouse.Id == 0) { db.CitizenHouses.Add(viewModel.CitizenHouse); } else { var citizenHouseInDB = db.CitizenHouses.Single(c => c.Id == viewModel.CitizenHouse.Id); citizenHouseInDB.Length = viewModel.CitizenHouse.Length; citizenHouseInDB.Width = viewModel.CitizenHouse.Width; citizenHouseInDB.Area = viewModel.CitizenHouse.Area; citizenHouseInDB.Floor = viewModel.CitizenHouse.Floor; citizenHouseInDB.CitizenId = viewModel.CitizenHouse.CitizenId; } db.SaveChanges(); return(RedirectToAction("Index", "CitizenHouse")); }
public void AddCitizen(Citizen ctz) { if (ctz != null) { _citizens.Add(ctz); using (var db = new CitizenDbContext()) { db.Citizens.Add(ctz); db.SaveChanges(); } } }
public ActionResult Save(Zone zone) { if (zone.Id == 0) { db.Zones.Add(zone); } else { var zoneInDB = db.Zones.Single(c => c.Id == zone.Id); zoneInDB.Code = zone.Code; zoneInDB.Description = zone.Description; } db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public void AddDocument(string name, int?serial, string whereIssued, DateTime date, Citizen ctz) { Document doc = new Document() { Name = name, Serial = serial.Value, WhereIssued = whereIssued, DateIssued = date, CitizenId = ctz.Id }; using (var db = new CitizenDbContext()) { db.Documents.Add(doc); db.SaveChanges(); } }
public void AddPerson(int cypher, int inn, string type, DateTime date, Citizen ctz) { Person prs = new Person() { Cypher = cypher, Inn = inn, Type = type, Date = date, CitizenId = ctz.Id }; using (var db = new CitizenDbContext()) { db.Persons.Add(prs); db.SaveChanges(); } }
//не используется public void EditCitizen(string name, string surname, string patronym) { using (var db = new CitizenDbContext()) { Citizen ctz = new Citizen() { Name = name, Surname = surname, Patronym = patronym }; var citizen = (from i in db.Citizens where i.Id == ctz.Id select i).First(); citizen.Name = ctz.Name; citizen.Surname = ctz.Surname; citizen.Patronym = ctz.Patronym; db.SaveChanges(); Debug.WriteLine("Изменение завершено"); } }
public ActionResult Save(LandValuation model) { if (!ModelState.IsValid) { var invalidModel = model; return(View("LandValuationForm", invalidModel)); } if (model.Id == 0) { db.LandValuations.Add(model); } else { var landValuationInDB = db.LandValuations.Single(h => h.Id == model.Id); landValuationInDB.Description = model.Description; landValuationInDB.LandType = model.LandType; landValuationInDB.CostPerAnna = model.CostPerAnna; } db.SaveChanges(); return(RedirectToAction("Index", "LandValuation")); }
public ActionResult Save(LandTaxViewModel viewModel) { if (!ModelState.IsValid) { var invalidViewModel = new LandTaxViewModel { LandTaxHistory = viewModel.LandTaxHistory, }; return(View("LandTaxCalculationForm", invalidViewModel)); } if (viewModel.LandTaxHistory.Id == 0) { db.LandTaxHistories.Add(viewModel.LandTaxHistory); } db.SaveChanges(); string ReportType = "pdf"; LocalReport localReport = new LocalReport(); localReport.ReportPath = Server.MapPath("~/Reports/TaxReport.rdlc"); localReport.DataSources.Add(new ReportDataSource { Name = "HouseTax", Value = db.HouseTaxHistories.Where(h => h.Id == viewModel.LandTaxHistory.HouseTaxHistoryId).ToList() }); localReport.DataSources.Add(new ReportDataSource { Name = "LandTax", Value = db.LandTaxHistories.Where(l => l.Id == viewModel.LandTaxHistory.Id).ToList() }); localReport.DataSources.Add(new ReportDataSource { Name = "Citizen", Value = db.Citizens.Where(c => c.CitizenId == viewModel.LandTaxHistory.CitizenId).ToList() }); localReport.DataSources.Add(new ReportDataSource { Name = "Lands", Value = db.CitizenLands.Where(l => l.CitizenId == viewModel.LandTaxHistory.CitizenId).ToList() }); localReport.DataSources.Add(new ReportDataSource { Name = "houses", Value = db.CitizenHouses.Where(l => l.CitizenId == viewModel.LandTaxHistory.CitizenId).ToList() }); string reportType = ReportType; string mimeType; string encoding; string fileNameExtension; //if (ReportType == "Excel") //{ // fileNameExtension = "xlsx"; //} //else if (ReportType == "PDF") //{ // fileNameExtension = "pdf"; //} //else //{ // fileNameExtension = "docx"; //} string[] streams; Warning[] warnings; byte[] renderByte; renderByte = localReport.Render(reportType, "", out mimeType, out encoding, out fileNameExtension, out streams, out warnings); Response.AddHeader("content-disposition", "attachment:filename= TaxReport." + fileNameExtension); return(File(renderByte, fileNameExtension)); //return RedirectToAction("Index", "LandTax"); }
public MainWindowVM() { _model.PropertyChanged += (sender, args) => { RaisePropertyChanged(args.PropertyName); }; RefreshCitizenTable = new DelegateCommand(() => { _model.RefreshTables(); }); AddCitizen = new DelegateCommand(() => { AddCitizenWindow acw = new AddCitizenWindow(); acw.ShowDialog(); _model.RefreshTables(); }); EditCitizen = new DelegateCommand(() => { EditCitizenWindow ecw = new EditCitizenWindow(); ecw.DataContext = SelectedCitizen; Citizen ctz = SelectedCitizen; if (ecw.ShowDialog() == true) { using (var db = new CitizenDbContext()) { var citizen = (from i in db.Citizens where i.Id == ctz.Id select i).First(); citizen.Name = ctz.Name; citizen.Surname = ctz.Surname; citizen.Patronym = ctz.Patronym; db.SaveChanges(); } _model.RefreshTables(); } }); DeleteCitizen = new DelegateCommand(() => { using (var db = new CitizenDbContext()) { var citizen = (from i in db.Citizens where i.Id == SelectedCitizen.Id select i).First(); db.Citizens.Remove(citizen); db.SaveChanges(); } _model.RefreshTables(); }); AddPerson = new DelegateCommand(() => { AddPersonWindow apw = new AddPersonWindow(); apw.ShowDialog(); _model.RefreshTables(); }); EditPerson = new DelegateCommand(() => { EditPersonWindow epw = new EditPersonWindow(); Person prs = SelectedPerson; epw.DataContext = prs; if (epw.ShowDialog() == true) { using (var db = new CitizenDbContext()) { var person = (from i in db.Persons where i.Id == prs.Id select i).First(); person.Cypher = prs.Cypher; person.Inn = prs.Inn; person.Type = prs.Type; person.Date = prs.Date; person.CitizenId = prs.CitizenId; db.SaveChanges(); } _model.RefreshTables(); } }); DeletePerson = new DelegateCommand(() => { using (var db = new CitizenDbContext()) { var person = (from i in db.Persons where i.Id == SelectedPerson.Id select i).First(); db.Persons.Remove(person); db.SaveChanges(); } _model.RefreshTables(); }); AddDocument = new DelegateCommand(() => { AddDocumentWindow adw = new AddDocumentWindow(); adw.ShowDialog(); _model.RefreshTables(); }); EditDocument = new DelegateCommand(() => { EditDocumentWindow edw = new EditDocumentWindow(); Document doc = SelectedDocument; edw.DataContext = doc; if (edw.ShowDialog() == true) { using (var db = new CitizenDbContext()) { var document = (from i in db.Documents where i.Id == doc.Id select i).First(); document.Name = doc.Name; document.Serial = doc.Serial; document.WhereIssued = doc.WhereIssued; document.DateIssued = doc.DateIssued; document.CitizenId = doc.CitizenId; db.SaveChanges(); } _model.RefreshTables(); } }); DeleteDocument = new DelegateCommand(() => { using (var db = new CitizenDbContext()) { var document = (from i in db.Documents where i.Id == SelectedDocument.Id select i).First(); db.Documents.Remove(document); db.SaveChanges(); } _model.RefreshTables(); }); FindByCypher = new DelegateCommand(() => { FindByCypherWindow fbc = new FindByCypherWindow(); fbc.Show(); }); SaveToJSON = new DelegateCommand(() => { _model.SaveToJSON(Citizens, Persons, Documents); MessageBox.Show("Все сохранено"); }); }