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;
}
