public Transition_Expenses(FundType ft) { InitializeComponent(); var i = new Invoice(); var t = i.AddTransition(); t.LeftAccount = new Account { Id = 1 }; //1 is general fund account id t.RightAccount = new Account { Id = 5 }; //5 is expenses account id if (ft == FundType.GeneralHidden) { t.IsHidden = true; txtMsg1.Visibility = Visibility.Visible; txtMsg2.Visibility = Visibility.Collapsed; var r = BaseDataBase._Scalar($@"select dbo.fn_GetHiddenBalance()"); txtBalance.Text = r; } else { var r = BaseDataBase._Scalar($@"(select (select isnull(sum(Value),0) from Transition where IsHidden = 0 and RightAccount = 1 - (select isnull(sum(Value),0) from Transition where IsHidden = 0 and LeftAccount = 1))" ); txtBalance.Text = r; } this.DataContext = i; }
private void btnDelLister_Click(object sender, RoutedEventArgs e) { if (dgListers.SelectedIndex != -1) { if (!BaseDataBase.CurrentUser.CanDelete) { MyMessageBox.Show("ليس لديك صلاحيات للحذف"); } else { Lister l = Lister.GetListerByID((int)(dgListers.Items[dgListers.SelectedIndex] as DataRowView)[0]); if (int.Parse(BaseDataBase._Scalar("select dbo.GetGroupCountByListerID(" + l.ListerID + ")")) > 0) { MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تقييم سابقة له ضمن فرق التقييم"); } else if (int.Parse(BaseDataBase._Scalar("select COUNT(ID) from Trained where TrainedType = 2 and TrainedID = " + l.ListerID)) > 0) { MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تدريب سابقة له"); } else if (DBMain.DeleteData(l)) { dgListers.ItemsSource = Lister.GetAllListersTable; MyMessage.DeleteMessage(); } } } }
private void cmboReciever_Changed(object sender, SelectionChangedEventArgs e) { if (IsLoaded) { var i = this.DataContext as Invoice; if ((sender as ComboBox).SelectedIndex == 3) { txtReceiver.IsReadOnly = false; txtReceiverPID.IsReadOnly = false; i.Receiver = ""; i.ReceiverPID = ""; } else { txtReceiver.IsReadOnly = true; txtReceiverPID.IsReadOnly = true; if ((sender as ComboBox).SelectedIndex == 0) { i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); } else if ((sender as ComboBox).SelectedIndex == 1) { i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Guardian where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Guardian where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); } else { i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Guardian where FamilyID = {f.FamilyID} and Gender = N'ذكر'"); i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Guardian where FamilyID = {f.FamilyID} and Gender = N'ذكر'"); } } } }
public Transition_OrphanFamilyWindow(Family f) { InitializeComponent(); this.f = f; txtFamily.Text = f.FamilyCode; var i = new Invoice(); foreach (var o in f.FamilyOrphans.Where(x => x.Type != "طالب علم" && x.CurrentSponsorship != null)) { var t = i.AddTransition(); t.RightAccount = o.Account; t.Value = o.CurrentSponsorship.AvailableSponsorship.SponsorshipValue; t.Value = o.CurrentSponsorship.IsDouble ? t.Value * 2 : t.Value; t.Details = "دفعة من صندوق الايتام"; t.LeftAccount = new Account() { Id = (o.Type == "يتيم" ? 2 : 3) }; //the id of ophan fund (2) account or ophan student fund (3) account t.RelatedSponsorship = o.CurrentSponsorship; t.RelatedSponsorship.OrphanName = o.FirstName + " " + o.LastName; t.SponsorshipID = o.CurrentSponsorship.ID; t.AccountType = (o.Type == "يتيم" ? Account.AccountType.Orphan : Account.AccountType.OrphanStudent); //the ophan type (2) or ophan student type (3) } i.Serial = "A"; i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'"); this.DataContext = i; }
private void btnDelLister_Click(object sender, RoutedEventArgs e) { if (dgSupervisor.SelectedIndex != -1) { if (!BaseDataBase.CurrentUser.CanDelete) { MyMessageBox.Show("ليس لديك صلاحيات للحذف"); } else { Supervisor s = Supervisor.GetSupervisorByID((int)(dgSupervisor.Items[dgSupervisor.SelectedIndex] as DataRowView)[0]); if (int.Parse(BaseDataBase._Scalar("select dbo.fn_SupervisorOrphansCount(" + s.SupervisorID + ")")) > 0) { MyMessageBox.Show("لا يمكن حذف المشرف \nبسبب وجود بيانات إشراف سابقة له"); } else if (int.Parse(BaseDataBase._Scalar("select COUNT(ID) from Trained where TrainedType = 3 and TrainedID = " + s.SupervisorID)) > 0) { MyMessageBox.Show("لا يمكن حذف المشرف \nبسبب وجود بيانات تدريب سابقة له"); } else { if (s.DeleteSupervisorData()) { dgSupervisor.ItemsSource = Supervisor.GetAllSupervisorTable; MyMessage.DeleteMessage(); } } } } }
public FamilyOrderControl(Order order) { InitializeComponent(); if (order.FamilyID.HasValue) { int.TryParse(BaseDataBase._Scalar($"select Max(Id) from [order] where FamilyID = " + order.FamilyID), out CurrentMaxOrderID); } else { int.TryParse(BaseDataBase._Scalar($"select Max(Id) from [order] where SpecialFamilyID = " + order.SpecialFamilyID), out CurrentMaxOrderID); } this.DataContext = order; dgOrderItems.ItemsSource = order.OIs; cmboInventory.ItemsSource = Inventory.GetAllInventory().Where(x => x.IsActive); if (!order.Id.HasValue) { order.Date = BaseDataBase.DateNow; if (order.Type == 3) { // if the order is urgent no need to select NextOrderDate if (!order.IsUrgentOrder) { order.NextOrderDate = order.Date.Value.AddDays(int.Parse(BaseDataBase._Scalar($"select dbo.GetNextOrderDaysByFamilyID({order.FamilyID})"))); //if the NextOrderDate is Friday or Thursday .. change it to Satruday order.NextOrderDate = order.NextOrderDate.Value.DayOfWeek == DayOfWeek.Thursday || order.NextOrderDate.Value.DayOfWeek == DayOfWeek.Friday ? order.NextOrderDate.Value.AddDays(2) : order.NextOrderDate.Value; } btnSelectItems_Click(null, null); } } //if(!order.Id.HasValue) // i.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupBySupportGroupID(-1, i.FamilyID.Value); // else i.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupBySupportGroupID(i.SupportGroupID, i.FamilyID.Value); }
private void ChekStudySide() { int i; string s = BaseDataBase._Scalar("Select Count(IsLocal) from MergedStudySide where IsLocal = 1"); if (string.IsNullOrEmpty(s)) { MyMessageBox.Show("حدثت مشكلة في قاعدة البيانات يرجى مراجعة فريق الدعم"); Environment.Exit(Environment.ExitCode); } else { i = int.Parse(s); if (i == 0) { StudySideInsertControl w = new StudySideInsertControl(); if (!w.ShowDialog() == true) { Environment.Exit(Environment.ExitCode); } } else if (i > 1) { MyMessageBox.Show("حدثت مشكلة في قاعدة البيانات يرجى مراجعة فريق الدعم"); Environment.Exit(Environment.ExitCode); } } }
internal bool CanRemove() { var r = BaseDataBase._Scalar("select count(*) from SpecialCardSource where SpecialCardID = " + ID); if (!string.IsNullOrEmpty(r) && int.Parse(r) > 0) { return(false); } return(true); }
bool CanPresent() { var s = BaseDataBase._Scalar($"select isnull(IsPresentable,0) from Sector where id = (select SectorID from Family where FamilyID = {FamilyID})"); if (!string.IsNullOrEmpty(s)) { return(bool.Parse(s)); } return(true); }
private void btnSave_Click(object sender, RoutedEventArgs e) { var order = this.DataContext as Order; if (order.IsValidateMainOrderData() && order.IsValidateOrderItemsData()) { try { // foreach (var item in x.FamilyNeeds) // if (!item.IsEnsured) // if (MyMessageBox.Show("لم يتم تأمين كامل احتياجات العائلة .. هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes) // return; // break; if (!order.Id.HasValue) { //check if there is any other order from other device int CurrentMaxOrderID_temp = 0; if (order.FamilyID.HasValue) { int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where FamilyID=" + order.FamilyID), out CurrentMaxOrderID_temp); } else { int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where SpecialFamilyID=" + order.SpecialFamilyID), out CurrentMaxOrderID_temp); } if (CurrentMaxOrderID_temp != 0 && CurrentMaxOrderID_temp != CurrentMaxOrderID) { MyMessageBox.Show("لقد تمت اضافة اعانة جديدة من جهاز اخر\nبجب اغلاق النافذة وتحديث البيانات للتحقق\nلايمكن الاضافة"); return; } if (Properties.Settings.Default.ActiveFingerPrint && o == null && MyMessageBox.Show("لم يتم اضافة البصمة الالكترونية هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes) { return; } if (Order.InsertData(order)) { SendFingerPrint(order); } } else if (Order.UpdateData(order)) { MyMessage.UpdateMessage(); } Task.Run(() => InsertOrderItems(order)); //PrintOrder(order); DialogResult = true; } catch (Exception ex) { MyMessageBox.Show(ex.Message); } } }
private void btnNext_Click(object sender, RoutedEventArgs e) { var o = DataContext as Order; var Id = BaseDataBase._Scalar("select Min(Id) from [order] o where Type in (1,2,5) and Id > " + o.Id); if (!string.IsNullOrEmpty(Id)) { SetDataContext(Order.GetOrderByID(int.Parse(Id))); } else { MyMessageBox.Show("تم الوصول لاخر امر"); } }
private void btnDelItem_Click(object sender, RoutedEventArgs e) { if (dgSelectedItems.SelectedIndex != -1) { txtSearch.Text = string.Empty; Order_Item s = dgSelectedItems.SelectedItem as Order_Item; var i = s.Item; if (s.Order != null) { double currentQuantity = 0; double previousQuantity = 0; if (s.Order.Id.HasValue) { double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={s.Item.Id} and OrderID = {s.Order.Id}"), out previousQuantity); } else { previousQuantity = 0; } double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {s.Order.InventoryID} and ItemID = {s.Item.Id}"), out currentQuantity); if (s.Order.Type == 1) { if (currentQuantity - previousQuantity < (s.Item.MinimumQuantity.HasValue ? s.Item.MinimumQuantity : 0)) { MyMessageBox.Show($"القيمة الحالية للمادة \"{s.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {(s.Item.MinimumQuantity.HasValue ? s.Item.MinimumQuantity : 0)}\nلا يمكن حذف المادة"); return; } } else { if (s.Item.MaximumQuantity.HasValue && currentQuantity + previousQuantity > s.Item.MaximumQuantity) { MyMessageBox.Show($"القيمة الحالية للمادة \"{s.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الذي يجب ان يحويه المستودع هو {s.Item.MaximumQuantity}\nلا يمكن حذف المادة"); return; } } } (lbMainItems.ItemsSource as List <Item>).Add(i); (dgSelectedItems.ItemsSource as List <Order_Item>).Remove(s); RefreshPanel(); if (s != null) { DeletedItems.Add(s); } } }
public static bool InsertData(TempFamily t) { t.Creator = BaseDataBase.CurrentUser.Name; t.ID = BaseDataBase._StoredProcedureReturnable("sp_Add2TempFamily" , new SqlParameter("@ID", System.Data.SqlDbType.Int) , new SqlParameter("@FamilyName", t.FamilyName) , new SqlParameter("@FamilyCode", t.FamilyCode) , new SqlParameter("@ApplyDate", t.ApplyDate) , new SqlParameter("@Notes", t.Notes) , new SqlParameter("@FamilyType", t.FamilyType) , new SqlParameter("@FamilyIdentityID", t.FamilyIdentityID) , new SqlParameter("@FatherFirstName", t.FatherFirstName) , new SqlParameter("@FatherFatherName", t.FatherFatherName) , new SqlParameter("@FatherLastName", t.FatherLastName) , new SqlParameter("@FatherBornPlace", t.FatherBornPlace) , new SqlParameter("@FatherPID", t.FatherPID) , new SqlParameter("@FatherDOB", t.FatherDOB) , new SqlParameter("@MotherFirstName", t.MotherFirstName) , new SqlParameter("@MotherFatherName", t.MotherFatherName) , new SqlParameter("@MotherLastName", t.MotherLastName) , new SqlParameter("@MotherBornPlace", t.MotherBornPlace) , new SqlParameter("@MotherPID", t.MotherPID) , new SqlParameter("@MotherDOB", t.MotherDOB) , new SqlParameter("@Phone", t.Phone) , new SqlParameter("@Mobile1", t.Mobile1) , new SqlParameter("@Mobile2", t.Mobile2) , new SqlParameter("@IsPrinted", t.IsPrinted) , new SqlParameter("@Printer", t.Printer) , new SqlParameter("@HouseSection", t.HouseSection) , new SqlParameter("@HouseStreet", t.HouseStreet) , new SqlParameter("@HouseBuildingNumber", t.HouseBuildingNumber) , new SqlParameter("@HouseFloor", t.HouseFloor) , new SqlParameter("@HouseAddress", t.HouseAddress) , new SqlParameter("@HouseOldAddress", t.HouseOldAddress) , new SqlParameter("@Creator", t.Creator) , new SqlParameter("@IsCancelled", t.IsCancelled) , new SqlParameter("@FamilyPersonCount", t.FamilyPersonCount) , new SqlParameter("@CancelReason", t.CancelReason) , new SqlParameter("@FamilyID", t.FamilyID) ); t.FamilyCode = BaseDataBase._Scalar("select FamilyCode from TempFamily where Id = " + t.ID); foreach (var tc in t.TempChilds) { tc.TempFamilyID = t.ID; TempChild.InsertData(tc); } return(t.ID.HasValue); }
private void AddSupport_Click(object sender, RoutedEventArgs e) { var sf = this.DataContext as SpecialFamily; if (!sf.Id.HasValue) { MyMessageBox.Show("يجب حفظ بيانات العائلة اولاً"); return; } if (!BaseDataBase.CurrentUser.CanPresent) { MyMessageBox.Show("ليس لديك صلاحية لاضافة اعانة"); } else { int NumberOfDays = 0; try { NumberOfDays = int.Parse(BaseDataBase._Scalar("select NumberOfDays from NextOrderSpecialFamily")); } catch { } if (NumberOfDays != 0) { DateTime?MaxOrderDate; try { MaxOrderDate = (from x in (lvOrders.ItemsSource as List <Order>) where x.Date.HasValue select x.Date).Max(); } catch { MaxOrderDate = null; } if (MaxOrderDate.HasValue && (BaseDataBase.DateNow - MaxOrderDate.Value).Days < NumberOfDays) { //if (MyMessageBox.Show("متبقي " + (MaxOrderDate.Value - BaseDataBase.DateNow).Days + " ايام للاستلام القادم\nهل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes) MyMessageBox.Show("متبقي " + (MaxOrderDate.Value - BaseDataBase.DateNow).Days + " ايام للاستلام القادم"); return; } } Order o = new Order(); o.Type = 4; o.SpecialFamilyID = sf.Id; FamilyOrderControl w = new FamilyOrderControl(o); w.cmboInventory.IsEnabled = true; if (w.ShowDialog() == true) { sf.Orders.Add(w.DataContext as Order); this.DataContext = null; this.DataContext = sf; } } }
public static bool InsertData(Order x, bool InsertOrderItems = false) { x.LastUserID = BaseDataBase.CurrentUser.ID.Value; x.Id = BaseDataBase._StoredProcedureReturnable("sp_Add_Order" , new SqlParameter("@Id", System.Data.SqlDbType.Int) , new SqlParameter("@InventoryID", x.InventoryID) , new SqlParameter("@FamilyID", x.FamilyID) , new SqlParameter("@OrphanID", x.OrphanID) , new SqlParameter("@SpecialFamilyID", x.SpecialFamilyID) , new SqlParameter("@Type", x.Type) , new SqlParameter("@Date", x.Date) , new SqlParameter("@NextOrderDate", x.NextOrderDate) , new SqlParameter("@Description", x.Description) , new SqlParameter("@Source", x.Source) , new SqlParameter("@InvoiceSerial", x.InvoiceSerial) , new SqlParameter("@Notes", x.Notes) , new SqlParameter("@LastUserID", x.LastUserID)); if (InsertOrderItems) { foreach (var item in x.OIs) { item.Order = x; Order_Item.InsertData(item); } } x.OrderCode = int.Parse(BaseDataBase._Scalar($"select OrderCode from [Order] where Id = {x.Id}")); x.BarCode = BaseDataBase._Scalar($"select BarCode from [Order] where Id = {x.Id}"); //if (x.Id.HasValue) //{ // foreach (var item in x.FamilyNeeds) // { // if (item.IsEnsured) // item.OrderID = x.Id; // else item.OrderID = null; // FamilyNeed_ListerGroup.UpdateData(item); // } //} return(x.Id.HasValue); }
bool CanRemoveOrder(Order o) { if (o != null) { foreach (var item in o.OIs) { double currentQuantity = 0; double previousQuantity = 0; if (item.Order.Id.HasValue) { double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={item.Item.Id} and OrderID = {item.Order.Id}"), out previousQuantity); } else { previousQuantity = 0; } double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {item.Order.InventoryID} and ItemID = {item.Item.Id}"), out currentQuantity); if (o.Type == 1) { if (currentQuantity - previousQuantity < (item.Item.MinimumQuantity.HasValue ? item.Item.MinimumQuantity : 0)) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {(item.Item.MinimumQuantity.HasValue ? item.Item.MinimumQuantity : 0)}\nلا يمكن حذف المادة"); return(false); } } else { if (item.Item.MaximumQuantity.HasValue && currentQuantity + previousQuantity > item.Item.MaximumQuantity) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الذي يجب ان يحويه المستودع هو {item.Item.MaximumQuantity}\nلا يمكن حذف المادة"); return(false); } } } } return(true); }
public Transition_StudentWindow(Orphan o) { InitializeComponent(); this.o = o; txtStudent.Text = o.FirstName + " " + o.LastName; var i = new Invoice(); var t = i.AddTransition(); t.RightAccount = o.Account; t.LeftAccount = new Account() { Id = 4 }; //4 is the id of student fund account t.Value = o.CurrentSponsorship.AvailableSponsorship.SponsorshipValue; t.Value = o.CurrentSponsorship.IsDouble ? t.Value * 2 : t.Value; t.SponsorshipID = o.CurrentSponsorship.ID; t.AccountType = Account.AccountType.Student; // 4 is the student type id txtSponsor.Text = o.CurrentSponsorship.AvailableSponsorship.RelatedSponsor.Name; i.Serial = "B"; i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {o.OrphanFamily.FamilyID} and Gender = 'أنثى'"); i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {o.OrphanFamily.FamilyID} and Gender = 'أنثى'"); this.DataContext = i; }
public static string GetUserNameByID(int id) { return(BaseDataBase._Scalar("select Name from Users where id =" + id)); }
private void Window_Loaded_1(object sender, RoutedEventArgs e) { txtCharity.Text = BaseDataBase._Scalar("select top 1 Name from MergedStudySide where IsLocal = 1"); txtVersion.Text = Assembly.GetExecutingAssembly().GetName().Version.ToString(); }
private void bw2_DoWork(object sender, DoWorkEventArgs e) { var bw = sender as BackgroundWorker; DataTable dt = e.Argument as DataTable; Family f = new Family(); f.FamilyType = dt.TableName; House h = new House(); for (int i = 0; i < dt.Rows.Count; i++) { f.FamilyCode = dt.DefaultView[i]["ID"].ToString(); f.FamilyName = dt.DefaultView[i]["Name"].ToString() != "" ? dt.DefaultView[i]["Name"].ToString() : dt.DefaultView[i]["WifeName"].ToString(); f.FamilyFather.FirstName = dt.DefaultView[i]["Name"].ToString(); f.FamilyFather.PID = dt.DefaultView[i]["PID"].ToString(); f.FamilyMother.FirstName = dt.DefaultView[i]["WifeName"].ToString(); f.FamilyMother.PID = dt.DefaultView[i]["WifePID"].ToString(); f.FamilyIdentityID = dt.DefaultView[i]["FamilyBookID"].ToString() + ((dt.DefaultView[i]["FamilyBookChar"].ToString() == "") ? "" : ((" " + dt.DefaultView[i]["FamilyBookChar"].ToString()) + ((dt.DefaultView[i]["FamilyNumber"].ToString() == "") ? "" : " " + dt.DefaultView[i]["FamilyNumber"].ToString()))); if (f.FamilyIdentityID == "") { f.FamilyIdentityID = "لايوجد دفتر عائلة"; } f.FamilyPersonCount = dt.DefaultView[i]["FamilyMemberCount"].ToString(); f.FamilyFather.Phone = dt.DefaultView[i]["Phone"].ToString(); f.FamilyFather.Mobile = dt.DefaultView[i]["Mobile"].ToString(); f.FamilyStatus = dt.DefaultView[i]["FamilyStatus"].ToString(); h.OldAddress = dt.DefaultView[i]["BasePlace"].ToString(); h.Address = dt.DefaultView[i]["CurrentPlace"].ToString(); f.Notes = dt.DefaultView[i]["Notes"].ToString(); f.Evaluation = dt.DefaultView[i]["Evaluation"].ToString(); f.ApplyDate = BaseDataBase.DateNow; List <FamilyPerson> fps = new List <FamilyPerson>(); int b1 = dt.DefaultView[i]["Baby1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby1"]; int b2 = dt.DefaultView[i]["Baby2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby2"]; int b3 = dt.DefaultView[i]["Baby3"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby3"]; int m1 = dt.DefaultView[i]["Male1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Male1"]; int m2 = dt.DefaultView[i]["Male2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Male2"] - 1; int f1 = dt.DefaultView[i]["Female1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female1"]; int f2 = dt.DefaultView[i]["Female2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female2"]; int f3 = dt.DefaultView[i]["Female3"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female3"]; if (f3 > 0) { f3--; f.FamilyMother.DOB = BaseDataBase.DateNow.AddYears(-50); f.FamilyFather.DOB = BaseDataBase.DateNow.AddYears(-55); } else { f2--; f.FamilyMother.DOB = BaseDataBase.DateNow.AddYears(-30); f.FamilyFather.DOB = BaseDataBase.DateNow.AddYears(-40); } int index = 0; while (b1 > 0) { b1--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddMonths(-2); if (m1 > 0) { m1--; fp.Gender = "ذكر"; } else { f1--; fp.Gender = "أنثى"; } fps.Add(fp); } while (b2 > 0) { b2--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddMonths(-10); if (m1 > 0) { m1--; fp.Gender = "ذكر"; } else { f1--; fp.Gender = "أنثى"; } fps.Add(fp); } while (b3 > 0) { b3--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddMonths(-18); if (m1 > 0) { m1--; fp.Gender = "ذكر"; } else { f1--; fp.Gender = "أنثى"; } fps.Add(fp); } while (m1 > 0) { m1--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddYears(-8); fp.Gender = "ذكر"; fps.Add(fp); } while (m2 > 0) { m2--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddYears(-15); fp.Gender = "ذكر"; fps.Add(fp); } while (f1 > 0) { f1--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddYears(-8); fp.Gender = "أنثى"; fps.Add(fp); } while (f2 > 0) { f2--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddYears(-15); fp.Gender = "أنثى"; fps.Add(fp); } while (f3 > 0) { f3--; FamilyPerson fp = new FamilyPerson(); fp.FirstName = "الابن " + ++index; fp.DOB = BaseDataBase.DateNow.AddYears(-50); fp.Gender = "أنثى"; fps.Add(fp); } f.FamilyID = BaseDataBase._StoredProcedureReturnable("sp_Add2FamilyHilal" , new SqlParameter("@FamilyID", SqlDbType.Int) , new SqlParameter("@FamilyCode", f.FamilyCode) , new SqlParameter("@FamilyName", f.FamilyName) , new SqlParameter("@FamilyType", f.FamilyType) , new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID) , new SqlParameter("@ApplyDate", f.ApplyDate) , new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount) , new SqlParameter("@FamilyStatus", f.FamilyStatus) , new SqlParameter("@Evaluation", f.Evaluation) , new SqlParameter("@Notes", f.Notes) , new SqlParameter("@Phone", f.FamilyFather.Phone) , new SqlParameter("@Mobile", f.FamilyFather.Mobile) , new SqlParameter("@FirstNameF", f.FamilyFather.FirstName) , new SqlParameter("@DOBF", f.FamilyFather.DOB) , new SqlParameter("@PIDF", f.FamilyFather.PID) , new SqlParameter("@FirstNameM", f.FamilyMother.FirstName) , new SqlParameter("@DOBM", f.FamilyMother.DOB) , new SqlParameter("@PIDM", f.FamilyMother.PID) , new SqlParameter("@OldAddress", h.OldAddress) , new SqlParameter("@Address", h.Address)); int ChildID = int.Parse(BaseDataBase._Scalar("select IsNull(Max(FamilyPersonID)+1,1) from FamilyPerson")); for (int j = 0; j < fps.Count; j++) { string s = string.Format("insert into FamilyPerson(FamilyPersonID,FamilyID,FirstName,Gender,DOB) values ({0},{1},'{2}','{3}',", ChildID + j, f.FamilyID, fps[j].FirstName, fps[j].Gender); if (fps[j].DOB.HasValue) { s += "'" + fps[j].DOB.Value.ToString("MM/dd/yyyy") + "')"; } else { s += "null)"; } BaseDataBase._NonQuery(s); } bw.ReportProgress(i); } }
private void btnSaveTable_Click(object sender, RoutedEventArgs e) { if (dgExcelFile.ItemsSource != null && dgExcelFile.Items.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Family f = new Family(); House h = new House(); List <FamilyPerson> fps = new List <FamilyPerson>(); try { if (dt.DefaultView[i][1].ToString() == "") { continue; } f.FamilyCode = dt.DefaultView[i][1].ToString(); f.FamilyType = dt.DefaultView[i][2].ToString(); f.FamilyIdentityID = dt.DefaultView[i][3].ToString(); if (dt.DefaultView[i][4].ToString() != "") { f.FamilyIdentityID += " " + dt.DefaultView[i][4].ToString(); if (dt.DefaultView[i][5].ToString() != "") { f.FamilyIdentityID += " " + dt.DefaultView[i][5].ToString(); } } f.ApplyDate = GetDate(dt.DefaultView[i][6].ToString()); f.FamilyPersonCount = dt.DefaultView[i][7].ToString(); f.FamilyName = dt.DefaultView[i][8].ToString(); f.Notes = dt.DefaultView[i][9].ToString(); f.FamilyFather.FirstName = dt.DefaultView[i][10].ToString(); f.FamilyFather.FatherName = dt.DefaultView[i][11].ToString(); f.FamilyFather.LastName = dt.DefaultView[i][12].ToString(); f.FamilyFather.BirthPlace = dt.DefaultView[i][13].ToString(); f.FamilyFather.DOB = GetDate(dt.DefaultView[i][14].ToString()); f.FamilyFather.PID = dt.DefaultView[i][15].ToString(); f.FamilyMother.FirstName = dt.DefaultView[i][16].ToString(); f.FamilyMother.FatherName = dt.DefaultView[i][17].ToString(); f.FamilyMother.LastName = dt.DefaultView[i][18].ToString(); f.FamilyMother.BirthPlace = dt.DefaultView[i][19].ToString(); f.FamilyMother.DOB = GetDate(dt.DefaultView[i][20].ToString()); f.FamilyMother.PID = dt.DefaultView[i][21].ToString(); h.Address = dt.DefaultView[i][22].ToString() + ((dt.DefaultView[i][23].ToString().Trim() == "") ? "" : (" بناء " + dt.DefaultView[i][23].ToString())) + ((dt.DefaultView[i][24].ToString().Trim() == "") ? "" : " طابق " + dt.DefaultView[i][24].ToString()); h.HouseType = dt.DefaultView[i][25].ToString(); f.FamilyFather.Phone = dt.DefaultView[i][26].ToString(); f.FamilyFather.Mobile = dt.DefaultView[i][27].ToString(); h.OldAddress = dt.DefaultView[i][28].ToString(); int j = 29; while (dt.DefaultView[i][j].ToString().Trim() != "") { FamilyPerson c = new FamilyPerson(); c.FirstName = dt.DefaultView[i][j].ToString(); c.DOB = GetDate(dt.DefaultView[i][j + 1].ToString()); c.Gender = (dt.DefaultView[i][j + 2].ToString() == "ذ") ? "ذكر" : "أنثى"; j += 3; fps.Add(c); } string temp = BaseDataBase._Scalar("select FamilyID from Family where FamilyCode = '" + f.FamilyCode + "'"); if (string.IsNullOrEmpty(temp)) { f.FamilyID = null; f.FamilyID = BaseDataBase._StoredProcedureReturnable("sp_Add2Family4Aleppo" , new SqlParameter("@FamilyID", SqlDbType.Int) , new SqlParameter("@FamilyCode", f.FamilyCode) , new SqlParameter("@FamilyName", f.FamilyName) , new SqlParameter("@FamilyType", f.FamilyType) , new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID) , new SqlParameter("@ApplyDate", f.ApplyDate) , new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount) , new SqlParameter("@FamilyStatus", f.FamilyStatus) , new SqlParameter("@Evaluation", f.Evaluation) , new SqlParameter("@Notes", f.Notes) , new SqlParameter("@Phone", f.FamilyFather.Phone) , new SqlParameter("@Mobile", f.FamilyFather.Mobile) , new SqlParameter("@FirstNameFF", f.FamilyFather.FirstName) , new SqlParameter("@FirstNameFFa", f.FamilyFather.FatherName) , new SqlParameter("@FirstNameFL", f.FamilyFather.LastName) , new SqlParameter("@BirthPlaceF", f.FamilyFather.BirthPlace) , new SqlParameter("@DOBF", f.FamilyFather.DOB) , new SqlParameter("@PIDF", f.FamilyFather.PID) , new SqlParameter("@FirstNameMF", f.FamilyMother.FirstName) , new SqlParameter("@FirstNameMFa", f.FamilyMother.FatherName) , new SqlParameter("@FirstNameML", f.FamilyMother.LastName) , new SqlParameter("@BirthPlaceM", f.FamilyMother.BirthPlace) , new SqlParameter("@DOBM", f.FamilyMother.DOB) , new SqlParameter("@PIDM", f.FamilyMother.PID) , new SqlParameter("@OldAddress", h.OldAddress) , new SqlParameter("@Address", h.Address)); if (!f.FamilyID.HasValue) { MessageBox.Show("خطأ في بيانات العائلة " + f.FamilyName + "\nذات الرقم " + f.FamilyCode); continue; } } else { f.FamilyID = int.Parse(temp); if (!BaseDataBase._StoredProcedure("sp_Add2Family4Aleppo1" , new SqlParameter("@FamilyID", f.FamilyID) , new SqlParameter("@FamilyCode", f.FamilyCode) , new SqlParameter("@FamilyName", f.FamilyName) , new SqlParameter("@FamilyType", f.FamilyType) , new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID) , new SqlParameter("@ApplyDate", f.ApplyDate) , new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount) , new SqlParameter("@FamilyStatus", f.FamilyStatus) , new SqlParameter("@Evaluation", f.Evaluation) , new SqlParameter("@Notes", f.Notes) , new SqlParameter("@Phone", f.FamilyFather.Phone) , new SqlParameter("@Mobile", f.FamilyFather.Mobile) , new SqlParameter("@FirstNameFF", f.FamilyFather.FirstName) , new SqlParameter("@FirstNameFFa", f.FamilyFather.FatherName) , new SqlParameter("@FirstNameFL", f.FamilyFather.LastName) , new SqlParameter("@BirthPlaceF", f.FamilyFather.BirthPlace) , new SqlParameter("@DOBF", f.FamilyFather.DOB) , new SqlParameter("@PIDF", f.FamilyFather.PID) , new SqlParameter("@FirstNameMF", f.FamilyMother.FirstName) , new SqlParameter("@FirstNameMFa", f.FamilyMother.FatherName) , new SqlParameter("@FirstNameML", f.FamilyMother.LastName) , new SqlParameter("@BirthPlaceM", f.FamilyMother.BirthPlace) , new SqlParameter("@DOBM", f.FamilyMother.DOB) , new SqlParameter("@PIDM", f.FamilyMother.PID) , new SqlParameter("@OldAddress", h.OldAddress) , new SqlParameter("@Address", h.Address))) { MessageBox.Show("خطأ في بيانات العائلة " + f.FamilyName + "\nذات الرقم " + f.FamilyCode); continue; } } BaseDataBase._NonQuery("delete from child where FamilyID = " + f.FamilyID); foreach (var item in fps) { item.FamilyID = f.FamilyID; DBMain.InsertData(item); } } catch { } } } }
void GetCurrentBalance(int MainId, int CrossID) { var r = BaseDataBase._Scalar($@"select dbo.fn_GetCrossAccountBalance({MainId},{CrossID})"); txtCurrentBalance.Text = r; }
internal static int GetInventoryByFamilyID(int?familyID) { try { return(int.Parse(BaseDataBase._Scalar($"select InventoryID from Sector where Id = (select SectorID from Family where FamilyID = {familyID})"))); } catch { return(-1); } }
internal bool CanRemove() { try { string sql = $"select(select count(*) from FormedBasket_Sector where SectorID = {ID}) + (select count(*) from Family where SectorID = {ID})"; var result = BaseDataBase._Scalar(sql); int n; if (int.TryParse(result, out n) && n > 0) { return(false); } return(true); } catch (Exception ex) { MyMessageBox.Show(ex.Message); return(false); } }
private bool ValidateAllItems() { var o = this.DataContext as Order; var lst = dgSelectedItems.ItemsSource as List <Order_Item>; if (o.Type >= 3)//FamilyOrder { foreach (var item in lst) { if (item.Item.MaxQuantityPerOrder.HasValue && item.Quantity > item.Item.MaxQuantityPerOrder) { MyMessageBox.Show($"أعلى كمية ممكن أن تستلمها العائلة من المادة\" {item.Item.Name}\" في اليوم هي " + item.Item.MaxQuantityPerOrder); return(false); } if (item.Item.MaxQuantityPerFamily.HasValue) { double sum = 0; double.TryParse(BaseDataBase._Scalar($"select sum(Quantity) from Order_item where OrderID in (select id from [Order] where IsNull(FamilyID,-1) = {o.FamilyID} and id <> {o.Id ?? -1}) and ItemID = {item.Item.Id}"), out sum); if (sum + item.Quantity > item.Item.MaxQuantityPerFamily) { MyMessageBox.Show($"تم استلام {sum} من المادة \"{item.Item.Name}\" لهذه العائلة سابقاً\nأعلى كمية ممكن ان تستلمها العائلة بشكل اجمالي هو {item.Item.MaxQuantityPerFamily}"); return(false); } } if (item.Item.MaxQuantityPerDay.HasValue) { double sum = 0; double.TryParse(BaseDataBase._Scalar($"select sum(Quantity) from Order_item where OrderID in (select id from [Order] where Type >= 3 and id <> {o.Id ?? -1} and InventoryID = {o.InventoryID} and CONVERT(date, [Date]) = CONVERT(date, GETDATE())) and ItemID = {item.Item.Id}"), out sum); if (sum + item.Quantity > item.Item.MaxQuantityPerDay) { MyMessageBox.Show($"تم تسليم {sum} من المادة \"{item.Item.Name}\" اليوم\nأعلى كمية ممكن تلسيها من هذه المادة في اليوم هو {item.Item.MaxQuantityPerDay }"); return(false); } } } } double currentQuantity = 0; double previousQuantity = 0; foreach (var item in lst) { if (o.Id.HasValue) { double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={item.Item.Id} and OrderID = {o.Id}"), out previousQuantity); } else { previousQuantity = 0; } double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {o.InventoryID} and ItemID = {item.Item.Id}"), out currentQuantity); if (o.Type == 1) { if (item.Item.MaximumQuantity.HasValue && item.Item.MaximumQuantity < currentQuantity - previousQuantity + item.Quantity) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الممكن ادخاله الى المستودع هو {item.Item.MaximumQuantity}\nلا يمكن الاضافة"); return(false); } } else { if (currentQuantity + previousQuantity == 0 || item.Quantity > currentQuantity + previousQuantity) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nلا يمكن الاضافة"); return(false); } if (item.Item.MinimumQuantity.HasValue && item.Item.MinimumQuantity > currentQuantity + previousQuantity - item.Quantity) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {item.Item.MinimumQuantity}\nلا يمكن الاضافة"); return(false); } else if (item.Item.WarningQuantity.HasValue && item.Item.WarningQuantity > currentQuantity + previousQuantity - item.Quantity) { if (!BaseDataBase.CurrentUser.IsAdmin) { MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما حد التنبيه للمادة هو {item.Item.WarningQuantity}\nلا يمكن الاضافة"); return(false); } else { if (MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما حد التنبيه للمادة هو {item.Item.WarningQuantity}\nهل تريد الاضافة بجميع الاحوال؟", MessageBoxButton.YesNo) != MessageBoxResult.Yes) { return(false); } } } } } return(true); }