private async void dg_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
var i = e.Row.DataContext as Inventory;
if (i != null && i.IsValidate())
{
if (!i.ID.HasValue)
{
if (Inventory.InsertData(i))
{
MyMessage.InsertMessage();
}
else
{
e.Cancel = true;
}
}
else
{
if (await Inventory.UpdateData(i))
{
MyMessage.UpdateMessage();
}
else
{
e.Cancel = true;
}
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var fb = this.DataContext as FormedBasket;
if (dgSelectedItems.Items.Count > 0)
{
fb.FormedBasketItems.Clear();
fb.FormedBasketItems.AddRange(dgSelectedItems.ItemsSource as List <FormedBasket_Item>);
}
fb.RelatedSectors = (lbSectors.ItemsSource as List <Sector>).Where(x => x.IsSelected).ToList();
if (fb.IsValidate())
{
if (!fb.Id.HasValue)
{
if (FormedBasket.InsertData(fb))
{
MyMessage.InsertMessage();
}
}
else
{
if (FormedBasket.UpdateData(fb))
{
MyMessage.UpdateMessage();
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as House;
if (x.IsValidate())
{
if (x.FamilyID == null && x.OrphanID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة او اليتيم");
return;
}
if (x.HouseID != null)
{
if (!BaseDataBase.CurrentUser.CanUpdate)
{
MyMessageBox.Show("لا يوجد لديك صلاحيات للتعديل");
}
else if (DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
Houses.Add(x);
TotalCount = Houses.Count;
Place = TotalCount;
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as FamilyPerson;
if (x.IsValidate())
{
if (x.FamilyID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.FamilyPersonID.HasValue)
{
if (BaseDataBase.CurrentUser.CanUpdate && DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
FamilyPersons.Add(x);
TotalCount = FamilyPersons.Count;
Place = TotalCount;
}
}
}
}
private void btnExecute_Click(object sender, RoutedEventArgs e)
{
MoveFocus(new TraversalRequest(FocusNavigationDirection.Next));
var tf = this.DataContext as TempFamily;
if (tf != null)
{
if (tf.IsValidate())
{
if (!tf.ID.HasValue)
{
if (TempFamily.InsertData(tf))
{
MyMessage.InsertMessage();
ColortxtFamilyCode();
btnExecute.Content = "تعديل";
}
}
else
{
if (TempFamily.UpadteData(tf))
{
MyMessage.UpdateMessage();
}
}
}
}
}
private void dg_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
var s = e.Row.DataContext as Sector;
if (s != null && s.IsValidate())
{
if (!s.ID.HasValue)
{
if (Sector.InsertData(s))
{
MyMessage.InsertMessage();
}
else
{
e.Cancel = true;
}
}
else
{
if (Sector.UpdateData(s))
{
MyMessage.UpdateMessage();
}
else
{
e.Cancel = true;
}
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as ExternalFamilySupport;
if (x.IsValidate())
{
if (x.FamilyID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.ExternalFamilySupportID != null)
{
if (x.UpdateExternalFamilyFata())
{
MyMessage.UpdateMessage();
UpdateCombo();
}
}
else
{
if (x.InsertExternalFamilyData())
{
MyMessage.InsertMessage();
ExternalFamilySupports.Add(x);
TotalCount = ExternalFamilySupports.Count;
Place = TotalCount;
UpdateCombo();
}
}
}
}
private void NewSponsorship_Click(object sender, RoutedEventArgs e)
{
SelectAvailableSponsorshipControl w = new SelectAvailableSponsorshipControl();
if (w.ShowDialog() == true)
{
var a = w.dgAvailableSponsorships.SelectedItem as AvailableSponsorship;
Sponsorship ss = new MainWPF.Sponsorship();
ss.AvailableSponsorship = a;
ss.IsDouble = w.chkIsDouble.IsChecked.Value;
ss.StartDate = w.dtpStartDate.SelectedDate;
if (a.SponsorType == "كفالة عامة")
{
ss.EndDate = null;
}
else
{
ss.EndDate = w.dtpStartDate.SelectedDate.Value.AddMonths((int)a.Duration.Value);
}
ss.OrphanID = OrphanID;
if (Sponsorship.InsertData(ss))
{
MyMessage.InsertMessage();
OrphanSponsorships.Add(ss);
dgAvailableSponsorship.Items.Refresh();
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as Specialty;
if (string.IsNullOrEmpty(x.SpecialtyValue) || x.Date == null)
{
MyMessageBox.Show("يجب إدخال التقييم والتاريخ");
return;
}
if (x.OrphanID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.ID != null)
{
x.UpdateData();
MyMessage.UpdateMessage();
}
else
{
x.InsertData();
MyMessage.InsertMessage();
Specialties.Add(x);
TotalCount = Specialties.Count;
Place = TotalCount;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!(BaseDataBase.CurrentUser.CanUpdateFamily || BaseDataBase.CurrentUser.PointAdmin))
{
MessageBox.Show("ليس لديك صلاحية اضافة بطافة خاصة");
return;
}
var x = this.DataContext as SpecialCardSource;
if (x.IsValidate())
{
if (x.Id.HasValue)
{
if (!BaseDataBase.CurrentUser.PointAdmin)
{
MessageBox.Show("ليس لديك صلاحية تعديل بطافة خاصة");
return;
}
if (BaseDataBase.CurrentUser.CanUpdate && SpecialCardSource.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (SpecialCardSource.InsertData(x))
{
MyMessage.InsertMessage();
SpecialCardSources.Add(x);
TotalCount = SpecialCardSources.Count;
Place = TotalCount;
}
}
}
}
private void dgCard_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
var c = e.Row.DataContext as SpecialCard;
if (c != null && c.IsValidate())
{
if (!c.ID.HasValue)
{
if (SpecialCard.InsertData(c))
{
MyMessage.InsertMessage();
}
else
{
e.Cancel = true;
}
}
else
{
if (SpecialCard.UpdateData(c))
{
MyMessage.UpdateMessage();
}
else
{
e.Cancel = true;
}
}
}
}
}
private void btnExecute_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as ItemCriteria;
if (x != null)
{
x.CriteriaItem = cmboItems.SelectedItem as Item;
if (radAdd.IsChecked == true)
{
if (isValidateByControls(x) && x.IsValidate() && ItemCriteria.InsertData(x))
{
MyMessage.InsertMessage();
dgMain.ItemsSource = ItemCriteria.GetAllItemCriteria();
}
}
else if (radUpdate.IsChecked == true)
{
if (isValidateByControls(x) && x.IsValidate() && ItemCriteria.UpdateData(x))
{
MyMessage.UpdateMessage();
dgMain.ItemsSource = ItemCriteria.GetAllItemCriteria();
}
}
else if (radDelete.IsChecked == true)
{
if (MyMessageBox.Show("هل تريد تأكيد حذف المعيار", MessageBoxButton.YesNo) == MessageBoxResult.Yes && ItemCriteria.DeleteData(x))
{
MyMessage.DeleteMessage();
dgMain.ItemsSource = ItemCriteria.GetAllItemCriteria();
}
}
}
}
private void BtnExecute_Click(object sender, RoutedEventArgs e)
{
var x = (Sponsor)this.DataContext;
if (x.IsValidate())
{
if (!x.SponsorID.HasValue)
{
if (Sponsor.InsertData(x))
{
MyMessage.InsertMessage();
x.Account = new MainWPF.Account();
x.Account.Name = x.Name;
x.Account.Type = Account.AccountType.Sponsor;
x.Account.CurrentBalance = 0;
x.Account.CreateDate = BaseDataBase.DateNow;
x.Account.OwnerID = x.SponsorID;
x.Account.Status = "مفعل";
x.Account.IsDebit = true;
Account.InsertData(x.Account);
}
}
else
{
if (Sponsor.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as FamilyProperty;
if (x.IsValidate())
{
if (x.FamilyID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.FamilyPropertyID != null)
{
if (DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
UpdateCombo();
}
}
else
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
FamilyProperties.Add(x);
TotalCount = FamilyProperties.Count;
Place = TotalCount;
UpdateCombo();
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if ((this.DataContext as Qualification).IsValidate())
{
var x = this.DataContext as Qualification;
if (x.PersonID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات الوالد");
return;
}
if (x.PersonQualificationID != null)
{
if (!BaseDataBase.CurrentUser.CanUpdate)
{
MyMessageBox.Show("لا يوجد لديك صلاحيات للتعديل");
}
else if (x.UpdatePersonQualificationData())
{
MyMessage.UpdateMessage();
}
}
else
{
if (x.InsertPersonQualificationData())
{
MyMessage.InsertMessage();
Qualifications.Add(x);
TotalCount = Qualifications.Count;
Place = TotalCount;
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as Orphan_Health;
if (x.IsValidate())
{
if (x.OrphanID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات اليتيم");
return;
}
if (x.ID != null)
{
if (!BaseDataBase.CurrentUser.CanUpdate)
{
MyMessageBox.Show("لا يوجد لديك صلاحيات للتعديل");
}
else if (x.UpdateOrphanHealthData())
{
MyMessage.UpdateMessage();
}
}
else
{
if (x.InsertOrphanHealthData())
{
MyMessage.InsertMessage();
OrphanHealthes.Add(x);
TotalCount = OrphanHealthes.Count;
Place = TotalCount;
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var order = this.DataContext as Order;
if (order.IsValidateMainOrderData() && order.IsValidateOrderItemsData())
{
try
{
if (order.Type == 5)
{
if (cmboInventory2.SelectedValue == null || int.Parse(cmboInventory2.SelectedValue.ToString()) == order.InventoryID)
{
MyMessageBox.Show("يجب اختيار المستودع المراد نقل المواد اليه ويجب ان يكون مختلفا عن المستودع الاساسي");
return;
}
}
if (order.Id == null)
{
if (Order.InsertData(order))
{
if (MyMessageBox.Show("هل تريد طباعة وصل", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
PrintTicket.printReportA6(order);
}
MyMessage.InsertMessage();
}
}
else
{
if (Order.UpdateData(order))
{
MyMessage.UpdateMessage();
}
}
foreach (var item in order.OIs)
{
if (item.Order == null)
{
item.Order = order;
Order_Item.InsertData(item);
}
else
{
Order_Item.UpdateData(item);
}
}
foreach (var item in DeletedItems)
{
if (item.Order != null)
{
Order_Item.DeleteData(item);
}
}
DialogResult = true;
}
catch (Exception ex) { MyMessageBox.Show(ex.Message); }
}
}
private void btnChild_Click(object sender, RoutedEventArgs e)
{
var tf = this.DataContext as TempFamily;
var tc = grdChild.DataContext as TempChild;
if (tc == null)
{
return;
}
if (radDel.IsChecked == true)
{
if (MyMessageBox.Show("هل تريد تأكيد الحذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (!tc.ChildID.HasValue || TempChild.DeleteData(tc))
{
tf.TempChilds.Remove(tc);
dgChild.Items.Refresh();
MyMessage.DeleteMessage();
radAdd.IsChecked = true;
}
}
}
else
{
if (tc.IsValidate())
{
if (radAdd.IsChecked == true)
{
tc.TempFamilyID = tf.ID;
if (!tf.ID.HasValue || TempChild.InsertData(tc))
{
tf.TempChilds.Add(tc);
dgChild.Items.Refresh();
grdChild.DataContext = new TempChild();
Keyboard.Focus(txtChildName);
if (tf.ID.HasValue)
{
MyMessage.InsertMessage();
}
}
}
else
{
tc.TempFamilyID = tf.ID;
if (!tf.ID.HasValue || TempChild.UpdateData(tc))
{
dgChild.Items.Refresh();
if (tf.ID.HasValue)
{
MyMessage.UpdateMessage();
}
}
}
}
}
}
private void btnExecute_Click(object sender, RoutedEventArgs e)
{
Lister x = (Lister)this.DataContext;
if (x.IsValidate())
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
DialogResult = true;
}
}
}
private void btnExecute_Click(object sender, RoutedEventArgs e)
{
var x = (Parent)this.DataContext;
if (x.IsValidate())
{
if (DBMain.InsertData(x))
{
BaseDataBase.MakeTabItemGreen(this.Parent as TabItem);
MyMessage.InsertMessage();
btnExecute.Visibility = System.Windows.Visibility.Hidden;
btnUpdate.Visibility = System.Windows.Visibility.Visible;
}
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
var a = this.DataContext as AvailableSponsorship;
if (a != null)
{
if (a.IsValidate())
{
if (AvailableSponsorship.InsertData(a))
{
MyMessage.InsertMessage();
DialogResult = true;
}
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
string query = "delete from VoucherCriteria; \n";
foreach (var item in VoucherGruopItems)
{
foreach (var i in item.Value)
{
query += string.Format("insert into VoucherCriteria Values ({0},{1},{2}); \n", i.Id, item.Key, BaseDataBase.CurrentUser.ID);
}
}
if (BaseDataBase._NonQuery(query) > 0)
{
MyMessage.InsertMessage();
DialogResult = true;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!BaseDataBase.CurrentUser.CanEnterListerGroup)
{
MyMessageBox.Show("ليس لديك صلاحية ادخال بيانات فريق تقييم");
return;
}
var x = this.DataContext as ListerGroup;
if (lbListerGroup.Items.Count <= 0)
{
MyMessageBox.Show("يجب إدخال مقيّمين");
return;
}
if (x.IsValidate())
{
if (x.FamilyID == null && x.OrphanID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة او اليتيم");
return;
}
if (x.GroupID != null)
{
if (!BaseDataBase.CurrentUser.IsAdmin && BaseDataBase.DateNow.ToShortDateString() != x.CreateDate.ToShortDateString())
{
MyMessageBox.Show("لايمكن تعديل بيانات فريق التقييم الا في يوم الادخال فقط");
return;
}
if (DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
ListerGroups.Add(x);
TotalCount = ListerGroups.Count;
Place = TotalCount;
}
}
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
var i = this.DataContext as Invoice;
i.Description = i.Transitions[0].Details;
if (i.IsValidate())
{
if (i.TotalValue < double.Parse(txtBalance.Text))
{
MyMessageBox.Show("لايوجد رصيد كافي في الصندوق");
}
else if (Invoice.InsertData(i) && Transition.InsertData(i.Transitions[0]))
{
PrintTicket.printInvoiceA6(i, 1);
MyMessage.InsertMessage();
DialogResult = true;
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var sf = this.DataContext as SpecialFamily;
if (sf.IsValidate())
{
if (sf.Id.HasValue)
{
if (SpecialFamily.UpdateData(sf))
{
MyMessage.UpdateMessage();
}
}
else if (SpecialFamily.InsertData(sf))
{
MyMessage.InsertMessage();
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var i = this.DataContext as Item;
if (i.IsValidate())
{
if (!i.Id.HasValue)
{
if (Item.InsertData(i))
{
MyMessage.InsertMessage();
}
}
else
{
if (Item.UpdateData(i))
{
MyMessage.UpdateMessage();
}
}
foreach (var item in i.BasketItems)
{
if (item.Basket == null)
{
item.Basket = i;
Basket_Item.InsertData(item);
}
else
{
Basket_Item.UpdateData(item);
}
}
foreach (var item in DeletedItems)
{
Basket_Item.UpdateData(item);
Basket_Item.DeleteData(item);
}
}
}
public void btnSave_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as Orphan;
if (x.IsValidate())
{
if (x.OrphanFamily.FamilyID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.OrphanFamily.FamilyType == "أيتام")
{
if (x.Gender == "ذكر" && (((BaseDataBase.DateNow - x.DOB.Value)).Days / 30 / 12) >= 14)
{
if (MyMessageBox.Show("عمر اليتيم أكبر من 14\nهل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return;
}
}
}
if (x.OrphanID != null)
{
if (Orphan.UpdateData(x))
{
MyMessage.UpdateMessage();
}
}
else
{
if (Orphan.InsertData(x))
{
MyMessage.InsertMessage();
}
}
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
var i = this.DataContext as Invoice;
if (i.IsValidate())
{
if (Invoice.InsertData(i))
{
foreach (var t in i.Transitions)
{
if (Transition.InsertData(t))
{
Transition tt = new Transition();
tt.Details = "ترصيد حساب اليتيم في الكفيل";
tt.LeftAccount = t.RightAccount;
tt.RightAccount = Account.GetAccountByOwnerID(Account.AccountType.Sponsor, t.RelatedSponsorship.AvailableSponsorship.RelatedSponsor.SponsorID.Value, false);
tt.SponsorshipID = t.RelatedSponsorship.ID;
tt.Value = t.Value;
tt.AccountType = t.AccountType;
Transition.InsertData(tt);
}
else
{
MyMessageBox.Show("حدث خطأ اثناء حفظ البيانات يرجى مراجعة مسؤل البرنامج");
return;
}
}
PrintTicket.printInvoiceA6(i, 2);
MyMessage.InsertMessage();
DialogResult = true;
}
else
{
MyMessageBox.Show("حدث خطأ اثناء حفظ البيانات يرجى مراجعة مسؤل البرنامج");
return;
}
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
var i = this.DataContext as Invoice;
i.Description = i.Transitions[0].Details;
if (i.IsValidate())
{
if (Invoice.InsertData(i) && Transition.InsertData(i.Transitions[0]))
{
Transition tt = new Transition();
tt.Details = "ترصيد حساب طالب العلم في الكفيل";
tt.LeftAccount = i.Transitions[0].RightAccount;
tt.RightAccount = Account.GetAccountByOwnerID(Account.AccountType.Sponsor, o.CurrentSponsorship.AvailableSponsorship.RelatedSponsor.SponsorID.Value, false);
tt.SponsorshipID = o.CurrentSponsorship.ID;
tt.Value = i.Transitions[0].Value;
tt.AccountType = Account.AccountType.Student;
Transition.InsertData(tt);
PrintTicket.printInvoiceA6(i, 2);
MyMessage.InsertMessage();
DialogResult = true;
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!BaseDataBase.CurrentUser.CanEnterFamilyNeed)
{
MyMessageBox.Show("ليس لديك صلاحية اضافة احتياجات عائلة");
return;
}
var x = this.DataContext as FamilyNeed;
if (x.IsValidate())
{
if (x.FamilyID == null)
{
MyMessageBox.Show("لم يتم إدخال بيانات العائلة");
return;
}
if (x.FamilyNeedID != null)
{
if (BaseDataBase.CurrentUser.CanUpdate && DBMain.UpdateData(x))
{
MyMessage.UpdateMessage();
UpdateCombo();
}
}
else
{
if (DBMain.InsertData(x))
{
MyMessage.InsertMessage();
FamilyNeeds.Add(x);
TotalCount = FamilyNeeds.Count;
Place = TotalCount;
UpdateCombo();
}
}
}
}
