Example #1
0
 partial void DeleteItemCategory(ItemCategory instance);
Example #2
0
 partial void InsertItemCategory(ItemCategory instance);
Example #3
0
 partial void UpdateItemCategory(ItemCategory instance);
        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) {
                }
            }
        }