private void bindDeadPersonForFamilyMember(ApplicationUser user)
{
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => x.FamilyMemberID.HasValue && x.FamilyMemberID.Value.Equals(user.FamilyMemberID));
ddlDeadPerson.Items.Clear();
ddlDeadPerson.Items.AddRange(listDeadPerson.Select(x => new ListItem(x.NameFormatted, x.DeadPersonID.ToString())).ToArray());
}
private void bindBookedServiceList(ApplicationUser user)
{
List <BookedService> listBookedService = new BookedServicesService().getByFamilyMemberID(user.FamilyMemberID.Value);
List <Guid> listBurialPlaceID = listBookedService.Select(x => x.BurialPlace.BurialPlaceID).ToList();
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => listBurialPlaceID.Contains(x.BurialPlaceID)).ToList();
repBookedServices.DataSource = listBookedService.Select(x => new BookedServiceViewModel(x, listDeadPerson.FirstOrDefault(y => y.BurialPlaceID.Equals(x.BurialPlaceID))));
repBookedServices.DataBind();
}
private void bindDeadPersonList()
{
ApplicationUser user = new UserService().getCurrentUser(Context);
if (user.FamilyMember != null)
{
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => x.FamilyMemberID.HasValue && x.FamilyMemberID.Equals(user.FamilyMember.FamilyMemberID));
repDeadPersons.DataSource = listDeadPerson;
repDeadPersons.DataBind();
}
}
protected void btnDelete_ServerClick(object sender, EventArgs e)
{
DeadPerson deadPerson = new DeadPersonService().getByID(DeadPersonID.ToString());
if (deadPerson != null)
{
new DeadPersonService().delete(deadPerson);
}
Response.Redirect("/Pages/DeadPersonsList.aspx");
}
private void loadDeadPerson()
{
DeadPerson deadPerson = new DeadPersonService().getByID(DeadPersonID.ToString());
if (deadPerson != null)
{
txtFirstName.Text = deadPerson.FirstName.ToString();
txtLastName.Text = deadPerson.LastName.ToString();
txtPesel.Text = deadPerson.PESEL.ToString();
ddlGender.DataSource = Enum.GetNames(typeof(EnumGender));
if (deadPerson.FamilyMemberID.HasValue)
{
ddlFamilyMember.SelectedValue = deadPerson.FamilyMemberID.Value.ToString();
}
else
{
ddlFamilyMember.SelectedValue = "";
}
int gender;
if (deadPerson.Gender == EnumGender.MALE)
{
gender = 0;
}
else
{
gender = 1;
}
ddlGender.SelectedValue = gender.ToString();
ddlGraveNumber.SelectedValue = deadPerson.BurialPlaceID.ToString();
Funeral funeral = new FuneralService().getByID(deadPerson.FuneralID.ToString());
txtFuneralDate.Text = funeral.FuneralShortDateFormatted;
}
else
{
Response.Redirect("/Pages/DeadPersonsList.aspx");
}
}
private void bindDeadPersonList()
{
try
{
List <DeadPerson> listDeadPerson = new DeadPersonService().getAll();
List <Guid> listDeadPersonID = listDeadPerson.Select(x => x.DeadPersonID).ToList();
List <DeadPersonViewModel> listDeadPersonViewModel = new List <DeadPersonViewModel>();
for (int i = 0; i < listDeadPerson.Count; i++)
{
listDeadPersonViewModel.Add(new DeadPersonViewModel(listDeadPerson[i]));
}
repDeadPerson.DataSource = listDeadPersonViewModel;
repDeadPerson.DataBind();
}
catch (Exception ex) { }
}
public void bindFamilyMemberDeadPerson()
{
DeadPerson deadPerson = new DeadPersonService().getByID(this.FamilyMemberDeadPersonID);
if (deadPerson == null)
{
Response.Redirect("/Pages/FamilyMemberDeadPersonsList");
}
else
{
txtFirstName.Text = deadPerson.FirstName;
txtLastName.Text = deadPerson.LastName;
txtPESEL.Text = deadPerson.PESEL;
txtFuneralDate.Text = deadPerson.Funeral?.FuneralShortDateFormatted;
txtFuneralCompany.Text = deadPerson.Funeral?.FuneralCompany?.Name;
txtFuneralStaffPerson.Text = deadPerson.Funeral?.CemeteryStaffPerson?.NameFormatted;
txtBurialPlaceFieldNumber.Text = deadPerson.BurialPlace?.FieldNumber;
txtBurialPlaceGraveNumber.Text = deadPerson.BurialPlace?.GraveNumber;
}
}
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) { }
}
private void bindBurialPlaceList()
{
try
{
List <BurialPlace> listBurialPlace = new BurialPlaceService().getAll();
List <Guid> listBurialPlaceID = listBurialPlace
.Select(x => x.BurialPlaceID)
.ToList();
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => x.BurialPlaceID != null && listBurialPlaceID.Contains(x.BurialPlaceID));
List <BurialPlaceViewModel> listBurialPlaceViewModel = listBurialPlace
.Select(x => new BurialPlaceViewModel(
x,
listDeadPerson.Find(y => y.BurialPlaceID.Equals(x.BurialPlaceID))))
.ToList();
repBurialPlace.DataSource = listBurialPlaceViewModel;
repBurialPlace.DataBind();
}
catch (Exception ex) { }
}
private void Tick(object sender, ElapsedEventArgs a)
{
DateTime dateNow = DateTime.Today;
// where the payment period is less than 30 days
DateTime compareDate = dateNow.AddDays(30);
List <BurialPlace> listPlaces = new BurialPlaceService().getBy(x => x.PaymentDate <= compareDate);
List <Guid> listPlacesId = listPlaces.Select(x => x.BurialPlaceID).ToList();
List <DeadPerson> listDeadPerson = new DeadPersonService().getBy(x => listPlacesId.Contains(x.BurialPlaceID));
List <Guid?> listFamilyId = listDeadPerson.Select(x => x.FamilyMemberID).ToList();
List <ApplicationUser> listUser = new UserService().getBy(x => listFamilyId.Contains(x.FamilyMemberID));
List <String> emails = listUser.Select(x => x.Email).ToList();
EmailService service = new EmailService();
service.sendMail(emails);
}
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);
}
}
