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