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("يجب التأكد من ادخال جميع البيانات"); } }