/// <summary> /// Update Customer Account and Insert in Payment History /// </summary> /// <param name="obj"> /// obj[0] = ModelCustomerInfo /// obj[1] = paymentAmount /// obj[2] = Remain Due /// </param> private void updatePaymentClick(object obj) { Mouse.OverrideCursor = Cursors.Wait; try { if (obj is ArrayList) { using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ArrayList dataList = obj as ArrayList; ModelCustomerIno selectedCustomer = dataList[0] as ModelCustomerIno; var customerInformation = dmDatabase.CustomerInformations.First(x => x.AutoInc == selectedCustomer.ID); customerInformation.DueAmount = +Convert.ToDecimal(dataList[2]); dmDatabase.AddToPaymentHistories(new PaymentHistory { AutoInc = default(long), Amount = Convert.ToDecimal(dataList[1]), CustomerName = selectedCustomer.CustomerName, PaymentDate = DateTime.Today, CustomerID=selectedCustomer.ID }); dmDatabase.SaveChanges(); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[1], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } else { Mouse.OverrideCursor = null; MessageBox.Show("Unable to receive payment", CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorException) { Mouse.OverrideCursor = null; MessageBox.Show(errorException.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } finally { Mouse.OverrideCursor = null; } }
/// <summary> /// Insert invoice Reports /// </summary> /// <param name="obj"> /// obj[0] = invoiceGrid.ItemSource /// obj[1] = Payment Amount /// obj[2] = Due Amount /// obj[3] = ModelCustomerInfo /// </param> private void updateInvoiceClick(object obj) { Mouse.OverrideCursor = null; try { if (obj is ArrayList) { using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ArrayList dataList = obj as ArrayList; ObservableCollection<ModelSalesHistory> salesItems = dataList[0] as ObservableCollection<ModelSalesHistory>; ModelCustomerIno selectedCustomer = dataList[3] as ModelCustomerIno; foreach (ModelSalesHistory sale in salesItems) { dmDatabase.AddToProductSaleHistories(new ProductSaleHistory { AutoInc = default(long), CustomerName = sale.CustomerName, ProductName = sale.PropductName, Quantity = sale.Quantity, Rate = sale.Rate, SaleDate = sale.SaleDate, CustomerID=selectedCustomer.ID }); } var customerInfo = dmDatabase.CustomerInformations.First(x => x.AutoInc == selectedCustomer.ID); customerInfo.DueAmount = +Convert.ToDecimal(dataList[2]); dmDatabase.AddToPaymentHistories(new PaymentHistory { AutoInc=default(long), CustomerName=selectedCustomer.CustomerName, Amount=Convert.ToDecimal(dataList[1]), PaymentDate=DateTime.Today, CustomerID=selectedCustomer.ID }); dmDatabase.SaveChanges(); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[1], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } else { Mouse.OverrideCursor = null; MessageBox.Show("Unable to save in database", CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorException) { Mouse.OverrideCursor = null; MessageBox.Show(errorException.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Error); } finally { Mouse.OverrideCursor = null; } }
/// <summary> /// Delete Product information /// </summary> /// <param name="obj"></param> private void deleteProductClick(object obj) { this.NewProductDelete.IsEnabled = false; try { if (MessageBox.Show(CommandData.ERROR_MESSAGE[3], CommandData.SOFTWARE_NAME, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ModelProductInfo deletedProductInfo = obj as ModelProductInfo; dmDatabase.ProductInformations.DeleteObject(dmDatabase.ProductInformations.First(x => x.AutoInc == deletedProductInfo.ID)); dmDatabase.SaveChanges(); (this.NewProductList.ItemsSource as ObservableCollection<ModelProductInfo>).Remove(deletedProductInfo); this.selectFirstItem(this.newCustomerList); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[4], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorMessagess) { Mouse.OverrideCursor = null; MessageBox.Show(errorMessagess.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Error); } finally { Mouse.OverrideCursor = null; this.NewProductDelete.IsEnabled = true; } }
/// <summary> /// Update or Insert Product information /// </summary> /// <param name="obj"></param> private void updateProductClick(object obj) { this.NewProductUpdate.IsEnabled = false; Mouse.OverrideCursor = Cursors.Wait; try { this.NewProductName.GetBindingExpression(TextBox.TextProperty); this.getValidationError(this.NewProductName); using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ModelProductInfo selectedProductInfo = obj as ModelProductInfo; var productExist = dmDatabase.ProductInformations.FirstOrDefault(x => x.AutoInc == selectedProductInfo.ID); if (productExist != null) { Mouse.OverrideCursor = null; if (MessageBox.Show(CommandData.ERROR_MESSAGE[0], CommandData.SOFTWARE_NAME, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; productExist.ProductName = selectedProductInfo.ProductName; productExist.Rate = selectedProductInfo.Rate; dmDatabase.SaveChanges(); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[1], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } else { return; } } else { ProductInformation newProductInfo = new ProductInformation { AutoInc = default(long), ProductName = selectedProductInfo.ProductName, Rate = selectedProductInfo.Rate }; dmDatabase.ProductInformations.AddObject(newProductInfo); dmDatabase.SaveChanges(); selectedProductInfo.ID = newProductInfo.AutoInc; Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[2], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorMessagess) { Mouse.OverrideCursor = null; MessageBox.Show(errorMessagess.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Error); } finally { Mouse.OverrideCursor = null; } }
/// <summary> /// Update or Insert Customer information /// </summary> /// <param name="obj"></param> private void updateCustomerClick(object obj) { this.newCustomerUpdate.IsEnabled = false; Mouse.OverrideCursor = Cursors.Wait; try { this.newCustomerName.GetBindingExpression(TextBox.TextProperty); this.getValidationError(this.newCustomerName); using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ModelCustomerIno selectedCustomer = obj as ModelCustomerIno; var custometIsExist = dmDatabase.CustomerInformations.FirstOrDefault(x => x.AutoInc== selectedCustomer.ID); if (custometIsExist!=null) { Mouse.OverrideCursor = null; if (MessageBox.Show(CommandData.ERROR_MESSAGE[0],CommandData.SOFTWARE_NAME,MessageBoxButton.YesNo,MessageBoxImage.Question)==MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; custometIsExist.Address = selectedCustomer.Address; custometIsExist.CustomerName = selectedCustomer.CustomerName; custometIsExist.DueAmount = selectedCustomer.DueAmount; custometIsExist.Mobile = selectedCustomer.Mobile; custometIsExist.Remark = selectedCustomer.Remark; custometIsExist.ShopName = selectedCustomer.ShopName; dmDatabase.SaveChanges(); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[1], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } else { return; } } else { CustomerInformation newCustomerInformation = new CustomerInformation { Address = selectedCustomer.Address, AutoInc = default(long), CreateDate = DateTime.Today, CustomerName = selectedCustomer.CustomerName, DueAmount = selectedCustomer.DueAmount, Mobile = selectedCustomer.Mobile, Remark = selectedCustomer.Remark, ShopName = selectedCustomer.ShopName }; dmDatabase.CustomerInformations.AddObject(newCustomerInformation); dmDatabase.SaveChanges(); selectedCustomer.ID = newCustomerInformation.AutoInc; Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[2], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorException) { Mouse.OverrideCursor = null; MessageBox.Show(errorException.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Error); } finally { Mouse.OverrideCursor = null; } }
/// <summary> /// Delete All items /// </summary> /// <param name="obj">DataGrid.ItemSource</param> private void deleteAllPaymentHistoryClick(object obj) { this.PaymentHisDeleteAll.IsEnabled = false; Mouse.OverrideCursor = Cursors.Wait; try { using (DueManagementEntity dmDatabase = new DueManagementEntity()) { ObservableCollection<ModelPaymentHistory> saleHestoryItems = new ObservableCollection<ModelPaymentHistory>(); foreach (var singleItem in obj as ObservableCollection<ModelPaymentHistory>) { saleHestoryItems.Add(singleItem); } foreach (var deletedItem in saleHestoryItems) { dmDatabase.PaymentHistories.DeleteObject(dmDatabase.PaymentHistories.First(x => x.AutoInc == deletedItem.ID)); (this.PaymentHisGrid.ItemsSource as ObservableCollection<ModelPaymentHistory>).Remove(deletedItem); } dmDatabase.SaveChanges(); Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[4], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Information); } } catch (NullReferenceException) { Mouse.OverrideCursor = null; MessageBox.Show(CommandData.ERROR_MESSAGE[5], CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Stop); } catch (Exception errorException) { Mouse.OverrideCursor = null; MessageBox.Show(errorException.Message, CommandData.SOFTWARE_NAME, MessageBoxButton.OK, MessageBoxImage.Error); } finally { Mouse.OverrideCursor = null; this.PaymentHisDeleteAll.IsEnabled = true; } }