public void ShowDate() { using (var db = new RfidContext()) { List <M_Calendar> RangeDate = null; if (_calendarTypeSetting == CalendarType.Holideys) { RangeDate = (from d in db.C_Calendar where (d.TypeDate == _calendarTypeSetting) select d).ToList(); } else if (_selectedUser != null) { RangeDate = (from d in db.C_Calendar where (d.P_Users.ID == _selectedId && d.TypeDate == _calendarTypeSetting) select d).ToList(); } else { MessageBox.Show((string)Application.Current.Resources["msb_selectUserOrHolidey"], "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } GetAll(RangeDate, C_ShowDate); } }
private void Button_FindUser(object sender, RoutedEventArgs e) { Singelton.EmailSetting.SmtpClient = TB_SmtpClient.Text; Singelton.EmailSetting.MailFrom = TB_MailFrom.Text; Singelton.EmailSetting.Password = StringCipher.Encrypt(TB_Password.Password, "f6v?jkfk+8#62&D=w7UW8pkfRLdxzEaKE=LH6N?q"); Singelton.EmailSetting.Subject = TB_Subject.Text; Singelton.EmailSetting.Body = TB_Body.Text; using (var db = new RfidContext()) { var remove = db.C_EmailSetting.FirstOrDefault(); db.C_EmailSetting.Remove(remove); db.SaveChanges(); db.C_Setting.SingleOrDefault().ExportInBdSetting(); db.SaveChanges(); } if (Singelton.Frame.CanGoBack) { Singelton.Frame.GoBack(); } }
private void Button_FindUser(object sender, RoutedEventArgs e) { using (var rfid = new RfidContext()) { var find = new UserFinderHelper() { FirstName = TB_User_FirstName.Text, SecondName = TB_User_SecondName.Text, ThirdName = TB_User_ThirdName.Text, PhoneNumber = TB_User_PhoneNumber.Text, DepartmentName = TB_User_DepartmentName.Text, DepartmentDirector = TB_User_DepartmentDirector.Text, Address = TB_User_Address.Text, Context = rfid }; if (!find.TryFind()) { NotFoundMessage.Visibility = Visibility.Visible; return; } var p = new FindResultPage(find); Singelton.Frame.Navigate(p); } }
private void SelectFile_Click(object sender, RoutedEventArgs e) { try { if (FileList.SelectedItem == null) { MessageBox.Show((string)Application.Current.Resources["msb_fileNotSekected"], "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (TB_Email.Text == string.Empty) { MessageBox.Show((string)Application.Current.Resources["msb_emailNotEntered"], "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } RfidContext db = new RfidContext(); string path = Singelton.ExcelSetting.Path + System.IO.Path.DirectorySeparatorChar + FileList.SelectedItem.ToString(); Singelton.EmailSetting.PathAttachmentFile = path; SendEmailHalper.SendEmailTo(TB_Email.Text); SVGenerationExcel.Visibility = Visibility.Visible; AllExcelFiles.Visibility = Visibility.Collapsed; } catch (FormatException) { MessageBox.Show((string)Application.Current.Resources["msb_emailUnknownError"], "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
public void Ticker_Tick(object sender, EventArgs e) { _context = new RfidContext(); foreach (var user in _context.C_Users) { if (user.isInside) { if (user.P_UserTime.Count != 0) { user.P_UserTime.Last().TimeOut = DateTime.Now; TimeSpan?lengthOfInside = user.P_UserTime.Last().TimeOut - user.P_UserTime.Last().TimeIn; if (lengthOfInside > Singelton.WatcherSetting.MaxTimeInside) { lengthOfInside = Singelton.WatcherSetting.MaxTimeInside; user.P_UserTime.Last().TimeOut = user.P_UserTime.Last().TimeIn + MaxTimeInside; DateTime?dtInsige = DateTime.Today.Add(lengthOfInside.Value); user.P_UserTime.Last().LengthOfInside = dtInsige; user.isInside = false; _context.SaveChanges(); } else { } } } } _context.Dispose(); }
public ReportPage() { InitializeComponent(); var db = new RfidContext(); GridBasicInformation.EnableColumnVirtualization = true; GridBasicInformation.Items.Clear(); GridBasicInformation.CanUserAddRows = false; GridBasicInformation.ItemsSource = db. Database. SqlQuery <BasicInformation>((new SqlBasicInformation()).SQl_BasicInformation). ToList(); GridBasicInformation.EnableColumnVirtualization = true; GridBasicInformation.Items.Refresh(); var queryAllDepartamentsNames = from cust in db.C_Departments where cust.ID != 1 select new { cust.Name }; var listDepInfo = new List <DepartamentsData>(); foreach (var depName in queryAllDepartamentsNames.ToList()) { var temp = getDepartamentClientData(depName.Name); listDepInfo.Add(temp); } GridMonthlyReport.ItemsSource = new List <TimeTableItem>(); GridDepartamentReport.ItemsSource = listDepInfo; GridDepartamentReport.Items.Refresh(); SelectedDepartamentReport_MouseLeftButtonUp(null, null); SelectedMonthlyReport_MouseLeftButtonUp(null, null); SelectedBasicInformation_MouseLeftButtonUp(null, null); }
private string WeekMonthYearInside(DateTime dateFrom, DateTime dateTo) { RfidContext db = new RfidContext(); try { var queryAllDepartaments = from cust in db.C_UserTime where cust.P_Users.ID == Id && cust.SingleDate > dateFrom && cust.SingleDate < dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; queryAllDepartaments.ToList(); var queryAllTime = from cust in db.C_Users where cust.P_Users.ID == Id select new { cust.P_InOutValidTimes.Start, cust.P_InOutValidTimes.And, cust.P_InOutValidTimes.Valid }; queryAllTime.Single(); // тут закынчив минулого разу double sumDate = 0; foreach (var temp in queryAllDepartaments) { sumDate += temp.LengthOfInside.Value.TimeOfDay.TotalMinutes; } return(sumDate.ToString()); } catch (Exception exp) { MessageBox.Show(exp.ToString()); return("Exception"); } }
private void GenerationExcelButton_Click(object sender, RoutedEventArgs e) { RfidContext db = new RfidContext(); string path; if (string.IsNullOrEmpty(Singelton.ExcelSetting.Path)) { MessageBox.Show(Application.Current.Resources["msb_floderNotSelected"].ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } else { path = Singelton.ExcelSetting.Path + System.IO.Path.DirectorySeparatorChar + DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss") + ".xlsx"; } List <TimeTableItem> TimeTable = null; List <UserTableItem> UserTable = UserTableItem.GenerateList(_gridBasicInformation); if (_gridBasicInformation.SelectedIndex != -1) { TimeTable = TimeTableItem.GenerateList(_gridMonthlyReport); } List <DepartmentTableItem> DepartmentTable = DepartmentTableItem.GenerateList(_gridDepartamentReport); CreateExcelFileHelper.CreateExcelDocument(UserTable, TimeTable, DepartmentTable, path); }
void run(int Id) { RfidContext db = new RfidContext(); M_Users user = new M_Users(); user = db.C_Users.Where(z => z.ID == Id).Single(); List <M_Rfids> prfids = new List <M_Rfids>(); prfids = user.P_Rfids.ToList(); var rfideCode = prfids.Where(x => x.IsArhive == false).Single(); RFIDCodeTags.Content = rfideCode.RfidID.ToString(); var queryAllCustomers = from cust in db.C_Rfids where cust.IsArhive == true && cust.P_Users.ID == Id select new { cust.Date, cust.RfidID, cust.Comment }; List <M_Rfids> queryAllCustomers1 = db.C_Rfids.Where(x => x.IsArhive == true && x.P_Users.ID == Id).ToList(); var ListQueryAllCustomers = queryAllCustomers.ToList(); LAadded.Content = user.P_Rfids.ToList()[0].Date.ToShortDateString(); GridRegistryChangesRFIDtags.ItemsSource = queryAllCustomers.ToList(); dynamic sdsdd = GridRegistryChangesRFIDtags.Items.CurrentItem; dynamic sdsdd1 = GridRegistryChangesRFIDtags.Items; if (GridRegistryChangesRFIDtags.Columns.Count > 0) { this.GridRegistryChangesRFIDtags.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy"; } GridRegistryChangesRFIDtags.Items.Refresh(); }
private string WeekMonthYearOutside(DateTime dateFrom, DateTime dateTo) { RfidContext db = new RfidContext(); try { var queryAllDepartaments = from cust in db.C_UserTime where cust.P_Users.ID == Id && cust.SingleDate > dateFrom && cust.SingleDate < dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; queryAllDepartaments.ToList(); double sumDate = 0; foreach (var temp in queryAllDepartaments) { if (temp.LengthOfOutside != null) { sumDate += temp.LengthOfOutside.Value.TimeOfDay.TotalMinutes; } } return(sumDate.ToString()); } catch (Exception exp) { MessageBox.Show(exp.ToString()); return("Exception"); } }
public AboutUserPage(int id) { InitializeComponent(); _db = new RfidContext(); _id = id; CurrentUser = new M_Users(); CurrentUser = _db.C_Users.Single(z => z.ID == id); IsInside = CurrentUser.isInside; _aboutHelper.Run(id, _db, CurrentUser, AboutUserGrid); }
public void Initialize(DataGrid gridBasicInformation, UserFinderHelper find) { Func <ICollection <M_Phones>, string> genListPhones = cust => { var str = string.Empty; foreach (var phone in cust) { str += phone.PhoneNumber + ", "; } if (str != string.Empty) { str = str.Substring(0, str.Length - 2); } return(str); }; using (var context = new RfidContext()) { find.Context = context; var searchResult = (from cust in find.Find() select new { cust.ID, cust.P_Names.FirstOrDefault().NameFirst, cust.P_Names.FirstOrDefault().NameLast, cust.P_Names.FirstOrDefault().NameThird, cust.P_Departments.Name, cust.P_InOutValidTimes.Start, cust.P_InOutValidTimes.End, cust.P_InOutValidTimes.Valid, cust.P_InOutValidTimes.Dinner, cust.P_Phones }).ToList(); GenereteColumns(gridBasicInformation); foreach (var item in searchResult) { var tableItem = new TableItem { Id = item.ID, FirstName = item.NameFirst, LastName = item.NameLast, ThirdName = item.NameThird, Departament = item.Name, Start = item.Start, End = item.End, Dinner = (DateTime)item.Dinner, Valid = item.Valid, Phone = genListPhones(item.P_Phones) }; gridBasicInformation.Items.Add(tableItem); } } }
private void ClickUlinkRFID(object sender, RoutedEventArgs e) { RfidContext db = new RfidContext(); var temp = db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false); db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false).Single().IsArhive = true; db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false).Single().Comment = "louse"; RFIDCodeTags.Content = ""; db.SaveChanges(); }
public void Snap(int id, string rfidNum) { try { var db = new RfidContext(); var temp = db.C_Rfids.Where(z => z.P_Users.ID == id).Where(x => x.IsArhive == false); M_Users user; if (temp.Count() != 0) { foreach (var rfid in db.C_Rfids.Where(z => z.P_Users.ID == id).Where(x => x.IsArhive == false)) { rfid.IsArhive = true; } var addRfid = new M_Rfids { RfidID = Convert.ToInt64(rfidNum), IsArhive = false, Date = DateTime.Now }; user = db.C_Users.Single(z => z.ID == id); addRfid.P_Users = user; user.P_Rfids.Add(addRfid); } else { foreach (var rfid in db.C_Rfids.Where(z => z.P_Users.ID == id).Where(x => x.IsArhive == false)) { rfid.IsArhive = true; } var addRfid = new M_Rfids { RfidID = Convert.ToInt64(rfidNum), IsArhive = false, Date = DateTime.Now }; user = db.C_Users.Single(z => z.ID == id); addRfid.P_Users = user; user.P_Rfids.Add(addRfid); } db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SnapRFIDTag(object sender, RoutedEventArgs e) { try { RfidContext db = new RfidContext(); var temp = db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false); WindowSnapRFID snapRfid = new WindowSnapRFID(); snapRfid.ShowDialog(); if (temp.Count() != 0) { foreach (var rfid in db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false)) { rfid.IsArhive = true; } M_Rfids addRfid = new M_Rfids(); addRfid.RfidID = Convert.ToInt64(snapRfid.TSnapRFID.Text); addRfid.IsArhive = false; db.C_Users.Where(z => z.ID == ID).Single().P_Rfids.Add(addRfid); } else { foreach (var rfid in db.C_Rfids.Where(z => z.P_Users.ID == ID).Where(x => x.IsArhive == false)) { rfid.IsArhive = true; } M_Rfids addRfid = new M_Rfids(); addRfid.RfidID = Convert.ToInt64(snapRfid.TSnapRFID.Text); addRfid.IsArhive = false; addRfid.Date = DateTime.Now; db.C_Users.Where(z => z.ID == ID).Single().P_Rfids.Add(addRfid); } RFIDCodeTags.Content = snapRfid.TSnapRFID.Text; db.SaveChanges(); } catch { // throw; } }
private void GridBasicInformation_SelectionChanged(object sender, SelectionChangedEventArgs e) { dynamic s = GridBasicInformation.CurrentCell.Item; SelectedId = s.ID; RfidContext db = new RfidContext(); var queryAllCustomers = from cust in db.C_UserTime where cust.P_Users.ID == SelectedId select new { cust.ID, cust.SingleDate, cust.Day, cust.TimeIn, cust.TimeOut, cust.LengthOfInside, cust.LengthOfOutside }; GridMonthlyReport.ItemsSource = queryAllCustomers.ToList(); //this.GridBasicInformation.Columns[5].ClipboardContentBinding.StringFormat = "HH:mm"; //this.GridBasicInformation.Columns[6].ClipboardContentBinding.StringFormat = "HH:mm"; //this.GridBasicInformation.Columns[7].ClipboardContentBinding.StringFormat = "HH:mm"; this.GridMonthlyReport.Columns[3].ClipboardContentBinding.StringFormat = "HH:mm"; this.GridMonthlyReport.Columns[4].ClipboardContentBinding.StringFormat = "HH:mm"; this.GridMonthlyReport.Columns[5].ClipboardContentBinding.StringFormat = "HH:mm"; this.GridMonthlyReport.Columns[6].ClipboardContentBinding.StringFormat = "HH:mm"; GridMonthlyReport.Items.Refresh(); var applicationPath = Directory.GetCurrentDirectory(); // get your 'Uploaded' folder var dir = new DirectoryInfo(System.IO.Path.Combine(applicationPath, "Photos")); var queryPhoto = from cust in db.C_Users where cust.ID == SelectedId select new { cust.Photo }; var z = queryPhoto.ToList(); string str = dir.FullName + "/" + z[0].Photo; imageReport.Source = new BitmapImage(new Uri(str)); }
private void Button_Click(object sender, RoutedEventArgs e) { Singelton.WatcherSetting.MaxTimeInside = (TimeSpan)LimitPicker.SelectedTime; Singelton.WatcherSetting.Interval = (TimeSpan)IntervalPicker.SelectedTime; using (var db = new RfidContext()) { db.C_Setting.SingleOrDefault().ExportInBdSetting(); db.SaveChanges(); } if (Singelton.Frame.CanGoBack) { Singelton.Frame.GoBack(); } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { Singelton.LanguageSetting.SelectedLanguage = CB_ChangeLanguage.SelectedIndex; using (var db = new RfidContext()) { db.C_Setting.SingleOrDefault().ExportInBdSetting(); db.SaveChanges(); } if (Singelton.Frame.CanGoBack) { Singelton.Frame.GoBack(); } }
public FP() { InitializeComponent(); RfidContext db = new RfidContext(); var queryAllCustomers = from cust in db.C_Names where cust.P_Users.IsUser == true select new { cust.P_Users.ID, cust.NameFirst, cust.NameLast, cust.NameThird, cust.P_Users.P_Departments.Name, cust.P_Users.P_InOutValidTimes.Start, cust.P_Users.P_InOutValidTimes.And, cust.P_Users.P_InOutValidTimes.Valid }; GridBasicInformation.EnableColumnVirtualization = true; GridBasicInformation.ItemsSource = queryAllCustomers.ToList(); GridBasicInformation.EnableColumnVirtualization = true; GridBasicInformation.Items.Refresh(); var a = GridBasicInformation.CommandBindings; //this.GridMonthlyReport.Columns[3].ClipboardContentBinding.StringFormat = "HH:mm"; var queryAllDepartamentsNames = from cust in db.C_Departments select new { cust.Name } ; List <DepartamentsData> listDepInfo = new List <DepartamentsData>(); foreach (var depName in queryAllDepartamentsNames.ToList()) { DepartamentsData temp = getDepartamentClientData(depName.Name); listDepInfo.Add(temp); } GridDepartamentReport.ItemsSource = listDepInfo; this.GridDepartamentReport.Items.Refresh(); var d = GridDepartamentReport.Columns; //GridDepartamentReport.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy"; }
private void buttonGetData_Click(object sender, RoutedEventArgs e) { var db = new RfidContext(); try { _dateHelper.GetData(CalendarFrom, CalendarTo, _id, db, labelSelectedTimeInside, labelSelectedTimeOutside); } catch (Exception) { MessageBox.Show((string)Application.Current.Resources[StringsMapper.ErrorNoDateSel], (string)Application.Current.Resources[StringsMapper.ErrorHeader], MessageBoxButton.OK, MessageBoxImage.Error); } }
private void run(int Id) { var db = new RfidContext(); var user = new M_Users(); user = db.C_Users.Single(z => z.ID == Id); var prfids = new List <M_Rfids>(); prfids = user.P_Rfids.ToList(); var rfideCode = prfids.LastOrDefault(x => x.IsArhive == false); if (prfids.LastOrDefault(x => x.IsArhive == false) != null) { RFIDCodeTags.Text = rfideCode.RfidID.ToString(); } else { RFIDCodeTags.Text = ""; } var queryAllCustomers = from cust in db.C_Rfids where cust.IsArhive && cust.P_Users.ID == Id select new { cust.Date, cust.RfidID, cust.Comment }; LAadded.Text = user.P_Rfids.ToList()[0].Date.ToShortDateString(); if (queryAllCustomers.Any()) { GridRegistryChangesRFIDtags.ItemsSource = queryAllCustomers.ToList(); } if (GridRegistryChangesRFIDtags.Columns.Count > 0) { GridRegistryChangesRFIDtags.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy"; } GridRegistryChangesRFIDtags.Items.Refresh(); if (GridRegistryChangesRFIDtags.Columns.Count != 0) { GridRegistryChangesRFIDtags.Columns[0].Header = Singelton.LanguageSetting.GetString(StringsMapper.AddingDate); GridRegistryChangesRFIDtags.Columns[1].Header = Singelton.LanguageSetting.GetString(StringsMapper.RfidNum); GridRegistryChangesRFIDtags.Columns[2].Header = Singelton.LanguageSetting.GetString(StringsMapper.Comment); } }
private DepartamentsData getDepartamentClientData(string name) { var db = new RfidContext(); var queryAllDepartaments = from cust in db.C_Names where cust.P_Users.P_Departments.Name.Equals(name) select new { cust.P_Users.IsUser, cust.P_Users.isInside }; var t1 = queryAllDepartaments.Count(); var t2 = queryAllDepartaments.Count(x => x.isInside); var t3 = queryAllDepartaments.Count(x => x.isInside == false); var date = DateTime.Now; var departParam = new DepartamentsData(date.ToString("dd.MM.yyyy"), name, t1, t2, t3); return(departParam); }
private void Btn_AddInterval_Click(object sender, RoutedEventArgs e) { if (DP_StarDate.SelectedDate > DP_EndDate.SelectedDate) { MessageBox.Show((string)Application.Current.Resources["msb_startIsBeggerEnd"], "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } var date = new M_Calendar(); try { date.Start = (DateTime)DP_StarDate.SelectedDate; date.End = (DateTime)DP_EndDate.SelectedDate; date.TypeDate = _calendarTypeSetting; } catch (FormatException) { MessageBox.Show((string)Application.Current.Resources["msb_slectDate"], "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation); } using (var db = new RfidContext()) { if (_selectedId != null) { var user = from d in db.C_Users where d.ID == _selectedId select d; user.Single().P_Calendar.Add(date);; db.SaveChanges(); } else if (_calendarTypeSetting == CalendarType.Holideys) { db.C_Calendar.Add(date); db.SaveChanges(); return; } else { MessageBox.Show((string)Application.Current.Resources["msb_startIsBeggerEnd"]); return; } ShowDate(); } }
public void GetData(Calendar calendarFrom, Calendar calendarTo, int?id, RfidContext db, Label timeInsideLb, Label timeOutsideLb) { var dateFrom = calendarFrom.SelectedDate.Value; var dateTo = calendarTo.SelectedDate.Value; IQueryable <dynamic> queryAllDepartaments; if (id == null) { queryAllDepartaments = from cust in db.C_UserTime where cust.SingleDate >= dateFrom && cust.SingleDate <= dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; } else { queryAllDepartaments = from cust in db.C_UserTime where cust.P_Users.ID == id && cust.SingleDate >= dateFrom && cust.SingleDate <= dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; } var sumDateInside = DateTime.MinValue; var sumDateOutside = DateTime.MinValue; foreach (var temp in queryAllDepartaments) { if (temp.LengthOfInside != null) { sumDateInside = sumDateInside.Add(((DateTime?)temp.LengthOfInside).Value.TimeOfDay); } if (temp.LengthOfOutside != null) { sumDateOutside = sumDateOutside.Add(((DateTime?)temp.LengthOfOutside).Value.TimeOfDay); } } var timeInside = new TimeSpan(sumDateInside.Ticks); var timeOutside = new TimeSpan(sumDateOutside.Ticks); timeInsideLb.Content = Application.Current.Resources[StringsMapper.TimePeriod] + $" {Math.Truncate(timeInside.TotalHours):####}h {timeInside.Minutes}m"; timeOutsideLb.Content = Application.Current.Resources[StringsMapper.TimePeriod] + $" {Math.Truncate(timeOutside.TotalHours):####}h {timeOutside.Minutes}m"; }
private void buttonGetData_Click(object sender, RoutedEventArgs e) { RfidContext db = new RfidContext(); try { DateTime dateFrom = CalendarFrom.SelectedDate.Value; DateTime dateTo = CalendarTo.SelectedDate.Value; var queryAllDepartaments = from cust in db.C_UserTime where cust.P_Users.ID == Id && cust.SingleDate > dateFrom && cust.SingleDate < dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; queryAllDepartaments.ToList(); double sumDateInside = 0; double sumDateOutside = 0; foreach (var temp in queryAllDepartaments) { if (temp.LengthOfInside != null) { sumDateInside += temp.LengthOfInside.Value.TimeOfDay.TotalMinutes; } if (temp.LengthOfOutside != null) { sumDateOutside += temp.LengthOfOutside.Value.TimeOfDay.TotalMinutes; } } labelSelectedTimeInside.Content = "Time by selected date : " + sumDateInside.ToString(); labelSelectedTimeOutside.Content = "Time by selected date : " + sumDateOutside.ToString(); } catch { MessageBox.Show(" Please select date "); } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (PathToExcelFile != string.Empty) { Singelton.ExcelSetting.Path = PathToExcelFile; using (var db = new RfidContext()) { db.C_Setting.SingleOrDefault().ExportInBdSetting(); db.SaveChanges(); } if (Singelton.Frame.CanGoBack) { Singelton.Frame.GoBack(); } } else { MessageBox.Show((string)Application.Current.Resources["msb_floderNotSelected"], "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void ClickUlinkRFID(object sender, RoutedEventArgs e) { var db = new RfidContext(); var usedRfid = db.C_Rfids.Where(z => z.P_Users.ID == ID).SingleOrDefault(x => x.IsArhive == false); if (usedRfid != null) { usedRfid.IsArhive = true; usedRfid.Comment = Application.Current.Resources[StringsMapper.Lost].ToString(); db.SaveChanges(); } else { MessageBox.Show(Application.Current.Resources[StringsMapper.AllRfidArchive].ToString(), Application.Current.Resources[StringsMapper.ErrorHeader].ToString(), MessageBoxButton.OK, MessageBoxImage.Error); } RFIDCodeTags.Text = ""; }
public string WeekMonthYearInside(DateTime dateFrom, DateTime dateTo, int?id) { var db = new RfidContext(); try { IQueryable <dynamic> queryAllDepartaments; if (id == null) { queryAllDepartaments = from cust in db.C_UserTime where cust.SingleDate >= dateFrom && cust.SingleDate < dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; } else { queryAllDepartaments = from cust in db.C_UserTime where cust.P_Users.ID == id && cust.SingleDate >= dateFrom && cust.SingleDate < dateTo select new { cust.SingleDate, cust.LengthOfInside, cust.LengthOfOutside }; } var sumDate = DateTime.MinValue; foreach (var temp in queryAllDepartaments) { if (temp.LengthOfInside != null) { sumDate = sumDate.Add(((DateTime?)temp.LengthOfInside).Value.TimeOfDay); } } var timeRes = new TimeSpan(sumDate.Ticks); return($" {Math.Truncate(timeRes.TotalHours):####}h {timeRes.Minutes}m"); } catch (Exception exp) { MessageBox.Show(exp.ToString()); } return(string.Empty); }
public M_Users GetUserInfo(int selectedId, TextBlock nameUser, ImageBrush imageReport) { var db = new RfidContext(); var selectedUser = (from d in db.C_Users where d.ID == selectedId select d).Single(); var dir = new DirectoryInfo(Singelton.PathToPhoto); var queryPhoto = from cust in db.C_Users where cust.ID == selectedId select new { cust.Photo }; var names = db.Database.SqlQuery <M_Names>(new SqlGetUserName() .SQl_GetUserFirstName, selectedId).SingleOrDefault(); var firstName = names.NameFirst; var lastName = names.NameLast; var z = queryPhoto.ToList(); nameUser.Text = firstName + " " + lastName; var str = dir.FullName + Path.AltDirectorySeparatorChar + z[0].Photo; try { var nameImage = z[0].Photo; var words = nameImage.Split('_'); var indexdot = words[2].IndexOf('.'); nameUser.Text = words[1] + " " + words[2].Remove(indexdot); imageReport.ImageSource = ImageLoaderHelper.GetImageFromFolder(str); } catch (Exception ex) { MessageBox.Show((string)Application.Current.Resources[StringsMapper.ErrorUserPhoto] + ex); } db.Dispose(); return(selectedUser); }
private void BOK_Click(object sender, RoutedEventArgs e) { try { RfidNumber = TBGetRfidId.Text; var db = new RfidContext(); var s = Convert.ToInt64(RfidNumber); var user = db.Database.SqlQuery <M_Users>(new SqlSearchUserForRfid().SQl_SearchUserForRfid, s).SingleOrDefault(); var dsd = db.C_Users.Single(z => z.ID == user.ID); AuthorithationUser = dsd; _rfidHelper.WriteById(dsd); db.SaveChanges(); var p = new AboutUserPage(AuthorithationUser.ID); Singelton.Frame.NavigationService.Navigate(p); } catch { MessageBox.Show((string)Application.Current.Resources[StringsMapper.ErrorEnterRfid], (string)Application.Current.Resources[StringsMapper.ErrorHeader], MessageBoxButton.OK, MessageBoxImage.Exclamation); } }