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