private async void dg_RowDetailsVisibilityChanged(object sender, DataGridRowDetailsEventArgs e) { if (e.Row.DetailsVisibility == Visibility.Visible) { DataGrid innerDataGrid = e.DetailsElement.FindName("dg2") as DataGrid; DataTable dt = await BaseDataBase._TablingStoredProcedureAsync("GetInventoryItemStaDetailsAll", new SqlParameter("@ItemID", (e.Row.Item as DataRowView)["ItemID"]), new SqlParameter("@date1", date1.SelectedDate ?? new DateTime(2000, 1, 1)), new SqlParameter("@date2", date2.SelectedDate ?? new DateTime(2050, 1, 1))); innerDataGrid.ItemsSource = dt.DefaultView; } }
private async void TabControl_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (tcMain.SelectedIndex == 0) { grdBottom.Visibility = System.Windows.Visibility.Collapsed; } if (tcMain.SelectedIndex > 0) { grdBottom.Visibility = System.Windows.Visibility.Visible; var control = tcMain.SelectedItem as TabItem; var DGMain = (control.Content as FrameworkElement).FindName("dgMain") as DataGrid; grdBottom.DataContext = DGMain; if (DGMain.ItemsSource == null) { switch (tcMain.SelectedIndex) { case 1: DGMain.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("GetStatistictsFamily")).DefaultView; ucFamily.GetData(); break; case 2: //DGMain.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("GetStatistictsItems")).DefaultView; break; case 3: DGMain.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("GetStatistictsFamilyPerson")).DefaultView; ucFamilyPerson.GetData(); break; case 4: DGMain.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("GetStatisticsFamilyNeed")).DefaultView; ucFamilyNeed.GetData(); break; case 5: DGMain.ItemsSource = (await BaseDataBase._TablingAsync(@" select FirstName + ' ' + LastName ListerName,FamilyCode,FamilyName,FamilyType,ApplyDate,FamilyPersonCount,IsCanceled,x.*,Family.Evaluation FamilyEvaluation from (select a.*, FamilyID,OrphanID,Date,ListerGroup.Notes ListerGroupNotes,Evaluation,CreatePerson,CreateDate,LastModifiedPerson FROM ListerGroup inner join (select Lister.*,GroupID from Lister_ListerGroup inner join Lister ON Lister_ListerGroup.ListerID = Lister.ListerID) a on ListerGroup.GroupID = a.GroupID) x Left outer join Family on x.FamilyID = Family.FamilyID")).DefaultView; break; default: break; } } } }
private async void btnRefresh_Click(object sender, RoutedEventArgs e) { Storyboard sb = (App.Current.Resources["sbRotateButton"] as Storyboard).Clone(); sb.SetValue(Storyboard.TargetProperty, sender); sb.Begin(); DataTable dt = await BaseDataBase._TablingStoredProcedureAsync("GetStatistictsInventoryItemsAll" , new SqlParameter("@date1", date1.SelectedDate ?? new DateTime(2000, 1, 1)) , new SqlParameter("@date2", date2.SelectedDate ?? new DateTime(2050, 1, 1))); sb.Pause(); dg.ItemsSource = dt.DefaultView; cmbo_SelectionChanged(null, null); }
private async void btnSearch2_Click(object sender, RoutedEventArgs e) { if (!isWorking2) { isWorking2 = true; Storyboard sb = (App.Current.Resources["sbRotateButton"] as Storyboard).Clone(); sb.SetValue(Storyboard.TargetProperty, sender); sb.Begin(); var dt = await BaseDataBase._TablingStoredProcedureAsync("sp_GetOrphanFamilyAllTable"); dgFamily.ItemsSource = dt.DefaultView; sb.Pause(); Control1_Changed(null, null); isWorking2 = false; } }
async void GetData() { DataTable dt = await BaseDataBase._TablingStoredProcedureAsync("GetStatisticsItemsCount", new SqlParameter("@Date1", BaseDataBase.DateNow.ToString("MM-dd-yyyy 00:00")), new SqlParameter("@Date2", BaseDataBase.DateNow.ToString("MM-dd-yyyy 23:59"))); //DataTable dt2 = await BaseDataBase._TablingAsync(@"select * from // (select 'العوائل الكلية' Name, COUNT(*) Number,1 ID from Family // Union // select 'العوائل الغير ملغاة', COUNT(*), 2 from Family where IsCanceled <> 1 // Union // select 'العوائل الملغاة', COUNT(*), 3 from Family where IsCanceled = 1 // ) a // order by ID"); DataTable dt2 = await BaseDataBase._TablingAsync(@" select Name, Number from Sector inner join (select SectorID,COUNT(*) Number from Family group by SectorID) g on g.SectorID = Sector.ID and IsActive = 1 order by Number DESC"); grdStaMain.DataContext = new StatisticsClass(dt); grdStaFamily.DataContext = new StatisticsClass(dt2); }
//static public async static Task <int> GetUnReadedMessages() { int num = 0; var dt = await BaseDataBase._TablingStoredProcedureAsync("GetUnReadedMessages", new SqlParameter("@RecieverID", BaseDataBase.CurrentUser.ID)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { var u = AllUsers.Where(x => x.ID == (int)item.ItemArray[0]).FirstOrDefault(); if (u != null) { u.UnreadedMessages = (int)item.ItemArray[1]; u.NotifyPropertyChanged("UnreadedMessages"); u.NotifyPropertyChanged("ShowNotification"); } } num = AllUsers.Sum(x => x.UnreadedMessages); } return(num); }
public async void CheckMessages() { var dt = await BaseDataBase._TablingStoredProcedureAsync("CheckMessages", new SqlParameter("@BaseUserID", BaseDataBase.CurrentUser.ID), new SqlParameter("@SubUserID", ID)); if (dt != null && dt.Rows.Count > 0 && (int)dt.Rows[0].ItemArray[0] != 0) { foreach (var item in Messages.Where(x => !x.IsReaded && x.MessageID <= (int)dt.Rows[0].ItemArray[0])) { item.IsReaded = true; item.NotifyPropertyChanged("IsReaded"); } } if (dt != null && dt.Rows.Count > 0 && (int)dt.Rows[0].ItemArray[1] != 0) { foreach (var item in Messages.Where(x => !x.IsReceived && x.MessageID <= (int)dt.Rows[0].ItemArray[1])) { item.IsReceived = true; item.NotifyPropertyChanged("IsReceived"); } } }
private async void btnSearch_Click(object sender, RoutedEventArgs e) { if (!isWorking) { if (cmboInventory.SelectedItem == null) { MyMessageBox.Show("يجب اختيار المستودع"); return; } isWorking = true; Storyboard sb = (App.Current.Resources["sbRotateButton"] as Storyboard).Clone(); sb.SetValue(Storyboard.TargetProperty, sender); sb.Begin(); dt = await BaseDataBase._TablingStoredProcedureAsync("sp_GetFamilyAllTable", new SqlParameter("@InventoryID", (cmboInventory.SelectedItem as Inventory).ID)); await Task.Run(() => dt2 = dt.Copy()); sb.Pause(); SetItemsSource(1); Control_Changed(null, null); isWorking = false; } }
private async void btnSearch_Click(object sender, RoutedEventArgs e) { if (!isWorking) { if (dtpPresentDateSupport1.SelectedDate.HasValue && dtpPresentDateSupport2.SelectedDate.HasValue) { isWorking = true; Storyboard sb = (App.Current.Resources["sbRotateButton"] as Storyboard).Clone(); sb.SetValue(Storyboard.TargetProperty, sender); sb.Begin(); dgMain.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("GetStatistictsItems", new System.Data.SqlClient.SqlParameter("@StartDate", dtpPresentDateSupport1.SelectedDate), new System.Data.SqlClient.SqlParameter("@EndDate", dtpPresentDateSupport2.SelectedDate))).DefaultView; GetData(); Changing(); sb.Pause(); isWorking = false; } else { MyMessageBox.Show("يجب اختيار مجال التاريخ"); } } }
public static async Task <DataTable> GetAllOrderTable() { return(await BaseDataBase._TablingStoredProcedureAsync("sp_Get_All_Order_Table")); }
//public async static Task<List<Item>> GetAllFormedBasket(int InventoryID) //{ // List<Item> xx = new List<Item>(); // await Task.Run(() => // { // SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); // SqlCommand com = new SqlCommand("sp_Get_All_FormedBasket", con); // com.CommandType = System.Data.CommandType.StoredProcedure; // com.Parameters.Add(new SqlParameter("@InventoryID", InventoryID)); // try // { // con.Open(); // SqlDataReader rd = com.ExecuteReader(); // while (rd.Read()) // { // Item x = new Item(); // if (!(rd["Id"] is DBNull)) // x.Id = int.Parse(rd["Id"].ToString()); // x.Name = rd["Name"].ToString(); // if (!(rd["IsActive"] is DBNull)) // x.IsActive = bool.Parse(rd["IsActive"].ToString()); // if (!(rd["IsBasket"] is DBNull)) // x.IsBasket = bool.Parse(rd["IsBasket"].ToString()); // x.Source = rd["Source"].ToString(); // x.Barcode = rd["Barcode"].ToString(); // x.ItemType = rd["ItemType"].ToString(); // x.Description = rd["Description"].ToString(); // x.StandardUnit = rd["StandardUnit"].ToString(); // x.Unit2 = rd["Unit2"].ToString(); // if (!(rd["Unit2Convert"] is DBNull)) // x.Unit2Convert = double.Parse(rd["Unit2Convert"].ToString()); // x.Unit3 = rd["Unit3"].ToString(); // if (!(rd["Unit3Convert"] is DBNull)) // x.Unit3Convert = double.Parse(rd["Unit3Convert"].ToString()); // if (!(rd["MinimumQuantity"] is DBNull)) // x.MinimumQuantity = double.Parse(rd["MinimumQuantity"].ToString()); // if (!(rd["MaximumQuantity"] is DBNull)) // x.MaximumQuantity = double.Parse(rd["MaximumQuantity"].ToString()); // if (!(rd["MaxQuantityPerOrder"] is DBNull)) // x.MaxQuantityPerOrder = double.Parse(rd["MaxQuantityPerOrder"].ToString()); // if (!(rd["MaxQuantityPerFamily"] is DBNull)) // x.MaxQuantityPerFamily = double.Parse(rd["MaxQuantityPerFamily"].ToString()); // if (!(rd["MaxQuantityPerDay"] is DBNull)) // x.MaxQuantityPerDay = double.Parse(rd["MaxQuantityPerDay"].ToString()); // if (!(rd["WarningQuantity"] is DBNull)) // x.WarningQuantity = double.Parse(rd["WarningQuantity"].ToString()); // if (!(rd["Weight"] is DBNull)) // x.Weight = double.Parse(rd["Weight"].ToString()); // if (!(rd["CurrentQuantity"] is DBNull)) // x.CurrentQuantity = double.Parse(rd["CurrentQuantity"].ToString()); // x.DefaultLocation = rd["DefaultLocation"].ToString(); // x.Notes = rd["Notes"].ToString(); // if (!(rd["LastUserID"] is DBNull)) // x.LastUserID = int.Parse(rd["LastUserID"].ToString()); // xx.Add(x); // } // rd.Close(); // } // catch // { // xx = null; // } // finally // { // con.Close(); // } // }); // return xx; //} public static async Task <DataTable> GetAllItemsTalbe() { return(await BaseDataBase._TablingStoredProcedureAsync("sp_Get_All_Item_Table")); }
private async void UserControl_Loaded(object sender, RoutedEventArgs e) { dgNotifications.ItemsSource = (await BaseDataBase._TablingStoredProcedureAsync("sp_Get_Notifications")).DefaultView; }