Beispiel #1
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string uid = (sender as Button).Uid;
            SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
            saveButton.Visibility = System.Windows.Visibility.Visible;

            if (dispathTimer != null) {
                dispathTimer.Stop();
                dispathTimer = null;
            }

            if (uid == "rowEdit") {
                pawnguardDb = new PawnGuardDBDataContext();
                toEditStone = pawnguardDb.Stones
                             .SingleOrDefault<Stone>(gld => gld.Id.ToString() == (sender as Button).Content.ToString());

                dgStones.SelectedItem = toEditStone;
                VisualStateManager.GoToElementState(this.LayoutRoot, "ShowState", true);
            }

            if (uid == "closePanel") {
                VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                FillGrid();
                page_Loaded(sender, e);
            }

            //if (uid == "save") {
            //    if (toEditGold == null) {

            //        if (!IsValid())
            //            return;

            //        pawnguardDb = new PawnGuardDBDataContext();
            //        bool exist = pawnguardDb.ItemCategories.AsEnumerable()
            //                     .Where(itm => itm.main.ToLower() == txtCategory.Text.ToLower() ||
            //                                   itm.option1.ToLower() == txtOption1.Text.ToLower() ||
            //                                   itm.option2.ToLower() == txtOption2.Text.ToLower())
            //                     .Any();

            //        if (exist) {
            //            categoryError.Visibility = System.Windows.Visibility.Visible;
            //            errorMsgCategory.Text = MSG_EXIST;
            //            return;
            //        }

            //        decimal price = 0;
            //        decimal.TryParse(txtPrice.Text, out price);
            //        pawnguardDb.ItemCategories.InsertOnSubmit(new ItemCategory() {
            //            parentId = AppData.parentId,
            //            code = txtCode.Text,
            //            main = txtCategory.Text,
            //            option1 = txtOption1.Text,
            //            option2 = txtOption2.Text,
            //            price = price,
            //            createdAt = DateTime.Now,
            //            updatedAt = DateTime.Now
            //        });
            //    } else {
            //        if (!IsValid())
            //            return;

            //        string editEmail = toEditGold.main;
            //        string editoption1 = toEditGold.option1;
            //        string editoption2 = toEditGold.option2;
            //        if (!editEmail.Equals(txtCategory.Text, StringComparison.InvariantCultureIgnoreCase) &&
            //            !editoption1.Equals(txtOption1.Text, StringComparison.InvariantCultureIgnoreCase) &&
            //            !editoption2.Equals(txtOption2.Text, StringComparison.InvariantCultureIgnoreCase)) {

            //            bool exist = pawnguardDb.ItemCategories.AsEnumerable()
            //                    .Where(itm => itm.main.ToLower() == txtCategory.Text.ToLower() ||
            //                                    itm.option1.ToLower() == txtOption1.Text.ToLower() ||
            //                                    itm.option2.ToLower() == txtOption2.Text.ToLower())
            //                    .Any();

            //            if (exist) {
            //                categoryError.Visibility = System.Windows.Visibility.Visible;
            //                errorMsgCategory.Text = MSG_EXIST;
            //                return;
            //            }
            //        }

            //        decimal price = 0;
            //        decimal.TryParse(txtPrice.Text, out price);
            //        toEditGold.parentId = AppData.parentId;
            //        toEditGold.code = txtCode.Text;
            //        toEditGold.main = txtCategory.Text;
            //        toEditGold.option1 = txtOption1.Text;
            //        toEditGold.option2 = txtOption2.Text;
            //        toEditGold.price = price;
            //        toEditGold.updatedAt = DateTime.Now;
            //    }

            //    try {
            //        pawnguardDb.SubmitChanges();
            //        saveButton.Visibility = System.Windows.Visibility.Collapsed;

            //        dispathTimer = new DispatcherTimer();
            //        dispathTimer.Interval = new TimeSpan(0, 0, 1);
            //        dispathTimer.Start();

            //        int time = 3;
            //        SuccessMessgage.Visibility = System.Windows.Visibility.Visible;
            //        dispathTimer.Tick += delegate(object s, EventArgs ea) {
            //            if (time >= 0)
            //                runTime.Text = time + " sec.";
            //            else {
            //                dispathTimer.Stop();
            //                SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
            //                VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
            //                runTime.Text = "3 sec.";

            //                FillGrid();
            //                page_Loaded(sender, e);
            //            }
            //            time--;
            //        };
            //    } catch (Exception) {
            //    }
            //}
        }
