private void FillDocument(tblDeadRegistration deadRegistration) { lbl_Amana.Text = labelIssuedBy.Text = labelIssuedBy1.Text = Helper.GetAmanaNameByEmp(Session["CurrUser"]); lbl_Government.Text = labelGovernorate.Text = Helper.GetAffairsNameByEmp(Session["CurrUser"]); labelIdHusband.Text = deadRegistration.tblCitizen.NationalNumber; labelNameController.Text = Helper.GetControllerNameByEmp(Session["CurrUser"]); labelRegistrar.Text = Helper.GetCivilRegistrarByEmp(Session["CurrUser"]); labelFirstNameHusbasd.Text = deadRegistration.tblCitizen.FirstName; var father = Helper.GetCitizen(deadRegistration.tblCitizen.FatherNationalNumber); labelFatherNameHusband.Text = (father != null) ? father.FirstName : string.Empty; var mother = Helper.GetCitizen(deadRegistration.tblCitizen.MotherNationalNumber); labelMotherNameHusband.Text = (mother != null) ? mother.FirstName + " " + mother.LastName : string.Empty; labelLastNameHusband.Text = deadRegistration.tblCitizen.LastName; labelIdFatherHusband.Text = (father != null) ? father.NationalNumber : string.Empty; labelIdMotherHusband.Text = (mother != null) ? mother.NationalNumber : string.Empty; labelAlamanaHusband.Text = Helper.GetAmanaNameByEmp(Session["CurrUser"]); labelPlaceEntryHusband.Text = deadRegistration.tblCitizen.KiedPlace; labelRegistrationNumberHusbans.Text = deadRegistration.tblCitizen.KiedNumber; lblHusbandId.Text = deadRegistration.tblCitizen.Id.ToString(); labelNotes.Text = deadRegistration.Notes; Gender.Text = deadRegistration.tblCitizen.Gender == "0" ? "أنثى" : "ذكر"; label_DocumentNumber.Text = deadRegistration.tblCitizen.Id.ToString(); lblMarrageDate.Text = deadRegistration.IncidentDate; lblDeadBirthday.Text = deadRegistration.tblCitizen.Birthday; lblDeadPlace.Text = deadRegistration.DeadPlace; Nationality.Text = (deadRegistration.tblCitizen.Gender == "0") ? "سورية" : "سوري"; }
protected void Page_Load(object sender, EventArgs e) { tblRole role = (tblRole)Session["Role"]; if (role == null || !role.DeathOut) { Response.Redirect("/403"); } try { string NationalNumber = (string)Session["SVCNationalNumber"]; string[] nums = NationalNumber.Split(';'); FatherNationalNumber = nums[0]; ChildNationalNumber = nums[1]; } catch { } using (EGovernmentEntities db = new EGovernmentEntities()) { tblDeadRegistration deadRegistration = db.tblDeadRegistrations.Where(x => x.NationalNumber == ChildNationalNumber).FirstOrDefault(); if (deadRegistration != null) { FillDocument(deadRegistration); } } }
public static bool CheckDuration(string HusbandNationalNum, string WifeNationalNum, int Days, IncidentType _IncidentType) { bool res = true; using (EGovernmentEntities db = new EGovernmentEntities()) { switch (_IncidentType) { case IncidentType.Divorce: tblDivorceIncident divorceIncident = GetLastDivorceIncident(HusbandNationalNum, WifeNationalNum); if (divorceIncident != null) { res = (DateTime.Now - DateTime.Parse(divorceIncident.IncidentDate)).TotalDays >= Days; } break; case IncidentType.Death: tblMarriageContract marriageContract = db.tblMarriageContracts.Where(x => x.HusbandNationalNum == HusbandNationalNum).Where(y => y.WifeNationalNum == WifeNationalNum).OrderByDescending(z => z.IncidentNumber).FirstOrDefault(); if (marriageContract != null) { if (IsDead(marriageContract.HusbandNationalNum)) { tblDeadRegistration deadRegistration = db.tblDeadRegistrations.Where(x => x.NationalNumber == HusbandNationalNum).FirstOrDefault(); if (deadRegistration != null) { res = (DateTime.Now - DateTime.Parse(deadRegistration.DeadDate)).TotalDays >= Days; } } } break; } } return(res); }
protected void btnNext_Click(object sender, EventArgs e) { if (Page.IsValid) { string FatherNationalNumber = Helper.GetCitizen(DeadNationalNumber.Text).FatherNationalNumber; int Penalty = Helper.GetPenalty(FatherNationalNumber, (int)(DateTime.Today - DateTime.Parse(DeadDate.Value)).TotalDays, IncidentType.Death); if (!Helper.CheckBalance(FatherNationalNumber, Penalty)) { lblErrorMSG.Visible = true; lblErrorMSG1.Text = "لا يمكن تسجيل الوفاة لأن حسابك لا يحوي على المبلغ الكافي لتسديد الضريبة"; return; } else { lblErrorMSG.Visible = false; } using (EGovernmentEntities db = new EGovernmentEntities()) { if (db.tblCitizens.Where(x => x.NationalNumber == DeadNationalNumber.Text).ToList().Count == 0) { lblErrorMSG.Visible = true; lblErrorMSG1.Text = "الرقم الوطني المدخل غير موجود في قاعدة البيانات"; return; } else { lblErrorMSG.Visible = false; } if (Helper.GetDate(DeadDate.Value) > DateTime.Now) { lblErrorMSG.Visible = true; lblErrorMSG1.Text = "تاريخ الوفاة أكبر من التاريخ الحالي"; return; } else { lblErrorMSG.Visible = false; } tblDeadRegistration deadRegistration = new tblDeadRegistration(); deadRegistration.NationalNumber = DeadNationalNumber.Text; deadRegistration.PoliceReportNum = PoliceReportNum.Text; deadRegistration.DeadPlace = DeadPlace.Text; deadRegistration.DeadDate = DeadDate.Value; deadRegistration.DoctorName = DoctorName.Text; deadRegistration.DeadReason = DeadReason.Text; deadRegistration.Notes = Notes.Text; deadRegistration.IncidentDate = DateTime.Now.ToShortDateString(); db.tblDeadRegistrations.AddObject(deadRegistration); db.SaveChanges(); List <string> lstWifes = Helper.GetActualWifes(DeadNationalNumber.Text); foreach (string wife in lstWifes) { Helper.EditSocialNumber(wife, SocialStatus.Widow); } Helper.Pay(FatherNationalNumber, Penalty); Response.Redirect("/Finish"); } } }