public JsonResult Post(DeadPerson deadp)
{
string query = @"
insert into dbo.DeadPeople values
(N'" + deadp.Name + @"', N'" + deadp.DateOfBirth + @"',
N'" + deadp.DateOfDeath + @"', '" + deadp.LodgingId + @"')";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("CmentarzConnectionTEST");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
return(new JsonResult("Dodano pomyślnie"));
}
}
public JsonResult Put(DeadPerson deadp)
{
string query = @"
update dbo.DeadPeople set
Name = N'" + deadp.Name + @"',
DateOfBirth = '" + deadp.DateOfBirth + @"',
DateOfDeath = '" + deadp.DateOfDeath + @"',
LodgingId = '" + deadp.LodgingId + @"'
where IdDeadPerson = '" + deadp.IdDeadPerson + @"'";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("CmentarzConnectionTEST");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
return(new JsonResult("Zaktualizowano pomyślnie"));
}
}
internal void delete(DeadPerson deadPerson)
{
using (ApplicationDbContext dbContext = new ApplicationDbContext())
{
new DeadPersonRepository(dbContext).delete(deadPerson);
dbContext.SaveChanges();
}
}
public void DeleteDeadPersonFromDb(DeadPerson deadp)
{
if (deadp == null)
{
throw new ArgumentNullException(nameof(deadp));
}
_context.DeadPeople.Remove(deadp);
}
public void AddDeadPersonToDb(DeadPerson deadp)
{
if (deadp == null)
{
throw new ArgumentException(nameof(deadp));
}
_context.DeadPeople.Add(deadp);
}
public void update(DeadPerson deadPerson)
{
try
{
using (ApplicationDbContext dbContext = new ApplicationDbContext())
{
new DeadPersonRepository(dbContext).update(deadPerson);
dbContext.SaveChanges();
}
}
catch (Exception ex) { }
}
public void Handle(PersonDied message)
{
Person person = storage.Load <Person>(message.Id);
DeadPerson deadPerson = new DeadPerson(person.AggregateId)
{
Name = person.Name
};
storage.Remove(person);
storage.Add(deadPerson);
}
public void Handle(PersonDied message)
{
Person person = storage.Items <Person>().Where(p => p.Id == message.Id).Single();
DeadPerson deadPerson = new DeadPerson
{
Id = person.Id,
Name = person.Name
};
storage.Remove(person);
storage.Add(deadPerson);
}
public DeadPerson getByID(Guid id)
{
try
{
DeadPerson deadPerson = null;
using (ApplicationDbContext db = new ApplicationDbContext())
{
deadPerson = new DeadPersonRepository(db).getByID(id.ToString());
}
return(deadPerson);
}
catch (Exception ex) { }
return(null);
}
public DeadPerson create(DeadPerson deadPerson)
{
try
{
using (ApplicationDbContext dbContext = new ApplicationDbContext())
{
new DeadPersonRepository(dbContext).create(deadPerson);
dbContext.SaveChanges();
return(deadPerson);
}
}
catch (Exception ex) { }
return(null);
}
private void bindFuneralList()
{
try
{
List <Funeral> listFuneral = new FuneralService().getAll();
List <Guid> listFuneralID = listFuneral.Select(x => x.FuneralID).ToList();
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => listFuneralID.Contains(x.FuneralID));
List <FuneralViewModel> listFuneralViewModel = new List <FuneralViewModel>();
for (int i = 0; i < listFuneral.Count; i++)
{
DeadPerson deadPerson = listDeadPerson.FirstOrDefault(x => x.FuneralID.Equals(listFuneral[i].FuneralID));
listFuneralViewModel.Add(new FuneralViewModel(listFuneral[i], deadPerson));
}
repFuneral.DataSource = listFuneralViewModel;
repFuneral.DataBind();
}
catch (Exception ex) { }
}
public void AddDeadPersonToDb(DeadPerson deadp)
{
throw new NotImplementedException();
}
public BurialPlaceViewModel(BurialPlace burialPlace, DeadPerson deadPerson)
{
this.BurialPlace = burialPlace;
this.DeadPerson = deadPerson;
}
public FuneralViewModel(Funeral funeral, DeadPerson deadPerson)
{
this.Funeral = funeral;
this.DeadPerson = deadPerson;
}
public void UpdateDeadPerson(DeadPerson deadp)
{
throw new NotImplementedException();
}
public void DeleteDeadPersonFromDb(DeadPerson deadp)
{
throw new NotImplementedException();
}
public DeadPersonViewModel(DeadPerson deadPerson)
{
this.DeadPerson = deadPerson;
}
public void UpdateDeadPerson(DeadPerson deadp)
{
}
public BookedServiceViewModel(BookedService bookedService, DeadPerson deadPerson)
{
this.BookedService = bookedService;
this.DeadPerson = deadPerson;
}
private void saveDeadPerson()
{
Funeral funeral = null;
DeadPerson deadPerson = null;
if (IsCreateMode)
{
funeral = new Funeral()
{
FuneralID = Guid.NewGuid()
};
deadPerson = new DeadPerson()
{
DeadPersonID = Guid.NewGuid()
};
}
else
{
deadPerson = new DeadPersonService().getByID(this.DeadPersonID.ToString());
funeral = new FuneralService().getByID(deadPerson.FuneralID.ToString());
}
FuneralCompany funeralCompany = new FuneralCompanyService().getByID(ddlFuneralCompany.SelectedValue);
CemeteryStaffPerson cemeteryStaff = new CemeteryStaffPersonService().getByID(ddlStaffPerson.SelectedValue);
funeral.FuneralDate = DateTime.ParseExact(txtFuneralDate.Text.Trim(), "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture);
funeral.FuneralCompanyID = funeralCompany.FuneralCompanyID;
funeral.CemeteryStaffPersonID = cemeteryStaff.CemeteryStaffPersonID;
BurialPlace burialPlace = new BurialPlaceService().getByID(ddlGraveNumber.SelectedValue);
deadPerson.FirstName = txtFirstName.Text;
deadPerson.LastName = txtLastName.Text;
deadPerson.PESEL = txtPesel.Text;
deadPerson.Gender = (EnumGender)int.Parse(ddlGender.SelectedValue);
deadPerson.BurialPlaceID = burialPlace.BurialPlaceID;
deadPerson.FuneralID = funeral.FuneralID;
try
{
Guid familyMemberID = Guid.Parse(ddlFamilyMember.SelectedValue);
if (familyMemberID == Guid.Empty)
{
deadPerson.FamilyMemberID = null;
deadPerson.FamilyMember = null;
}
else
{
if (!IsCreateMode)
{
deadPerson.FamilyMember = new FamilyMemberService().getBy(x => x.FamilyMemberID.Equals(familyMemberID))[0];
}
deadPerson.FamilyMemberID = familyMemberID;
}
}
catch (Exception ex) { }
if (IsCreateMode)
{
new FuneralService().create(funeral);
new DeadPersonService().create(deadPerson);
Response.Redirect(string.Format("/Pages/DeadPersonsDetails?DeadPersonID={0}", deadPerson.DeadPersonID.ToString()));
}
else
{
new DeadPersonService().update(deadPerson);
}
}