Beispiel #2
0
        private void ImportExcel(string path)
        {
            object rarity = null;
            object name = null;
            object carat = null;
            object price = null;
            object misValue = System.Reflection.Missing.Value;

            excelApp = new Excel.Application();
            Excel.Range range;
            worker = new BackgroundWorker();
            worker.WorkerSupportsCancellation = true;
            worker.WorkerReportsProgress = true;

            ProgStackPanel.Visibility = System.Windows.Visibility.Visible;
            ProgTextCancel.Visibility = System.Windows.Visibility.Collapsed;
            ProgressGrid.Visibility = System.Windows.Visibility.Visible;
            StoneListGrid.Visibility = System.Windows.Visibility.Hidden;
            Import.IsEnabled = false;
            Export.IsEnabled = false;
            this.MinHeight = 500;
            ProgText.Text = "Importing Data...";
            ProgressStone.Value = 0;

            worker.DoWork += delegate(object sdr, DoWorkEventArgs dw) {
                Excel.Application _excelApp = (Excel.Application)dw.Argument;
                xlWorkBook = _excelApp.Workbooks.Open(path, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
                xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

                range = xlWorkSheet.UsedRange;
                List<Stone> stoneItem = new List<Stone>();
                for (int row = 0; row <= range.Rows.Count; row++) {
                    for (int col = 0; col <= range.Columns.Count; col++) {
                        if ((range.Cells[row + 2, col + 1] as Excel.Range).Value2 != null) {
                            if (col == 0) rarity = (range.Cells[row + 2, col + 1] as Excel.Range).Value2;
                            if (col == 1) name = (range.Cells[row + 2, col + 1] as Excel.Range).Value2;
                            if (col == 2) carat = (range.Cells[row + 2, col + 1] as Excel.Range).Value2;
                            if (col == 3) price = (range.Cells[row + 2, col + 1] as Excel.Range).Value2;

                        } else {
                            if (col == 0) rarity = string.Empty;
                            if (col == 1) name = string.Empty;
                            if (col == 2) carat = string.Empty;
                            if (col == 3) price = string.Empty;
                        }
                    }

                    if (worker.CancellationPending) {
                        ProgText.Dispatcher.Invoke(new Action(() => { ProgText.Text = "Canceling..."; }));
                        System.Threading.Thread.Sleep(3000);
                        dw.Cancel = true;
                        return;
                    }

                    try {
                        if (!string.IsNullOrWhiteSpace(name.ToString())) {
                            stoneItem.Add(new Stone {
                                Id = row + 1,
                                name = name.ToString(),
                                rarity = rarity.ToString(),
                                carat = carat.ToString(),
                                price = price.ToString(),
                            });
                        }
                    } catch (Exception) {
                        ProgText.Dispatcher.Invoke(new Action(() => { ProgText.Text = "Invalid Template!"; }));
                        System.Threading.Thread.Sleep(1300);
                        worker.CancelAsync();
                    }

                    worker.ReportProgress(Convert.ToInt32(((decimal)row / (decimal)range.Rows.Count) * 100));
                    System.Threading.Thread.Sleep(5);
                    dw.Result = stoneItem;
                }
            };

            worker.ProgressChanged += delegate(object s, ProgressChangedEventArgs args) {
                ProgressStone.Value = args.ProgressPercentage;
            };

            worker.RunWorkerCompleted += delegate(object sdr, RunWorkerCompletedEventArgs rwc) {
                xlWorkBook.Close(true, misValue, misValue);
                excelApp.Quit();

                releaseObject(xlWorkSheet);
                releaseObject(xlWorkBook);
                releaseObject(excelApp);
                ProgressGrid.Visibility = System.Windows.Visibility.Hidden;
                StoneListGrid.Visibility = System.Windows.Visibility.Visible;
                Import.IsEnabled = true;
                Export.IsEnabled = true;
                this.MinHeight = 300;

                if (rwc.Error != null) {
                    MessageBox.Show(rwc.Error.Message);
                    return;
                }

                if (!rwc.Cancelled) {
                    List<Stone> stone = (List<Stone>)rwc.Result;
                    for (int i = 0; i < stone.Count; i++) {
                        stone[i].parentId = AppData.parentId;
                        stone[i].updatedAt = DateTime.Now;
                        stone[i].createdAt = DateTime.Now;
                    }

                    pawnguardDb = new PawnGuardDBDataContext();
                    LinqExt.Truncate(pawnguardDb.Stones);
                    pawnguardDb.Stones.InsertAllOnSubmit(stone);
                    pawnguardDb.SubmitChanges();

                    FillGrid();
                    page_Loaded(null, new RoutedEventArgs());
                }
            };

            worker.RunWorkerAsync(excelApp);
        }
Beispiel #3
0
        private void SearchTextBox_TextChange(object sender, TextChangedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var searchItems = GoldRecords
                              .Where(usr => usr.name.Contains((sender as TextBox).Text))
                              .ToList<Stone>();

            dgStones.ItemsSource = searchItems;
        }
Beispiel #4
0
        private void ExportExcel(string path)
        {
            bool success = false;
            object misValue = System.Reflection.Missing.Value;

            excelApp = new Microsoft.Office.Interop.Excel.Application();

            if (excelApp == null) {
                MessageBox.Show("Excel is not properly installed!!");
                return;
            }

            worker = new BackgroundWorker();
            worker.WorkerSupportsCancellation = true;
            worker.WorkerReportsProgress = true;

            PawnGuardDBDataContext pawnguard = new PawnGuardDBDataContext();
            ProgStackPanel.Visibility = System.Windows.Visibility.Visible;
            ProgTextCancel.Visibility = System.Windows.Visibility.Collapsed;
            ProgressGrid.Visibility = System.Windows.Visibility.Visible;
            StoneListGrid.Visibility = System.Windows.Visibility.Hidden;
            Import.IsEnabled = false;
            Export.IsEnabled = false;
            this.MinHeight = 500;
            ProgText.Text = "Exporting Data...";
            ProgressStone.Value = 0;

            worker.DoWork += delegate(object sdr, DoWorkEventArgs dw) {
                Excel.Application _excelApp = (Excel.Application)dw.Argument;
                xlWorkBook = _excelApp.Workbooks.Open(path);
                xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

                List<Stone> stones = pawnguard.Stones.ToList<Stone>();
                for (int row = 0; row < stones.Count; row++) {
                    for (int col = 0; col < 13; col++) {
                        if (col == 0)  xlWorkSheet.Cells[row + 2, col + 1] = stones[row].rarity;
                        if (col == 1) xlWorkSheet.Cells[row + 2, col + 1] = stones[row].name;
                        if (col == 2) xlWorkSheet.Cells[row + 2, col + 1] = stones[row].carat;
                        if (col == 3) xlWorkSheet.Cells[row + 2, col + 1] = stones[row].price;
                    }
                    worker.ReportProgress(Convert.ToInt32(((decimal)row / (decimal)stones.Count) * 100));
                    System.Threading.Thread.Sleep(100);

                    if (worker.CancellationPending) {
                        ProgText.Dispatcher.Invoke(new Action(() => { ProgText.Text = "Canceling..."; }));
                        System.Threading.Thread.Sleep(2000);
                        dw.Cancel = true;
                        return;
                    }
                }
            };

            worker.ProgressChanged += delegate(object s, ProgressChangedEventArgs args) {
                ProgressStone.Value = args.ProgressPercentage;
            };

            worker.RunWorkerCompleted += delegate(object sdr, RunWorkerCompletedEventArgs rwc) {
                if (rwc.Error != null) {
                    MessageBox.Show(rwc.Error.Message);
                    return;
                }

                if (!rwc.Cancelled) {
                    ProgressStone.Value = 100;
                    SaveFileDialog dlg = new SaveFileDialog();
                    dlg.FileName = "Stone Template.xlsx";
                    dlg.DefaultExt = ".xlsx";
                    dlg.Filter = "Stone Template|*.xlsx";

                    Nullable<bool> result = dlg.ShowDialog();
                    if (result == true) {
                        string filename = dlg.FileName;
                        xlWorkBook.SaveAs(filename);
                        success = true;
                        path = filename;
                    }
                } else {
                    ProgText.Dispatcher.Invoke(new Action(() => { ProgText.Text = "Cancelled"; }));
                }

                xlWorkBook.Close(true, misValue, misValue);
                excelApp.Quit();

                releaseObject(xlWorkSheet);
                releaseObject(xlWorkBook);
                releaseObject(excelApp);

                ProgressGrid.Visibility = System.Windows.Visibility.Hidden;
                StoneListGrid.Visibility = System.Windows.Visibility.Visible;
                Import.IsEnabled = true;
                Export.IsEnabled = true;
                this.MinHeight = 300;

                if (success) {
                    System.Diagnostics.Process.Start(path);
                }
            };

            worker.RunWorkerAsync(excelApp);
        }
Beispiel #5
0
 private void FillGrid()
 {
     pawnguardDb = new PawnGuardDBDataContext();
     var lambdaJoin = pawnguardDb.Stones.AsQueryable<Stone>();
     GoldRecords = lambdaJoin;
 }
Beispiel #6
0
        private void SearchTextBox_TextChange(object sender, TextChangedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var searchPos = pawnguardDb.Positions
                            .Where(pos => pos.name.Contains((sender as TextBox).Text))
                            .ToList<Position>();

            dgPosition.ItemsSource = searchPos;
        }
        private void SaveSetUp()
        {
            using (PawnGuardDBDataContext db = new PawnGuardDBDataContext()) {
                LinqExt.Truncate(db.Branches);
                LinqExt.Truncate(db.AppSettings);
                LinqExt.Truncate(db.Moneys);
                LinqExt.Truncate(db.Currencies);
                LinqExt.Truncate(db.ItemCategories);
                LinqExt.Truncate(db.Golds);
                LinqExt.Truncate(db.Stones);
                LinqExt.Truncate(db.InitialSetups);

                db.Branches.InsertOnSubmit(Branch);
                db.AppSettings.InsertOnSubmit(BranchPrimaryCurreny);
                db.Moneys.InsertAllOnSubmit(BranchMoney);
                db.Currencies.InsertAllOnSubmit(BranchCurrency);
                db.ItemCategories.InsertAllOnSubmit(ItemCategories);
                db.Golds.InsertAllOnSubmit(GoldList);
                db.Stones.InsertAllOnSubmit(StoneList);

                InitialSetup inSetup = new InitialSetup() {
                    parentId = "000001",
                    step = "SetState",
                    createdAt = DateTime.Now,
                    updateAt = DateTime.Now
                };

                db.InitialSetups.InsertOnSubmit(inSetup);
                db.SubmitChanges();

                ProgressBarFinal.Dispatcher.Invoke(new Action(() => {
                    ProgressBarFinal.Visibility = Visibility.Hidden;
                }));
                ButtonStartApp.Dispatcher.Invoke(new Action(() => {
                    ButtonStartApp.Visibility = Visibility.Visible;
                }));
            }
        }
Beispiel #8
0
        private void Page_Loaded(object sender, RoutedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var userlevel = from userLevel in pawnguardDb.UserLevels
                           select userLevel;

            dgUserLevel.ItemsSource = userlevel;
        }
Beispiel #9
0
        private void SearchTextBox_TextChange(object sender, TextChangedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var searchUsrLvl = pawnguardDb.UserLevels
                               .Where(usrl => usrl.role.Contains((sender as TextBox).Text))
                               .ToList<UserLevel>();

            dgUserLevel.ItemsSource = searchUsrLvl;
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string uid = (sender as Button).Uid;
            SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
            saveButton.Visibility = System.Windows.Visibility.Visible;

            if (dispathTimer != null) {
                dispathTimer.Stop();
                dispathTimer = null;
            }

            if (uid == "addNew") {
                dgItems.SelectedItem = null;
                toEditItem = null;
            }

            if (uid == "rowEdit") {
                pawnguardDb = new PawnGuardDBDataContext();
                toEditItem = pawnguardDb.ItemCategories
                             .SingleOrDefault<ItemCategory>(pos => pos.id.ToString() == (sender as Button).Content.ToString());

                dgItems.SelectedItem = toEditItem;
                VisualStateManager.GoToElementState(this.LayoutRoot, "ShowState", true);
            }

            if (uid == "closePanel") {
                VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                FillGrid();
                page_Loaded(sender, e);
            }

            if (uid == "deleteAll") {
                if (toDeleteItem.Count > 0) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    List<ItemCategory> deleteUser = new List<ItemCategory>();
                    for (int i = 0; i < toDeleteItem.Count; i++) {
                        var itemCategory = pawnguardDb.ItemCategories
                                   .FirstOrDefault(usr => usr.id == toDeleteItem[i].id);

                        deleteUser.Add(itemCategory);
                    }

                    if (deleteUser.Count > 0) {
                        pawnguardDb.ItemCategories.DeleteAllOnSubmit(deleteUser);
                        pawnguardDb.SubmitChanges();
                        isCheckAll.IsChecked = false;
                        toDeleteItem.Clear();

                        FillGrid();
                        page_Loaded(sender, e);
                    }
                }
            }

            if (uid == "save") {
                if (toEditItem == null) {

                    if (!IsValid())
                        return;

                    pawnguardDb = new PawnGuardDBDataContext();
                    bool exist = pawnguardDb.ItemCategories.AsEnumerable()
                                 .Where(itm => itm.main.ToLower() == txtCategory.Text.ToLower() ||
                                               itm.option1.ToLower() == txtOption1.Text.ToLower() ||
                                               itm.option2.ToLower() == txtOption2.Text.ToLower())
                                 .Any();

                    if (exist) {
                        categoryError.Visibility = System.Windows.Visibility.Visible;
                        errorMsgCategory.Text = MSG_EXIST;
                        return;
                    }

                    decimal price = 0;
                    decimal.TryParse(txtPrice.Text, out price);
                    pawnguardDb.ItemCategories.InsertOnSubmit(new ItemCategory() {
                        parentId = AppData.parentId,
                        code = txtCode.Text,
                        main = txtCategory.Text,
                        option1 = txtOption1.Text,
                        option2 = txtOption2.Text,
                        price = price,
                        createdAt = DateTime.Now,
                        updatedAt = DateTime.Now
                    });
                } else {
                    if (!IsValid())
                        return;

                    string editEmail = toEditItem.main;
                    string editoption1 = toEditItem.option1;
                    string editoption2 = toEditItem.option2;
                    if (!editEmail.Equals(txtCategory.Text, StringComparison.InvariantCultureIgnoreCase) &&
                        !editoption1.Equals(txtOption1.Text, StringComparison.InvariantCultureIgnoreCase) &&
                        !editoption2.Equals(txtOption2.Text, StringComparison.InvariantCultureIgnoreCase)) {

                        bool exist = pawnguardDb.ItemCategories.AsEnumerable()
                                .Where(itm => itm.main.ToLower() == txtCategory.Text.ToLower() ||
                                                itm.option1.ToLower() == txtOption1.Text.ToLower() ||
                                                itm.option2.ToLower() == txtOption2.Text.ToLower())
                                .Any();

                        if (exist) {
                            categoryError.Visibility = System.Windows.Visibility.Visible;
                            errorMsgCategory.Text = MSG_EXIST;
                            return;
                        }
                    }

                    decimal price = 0;
                    decimal.TryParse(txtPrice.Text, out price);
                    toEditItem.parentId = AppData.parentId;
                    toEditItem.code = txtCode.Text;
                    toEditItem.main = txtCategory.Text;
                    toEditItem.option1 = txtOption1.Text;
                    toEditItem.option2 = txtOption2.Text;
                    toEditItem.price = price;
                    toEditItem.updatedAt = DateTime.Now;
                }

                try {
                    pawnguardDb.SubmitChanges();
                    saveButton.Visibility = System.Windows.Visibility.Collapsed;

                    dispathTimer = new DispatcherTimer();
                    dispathTimer.Interval = new TimeSpan(0, 0, 1);
                    dispathTimer.Start();

                    int time = 3;
                    SuccessMessgage.Visibility = System.Windows.Visibility.Visible;
                    dispathTimer.Tick += delegate(object s, EventArgs ea) {
                        if (time >= 0)
                            runTime.Text = time + " sec.";
                        else {
                            dispathTimer.Stop();
                            SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
                            VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                            runTime.Text = "3 sec.";

                            FillGrid();
                            page_Loaded(sender, e);
                        }
                        time--;
                    };
                } catch (Exception) {
                }
            }
        }
