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");
}
}
}
