protected void Page_Load(object sender, EventArgs e)
{
tblRole role = (tblRole)Session["Role"];
if (role == null || !role.ICR_Out)
{
Response.Redirect("/403");
}
try
{
_NationalNumber = (string)Session["SVCNationalNumber"];
}
catch { }
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCitizen citizen = db.tblCitizens.Where(x => x.NationalNumber == _NationalNumber).FirstOrDefault();
if (citizen != null)
{
FillDocument(citizen);
}
}
}
public static void SyncCitizens()
{
List <tblCitizen> lstCitizens = RestHelper.GetCitizens();
using (EGovernmentEntities db = new EGovernmentEntities())
{
foreach (tblCitizen citizen in lstCitizens)
{
if (db.tblCitizens.Where(x => x.NationalNumber == citizen.NationalNumber).ToList().Count == 0)
{
db.tblCitizens.AddObject(citizen);
db.SaveChanges();
}
else
{
tblCitizen _tblCitizen = db.tblCitizens.Where(x => x.NationalNumber == citizen.NationalNumber).FirstOrDefault();
_tblCitizen.FirstName = citizen.FirstName;
_tblCitizen.LastName = citizen.LastName;
_tblCitizen.FatherNationalNumber = citizen.FatherNationalNumber;
_tblCitizen.MotherNationalNumber = citizen.MotherNationalNumber;
_tblCitizen.Birthday = citizen.Birthday;
_tblCitizen.BirthPlace = citizen.BirthPlace;
_tblCitizen.KiedPlace = citizen.KiedPlace;
_tblCitizen.KiedNumber = citizen.KiedNumber;
_tblCitizen.Gender = citizen.Gender;
db.SaveChanges();
}
}
}
}
public static tblEmployeesCivilRegistry GetCivilRegistryEmployee(string NationalNumber)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblEmployeesCivilRegistries.Where(x => x.EmployeNationalNumber == NationalNumber).OrderByDescending(y => y.Id).Where(z => z.E_date == null).FirstOrDefault());
}
}
public static tblEmployeesCivilRegistry GetActiveEmployeeRecord(string nationalNum)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblEmployeesCivilRegistries.Where(x => x.EmployeNationalNumber == nationalNum).Where(x => x.E_date == null).FirstOrDefault());
}
}
public static tblEmployee GetEmployee(string EmployeeId)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblEmployees.Where(x => x.NationalNumber == EmployeeId).FirstOrDefault());
}
}
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 void EditSocialNumber(string NationalNumber, SocialStatus _SocialStatus)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCitizen citizen = db.tblCitizens.Where(x => x.NationalNumber == NationalNumber).FirstOrDefault();
switch (_SocialStatus)
{
case SocialStatus._Single:
citizen.SocialStatus = "1";
break;
case SocialStatus.Marriad:
citizen.SocialStatus = "2";
break;
case SocialStatus.Widow:
citizen.SocialStatus = "3";
break;
case SocialStatus.Divorced:
citizen.SocialStatus = "4";
break;
}
db.SaveChanges();
}
}
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 btnAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilregistry = null;
EditPage = (btnAdd.Text == "حفظ التعديلات");
if (!EditPage)
{
civilregistry = new tblCivilRegistry();
}
else
{
int CivilRegistryid = int.Parse(txtCivilRegistry.Text);
civilregistry = db.tblCivilRegistries.Where(x => x.Id == CivilRegistryid).FirstOrDefault();
}
civilregistry.Name = txtName.Text;
civilregistry.Area = txtArea.Text;
civilregistry.CivilAffairsID = Int32.Parse(ddlCivilAffairs.SelectedValue);
if (!EditPage)
{
db.tblCivilRegistries.AddObject(civilregistry);
}
db.SaveChanges();
}
Response.Redirect("/Finish");
}
}
public static int CivilRegistryId(string CivilRegistryName)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblCivilRegistries.Where(x => x.Name == CivilRegistryName).FirstOrDefault().Id);
}
}
public static string GetAmanaNameByEmp(object CurrUser)
{
string res = string.Empty;
try
{
tblEmployee emp = (tblEmployee)CurrUser;
tblEmployeesCivilRegistry employeesCivilRegistry = GetCivilRegistryEmployee(emp.NationalNumber);
if (employeesCivilRegistry != null)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilRegistry = db.tblCivilRegistries.Where(x => x.Id == employeesCivilRegistry.CivilRegistryID).FirstOrDefault();
if (civilRegistry != null)
{
res = civilRegistry.Name;
}
}
}
}
catch { res = "الأمانة المركزية"; }
return(res);
}
public static string GetCivilRegistrarById(int CivilRegistryID)
{
string res = string.Empty;
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilRegistry = db.tblCivilRegistries.Where(x => x.Id == CivilRegistryID).FirstOrDefault();
if (civilRegistry != null)
{
List <tblEmployeesCivilRegistry> lstEmployeesCivilRegistry = GetCivilRegistryEmployeesById(civilRegistry.Id);
foreach (var item in lstEmployeesCivilRegistry)
{
if (item.IsCivilRegisterer == true)
{
tblCitizen temp = GetCitizen(db.tblEmployees.Where(x => x.NationalNumber == item.EmployeNationalNumber).FirstOrDefault().NationalNumber);
if (temp != null)
{
res = string.Format("{0} {1}", temp.FirstName, temp.LastName);
}
break;
}
}
}
}
return(res);
}
public static List <tblEmployee> GetEmployeeByAffairs(int CivilRegistryID)
{
List <tblEmployee> lstEmployees = new List <tblEmployee>();
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilRegistry = db.tblCivilRegistries.Where(x => x.Id == CivilRegistryID).FirstOrDefault(); // جلب السجل المدني الموافق رقمه لل CivilRegistryID
tblCivilAffair civilAffair = db.tblCivilAffairs.Where(x => x.Id == civilRegistry.CivilAffairsID).FirstOrDefault(); // جلب الشؤون المدنية التي رقمها موافق لرقم السجل المدني civilRegistry
List <tblCivilRegistry> lstCivilRegistry = db.tblCivilRegistries.Where(x => x.CivilAffairsID == civilAffair.Id).ToList(); // جلب السجلات المدنية التابعة لهذه الشؤون المدنية civilAffair
foreach (tblCivilRegistry item in lstCivilRegistry) // جلب موظفين السجلات المدنية التالية lstCivilRegistry
{
List <tblEmployeesCivilRegistry> lstEmployeesCivilRegistry = db.tblEmployeesCivilRegistries.Where(x => x.CivilRegistryID == item.Id).ToList(); // جلب سجلات كسر الموظفين للسجل المدني item
foreach (var subitem in lstEmployeesCivilRegistry)
{
if (subitem.E_date == null) // الموظف يعمل
{
tblEmployee emp = db.tblEmployees.Where(x => x.NationalNumber == subitem.EmployeNationalNumber).FirstOrDefault();
if (emp != null)
{
lstEmployees.Add(emp);
}
}
}
}
}
return(lstEmployees);
}
public static int GetRoleId(string RoleName)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblRoles.Where(x => x.Name == RoleName).FirstOrDefault().Id);
}
}
protected void ddlCivilAffairs_SelectedIndexChanged(object sender, EventArgs e)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilregistry = new tblCivilRegistry();
int idCivilAffairs = int.Parse(ddlCivilAffairs.SelectedItem.Value);
var c = db.tblCivilRegistries.Where(b => b.CivilAffairsID == idCivilAffairs).ToList();
if (c.Count == 0)
{
lblNoData.Visible = true;
divCivilRegistry.Visible = false;
btnEdit.Visible = false;
}
else
{
lblNoData.Visible = false;
divCivilRegistry.Visible = true;
btnEdit.Visible = true;
}
ddlCivilRegistry.DataValueField = "Id";
ddlCivilRegistry.DataTextField = "Name";
ddlCivilRegistry.DataSource = c;
ddlCivilRegistry.DataBind();
}
}
private static tblDivorceIncident GetLastDivorceIncident(string HusbandNationalNum, string WifeNationalNum)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblDivorceIncidents.Where(x => x.HusbandNationalNum == HusbandNationalNum).Where(y => y.WifeNationalNum == WifeNationalNum).OrderByDescending(z => z.IncidentDate).FirstOrDefault());
}
}
public static string GetEmployeeId(string UserName)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblUsers.Where(x => x.Username == UserName).FirstOrDefault().EmployeeId);
}
}
public static List <tblEmployee> GetEmployeeByCivilRegisterar(int CivilRegistryID)
{
List <tblEmployee> lstEmployees = new List <tblEmployee>();
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilRegistry civilRegistry = db.tblCivilRegistries.Where(x => x.Id == CivilRegistryID).FirstOrDefault(); // جلب السجل المدني الموافق رقمه لل CivilRegistryID
List <tblEmployeesCivilRegistry> lstEmployeesCivilRegistry = db.tblEmployeesCivilRegistries.Where(x => x.CivilRegistryID == civilRegistry.Id).ToList(); // جلب سجلات كسر الموظفين للسجل المدني civilRegistry
foreach (var subitem in lstEmployeesCivilRegistry)
{
if (subitem.E_date == null) // الموظف يعمل
{
tblEmployee emp = db.tblEmployees.Where(x => x.NationalNumber == subitem.EmployeNationalNumber).FirstOrDefault();
if (emp != null)
{
lstEmployees.Add(emp);
}
}
}
}
return(lstEmployees);
}
public static List <tblCitizen> GetCitizens()
{
SyncCitizens();
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblCitizens.ToList());
}
}
public static tblCitizen GetCitizen(string NationalNumber)
{
SyncCitizens();
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblCitizens.Where(x => x.NationalNumber == NationalNumber).FirstOrDefault());
}
}
public static List <tblCitizen> GetCitizensByFatherNationalNumber(string NationalNumber)
{
SyncCitizens();
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblCitizens.Where(x => x.FatherNationalNumber == NationalNumber).ToList());
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
Session["RoleToEdit"] = Helper.GetRoleById(Convert.ToInt32(ddlRoles.SelectedValue));
Response.Redirect("/Administration/Roles");
}
}
protected void btnNext2_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
if (db.tblCitizens.Where(x => x.NationalNumber == WifeNationalNum.Text).ToList().Count == 0)
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل غير موجود في قاعدة البيانات";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (db.tblCitizens.Where(x => x.NationalNumber == WifeNationalNum.Text).FirstOrDefault().Gender.Trim() == "1")
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل خاص بذكر";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (Helper.IsDead(WifeNationalNum.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "لا يمكن الطلاق من صاحبة هذا الرقم الوطني لأنها ميتة";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (!Helper.IsWifeMarried(WifeNationalNum.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "لا يمكن الطلاق من صاحبة هذا الرقم الوطني لأنها غير متزوجة";
return;
}
else
{
lblErrorMSG.Visible = false;
}
// مطلقة لم تكمل العدة 3أشهر إذا مطلقة و3 أشهر وعشر أيام أرملة
}
}
MultiView1.ActiveViewIndex = 2;
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
if (db.tblCitizens.Where(x => x.NationalNumber == HusbandNationalNum.Text).ToList().Count == 0)
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل غير موجود في قاعدة البيانات";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (db.tblCitizens.Where(x => x.NationalNumber == HusbandNationalNum.Text).FirstOrDefault().Gender.Trim() == "0")
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل خاص بأنثى";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (Helper.IsDead(HusbandNationalNum.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "لا يمكن الطلاق من صاحب هذا الرقم الوطني لأنه ميت";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (!Helper.IsHusbandMarried(HusbandNationalNum.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "لا يمكن الطلاق من صاحب هذا الرقم الوطني لأنه غير متزوج";
return;
}
else
{
lblErrorMSG.Visible = false;
}
}
}
MultiView1.ActiveViewIndex = 1;
}
public static bool IsDead(string NationalNumber)
{
bool res = false;
using (EGovernmentEntities db = new EGovernmentEntities())
{
return(db.tblDeadRegistrations.Where(x => x.NationalNumber == NationalNumber).ToList().Count > 0);
}
return(res);
}
public static bool IsWifeMarried(string NationalNumber)
{
bool res = false;
using (EGovernmentEntities db = new EGovernmentEntities())
{
res = db.tblMarriageContracts.Where(x => x.WifeNationalNum == NationalNumber).ToList().Count > 0;
}
return(res);
}
public static tblEmployee GetEmployeeByNationalNumber(string NationalNumber)
{
tblEmployee emp = new tblEmployee();
using (EGovernmentEntities db = new EGovernmentEntities())
{
emp = db.tblEmployees.Where(x => x.NationalNumber == NationalNumber).FirstOrDefault();
}
return(emp);
}
private static List <tblEmployeesCivilRegistry> GetCivilRegistryEmployeesById(int CivilRegistryId)
{
List <tblEmployeesCivilRegistry> lstEmployeesCivilRegistry = new List <tblEmployeesCivilRegistry>();
using (EGovernmentEntities db = new EGovernmentEntities())
{
lstEmployeesCivilRegistry = db.tblEmployeesCivilRegistries.Where(x => x.CivilRegistryID == CivilRegistryId).Where(y => y.E_date == null).ToList();
}
return(lstEmployeesCivilRegistry);
}
public static bool HasAtleastOneDivorce(string HusbandNationalNumber)
{
bool res = false;
using (EGovernmentEntities db = new EGovernmentEntities())
{
res = db.tblDivorceIncidents.Where(x => x.HusbandNationalNum == HusbandNationalNumber).ToList().Count > 0;
}
return(res);
}
public static bool IsMarriage(string NationalNumber)
{
bool res = false;
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblMarriageContract marriageContract = GetLastMarriageContract(NationalNumber);
res = (marriageContract == null) ? false : true;
}
return(res);
}