Beispiel #11
0
        private void checkItem_Click(object sender, RoutedEventArgs e)
        {
            string content = (sender as CheckBox).Name;
            if (content == "isCheckAll") {
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    toDeleteUserLevel = dgUserLevel.ItemsSource
                                       .OfType<UserLevel>()
                                       .ToList<UserLevel>();
                }

                if ((bool)(sender as CheckBox).IsChecked == false) {
                    toDeleteUserLevel.Clear();
                }
            } else {
                string id = (sender as CheckBox).Content.ToString();

                if ((bool)(sender as CheckBox).IsChecked == true) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    UserLevel position = pawnguardDb.UserLevels
                                        .FirstOrDefault(usrl => usrl.id.ToString() == id);

                    if (!toDeleteUserLevel.Contains(position))
                        toDeleteUserLevel.Add(position);

                } else if ((bool)(sender as CheckBox).IsChecked == false) {
                    UserLevel position = toDeleteUserLevel
                                        .FirstOrDefault(usrl => usrl.id.ToString() == id);

                    if (toDeleteUserLevel.Contains(position))
                        toDeleteUserLevel.Remove(position);
                }
            }
        }
        private void SearchTextBox_TextChange(object sender, TextChangedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var searchItems = UserRecords
                              .Where(usr => usr.main.Contains((sender as TextBox).Text) ||
                                            usr.option1.Contains((sender as TextBox).Text) ||
                                            usr.option2.Contains((sender as TextBox).Text) ||
                                            usr.code.Contains((sender as TextBox).Text))
                              .ToList<ItemCategory>();

            dgItems.ItemsSource = searchItems;
        }
 private void FillGrid()
 {
     pawnguardDb = new PawnGuardDBDataContext();
     var lambdaJoin = pawnguardDb.ItemCategories.AsQueryable<ItemCategory>();
     UserRecords = lambdaJoin;
 }
        private void checkItem_Click(object sender, RoutedEventArgs e)
        {
            string content = (sender as CheckBox).Name;
            if (content == "isCheckAll") {
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    toDeleteItem = dgItems.ItemsSource
                                  .OfType<ItemCategory>()
                                  .ToList<ItemCategory>();
                }

                if ((bool)(sender as CheckBox).IsChecked == false) {
                    if (toDeleteItem != null)
                        toDeleteItem.Clear();
                }
            } else {
                string id = (sender as CheckBox).Content.ToString();
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    ItemCategory itemCategory = pawnguardDb.ItemCategories
                                            .FirstOrDefault(pos => pos.id.ToString() == id);

                    if (!toDeleteItem.Contains(itemCategory))
                        toDeleteItem.Add(itemCategory);

                } else if ((bool)(sender as CheckBox).IsChecked == false) {
                    ItemCategory itemCategory = toDeleteItem.FirstOrDefault(usr => usr.id.ToString() == id);

                    if (toDeleteItem.Contains(itemCategory))
                        toDeleteItem.Remove(itemCategory);
                }
            }
        }
