public UpdateTeacher(SelfCard s)
{
InitializeComponent();
DataContext = s;
db = new PersonelDBContext();
List <string> workplaces = db.Works.Select(w => w.WorkPlace).ToList();
workplace.ItemsSource = workplaces;
emp = s;
//List<string> ca = db.Jobs.Where(c => c.JobId > 89).Select(x=>x.Category).ToList();
//firstname.Text = s.FirstName;
//last.Text = s.LastName;
//father.Text = s.FatherName;
//mother.Text = s.MotherName;
//sex.SelectedItem = s.Sex;
//grade.ItemsSource = ca;
List <string> cert = db.Certificates.Select(x => x.CertName).ToList();
certificate.ItemsSource = cert;
certificate.SelectedItem = s.Certificate;
}
public ShowTeacher(SelfCard s)
{
InitializeComponent();
db = new PersonelDBContext();
DataContext = s;
db = new PersonelDBContext();
List <string> workplaces = db.Works.Select(w => w.WorkPlace).ToList();
workplace.ItemsSource = workplaces;
workplace.SelectedValue = s.Workplace;
emp = s;
}
private void Edit_Employee(object sender, RoutedEventArgs e)
{
SelfCard self = new SelfCard();
if (search_emp.SelectedItem != null)
{
self = (SelfCard)search_emp.SelectedItem;
UpdateTeacher up = new UpdateTeacher(self);
up.Show();
this.Close();
}
else
{
MessageBox.Show("اختر موظفً");
}
}
private void View_Employee(object sender, RoutedEventArgs e)
{
SelfCard self1 = new SelfCard();
if (search_emp.SelectedItem != null)
{
self1 = (SelfCard)search_emp.SelectedItem;
ShowTeacher up1 = new ShowTeacher(self1);
up1.Show();
this.Close();
}
else
{
MessageBox.Show(" اختر موظفاً");
}
}
private void emp_name_DropDownClosed(object sender, EventArgs e)
{
var emp_id = (from m in db.SelfCards select new { m.PersonId, full = m.FirstName + " " + m.FatherName + " " + m.LastName, m.Category, m.JobTitle, m.Mission, m.Status, m.Workplace, m.Salary }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().FirstOrDefault();
if (id != null)
{
long empId = id.PersonId;
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
grade.Text = person.Category;
job.Text = person.JobTitle;
mission.Text = person.Mission;
salary.Text = person.Salary.ToString();
status.Text = person.Status;
pp.Text = person.Workplace;
}
}
public UpdateEmp(SelfCard s)
{
InitializeComponent();
DataContext = s;
db = new PersonelDBContext();
List <string> workplaces = db.Works.Select(w => w.WorkPlace).ToList();
workplace.ItemsSource = workplaces;
emp = s;
List <string> cert = db.Certificates.Select(x => x.CertName).ToList();
certificate.ItemsSource = cert;
certificate.SelectedItem = s.Certificate;
//firstname.Text = s.FirstName;
//last.Text = s.LastName;
//father.Text = s.FatherName;
//mother.Text = s.MotherName;
//sex.SelectedItem = s.Sex;
}
private void Add_person(object sender, RoutedEventArgs e)
{
try
{
//PersonelDBContext db = new PersonelDBContext();
SelfCard teatcher = new SelfCard
{
EmployeeId = Int32.Parse(empid.Text),
FirstName = firstname.Text,
LastName = last.Text,
FatherName = father.Text,
MotherName = mother.Text,
Sex = sex.Text,
Religion = religion.Text,
SocialSituation = social.Text,
Address = address.Text,
BirthPlace = birth.Text,
Birthday = birthday.SelectedDate,
Phone = phone.Text,
Military = military.Text,
Recruitment = recruitment.Text,
RegisteredId = registered_id.Text,
Nationality = nationalty.Text,
InsuranceId = insurid.Text,
Specialization = specialization.Text,
Certificate = certificate.Text,
FileId = fileid.Text,
FileClass = fileclass.Text,
Mission = mission.Text,
Employer = employer.Text,
JobTitle = job.Text,
// Salary = long.Parse(salary.Text),
Salary = 0,
Workplace = workplace.Text,
Photo = photo.Text,
Section = dept.Text,
Division = div.Text,
Category = grade.Text,
Status = status.Text,
Notes = note.Text,
BeginningDate = begindate.SelectedDate,
NominationType = type.Text,
InsuranceCard = card.Text,
Register = register.Text,
WorkContracts = workcontract.Text,
Languages = lang.Text,
TrainingCourses = course.Text,
IsTeacher = 1
};
db.SelfCards.Add(teatcher);
db.SaveChanges();
MessageBox.Show("تمت الاضافة بنجاح");
}
catch (Exception ex) { MessageBox.Show(ex.StackTrace); }
}
private void Button_Click(object sender, RoutedEventArgs e)
{
SelfCard person = new SelfCard();
var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
Decision des = new Decision();
int number = Int32.Parse(num_Copy.Text);
des = db.Decisions.Where(x => x.DecisionNumber == number && x.DecisionYear == Int32.Parse(year.Text) && x.DecisionSource == sorce.Text).FirstOrDefault();
if (des == null)
{
MessageBox.Show("هذا القرار غير موجود");
}
else
{
Rest r = new Rest();
r = db.Rests.Where(x => x.DecisionId == des.DecisionId && x.PersonId == empId && x.RestType == "إجازة بلا أجر").FirstOrDefault();
if (r == null)
{
MessageBox.Show("لا يمكن تطبيق قرار قطع إجازة بلا أجر على الموظف المحدد");
}
else
{
r.RestPeriod = Int32.Parse(period.Text);
if (res_per1.IsChecked == true)
{
res_per = res_per1.Content.ToString();
}
if (res_per2.IsChecked == true)
{
res_per = res_per2.Content.ToString();
}
if (res_per3.IsChecked == true)
{
res_per = res_per3.Content.ToString();
}
var dd = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
r.RestEnd = dd.DecisionStart;
r.Period = res_per;
db.Rests.Update(r);
db.SaveChanges();
///////////////////////////////////////////////
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "قائم على رأس عمله";
db.SelfCards.Update(person);
db.SaveChanges();
MessageBox.Show("تم تطبيق قرار قطع الإجازة بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
res_per1.IsChecked = false;
res_per2.IsChecked = false;
res_per3.IsChecked = false;
num_Copy.Text = null;
year.Text = null;
sorce.Text = null;
emp_name.Text = null;
period.Text = null;
this.Visibility = Visibility.Collapsed;
var d = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
excute.IsChecked = true;
// d.IsExcute = true;
d.IsExcute = true;
db.Decisions.Update(d);
db.SaveChanges();
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
else if (result == MessageBoxResult.No)
{
res_per1.IsChecked = false;
res_per2.IsChecked = false;
res_per3.IsChecked = false;
num_Copy.Text = null;
year.Text = null;
sorce.Text = null;
emp_name.Text = null;
period.Text = null;
}
}
}
}
private void insert_rest(object sender, RoutedEventArgs e)
{
try
{
var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName,d.Salary,d.Workplace,d.JobTitle,d.Category,d.Register }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
int c = db.Rests.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == empId).Count();
if (c > 0)
{
MessageBox.Show("تم تطبيق هذا القرار مسبقا على الموظف المحدد");
}
else
{
EmpRest er = new EmpRest();
if (res_type.Text == "إجازة ادارية")
{
int m = er.canrest(empId);
int can = m - (Int32.Parse(perod.Text));
if (can < 0)
{
MessageBox.Show("لا يحق لهذا الموظف العدد المطلوب من الاجازات الادارية. عدد الأيام المسموح به " + m.ToString());
}
else
{
dec_excute();
}
}
else if (res_type.Text == "إجازة بلا أجر")
{
int sum = er.calculate(empId);
int can = restcount();
if ((sum + can) > (5 * 360))
{
MessageBox.Show("لا يحق لهذا الموظف العدد المطلوب من الاجازات بلا أجر. عدد الأيام المسموح به " +" "+ ((360 * 5) - sum).ToString());
}
else
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
if(int.Parse(perod.Text)>=90)
person.Status = "بلا أجر";
db.SelfCards.Update(person);
db.SaveChanges();
dec_excute();
//RestReport rs = new RestReport();
RestReport rs = new RestReport(long.Parse(dec_id.Text));
}
}
else if (res_type.Text == "إجازة صحية") { dec_excute(); }
else if (res_type.Text == "احتياط") {
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "احتياط";
db.SelfCards.Update(person);
db.SaveChanges();
dec_excute(); }
else if (res_type.Text == "الزامي") {
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "خدمة الزامية";
db.SelfCards.Update(person);
db.SaveChanges();
dec_excute(); }
else if (res_type.Text == "دراسية بتمام الأجر") {
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "اجازة دراسية بتمام الأجر";
db.SelfCards.Update(person);
db.SaveChanges();
dec_excute(); }
else if (res_type.Text == "دراسية بلا أجر") {
int mothetcount = db.Rests.Where(x => x.PersonId == empId && x.RestType == "دراسية بلا أجر").Count();
MessageBox.Show("عدد الاجازات الدراسية السابقة لهذا الموظف"+ " "+ mothetcount);
if (mothetcount == 2) {
MessageBox.Show("لا يحق لهذا الموظف اجازة دراسية بلا اجر");
}
else {
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "اجازة دراسية بلا أجر";
db.SelfCards.Update(person);
db.SaveChanges();
dec_excute();
}
}
else if (res_type.Text == "حج") { dec_excute(); }
else if (res_type.Text == "أمومة") {
int mothetcount= db.Rests.Where(x => x.PersonId == empId && x.RestType == "أمومة").Count();
MessageBox.Show("عدد اجازات الامومة السابقة لهذا الموظف: " + mothetcount);
if (mothetcount == 3)
{
MessageBox.Show("لا يحق لهذا الموظف اجازة أمومة");
}
else
{
dec_excute();
}
}
else if (res_type.Text == "استكمال أمومة") {
int mothetcount = db.Rests.Where(x => x.PersonId == empId && x.RestType == "استكمال أمومة").Count();
MessageBox.Show("عدد اجازات استكمال الامومة السابقة لهذا الموظف: " + mothetcount);
if (mothetcount == 3)
{
MessageBox.Show("لا يحق لهذا الموظف اجازة استكمال أمومة");
}
else
{
dec_excute();
}
}
else if (res_type.Text == "زواج") { dec_excute(); }
else if (res_type.Text == "وفاة") { dec_excute(); }
}
}
catch (Exception ex) { MessageBox.Show("يجب التأكد من ادخال جميع البيانات"); }
}
private void Add_Change(object sender, RoutedEventArgs e)
{
try
{
var emp_id = (from m in db.SelfCards select new { m.PersonId, full = m.FirstName + " " + m.FatherName + " " + m.LastName }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
int c = db.FunctionalChanges.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == empId).Count();
if (c > 0)
{
MessageBox.Show("تم تطبيق هذا القرار مسبقا على الموظف المحدد");
}
else
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
if (mission_Copy.Text == "اعادة إلى العمل")
{
status.Text = "قائم على رأس عمله";
person.Status = "قائم على رأس عمله";
person.InsuranceCard = "ضمن الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
// status.Text = "قائم على رأس عمله";
}
if (mission_Copy.SelectedItem == null)
{
MessageBox.Show("ادخل نوع التبدل الوظيفي من فضلك");
}
else if (mission_Copy.Text == "استقالة")
{
status.Text = "مستقيل";
person.Status = "مستقيل";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تعيين")
{
status.Text = "قائم على رأس عمله";
person.Status = "قائم على رأس عمله";
person.Salary = double.Parse(salary.Text);
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "نهاية خدمة")
{
status.Text = "متقاعد";
person.Status = "متقاعد";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تجميد")
{
status.Text = "مجمد";
person.Status = "مجمد";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تفريغ للحزب")
{
status.Text = "مفرغ للحزب";
person.Status = "مفرغ للحزب";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "بحكم المستقيل")
{
status.Text = "بحكم المستقيل";
person.Status = "بحكم المستقيل";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "صرف من الخدمة")
{
status.Text = "مصروف من الخدمة";
person.Status = "مصروف من الخدمة";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "طي اسم")
{
status.Text = "متوفى";
person.Status = "متوفى";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "احالة على المعاش")
{
status.Text = "متقاعد";
person.Status = "متقاعد";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تسريح صحي")
{
status.Text = "مسرح صحياً";
person.Status = "مسرح صحياً";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "كف يد")
{
status.Text = "كف اليد";
person.Status = "كف اليد";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تغيير فئة")
{
grade.Text = "";
person.Category = grade.Text;
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تغيير مسمى وظيفي")
{
job.Text = "";
person.JobTitle = job.Text;
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "تغيير مهمة")
{
mission.Text = "";
person.Mission = mission.Text;
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "نقل")
{
pp.Text = "";
person.Workplace = pp.Text;
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "نقل خارج الجامعة")
{
pp.Text = "";
person.Status = "منقول خارج الجامعة";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (mission_Copy.Text == "اجازة بلا أجر")
{
status.Text = "بلا أجر";
person.Status = "بلا أجر";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
FunctionalChange fn = new FunctionalChange
{
PersonId = empId,
DecisionId = int.Parse(dec_id.Text),
Category = grade.Text,
WorkPlace = pp.Text,
functional_changes_type = mission_Copy.Text,
Mission = mission.Text,
ChangeDate = (DateTime)chandate1.SelectedDate,
Status = status.Text,
Salary = double.Parse(salary.Text),
JobTitle = job.Text, Register = Login.regName
};
db.FunctionalChanges.Add(fn);
db.SaveChanges();
MessageBox.Show("تم إجراءالتبدل الوظيفي بنجاح...");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
var d = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
d.IsExcute = true;
db.Decisions.Update(d);
db.SaveChanges();
emp_name.SelectedItem = null;
chandate1.SelectedDate = null;
pp.SelectedItem = null;
grade.SelectedItem = null;
job.SelectedItem = null;
mission.SelectedItem = null;
status.SelectedItem = null;
salary.Text = null;
mission_Copy.SelectedItem = null;
this.Visibility = Visibility.Collapsed;
var dd = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
excute.IsChecked = true;
// d.IsExcute = true;
dd.IsExcute = true;
db.Decisions.Update(dd);
db.SaveChanges();
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
else if (result == MessageBoxResult.No)
{
emp_name.SelectedItem = null;
chandate1.SelectedDate = null;
pp.SelectedItem = null;
grade.SelectedItem = null;
job.SelectedItem = null;
mission.SelectedItem = null;
status.SelectedItem = null;
salary.Text = null;
mission_Copy.SelectedItem = null;
}
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
// MessageBox.Show("يجب التأكد من ادخال جميع البيانات");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
int index = 0;
List <Scar> scars = new List <Scar>();
var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName, d.JobTitle, d.Category, d.Register, d.Salary }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
//فحص مدة الندب
scars = db.Scars.Where(x => x.PersonId == empId).ToList <Scar>();
foreach (Scar s in scars)
{
if (s.PeriodType == "سنة" && del_per3.IsChecked == true)
{
index = index + (int)s.PeriodNum + int.Parse(perod.Text);
}
}
// فحص اذا كان القرار مطبق مسبقا على هذا الموظف
int c = db.Scars.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == empId).Count();
if (c > 0)
{
MessageBox.Show("تم تطبيق هذا القرار مسبقا على الموظف المحدد");
}
else
{
if (index > 4)
{
MessageBox.Show("لقد تجاوز هذا الموظف مدة الندب ولا يحق له قرار ندب جديد");
}
else
{
if (del_per1.IsChecked == true)
{
del_per = del_per1.Content.ToString();
}
if (del_per2.IsChecked == true)
{
del_per = del_per2.Content.ToString();
}
if (del_per3.IsChecked == true)
{
del_per = del_per3.Content.ToString();
}
Scar del = new Scar
{
PersonId = empId,
DecisionId = long.Parse(dec_id.Text),
PeriodType = del_per,
PeriodNum = Int32.Parse(perod.Text),
ScarReason = reason.Text,
ScarPlace = country.Text,
ScarStart = del_start.SelectedDate,
ScarEnd = del_end.SelectedDate,
Notes = note.Text,
JobTitle = id.JobTitle, Category = id.Category, Register = Login.regName,
Salary = id.Salary
};
db.Scars.Add(del);
db.SaveChanges();
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "مندوب";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
MessageBox.Show("تم إضافة تفصيل قرار الندب بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
del_per1.IsChecked = false;
del_per2.IsChecked = false;
del_per3.IsChecked = false;
del_start.Text = null;
del_end.Text = null;
country.Text = "";
reason.Text = null;
note.Text = "";
perod.Text = "";
this.Visibility = Visibility.Collapsed;
var d = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
excute.IsChecked = true;
d.IsExcute = true;
db.Decisions.Update(d);
db.SaveChanges();
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
else if (result == MessageBoxResult.No)
{
del_per1.IsChecked = false;
del_per2.IsChecked = false;
del_per3.IsChecked = false;
del_start.Text = null;
del_end.Text = null;
country.Text = "";
reason.Text = null;
note.Text = "";
perod.Text = "";
}
}
}
}
catch (Exception ex) { MessageBox.Show("يجب التأكد من ادخال جميع البيانات"); }
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try {
var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName, d.JobTitle, d.Salary, d.Category, d.Register }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
int c = db.Secondments.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == empId).Count();
if (c > 0)
{
MessageBox.Show("تم تطبيق هذا القرار مسبقا على الموظف المحدد");
}
else
{
if (sec_per1.IsChecked == true)
{
sec_per = sec_per1.Content.ToString();
}
if (sec_per2.IsChecked == true)
{
sec_per = sec_per2.Content.ToString();
}
if (sec_per3.IsChecked == true)
{
sec_per = sec_per3.Content.ToString();
}
Secondment r = new Secondment
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
SecondmentType = sec_type.Text,
PeriodNum = Int32.Parse(perod.Text),
PeriodType = sec_per,
SecondmentPlace = place.Text,
SecondmentStart = sec_start.SelectedDate,
SecondmentEnd = sec_end.SelectedDate,
Notes = note.Text,
JobTitle = id.JobTitle, Salary = id.Salary, Category = id.Category, Register = Login.regName
};
db.Add(r);
db.SaveChanges();
if (sec_type.Text == "إعارة داخلية")
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "معار داخلياً";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (sec_type.Text == "إعارة خارجية")
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "معار خارجياً";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
MessageBox.Show("تم تنفيذ قرار الاعارة");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
sec_per1.IsChecked = false;
sec_per2.IsChecked = false;
sec_per3.IsChecked = false;
sec_start.Text = null;
sec_type.Text = null;
sec_end.Text = null;
emp_name.Text = null;
place.Text = null;
note.Text = "";
perod.Text = "";
this.Visibility = Visibility.Collapsed;
var d = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
excute.IsChecked = true;
// d.IsExcute = true;
d.IsExcute = true;
db.Decisions.Update(d);
db.SaveChanges();
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
else if (result == MessageBoxResult.No)
{
sec_per1.IsChecked = false;
sec_per2.IsChecked = false;
sec_per3.IsChecked = false;
sec_start.Text = null;
sec_type.Text = null;
sec_end.Text = null;
emp_name.Text = null;
place.Text = null;
note.Text = "";
perod.Text = "";
}
}
}
catch (Exception ex) { MessageBox.Show("يجب التأكد من ادخال جميع البيانات"); }
}
private void insert_del(object sender, RoutedEventArgs e)
{
try
{
var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName, d.JobTitle, d.Salary, d.Category, d.Register }).ToList();
var id = emp_id.Where(d => d.full == emp_name.Text).ToList().ElementAt(0);
long empId = id.PersonId;
// فحص اذا كان القرار مطبق مسبقا على هذا الموظف
int c = db.Delegatings.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == empId).Count();
if (c > 0)
{
MessageBox.Show("تم تطبيق هذا القرار مسبقا على الموظف المحدد");
}
else
{
if (del_per1.IsChecked == true)
{
del_per = del_per1.Content.ToString();
}
if (del_per2.IsChecked == true)
{
del_per = del_per2.Content.ToString();
}
if (del_per3.IsChecked == true)
{
del_per = del_per3.Content.ToString();
}
Delegating del = new Delegating
{
PersonId = empId,
DecisionId = long.Parse(dec_id.Text),
DelegatingType = del_type.Text,
PeriodType = del_per,
PeriodNum = Int32.Parse(perod.Text),
DelegatingReason = reson.Text,
DelegatingCountry = country.Text,
DelegatingStart = del_start.SelectedDate,
DelegatingEnd = del_end.SelectedDate,
Notes = note.Text,
JobTitle = id.JobTitle,
Salary = id.Salary, Category = id.Category,
Register = Login.regName
};
db.Delegatings.Add(del);
db.SaveChanges();
if (del_type.Text == "إيفاد داخلي")
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "موفد داخلياً";
db.SelfCards.Update(person);
db.SaveChanges();
}
else if (del_type.Text == "إيفاد خارجي")
{
SelfCard person = new SelfCard();
person = db.SelfCards.Where(x => x.PersonId == empId).FirstOrDefault();
person.Status = "موفد خارجياً";
person.InsuranceCard = "خارج الخدمة";
db.SelfCards.Update(person);
db.SaveChanges();
}
MessageBox.Show("تم إضافة تفصيل الايفاد بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
del_per1.IsChecked = false;
del_per2.IsChecked = false;
del_per3.IsChecked = false;
del_start.Text = null;
del_type.Text = null;
del_end.Text = null;
country.Text = "";
reson.Text = null;
note.Text = "";
perod.Text = "";
this.Visibility = Visibility.Collapsed;
var d = db.Decisions.Where(c => c.DecisionId == long.Parse(dec_id.Text)).Single();
excute.IsChecked = true;
d.IsExcute = true;
db.Decisions.Update(d);
db.SaveChanges();
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
//Window parentWindow = Window.GetWindow(this);
//object obj = parentWindow.FindName("result");
//DataGrid dg = (DataGrid)obj;
//dg.UnselectAll();
}
else if (result == MessageBoxResult.No)
{
del_per1.IsChecked = false;
del_per2.IsChecked = false;
del_per3.IsChecked = false;
del_start.Text = null;
del_type.Text = null;
del_end.Text = null;
country.Text = "";
reson.Text = null;
del_type.Text = null;
note.Text = "";
perod.Text = "";
}
}
}
catch (Exception ex) { MessageBox.Show("يجب التأكد من ادخال جميع البيانات"); }
}
