private void GoToDecisions(object sender, RoutedEventArgs e)
{
Decision_View de = new Decision_View();
de.Show();
this.Close();
}
public void excute()
{
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);
Reward r = new Reward
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
RewardType = rew_type.Text,
Reason = reason.Text,
RewardDate = res_start.SelectedDate,
Amount = amount.Text,
Notes = note.Text
};
db.Rewards.Add(r);
db.SaveChanges();
MessageBox.Show("تم إضافة المكافئة بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
res_start.Text = null;
res_type.Text = null;
emp_name.Text = null;
note.Text = "";
rew_type.Text = null;
reason.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;
excutee.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)
{
res_start.Text = null;
res_type.Text = null;
emp_name.Text = null;
note.Text = "";
rew_type.Text = null;
reason.Text = null;
}
}
public void excutee()
{
var emp_id = (from Z in db.SelfCards
where Z.Status != "بحكم المستقيل" && Z.Status != "كف اليد" && Z.Status != "مصروف من الخدمة"
select new { Z.PersonId, full = Z.FirstName + " " + Z.FatherName + " " + Z.LastName, Z.Salary, Z.maxsalary, Z.Status, Z.JobTitle, Z.Workplace, Z.Category, Z.Register }).ToList();
foreach (string ss in emp.ToList())
{
var id = emp_id.Where(d => d.full == ss).ToList().ElementAt(0);
long eid = id.PersonId;
long before = (long)id.Salary;
int c = db.SalaryIncrease.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == eid).Count();
if (c > 0)
{
MessageBox.Show(" تم تطبيق هذا القرار على الموظف " + id.full);
}
else
{
if (id.Status == "متقاعد")
{
SalaryIncrease sn = new SalaryIncrease
{
PersonId = eid,
DecisionId = long.Parse(dec_id.Text),
SalaryBefore = before,
SalaryAfter = before + long.Parse(off.Text),
Increase = long.Parse(off.Text),
Category = id.Category,
Workplace = id.Workplace,
JobTitle = id.JobTitle,
Register = Login.regName
};
db.SalaryIncrease.Add(sn);
db.SaveChanges();
var self = db.SelfCards.Where(x => x.PersonId == eid).Single();
self.Salary = before + long.Parse(off.Text);
self.maxsalary = id.maxsalary + long.Parse(off.Text);
db.SelfCards.Update(self);
db.SaveChanges();
}
else
{
SalaryIncrease sn = new SalaryIncrease
{
PersonId = eid,
DecisionId = long.Parse(dec_id.Text),
SalaryBefore = before,
SalaryAfter = before + long.Parse(increase1.Text),
Increase = long.Parse(increase1.Text),
};
db.SalaryIncrease.Add(sn);
db.SaveChanges();
var self = db.SelfCards.Where(x => x.PersonId == eid).Single();
self.Salary = before + long.Parse(increase1.Text);
self.maxsalary = id.maxsalary + long.Parse(increase1.Text);
db.SelfCards.Update(self);
db.SaveChanges();
}
}
}
MessageBox.Show("تمت عملية الانتهاء من تنفيذ قرار الزيادة");
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();
}
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;
}
}
}
}
public void excutee()
{
DateTime fromDate;
DateTime toDate;
double bouns = 0.09;
int days;
var emp_id = (from d in db.SelfCards
where d.Status != "بحكم المستقيل" && d.Status != "كف اليد" && d.Status != "مصروف من الخدمة" && d.Status != "بلا أجر" && d.Status != "متوفى" && d.Status != "مستقيل" && d.Status != "متقاعد"
select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName, d.Salary, d.maxsalary, d.Workplace, d.JobTitle, d.Category, d.Register }).ToList();
var id = emp_id.Where(d => d.full == list.Text).ToList().ElementAt(0);
//foreach (string ss in emp.ToList())
//{
int sum1 = 0;
double amount = 0;
double allDays = 0;
// var id = emp_id.Where(d => d.full == ss).ToList().ElementAt(0);
long eid = id.PersonId;
int c = db.Bonuses.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == eid).Count();
if (c > 0)
{
MessageBox.Show(" تم تطبيق هذا القرار على الموظف " + id.full);
}
else
{
// حساب عدد ايام الدوام
fromDate = (DateTime)from.SelectedDate;
toDate = (DateTime)to.SelectedDate;
//days in first yaer
List <Rest> rests1 = db.Rests.Where(x => x.PersonId == eid && x.RestType == "إجازة بلا أجر" && x.RestStart >= fromDate && x.RestStart <= toDate).ToList();
foreach (Rest rset in rests1)
{
if (rset.Period == "يوم")
{
sum1 += rset.RestPeriod;
}
else if (rset.Period == "شهر")
{
sum1 += (rset.RestPeriod * 30);
}
else if (rset.Period == "سنة")
{
sum1 += (rset.RestPeriod * 360);
}
}
allDays = 720 - sum1;
if (allDays >= 0)
{
amount = (double)((allDays / 720) * (0.09 * id.Salary));
if (id.Salary + amount <= id.maxsalary)
{
Bonuse r = new Bonuse
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
Bouns = 0.09,
FromYear = (DateTime)from.SelectedDate,
ToYear = (DateTime)to.SelectedDate,
Salary = (double)id.Salary,
NumDays = (int)allDays,
SalaryBouns = (double)(id.Salary + ((allDays / 720) * (0.09 * id.Salary))),
Workplace = id.Workplace, JobTitle = id.JobTitle, Category = id.Category, Register = Login.regName
};
db.Bonuses.Add(r);
db.SaveChanges();
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();
(from p in db.SelfCards
where p.PersonId == eid
select p).ToList()
.ForEach(x => x.Salary = (double)(id.Salary + ((allDays / 720) * (0.09 * id.Salary))));
db.SaveChanges();
}
else if (id.Salary + amount > id.maxsalary)
{
Bonuse r = new Bonuse
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
Bouns = 0.09,
FromYear = (DateTime)from.SelectedDate,
ToYear = (DateTime)to.SelectedDate,
Salary = (double)id.Salary,
NumDays = (int)allDays,
SalaryBouns = (double)(id.Salary + (id.maxsalary - id.Salary)),
Workplace = id.Workplace,
JobTitle = id.JobTitle,
Category = id.Category,
Register = Login.regName
};
db.Bonuses.Add(r);
db.SaveChanges();
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();
(from p in db.SelfCards
where p.PersonId == eid
select p).ToList()
.ForEach(x => x.Salary = (double)(id.Salary + ((allDays / 720) * (0.09 * id.Salary))));
db.SaveChanges();
}
}
else if (allDays < 0)
{
Bonuse r = new Bonuse
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
Bouns = 0.09,
FromYear = (DateTime)from.SelectedDate,
ToYear = (DateTime)to.SelectedDate,
Salary = (double)id.Salary,
NumDays = 0,
SalaryBouns = (double)id.Salary,
Workplace = id.Workplace,
JobTitle = id.JobTitle,
Category = id.Category,
Register = Login.regName
};
db.Bonuses.Add(r);
db.SaveChanges();
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();
}
}
// }
list.SelectedItem = null;
this.Visibility = Visibility.Collapsed;
MessageBox.Show("تمت عملية الانتهاء من تنفيذ قرار الترفيعة");
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
public void dec_excute()
{
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);
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(); }
Rest r = new Rest
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
RestType = res_type.Text,
RestStart = res_start.SelectedDate,
RestEnd = res_end.SelectedDate,
Period = res_per,
RestPeriod = Int32.Parse(perod.Text),
Attachment = att.Text,
Notes = note.Text,
Salary=id.Salary,Workplace=id.Workplace,JobTitle=id.JobTitle,Category=id.Category,Register= Login.regNames
};
db.Rests.Add(r);
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;
res_start.Text = null;
res_type.Text = null;
res_end.Text = null;
emp_name.Text = null;
att.Text = "";
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)
{
res_per1.IsChecked = false;
res_per2.IsChecked = false;
res_per3.IsChecked = false;
res_start.Text = null;
res_type.Text = null;
res_end.Text = null;
emp_name.Text = null;
att.Text = "";
note.Text = "";
perod.Text = "";
}
}
public void dec_excute()
{
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);
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();
}
Punishment r = new Punishment
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
PunishmentType = p_type.Text,
Period = Int32.Parse(perod.Text),
StartDate = p_start.SelectedDate,
EndDate = p_end.SelectedDate,
Reason = p_reason.Text,
periodType = res_per,
Discount = double.Parse(p_dis.Text),
Notes = note.Text
};
db.Punishments.Add(r);
db.SaveChanges();
MessageBox.Show("تم إضافة الاجازة بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
p_start.Text = null;
p_end.Text = null;
perod.Text = null;
emp_name.Text = null;
note.Text = "";
p_reason.Text = null;
p_dis.Text = null;
p_type.Text = null;
res_per1.IsChecked = false;
res_per2.IsChecked = false;
res_per3.IsChecked = false;
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)
{
p_start.Text = null;
p_end.Text = null;
perod.Text = null;
emp_name.Text = null;
note.Text = "";
p_reason.Text = null;
p_dis.Text = null;
p_type.Text = null;
res_per1.IsChecked = false;
res_per2.IsChecked = false;
res_per3.IsChecked = false;
}
}
private void collaps_Click(object sender, RoutedEventArgs e)
{
//Decision d = (Decision)DataContext;
try
{
Decision des = new Decision();
db = new PersonelDBContext();
int number = Int32.Parse(num.Text);
des = db.Decisions.Where(x => x.DecisionNumber == number && x.DecisionYear == Int32.Parse(num_Copy.Text) && x.DecisionSource == sorce.Text).FirstOrDefault();
if (des == null)
{
MessageBox.Show("هذا القرار غير موجود");
}
else
{
string con = des.DecisionContent;
if (con == "تبدل وظيفي")
{
var x = (from y in db.FunctionalChanges
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.FunctionalChanges.Remove(row);
}
}
else if (con == "قرار طي تبدل")
{
}
else if (con == "قرارإجازة")
{
var x = (from y in db.Rests
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Rests.Remove(row);
}
}
else if (con == "قرار إعارة")
{
var x = (from y in db.Secondments
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Secondments.Remove(row);
}
}
else if (con == "قرار إيفاد")
{
var x = (from y in db.Delegatings
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Delegatings.Remove(row);
}
}
else if (con == "قرار ندب")
{
var x = (from y in db.Scars
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Scars.Remove(row);
}
}
else if (con == "قرار عقوبة")
{
var x = (from y in db.Punishments
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Punishments.Remove(row);
}
}
else if (con == "قرار ترفيعة")
{
var x = (from y in db.Bonuses
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Bonuses.Remove(row);
}
}
else if (con == "قرار ترفيعة استثنائية")
{
var x = (from y in db.Bonuses
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Bonuses.Remove(row);
}
}
else if (con == "قرار ترفيعة تدريسية")
{
var x = (from y in db.Bonuses
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Bonuses.Remove(row);
}
}
else if (con == "قرار مكافأة")
{
var x = (from y in db.Rewards
where y.DecisionId == des.DecisionId
select y);
foreach (var row in x.ToList())
{
db.Rewards.Remove(row);
}
}
else if (con == "قرار زيادة")
{
//var x = (from y in db.FunctionalChanges
// where y.DecisionId == des.DecisionId
// select y).FirstOrDefault();
//db.FunctionalChanges.Remove(x);
//db.SaveChanges();
}
des.DecisionStatus = "قرار مطوي";
des.CollapsDate = date.SelectedDate;
db.Decisions.Update(des);
db.SaveChanges();
MessageBox.Show("تم طي القرار بنجاح");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
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)
{
num.Text = null;
date.SelectedDate = null;
num_Copy.Text = null;
sorce.SelectedItem = null;
}
}
}
catch (Exception m)
{ MessageBox.Show("يوجد خطأ"); }
}
private void insert_decision(object sender, RoutedEventArgs e)
{
try
{
int count = 0;
pdb = new PersonelDBContext();
count = pdb.Decisions.Where(x => x.DecisionNumber == Int32.Parse(dec_num.Text) && x.DecisionYear == Int32.Parse(dec_year.Text) && x.DecisionSource == dec_source.Text).Count();
if (dec_con.Text != null && dec_year.Text != null && dec_type.Text != null && dec_start.Text != null && dec_end.Text != null && dec_source.Text != null && dec_effect.Text != null && dec_result.Text != null && dec_num.Text != null)
{
if (count == 0)
{
if (dec_source.Text == "جهة أخرى")
{
Decision dec = new Decision
{
DecisionNumber = Int32.Parse(dec_num.Text),
DecisionYear = Int32.Parse(dec_year.Text),
DecisionType = dec_type.Text,
DecisionContent = dec_con.Text,
DecisionStart = dec_start.SelectedDate,
DecisionEnd = dec_end.SelectedDate,
DecisionSource = others.Text,
EffectType = dec_effect.Text,
Result = dec_result.Text,
DecisionStatus = "قرار ساري",
CollapsDate = null
};
decisions.Add(dec);
pdb.Decisions.Add(dec);
pdb.SaveChanges();
MessageBox.Show("تمت الاضافة بنجاح");
string message = "هل تريد تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
Decision_View dv = new Decision_View();
dv.Show();
dv.result.ItemsSource = decisions;
var myWindow = Window.GetWindow(this);
myWindow.Close();
}
else if (result == MessageBoxResult.No)
{
this.Visibility = Visibility.Collapsed;
}
}
else
{
Decision dec = new Decision
{
DecisionNumber = Int32.Parse(dec_num.Text),
DecisionYear = Int32.Parse(dec_year.Text),
DecisionType = dec_type.Text,
DecisionContent = dec_con.Text,
DecisionStart = dec_start.SelectedDate,
DecisionEnd = dec_end.SelectedDate,
DecisionSource = dec_source.Text,
EffectType = dec_effect.Text,
Result = dec_result.Text,
DecisionStatus = "قرار ساري",
CollapsDate = null
};
decisions.Add(dec);
pdb.Decisions.Add(dec);
pdb.SaveChanges();
MessageBox.Show("تمت الاضافة بنجاح");
string message = "هل تريد تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
Decision_View dv = new Decision_View();
dv.Show();
dv.result.ItemsSource = decisions;
var myWindow = Window.GetWindow(this);
myWindow.Close();
}
else if (result == MessageBoxResult.No)
{
this.Visibility = Visibility.Collapsed;
}
}
}
else
{
MessageBox.Show("لا يمكن إضافة هذا القرار، قد يكون هناك تكرار في رقم القرار أو مصدره أو سنة صدوره");
}
}
else
{
MessageBox.Show("تأكد من ادخال جميع البيانات");
}
}
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("يجب التأكد من ادخال جميع البيانات"); }
}
public void excutee()
{
//var emp_id = (from d in db.SelfCards select new { d.PersonId, full = d.FirstName + " " + d.FatherName + " " + d.LastName }).ToList();
//emp= emp_id.Where(d => d.full == emp_list.Text).FirstOrDefault().ToString();
//long empId = id.PersonId;
//emp = empname.Text;///////////
var id = (from x in db.SelfCards
where x.FirstName + " " + x.FatherName + " " + x.LastName == emp_list.Text
select new { x.PersonId, x.Salary, x.maxsalary, x.Category, x.Workplace, x.JobTitle }).Single();
double amount = 0;
long eid = id.PersonId;
int c = db.Bonuses.Where(x => x.DecisionId == long.Parse(dec_id.Text) && x.PersonId == eid).Count();
if (c > 0)
{
MessageBox.Show(" تم تطبيق هذا القرار على الموظف " + emp_list.Text);
}
else
{
var query = (from p in db.Bonuses
join d in db.Decisions on p.DecisionId equals d.DecisionId
where p.PersonId == eid && d.DecisionContent == "قرار ترفيعة استثنائية"
select new { p.DecisionId, fu = (d.DecisionNumber + " " + d.DecisionType + " " + d.DecisionYear) }).Count();
if (query > 0)
{
MessageBox.Show(" تم منح ترفيعة استثنائية من قبل للموظف " + emp_list.Text);
}
else
{
if (id.Category == "الأولى")
{
amount = 1000;
}
else if (id.Category == "الثانية")
{
amount = 600;
}
Bonuse r = new Bonuse
{
PersonId = id.PersonId,
DecisionId = long.Parse(dec_id.Text),
Bouns = amount,
FromYear = null,
ToYear = null,
Salary = (double)id.Salary,
NumDays = 0,
SalaryBouns = (double)(id.Salary + amount),
Workplace = id.Workplace,
JobTitle = id.JobTitle,
Category = id.Category,
Register = Login.regName
};
db.Bonuses.Add(r);
db.SaveChanges();
(from p in db.SelfCards
where p.PersonId == eid
select p).ToList()
.ForEach(x => x.Salary = (double)(id.Salary + amount));
db.SaveChanges();
MessageBox.Show("تمت عملية الانتهاء من تنفيذ قرار الترفيعة");
string message = "هل انتهى تنفيذ القرار؟";
string caption = "تنبيه";
var result = MessageBox.Show(message, caption,
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
emp_list.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();
this.Visibility = Visibility.Collapsed;
Decision_View dv = new Decision_View();
Window parentWindow = Window.GetWindow(this);
parentWindow.Close();
dv.Show();
}
else if (result == MessageBoxResult.No)
{
emp_list.Text = null;
}
}
}
}
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("يجب التأكد من ادخال جميع البيانات"); }
}