Beispiel #15
0
        private void checkItem_Click(object sender, RoutedEventArgs e)
        {
            string content = (sender as CheckBox).Name;
            if (content == "isCheckAll") {
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    toDeletePosition = dgPosition.ItemsSource
                                       .OfType<Position>()
                                       .ToList<Position>();
                }

                if ((bool)(sender as CheckBox).IsChecked == false) {
                    toDeletePosition.Clear();
                }
            } else {
                string id = (sender as CheckBox).Content.ToString();
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    Position position = pawnguardDb.Positions
                                        .FirstOrDefault(pos => pos.id.ToString() == id);

                    if (!toDeletePosition.Contains(position))
                        toDeletePosition.Add(position);

                } else if ((bool)(sender as CheckBox).IsChecked == false) {
                    Position position = toDeletePosition
                                        .FirstOrDefault(pos => pos.id.ToString() == id);

                    if (toDeletePosition.Contains(position))
                        toDeletePosition.Remove(position);
                }
            }
        }
Beispiel #16
0
        private void checkItem_Click(object sender, RoutedEventArgs e)
        {
            string content = (sender as CheckBox).Name;
            if (content == "isCheckAll") {
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    toDeleteGold = dgGolds.ItemsSource
                                  .OfType<Gold>()
                                  .ToList<Gold>();
                }

                if ((bool)(sender as CheckBox).IsChecked == false) {
                    if (toDeleteGold != null)
                        toDeleteGold.Clear();
                }
            } else {
                string id = (sender as CheckBox).Content.ToString();
                if ((bool)(sender as CheckBox).IsChecked == true) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    Gold gold = pawnguardDb.Golds
                                        .FirstOrDefault(pos => pos.Id.ToString() == id);

                    if (!toDeleteGold.Contains(gold))
                        toDeleteGold.Add(gold);

                } else if ((bool)(sender as CheckBox).IsChecked == false) {
                    Gold gold = toDeleteGold.FirstOrDefault(usr => usr.Id.ToString() == id);

                    if (toDeleteGold.Contains(gold))
                        toDeleteGold.Remove(gold);
                }
            }
        }
