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"); } }
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(); } }
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 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 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 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); }
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(); ddlCivilRegistry.DataValueField = "Id"; ddlCivilRegistry.DataTextField = "Name"; ddlCivilRegistry.DataSource = c; ddlCivilRegistry.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { tblRole role = (tblRole)Session["Role"]; if (role == null || !role.EditCivilRegister || !role.SearchCivilRegister) { Response.Redirect("/403"); } if (!IsPostBack) { 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(); tblCivilRegistry civilregistry = new tblCivilRegistry(); int idCivilAffairs = int.Parse(ddlCivilAffairs.SelectedItem.Value); var c = db.tblCivilRegistries.Where(b => b.CivilAffairsID == 1).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(); } } }
protected void Page_Load(object sender, EventArgs e) { string CivilRegistrarId = (string)Session["CivilRegistry"]; if (CivilRegistrarId != null) { EditPage = true; using (EGovernmentEntities db = new EGovernmentEntities()) { int IdCivilRegistrar = int.Parse(CivilRegistrarId); tblCivilRegistry CivilRegistrar = db.tblCivilRegistries.Where(y => y.Id == IdCivilRegistrar).FirstOrDefault(); txtName.Text = CivilRegistrar.Name; txtArea.Text = CivilRegistrar.Area; txtCivilRegistry.Text = CivilRegistrarId; ddlCivilAffairs.SelectedValue = Convert.ToString(CivilRegistrar.CivilAffairsID); btnAdd.Text = "حفظ التعديلات"; Session["CivilRegistry"] = null; } } }
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; } } }