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 string GetAffairsNameByEmp(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)
{
tblCivilAffair civilAffair = db.tblCivilAffairs.Where(x => x.Id == civilRegistry.CivilAffairsID).FirstOrDefault();
if (civilAffair != null)
{
res = civilAffair.Name;
}
}
}
}
}
catch { res = "دمشق"; }
return(res);
}
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)
{
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;
}
}
}