Beispiel #17
0
        private void Page_Loaded(object sender, RoutedEventArgs e)
        {
            pawnguardDb = new PawnGuardDBDataContext();
            var position = from positions in pawnguardDb.Positions
                           select positions;

            dgPosition.ItemsSource = position;
        }
Beispiel #18
0
        private void SigninButton_Click(object sender, RoutedEventArgs e)
        {
            if (string.IsNullOrWhiteSpace(Email.Text)) {
                Email.Focus();
                return;
            }

            if (string.IsNullOrWhiteSpace(Password.Password)) {
                Password.Focus();
                return;
            }

            try {
                using (PawnGuardDBDataContext tblUser = new PawnGuardDBDataContext()) {
                    var data = tblUser.Users.AsEnumerable()
                               .FirstOrDefault(usr => usr.email == Email.Text &&
                                                      usr.password == Password.Password);

                    if (data != null) {
                        User user = data;
                        LoginError.Visibility = System.Windows.Visibility.Collapsed;
                        PawnGuardPro.Properties.Settings.Default.UserID = user.Id.ToString();
                        PawnGuardPro.Properties.Settings.Default.Name = user.name;
                        PawnGuardPro.Properties.Settings.Default.Branch = TablesGetData.tblBranch(user.branchCode, "code", "name").ToString();
                        PawnGuardPro.Properties.Settings.Default.BranchCode = user.branchCode;
                        PawnGuardPro.Properties.Settings.Default.Company = user.company;
                        PawnGuardPro.Properties.Settings.Default.ParentID = user.parentId;
                        //PawnGuardPro.Properties.Settings.Default.Currency = "PHP";
                        PawnGuardPro.Properties.Settings.Default.Save();
                        VisualStateManager.GoToElementState(this.LayouRoot, "UserSignin", true);
                        MainWindow main = Application.Current.MainWindow as MainWindow;
                        main.IsLogin(this, new EventArgs());
                        this.Dispose();
                    } else {
                        LoginError.Visibility = System.Windows.Visibility.Visible;
                    }
                }
            } catch (SqlException ex) {
                if (ex.Number == -2) {
                    MessageBox.Show("Timeout occurred");
                } else {
                    MessageBox.Show(ex.Message, "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
Beispiel #19
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string uid = (sender as Button).Uid;
            positionError.Visibility = System.Windows.Visibility.Collapsed;
            SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
            saveButton.Visibility = System.Windows.Visibility.Visible;

            if (dispathTimer != null) {
                dispathTimer.Stop();
                dispathTimer = null;
            }

            if (uid == "addNew") {
                dgPosition.SelectedItem = null;
                toEditPosition = null;
            }

            if (uid == "rowEdit") {
                pawnguardDb = new PawnGuardDBDataContext();
                toEditPosition = pawnguardDb.Positions
                               .SingleOrDefault<Position>(pos => pos.id.ToString() == (sender as Button).Content.ToString());

                dgPosition.SelectedItem = toEditPosition;
                VisualStateManager.GoToElementState(this.LayoutRoot, "ShowState", true);
            }

            if (uid == "closePanel") {
                VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                Page_Loaded(sender, e);
            }

            if (uid == "deleteAll") {
                if (toDeletePosition.Count > 0) {
                    pawnguardDb = new PawnGuardDBDataContext();
                    List<Position> deletePosition = new List<Position>();
                    for (int i = 0; i < toDeletePosition.Count; i++) {
                        var _pos = pawnguardDb.Positions
                                   .FirstOrDefault(pos => pos.id == toDeletePosition[i].id);

                        deletePosition.Add(_pos);
                    }

                    if (deletePosition.Count > 0) {
                        pawnguardDb.Positions.DeleteAllOnSubmit(deletePosition);
                        pawnguardDb.SubmitChanges();
                        Page_Loaded(sender, e);
                        isCheckAll.IsChecked = false;
                        toDeletePosition.Clear();
                    }
                }
            }

            if (uid == "save") {
                if (toEditPosition == null) {
                    if (string.IsNullOrWhiteSpace(txtPositionName.Text)) {
                        positionError.Visibility = System.Windows.Visibility.Visible;
                        errorMsg.Text = MSG_REQUIRED;
                        return;
                    }

                    pawnguardDb = new PawnGuardDBDataContext();
                    bool exist = pawnguardDb.Positions.AsEnumerable()
                                 .Where(pos => pos.name.ToLower() == txtPositionName.Text.ToLower())
                                 .Any();

                    if (exist) {
                        positionError.Visibility = System.Windows.Visibility.Visible;
                        errorMsg.Text = MSG_EXIST;
                        return;
                    }

                    pawnguardDb.Positions.InsertOnSubmit(new Position() {
                        name = txtPositionName.Text,
                        createdAt = DateTime.Now,
                        updatedAt = DateTime.Now
                    });
                } else {
                    string editName = toEditPosition.name;
                    if (!editName.Equals(txtPositionName.Text, StringComparison.InvariantCultureIgnoreCase)) {
                        bool exist = pawnguardDb.Positions.AsEnumerable()
                                 .Where(pos => pos.name.ToLower() == txtPositionName.Text.ToLower())
                                 .Any();

                        if (exist) {
                            positionError.Visibility = System.Windows.Visibility.Visible;
                            errorMsg.Text = MSG_EXIST;
                            return;
                        }
                    } else {
                        VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                        return;
                    }

                    toEditPosition.name = txtPositionName.Text;
                    toEditPosition.updatedAt = DateTime.Now;
                }

                try {
                    pawnguardDb.SubmitChanges();
                    saveButton.Visibility = System.Windows.Visibility.Collapsed;

                    dispathTimer = new DispatcherTimer();
                    dispathTimer.Interval = new TimeSpan(0, 0, 1);
                    dispathTimer.Start();

                    int time = 3;
                    SuccessMessgage.Visibility = System.Windows.Visibility.Visible;
                    dispathTimer.Tick += delegate(object s, EventArgs ea) {
                        if (time >= 0)
                            runTime.Text = time + " sec.";
                        else {
                            dispathTimer.Stop();
                            SuccessMessgage.Visibility = System.Windows.Visibility.Collapsed;
                            VisualStateManager.GoToElementState(this.LayoutRoot, "HideState", true);
                            runTime.Text = "3 sec.";
                            txtPositionName.Clear();
                            Page_Loaded(sender, e);
                        }
                        time--;
                    };
                } catch (Exception) {
                }
            }
        }
Beispiel #20
0
        public UserDataSource()
        {
            _appUser = new ObservableCollection<AppUser>();
            using (PawnGuardDBDataContext db = new PawnGuardDBDataContext()) {

                List<User> users = db.Users.ToList<User>();
                for (int i = 0; i < users.Count; i++) {
                    //_appUser.Add((AppUser)users[i]);
                    _appUser.Add(new AppUser() {
                        name = users[i].name
                    });
                }
            }
        }