private void saveFuneral()
{
Funeral funeral = null;
if (IsCreateMode)
{
funeral = new Funeral()
{
FuneralID = Guid.NewGuid()
};
}
else
{
funeral = new FuneralService().getByID(this.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;
// FuneralCompany company = new FuneralCompanyService().getByID(ddlFuneralCompany.SelectedValue);
if (IsCreateMode)
{
new FuneralService().create(funeral);
Response.Redirect(string.Format("/Pages/FuneralsDetails?FuneralID={0}", funeral.FuneralID.ToString()));
}
else
{
new FuneralService().update(funeral);
}
}
public ActionResult DeactivateFuneral(Guid funeralId)
{
var returnObject = FuneralService.DeactivateFuneral(funeralId);
return(returnObject.State == "success"
? Json(new { state = "success", funeralId = returnObject.Id }, JsonRequestBehavior.AllowGet)
: Json(new { state = "success", message = "" }, JsonRequestBehavior.AllowGet));
}
protected void btnDelete_ServerClick(object sender, EventArgs e)
{
Funeral funeral = new FuneralService().getByID(FuneralID.ToString());
if (funeral != null)
{
new FuneralService().delete(funeral);
}
Response.Redirect("/Pages/FuneralsList.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 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 loadFuneral()
{
Funeral funeral = new FuneralService().getByID(FuneralID.ToString());
if (funeral != null)
{
txtFuneralDate.Text = funeral.FuneralShortDateFormatted;
ddlFuneralCompany.SelectedValue = funeral.FuneralCompanyID.ToString();
ddlStaffPerson.SelectedValue = funeral.CemeteryStaffPersonID.ToString();
//txtFieldNumber.Text = funeral.FieldNumber;
//txtGraveNumber.Text = funeral.GraveNumber;
//ddlType.SelectedValue = ((int)funeral.Type).ToString();
//ddlStatus.SelectedValue = ((int)funeral.Status).ToString();
//ddlPaymentClass.SelectedValue = funeral.PaymentClassID.ToString();
//txtPaymentDate.Text = funeral.PaymentDateFormatted;
//txtDescription.Text = funeral.Description;
}
else
{
Response.Redirect("/Pages/FuneralsList.aspx");
}
}
public ActionResult CreateFuneral(List <KeyValue> deceased, List <KeyValue> informant, List <KeyValue> nextOfKin,
List <KeyValue> doctor, List <KeyValue> homeAffairsOfficer, List <KeyValue> funeral)
{
if (funeral == null)
{
funeral = new List <KeyValue>();
}
if (deceased != null && deceased.Count > 0)
{
var deceasedAddress = KeyValueService.GetAttributeValue(deceased, "FullAddress");
if (deceasedAddress != null)
{
var address = new List <KeyValue>();
KeyValueService.AddAttribute(address, "Id", Guid.NewGuid().ToString());
KeyValueService.AddAttribute(address, "FullAddress", deceasedAddress);
var addressReturnObject = AddressService.InsertAddress(address);
if (addressReturnObject.State == "success")
{
KeyValueService.AddAttribute(deceased, "AddressId", addressReturnObject.Id);
}
}
var deceasedPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(deceased, "Id", deceasedPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(deceased, GetCurrentUserId());
var deceasedPersonReturnObject = PersonService.InsertPerson(deceased);
if (deceasedPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(deceased, "PersonId", deceasedPersonId);
var deceasedReturnObject = DeceasedService.InsertDeceased(deceased);
if (deceasedReturnObject.State == "success")
{
KeyValueService.AddAttribute(funeral, "DeceasedId", deceasedReturnObject.Id);
}
}
}
if (informant != null && informant.Count > 0)
{
var informantPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(informant, "Id", informantPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(informant, GetCurrentUserId());
var informantPersonReturnObject = PersonService.InsertPerson(informant);
if (informantPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(informant, "PersonId", informantPersonId);
var informantReturnObject = InformantService.InsertInformant(informant);
if (informantReturnObject.State == "success")
{
KeyValueService.AddAttribute(funeral, "InformantId", informantReturnObject.Id);
}
}
}
if (nextOfKin != null && nextOfKin.Count > 0)
{
var nextOfKinPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(nextOfKin, "Id", nextOfKinPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(nextOfKin, GetCurrentUserId());
var nextOfKinPersonReturnObject = PersonService.InsertPerson(nextOfKin);
if (nextOfKinPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(nextOfKin, "PersonId", nextOfKinPersonId);
var nextOfKinReturnObject = NextOfKinService.InsertNextOfKin(nextOfKin);
if (nextOfKinReturnObject.State == "success")
{
KeyValueService.AddAttribute(funeral, "NextOfKinId", nextOfKinReturnObject.Id);
}
}
}
if (doctor != null && doctor.Count > 0)
{
if (KeyValueService.AttributeContainsValue(doctor, "Id"))
{
var doctorPersonId = KeyValueService.GetAttributeValue(doctor, "Id");
KeyValueService.AddAttribute(funeral, "DoctorId", doctorPersonId);
}
else
{
var doctorPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(doctor, "Id", doctorPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(doctor, GetCurrentUserId());
var nextOfKinPersonReturnObject = PersonService.InsertPerson(doctor);
if (nextOfKinPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(doctor, "PersonId", doctorPersonId);
var doctorReturnObject = DoctorService.InsertDoctor(doctor);
if (doctorReturnObject.State == "success")
{
KeyValueService.AddAttribute(funeral, "DoctorId", doctorReturnObject.Id);
}
}
}
}
if (homeAffairsOfficer != null && homeAffairsOfficer.Count > 0)
{
if (KeyValueService.AttributeContainsValue(homeAffairsOfficer, "Id"))
{
var homeAffairsOfficerPersonId = KeyValueService.GetAttributeValue(homeAffairsOfficer, "Id");
KeyValueService.AddAttribute(funeral, "HomeAffairsOfficerId", homeAffairsOfficerPersonId);
}
else
{
var homeAffairsOfficerPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(homeAffairsOfficer, "Id", homeAffairsOfficerPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(homeAffairsOfficer, GetCurrentUserId());
var homeAffairsOfficerPersonReturnObject = PersonService.InsertPerson(homeAffairsOfficer);
if (homeAffairsOfficerPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(homeAffairsOfficer, "PersonId",
homeAffairsOfficerPersonReturnObject.Id);
var homeAffairsOfficerReturnObject =
HomeAffairsOfficerService.InsertHomeAffairesOfficer(homeAffairsOfficer);
if (homeAffairsOfficerReturnObject.State == "success")
{
KeyValueService.AddAttribute(funeral, "HomeAffairsOfficerId",
homeAffairsOfficerReturnObject.Id);
}
}
}
}
if (funeral.Count <= 0)
{
return(Json(new { state = "error", message = "" }, JsonRequestBehavior.AllowGet));
}
var funeralId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(funeral, "Id", funeralId);
#region Get Vehicle Number
var counterConfiguration = NumberConfigurationService.GetNextNumber("funeral");
var counterConfigurationId = (Guid)counterConfiguration.FirstOrDefault(x => x.Key == "Id").Value;
var entityName = (string)counterConfiguration.FirstOrDefault(x => x.Key == "EntityName").Value;
var nextNumber = (int)counterConfiguration.FirstOrDefault(x => x.Key == "NextNumber").Value;
var prefix = (string)counterConfiguration.FirstOrDefault(x => x.Key == "Prefix").Value;
var incrementBy = (int)counterConfiguration.FirstOrDefault(x => x.Key == "IncrementBy").Value;
var length = (int)counterConfiguration.FirstOrDefault(x => x.Key == "Length").Value;
var number = length == 0 ? "" : nextNumber.ToString("D" + length);
var funeralNumber = prefix + number;
#endregion
KeyValueService.AddAttribute(funeral, "FuneralNumber", funeralNumber);
GenericModelService.AddAuditAttributeForCreateEvent(funeral, GetCurrentUserId());
var funeralReturnObject = FuneralService.InsertFuneral(funeral);
if (funeralReturnObject.State != "success")
{
return(Json(new { state = "error", message = "" }, JsonRequestBehavior.AllowGet));
}
nextNumber = nextNumber + incrementBy;
NumberConfigurationService.SetNextNumber(counterConfigurationId.ToString(), entityName, nextNumber);
return(Json(new { state = "success", funeralId = funeralReturnObject.Id }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateFuneral(List <KeyValue> deceased, List <KeyValue> informant, List <KeyValue> nextOfKin,
List <KeyValue> doctor, List <KeyValue> homeAffairsOfficer, List <KeyValue> funeral)
{
var funeralId = Guid.Empty;
if (funeral == null)
{
funeral = new List <KeyValue>();
}
else
{
funeralId = Guid.Parse(funeral.FirstOrDefault(x => x.Key == "Id")?.Value);
}
if (deceased != null && deceased.Count > 0)
{
KeyValueService.AddAttribute(deceased, "ModifiedById", GetCurrentUserId());
var deceasedPersonReturnObject = PersonService.UpdatePerson(deceased);
if (deceasedPersonReturnObject.State == "success")
{
var deceasedReturnObject = DeceasedService.UpdateDeceased(deceased);
}
}
if (informant != null && informant.Count > 0)
{
var existingInformantCount = InformantService.QueryCountOfInformantsByFuneralId(funeralId);
if (existingInformantCount > 0)
{
KeyValueService.AddAttribute(informant, "ModifiedById", GetCurrentUserId());
var informantPersonReturnObject = PersonService.UpdatePerson(informant);
if (informantPersonReturnObject.State == "success")
{
var informantReturnObject = InformantService.UpdateInformant(informant);
}
}
else
{
var informantPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(informant, "Id", informantPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(informant, GetCurrentUserId());
var informantPersonReturnObject = PersonService.InsertPerson(informant);
if (informantPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(informant, "PersonId", informantPersonId);
var informantReturnObject = InformantService.InsertInformant(informant);
if (informantReturnObject.State == "success")
{
KeyValueService.SetOrAddAttribute(funeral, "InformantId", informantReturnObject.Id);
}
}
}
}
if (nextOfKin != null && nextOfKin.Count > 0)
{
var existingNextOfKinCount = NextOfKinService.QueryCountOfNextOsKinssByFuneralId(funeralId);
if (existingNextOfKinCount > 0)
{
KeyValueService.AddAttribute(nextOfKin, "ModifiedById", GetCurrentUserId());
var nextOfKinPersonReturnObject = PersonService.UpdatePerson(nextOfKin);
if (nextOfKinPersonReturnObject.State == "success")
{
var nextOfKinReturnObject = NextOfKinService.UpdateNextOfKin(nextOfKin);
}
}
else
{
var nextOfKinPersonId = Guid.NewGuid().ToString();
KeyValueService.AddAttribute(nextOfKin, "Id", nextOfKinPersonId);
GenericModelService.AddAuditAttributeForCreateEvent(nextOfKin, GetCurrentUserId());
var nextOfKinPersonReturnObject = PersonService.InsertPerson(nextOfKin);
if (nextOfKinPersonReturnObject.State == "success")
{
KeyValueService.AddAttribute(nextOfKin, "PersonId", nextOfKinPersonId);
var nextOfKinReturnObject = NextOfKinService.InsertNextOfKin(nextOfKin);
if (nextOfKinReturnObject.State == "success")
{
KeyValueService.SetOrAddAttribute(funeral, "NextOfKinId", nextOfKinReturnObject.Id);
}
}
}
}
//if (doctor != null && doctor.Count > 0)
//{
// var existingDoctorCount = DoctorService.QueryCountOfDoctorsByFuneralId(funeralId);
// if (existingDoctorCount > 0)
// {
// KeyValueService.AddAttribute(doctor, "ModifiedById", GetCurrentUserId());
// var nextOfKinPersonReturnObject = PersonService.UpdatePerson(doctor);
// if (nextOfKinPersonReturnObject.State == "success")
// {
// DoctorService.UpdateDoctor(doctor);
// }
// }
// else
// {
// var doctorPersonId = Guid.NewGuid().ToString();
// KeyValueService.AddAttribute(doctor, "Id", doctorPersonId);
// GenericModelService.AddAuditAttributeForCreateEvent(doctor, GetCurrentUserId());
// var nextOfKinPersonReturnObject = PersonService.InsertPerson(doctor);
// if (nextOfKinPersonReturnObject.State == "success")
// {
// KeyValueService.AddAttribute(doctor, "PersonId", doctorPersonId);
// var doctorReturnObject = DoctorService.InsertDoctor(doctor);
// KeyValueService.SetOrAddAttribute(funeral, "DoctorId", doctorReturnObject.Id);
// }
// }
//}
//if (homeAffairsOfficer != null && homeAffairsOfficer.Count > 0)
//{
// var existingHomeAffairsOfficerCount = HomeAffairsOfficerService.QueryCountOfHomeAffairsOfficersByFuneralId(funeralId);
// if(existingHomeAffairsOfficerCount > 0)
// {
// KeyValueService.AddAttribute(homeAffairsOfficer, "ModifiedById", GetCurrentUserId());
// var homeAffairsOfficerPersonReturnObject = PersonService.UpdatePerson(homeAffairsOfficer);
// }
// else
// {
// var homeAffairsOfficerPersonId = Guid.NewGuid().ToString();
// KeyValueService.AddAttribute(homeAffairsOfficer, "Id", homeAffairsOfficerPersonId);
// GenericModelService.AddAuditAttributeForCreateEvent(homeAffairsOfficer, GetCurrentUserId());
// var homeAffairsOfficerPersonReturnObject = PersonService.InsertPerson(homeAffairsOfficer);
// if (homeAffairsOfficerPersonReturnObject.State == "success")
// {
// KeyValueService.AddAttribute(homeAffairsOfficer, "PersonId", Guid.NewGuid().ToString());
// var homeAffairsOfficerReturnObject = HomeAffairsOfficerService.InsertHomeAffairesOfficer(homeAffairsOfficer);
// if(homeAffairsOfficerReturnObject.State == "success")
// {
// KeyValueService.SetOrAddAttribute(funeral, "HomeAffairsOfficerId", homeAffairsOfficerReturnObject.Id);
// }
// }
// }
//}
if (funeral.Count <= 0)
{
return(Json("error", JsonRequestBehavior.AllowGet));
}
KeyValueService.AddAttribute(funeral, "ModifiedById", GetCurrentUserId());
var funeralReturnObject = FuneralService.UpdateFuneral(funeral);
return(funeralReturnObject.State == "success"
? Json(new { state = "success", funeralId = funeralReturnObject.Id }, JsonRequestBehavior.AllowGet)
: Json("error", JsonRequestBehavior.AllowGet));
}
public ActionResult GetFuneralById(Guid funeralId)
{
var record = FuneralService.QueryFuneralById(funeralId);
return(Json(record, JsonRequestBehavior.AllowGet));
}
public ActionResult GetActiveFunerals(int pageNumber, int listType)
{
var records = FuneralService.QueryActiveFunerals(pageNumber, listType);
return(Json(records, JsonRequestBehavior.AllowGet));
}
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);
}
}
