Beispiel #1
0
        private void myRadDataForm_DeletingItem(object sender, System.ComponentModel.CancelEventArgs e)
        {
            Window lWindows = Models.CommonFunction.GetApplicationWindow();

            if (MessageBox.Show(lWindows, "Are you sure you want to delete?", "Delete",
                                MessageBoxButton.OKCancel) == MessageBoxResult.Cancel)
            {
                e.Cancel = true;
            }
            else
            {
                SunSeven.Models.HSEmployee lItem = myRadDataForm.CurrentItem as SunSeven.Models.HSEmployee;

                DataSource.JSDataContext lDataContext;

                lDataContext = new CommonFunction().JSDataContext();

                try
                {
                    var lDelEmpDept = lDataContext.Emp_Depts.Where(p => p.EmployeeId == lItem.Id);
                    lDataContext.Emp_Depts.DeleteAllOnSubmit(lDelEmpDept);

                    var lDelItem = lDataContext.Employees.Single(p => p.Id == lItem.Id);

                    lDataContext.Employees.DeleteOnSubmit(lDelItem);
                    lDataContext.SubmitChanges();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    e.Cancel = true;
                }
            }
        }
        private int saveInvoiceStatus(string invoiceNo)
        {
            DataSource.Invoice lInvoice = lDataContext.Invoices.SingleOrDefault(p => p.InvoiceNo == invoiceNo);

            try
            {
                lInvoice.Status = 3;  // Returned

                lDataContext.SubmitChanges();

                return(0);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Save Status : Can not find Invoice No [" + invoiceNo + "]");
                //MessageBox.Show(ex.Message);
                return(-1);
            }
        }
Beispiel #3
0
        private void OnApplyCommandExecuted(object id)
        {
            var luserScreen = lDataContext.UserScreens.Where(p => p.UserId == this.UserId);

            lDataContext.UserScreens.DeleteAllOnSubmit(luserScreen);

            foreach (JSScreen l in this.Where(p => p.IsSelected == true))
            {
                DataSource.UserScreen lNewScreen = new DataSource.UserScreen();
                lNewScreen.UserId   = this.UserId;
                lNewScreen.ScreenId = l.ScreenAvailable.ScreenId;
                lNewScreen.Default  = l.IsDefault;
                lDataContext.UserScreens.InsertOnSubmit(lNewScreen);
            }

            try
            {
                lDataContext.SubmitChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }