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 string EditCitizen(tblCitizen citizen)
{
string ErrorMsg = string.Empty;
try
{
string id = GetCitizenByNN(citizen.NationalNumber).Id.ToString();
var client = new RestClient("http://fv4online.com/egov_api/v2/");
var request = new RestRequest("civilians/" + id, Method.PUT);
request.AddParameter("first_name", citizen.FirstName);
request.AddParameter("last_name", citizen.LastName);
request.AddParameter("father_id", GetCitizenByNN(citizen.NationalNumber).Id);
request.AddParameter("mother_id", GetCitizenByNN(citizen.NationalNumber).Id);
request.AddParameter("birth_date", citizen.Birthday);
request.AddParameter("birth_place", citizen.BirthPlace);
request.AddParameter("register_place", citizen.KiedPlace);
request.AddParameter("register_no", citizen.KiedNumber);
request.AddParameter("id_card_no", GenerateRandomNumber(8));
request.AddParameter("nationality", (citizen.Gender == "0") ? "سورية" : "سوري");
request.AddParameter("secretariate", "دمشق");
request.AddParameter("national_no", citizen.NationalNumber);
request.AddParameter("gender", (citizen.Gender == "0") ? "female" : "male");
request.AddParameter("address", citizen.KiedPlace);
request.AddParameter("tel", "09" + GenerateRandomNumber(8));
request.AddParameter("granting_date", RandomDay());
IRestResponse response = client.Execute(request);
var content = response.Content;
}
catch (Exception ex)
{
ErrorMsg = ex.Message;
}
return(ErrorMsg);
}
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 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();
}
}
}
}
private void FillDocument(tblCitizen citizen)
{
lblNameID.Text = citizen.Id.ToString();
lblFirstName.Text = citizen.FirstName;
lblLastName.Text = citizen.LastName;
var father = Helper.GetCitizen(citizen.FatherNationalNumber);
lblFatherName.Text = (father != null) ? father.FirstName : string.Empty;
var mother = Helper.GetCitizen(citizen.MotherNationalNumber);
lblMotherFullName.Text = (mother != null) ? mother.FirstName + " " + mother.LastName : string.Empty;
lblControllerName.Text = Helper.GetControllerNameByEmp(Session["CurrUser"]);
lblCivilRegisterer.Text = Helper.GetCivilRegistrarByEmp(Session["CurrUser"]);
lbl_Amana.Text = lblAmana.Text = Helper.GetAmanaNameByEmp(Session["CurrUser"]);
lbl_Government.Text = Helper.GetAffairsNameByEmp(Session["CurrUser"]);
lblKiedPlaceAndNumber.Text = citizen.KiedPlace + " " + citizen.KiedNumber;
lblBirthdayPlace.Text = citizen.BirthPlace + " " + citizen.Birthday;
lblNotes.Text = "لا يوجد";
lblNationalNumber.Text = citizen.NationalNumber;
lblGender.Text = (citizen.Gender == "1") ? "ذكر" : "أنثى";
lblKiedDate.Text = citizen.Birthday;
lblSocialStatus.Text = (citizen.SocialStatus == "1") ? "عازب" : (citizen.SocialStatus == "2") ? "متأهل" : (citizen.SocialStatus == "3") ? "أرمل" : (citizen.SocialStatus == "4") ? "مطلق" : "";
lblDate.Text = DateTime.Now.ToShortDateString();
lblRelegion.Text = citizen.Religion;
}
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 tblCitizen GetCitizenById(string Id)
{
tblCitizen citizen = new tblCitizen();
var client = new RestClient("http://fv4online.com/egov_api/v2/");
var request = new RestRequest("civilians/" + Id, Method.GET);
var queryResult = client.Execute <List <Citizen> >(request).Content;
Citizen temp = JsonConvert.DeserializeObject <Citizen>(queryResult);
citizen = ConvertToCitizenRow(temp);
return(citizen);
}
private static tblCitizen ConvertToCitizenRow(Citizen citizen)
{
tblCitizen _citizen = new tblCitizen();
_citizen.FirstName = citizen.first_name;
_citizen.LastName = citizen.last_name;
_citizen.FatherNationalNumber = citizen.father_no;
_citizen.MotherNationalNumber = citizen.mother_no;
_citizen.NationalNumber = citizen.national_no;
_citizen.Birthday = citizen.birth_date;
_citizen.BirthPlace = citizen.birth_place;
_citizen.KiedPlace = citizen.register_place;
_citizen.KiedNumber = citizen.register_no;
_citizen.Gender = (citizen.gender == "male") ? "1" : "0";
_citizen.SocialStatus = "1";
_citizen.Religion = "مسلم";
return(_citizen);
}
public static List <tblCitizen> MortalityAtAnEarlyAge(int age, int year)
{
List <tblCitizen> lstRes = new List <tblCitizen>();
using (EGovernmentEntities db = new EGovernmentEntities())
{
List <tblDeadRegistration> deadRegistration = db.tblDeadRegistrations.ToList();
foreach (var item in deadRegistration)
{
tblCitizen citizen = GetCitizen(item.NationalNumber);
int CitizenAge = (GetDate(item.DeadDate) - DateTime.Parse(citizen.Birthday)).Days / 365;
if (GetDate(item.DeadDate).Year == year && CitizenAge == age)
{
lstRes.Add(citizen);
}
}
}
return(lstRes);
}
public static bool CheckAge(string NationalNumber, int minAge)
{
bool res = false;
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCitizen citizen = GetCitizen(NationalNumber);
var today = DateTime.Today;
var age = today.Year - DateTime.Parse(citizen.Birthday).Year;
if (age < minAge)
{
res = false;
}
else
{
res = true;
}
}
return(res);
}
// قائمة بالمتزوجين في عمر معين
public static List <tblCitizen> GetMarriedByAge(int age)
{
List <tblCitizen> lstRes = new List <tblCitizen>();
using (EGovernmentEntities db = new EGovernmentEntities())
{
List <tblMarriageContract> lstMarriageContract = db.tblMarriageContracts.ToList();
foreach (tblMarriageContract item in lstMarriageContract)
{
if (IsDivorced(item.HusbandNationalNum, item.WifeNationalNum))
{
continue;
}
tblCitizen ctzn = GetCitizen(item.HusbandNationalNum);
int CitizenAge = (DateTime.Now - DateTime.Parse(ctzn.Birthday)).Days / 365;
if (CitizenAge == age)
{
lstRes.Add(ctzn);
}
ctzn = GetCitizen(item.WifeNationalNum);
CitizenAge = (DateTime.Now - DateTime.Parse(ctzn.Birthday)).Days / 365;
if (CitizenAge == age)
{
lstRes.Add(ctzn);
}
}
}
return(lstRes);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
EditPage = (btnAdd.Text == "حفظ التعديلات");
#region Checks
if (!EditPage && db.tblCitizens.Where(x => x.NationalNumber == NationalNumber.Value).ToList().Count > 0)
{
var cit = db.tblCitizens.Where(x => x.NationalNumber == NationalNumber.Value).FirstOrDefault();
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل موجود مسبقاً في قاعدة البيانات" + Environment.NewLine + "ويعود للمواطن " + string.Format("{0} {1} {2}", cit.FirstName, Helper.GetCitizen(cit.FatherNationalNumber).FirstName, cit.LastName);
return;
}
#endregion
tblCitizen citizen;
string NationalNum = string.Empty;
if (EditPage)
{
citizen = db.tblCitizens.Where(x => x.NationalNumber == NationalNumber.Value).FirstOrDefault();
}
else
{
citizen = new tblCitizen();
}
citizen.Birthday = Birthday.Value;
citizen.BirthPlace = BirthPlace.Value;
citizen.FatherNationalNumber = FatherNationalNumber.Value; //
citizen.FirstName = FirstName.Value;
citizen.Gender = male.Checked ? "1" : "0";
citizen.KiedPlace = KiedPlace.Value;
citizen.KiedNumber = KiedNumber.Value;
citizen.Religion = Religion.Value;
citizen.LastName = LastName.Value;
citizen.MotherNationalNumber = MotherNationalNumber.Value;//
citizen.NationalNumber = NationalNumber.Value;
citizen.SocialStatus = ss1.Checked ? "1" : ss2.Checked ? "2" : ss3.Checked ? "3" : "4";
if (!EditPage)
{
db.tblCitizens.AddObject(citizen);
RestHelper.AddCitizen(citizen);
}
else
{
RestHelper.EditCitizen(citizen);
}
db.SaveChanges();
if (!Helper.HasBalance(NationalNumber.Value))
{
Helper.AddBalance(NationalNumber.Value, 50000);
}
if (Directory.Exists(Server.MapPath("~/Images/" + NationalNumber + "/")))
{
Directory.Delete(Server.MapPath("~/Images/" + NationalNumber + "/"));
}
if (!string.IsNullOrEmpty(FileUploadControl.FileName))
{
string filename = "Profile" + Path.GetExtension(FileUploadControl.FileName);
if (!Directory.Exists(Server.MapPath("~/Images/" + citizen.NationalNumber)))
{
Directory.CreateDirectory(Server.MapPath("~/Images/" + citizen.NationalNumber));
}
FileUploadControl.SaveAs(Server.MapPath("~/Images/" + citizen.NationalNumber + "/") + filename);
}
Session["CitizenInfo"] = null;
Response.Redirect("/Finish");
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
int Penalty = Helper.GetPenalty(FatherNationalNumber.Text, (int)(DateTime.Today - DateTime.Parse(IncidentDate.Value)).TotalDays, IncidentType.Birth);
if (!Helper.CheckBalance(FatherNationalNumber.Text, Penalty))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "لا يمكن تسجيل الولادة لأن حسابك لا يحوي على المبلغ الكافي لتسديد الضريبة";
return;
}
else
{
lblErrorMSG.Visible = false;
}
using (EGovernmentEntities db = new EGovernmentEntities())
{
if (db.tblCitizens.Where(x => x.NationalNumber == FatherNationalNumber.Text).ToList().Count == 0)
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل للأب غير موجود في قاعدة البيانات";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (db.tblCitizens.Where(x => x.NationalNumber == MotherNationalNumber.Text).ToList().Count == 0)
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الرقم الوطني المدخل للأم غير موجود في قاعدة البيانات";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (!Helper.CheckIsWife(FatherNationalNumber.Text, MotherNationalNumber.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "الأم ليست على ذمة هذا الرجل";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (!Helper.CheckPregnancy(Pregnancy.Text))
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "مدة الحمل غير نظامية";
return;
}
else
{
lblErrorMSG.Visible = false;
}
if (Helper.GetDate(IncidentDate.Value) > DateTime.Now)
{
lblErrorMSG.Visible = true;
lblErrorMSG1.Text = "تاريخ الولادة أكبر من التاريخ الحالي";
return;
}
else
{
lblErrorMSG.Visible = false;
}
tblCitizen father = Helper.GetCitizen(FatherNationalNumber.Text);
tblCitizen citize = new tblCitizen();
citize.NationalNumber = Helper.GetNationalNumber(db, new List <string>());
citize.KiedPlace = father.KiedPlace;
citize.KiedNumber = father.KiedNumber;
citize.LastName = father.LastName;
citize.BirthPlace = BirthPlace1.Text;
citize.Birthday = IncidentDate.Value;
citize.Gender = male.Checked ? "1" : "0";
citize.SocialStatus = "1";
citize.Religion = father.Religion;
citize.FirstName = ChildName.Text;
citize.FatherNationalNumber = FatherNationalNumber.Text;
citize.MotherNationalNumber = MotherNationalNumber.Text;
db.tblCitizens.AddObject(citize);
db.SaveChanges();
tblBirthRegistration birthRegistration = new tblBirthRegistration();
birthRegistration.NationalNumber = citize.NationalNumber;
birthRegistration.Pregnancy = int.Parse(Pregnancy.Text);
birthRegistration.Doctor = Doctor.Text;
birthRegistration.BirthPlace = ss1.Checked ? "1" : ss2.Checked ? "2" : "3";
birthRegistration.BirthType = ss4.Checked ? "1" : ss5.Checked ? "2" : "3";
birthRegistration.Notes = txtNotes.Text;
birthRegistration.IncidentDate = DateTime.Now.ToShortDateString();
db.tblBirthRegistrations.AddObject(birthRegistration);
db.SaveChanges();
Helper.Pay(FatherNationalNumber.Text, Penalty);
Response.Redirect("/Finish");
}
}
}
public static List <string> GetForbidden(string NationalNumber)
{
List <string> lstForbidden = new List <string>();
//خالة عمة أم ست أخت
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCitizen citizen = GetCitizen(NationalNumber);
if (citizen != null)
{
if (citizen.Gender == "1") // ذكر
{
var mother = GetCitizen(citizen.MotherNationalNumber);
if (mother != null)
{
lstForbidden.AddRange(GetSibiling(Gender.Female, mother.NationalNumber)); // خالاته
}
var father = GetCitizen(citizen.FatherNationalNumber);
if (father != null)
{
lstForbidden.AddRange(GetSibiling(Gender.Female, father.NationalNumber)); // عماته
}
lstForbidden.Add(mother.NationalNumber); // الأم
lstForbidden.AddRange(GetSibiling(Gender.Female, NationalNumber)); // الأخوات
var grandMother = GetCitizen(mother.MotherNationalNumber);
if (grandMother != null)
{
lstForbidden.Add(grandMother.NationalNumber); // الجدة
}
}
else // أنثى
{
var mother = GetCitizen(citizen.MotherNationalNumber);
if (mother != null)
{
lstForbidden.AddRange(GetSibiling(Gender.Male, mother.NationalNumber)); // خوالها
}
var father = GetCitizen(citizen.FatherNationalNumber);
if (father != null)
{
lstForbidden.AddRange(GetSibiling(Gender.Male, father.NationalNumber)); // عمومها
lstForbidden.Add(father.NationalNumber); // الأب
var grandFather = GetCitizen(father.MotherNationalNumber);
if (grandFather != null)
{
lstForbidden.Add(grandFather.NationalNumber); // الجد
}
}
lstForbidden.AddRange(GetSibiling(Gender.Male, NationalNumber)); // الأخوة
}
}
}
return(lstForbidden);
}
protected void Page_Load(object sender, EventArgs e)
{
tblRole role = (tblRole)Session["Role"];
if (role == null || !role.AddEmployee)
{
Response.Redirect("/403");
}
if (!IsPostBack)
{
_EmployeeInfo = (EmployeeInfo)Session["EmployeeInfo"];
using (EGovernmentEntities db = new EGovernmentEntities())
{
tblCivilAffair civilAffairs = new tblCivilAffair();
var c1 = db.tblCivilAffairs.ToList();
ddlCivilAffairs.DataValueField = "Id";
ddlCivilAffairs.DataTextField = "Name";
ddlCivilAffairs.DataSource = c1;
ddlCivilAffairs.DataBind();
if (_EmployeeInfo == null)
{
tblCivilRegistry civilregistry = new tblCivilRegistry();
int idCivilAffairs = int.Parse(ddlCivilAffairs.SelectedItem.Value);
var c = db.tblCivilRegistries.Where(b => b.CivilAffairsID == 1).ToList();
ddlCivilRegistry.DataValueField = "Id";
ddlCivilRegistry.DataTextField = "Name";
ddlCivilRegistry.DataSource = c;
ddlCivilRegistry.DataBind();
}
tblRole roles = new tblRole();
var temp = db.tblRoles.ToList();
ddlRole.DataValueField = "Id";
ddlRole.DataTextField = "Name";
ddlRole.DataSource = temp;
ddlRole.DataBind();
}
if (_EmployeeInfo != null)
{
MultiView.ActiveViewIndex = 1;
btnPrevious.Visible = false;
divStatus.Visible = true;
EditPage = true;
labelNationalNum.Text = _EmployeeInfo.NationalNumber;
labelFirstName.Text = _EmployeeInfo.FirstName;
lableLastName.Text = _EmployeeInfo.LastName;
tblCitizen citizen = Helper.GetCitizen(_EmployeeInfo.NationalNumber);
try
{
lableFatherName.Text = Helper.GetCitizen(Helper.GetCitizen(_EmployeeInfo.NationalNumber).FatherNationalNumber).FirstName;
lableMotherName.Text = Helper.GetCitizen(Helper.GetCitizen(_EmployeeInfo.NationalNumber).MotherNationalNumber).FirstName;
}
catch { }
txtAddress.Text = _EmployeeInfo.Address;
txtPhoneNumber.Text = _EmployeeInfo.Phone;
txtSpecialization.Text = _EmployeeInfo.Specialization;
switch (_EmployeeInfo.Rank)
{
case "مدير":
rdoManager.Checked = true;
break;
case "مراقب":
rdoIsController.Checked = true;
break;
case "أمين السجل المدني":
rdoIsCivilRegisterer.Checked = true;
break;
case "موظف عادي":
rdoEmployee.Checked = true;
break;
}
ddlCivilAffairs.SelectedValue = _EmployeeInfo.CivilAffairs;
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();
ddlCivilRegistry.DataValueField = "Id";
ddlCivilRegistry.DataTextField = "Name";
ddlCivilRegistry.DataSource = c;
ddlCivilRegistry.DataBind();
}
ddlCivilRegistry.SelectedValue = _EmployeeInfo.CivilRegistry;
ddlRole.SelectedValue = _EmployeeInfo.Role;
CheckBox1.Checked = _EmployeeInfo.IsWorking;
btnAdd.Text = "حفظ التعديلات";
Session["CitizenInfo"] = null;
}
}
}
