public NewQuoteItemsContent() { InitializeComponent(); isInitialized = true; currentItem = new NewQuoteItemEntity(); FillGlassTypes(); FillShapes(); FillCutoutData(); FillInsulationDetails(); currentItem.GlassType1 = new InsulationDetails(); currentItem.GlassType2 = new InsulationDetails(); }
private void btnNewItem_Click(object sender, RoutedEventArgs e) { try { if (currentItem != null) { var result = Helper.ShowQuestionMessageBox("Are you sure to discard current changes?"); if (result == MessageBoxResult.Yes) { currentItem = new NewQuoteItemEntity(); allCutoutData.Clear(); currentItem.GlassType1 = new InsulationDetails(); currentItem.GlassType2 = new InsulationDetails(); UpdateCurrentTotal(); ResetAllControls(); } } else { currentItem = new NewQuoteItemEntity(); allCutoutData.Clear(); currentItem.GlassType1 = new InsulationDetails(); currentItem.GlassType2 = new InsulationDetails(); UpdateCurrentTotal(); ResetAllControls(); } } catch (Exception ex) { Logger.LogException(ex); } }
internal static NewQuoteItemEntity GetLineItemDetails(string quoteNumber, int lineID) { NewQuoteItemEntity item = null; try { SqlParameter pQuoteNumber = new SqlParameter(); pQuoteNumber.ParameterName = "quoteNumber"; pQuoteNumber.Value = quoteNumber; SqlParameter pLineID = new SqlParameter(); pLineID.ParameterName = "lineID"; pLineID.Value = lineID; var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetLineItemInformation, pQuoteNumber, pLineID); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) return item; item = new NewQuoteItemEntity(); if (result.Tables.Count > 0) { item.GlassTypeID = int.Parse(result.Tables[0].Rows[0][ColumnNames.SelectedGlassIndex].ToString()); item.ThicknessID = int.Parse(result.Tables[0].Rows[0][ColumnNames.SelectedThicknessIndex].ToString()); item.IsLogoRequired = bool.Parse(result.Tables[0].Rows[0][ColumnNames.IsLogo].ToString()); item.IsTempered = bool.Parse(result.Tables[0].Rows[0][ColumnNames.IsTempered].ToString()); item.ShapeID = int.Parse(result.Tables[0].Rows[0][ColumnNames.SelectedShapeIndex].ToString()); item.GlassWidth = int.Parse(result.Tables[0].Rows[0][ColumnNames.ActualWidth].ToString()); item.GlassWidthFraction = result.Tables[0].Rows[0][ColumnNames.ActualWidthFraction].ToString(); item.GlassHeight = int.Parse(result.Tables[0].Rows[0][ColumnNames.ActualHeight].ToString()); item.GlassHeightFraction = result.Tables[0].Rows[0][ColumnNames.ActualHeightFraction].ToString(); item.Quantity = int.Parse(result.Tables[0].Rows[0][ColumnNames.Quantity].ToString()); item.TotalSqFT = int.Parse(result.Tables[0].Rows[0][ColumnNames.ActualTotalSqft].ToString()); item.GlassWidthCharged = int.Parse(result.Tables[0].Rows[0][ColumnNames.ChargedWidth].ToString()); item.GlassHeightCharged = int.Parse(result.Tables[0].Rows[0][ColumnNames.ChargedHeight].ToString()); item.TotalSqFTCharged = int.Parse(result.Tables[0].Rows[0][ColumnNames.ChargedTotal].ToString()); item.StraightPolishTotalInches = int.Parse(result.Tables[0].Rows[0][ColumnNames.StraightTotalPolish].ToString()); item.StraightPolishLongSide = int.Parse(result.Tables[0].Rows[0][ColumnNames.StraightLongSide].ToString()); item.StraightPolishShortSide = int.Parse(result.Tables[0].Rows[0][ColumnNames.StraightShortSide].ToString()); item.CustomPolishTotalInches = int.Parse(result.Tables[0].Rows[0][ColumnNames.CustomTotalPolish].ToString()); item.MiterTotalInches = int.Parse(result.Tables[0].Rows[0][ColumnNames.MiterTotalPolish].ToString()); item.MiterLongSide = int.Parse(result.Tables[0].Rows[0][ColumnNames.MiterLongSide].ToString()); item.MiterShortSide = int.Parse(result.Tables[0].Rows[0][ColumnNames.MiterShortSide].ToString()); item.Notches = int.Parse(result.Tables[0].Rows[0][ColumnNames.Notches].ToString()); item.Patches = int.Parse(result.Tables[0].Rows[0][ColumnNames.Patches].ToString()); item.Holes = int.Parse(result.Tables[0].Rows[0][ColumnNames.Holes].ToString()); item.Hinges = int.Parse(result.Tables[0].Rows[0][ColumnNames.Hinges].ToString()); item.CutoutTotal = int.Parse(result.Tables[0].Rows[0][ColumnNames.CutoutTotal].ToString()); } if (result.Tables.Count > 1) { item._allCutoutData = new ObservableCollection<CutoutData>(); CutoutData tempItem = null; for (int rowIndex = 0; rowIndex < result.Tables[1].Rows.Count; rowIndex++) { tempItem = new CutoutData(); tempItem.Quantity = int.Parse(result.Tables[1].Rows[rowIndex][ColumnNames.Quantity].ToString()); tempItem.Width = int.Parse(result.Tables[1].Rows[rowIndex][ColumnNames.Width].ToString()); tempItem.Height = int.Parse(result.Tables[1].Rows[rowIndex][ColumnNames.Height].ToString()); tempItem.Price = int.Parse(result.Tables[1].Rows[rowIndex][ColumnNames.Price].ToString()); item._allCutoutData.Add(tempItem); } } if (result.Tables.Count > 2) { item.GlassType1 = new InsulationDetails(); item.GlassType2 = new InsulationDetails(); item.GlassType1.GlassTypeID = int.Parse(result.Tables[2].Rows[0][ColumnNames.GlassType1Index].ToString()); item.GlassType1.ThicknessID = int.Parse(result.Tables[2].Rows[0][ColumnNames.Thickness1Index].ToString()); item.GlassType1.IsTempered = bool.Parse(result.Tables[2].Rows[0][ColumnNames.IsTemp1].ToString()); item.GlassType1.SqFt = int.Parse(result.Tables[2].Rows[0][ColumnNames.Sqft].ToString()); item.GlassType1.Total = int.Parse(result.Tables[2].Rows[0][ColumnNames.Total1].ToString()); item.GlassType2.GlassTypeID = int.Parse(result.Tables[2].Rows[0][ColumnNames.GlassType2Index].ToString()); item.GlassType2.ThicknessID = int.Parse(result.Tables[2].Rows[0][ColumnNames.Thickness2Index].ToString()); item.GlassType2.IsTempered = bool.Parse(result.Tables[2].Rows[0][ColumnNames.IsTemp2].ToString()); item.GlassType2.SqFt = int.Parse(result.Tables[2].Rows[0][ColumnNames.Sqft].ToString()); item.GlassType2.Total = int.Parse(result.Tables[2].Rows[0][ColumnNames.Total2].ToString()); item.MaterialCost = int.Parse(result.Tables[2].Rows[0][ColumnNames.MaterialCost].ToString()); item.InsulationTier = int.Parse(result.Tables[2].Rows[0][ColumnNames.InsulationTier].ToString()); item.InsulationTierTotal = int.Parse(result.Tables[2].Rows[0][ColumnNames.InsulationTierTotal].ToString()); item.InsulationTotal = int.Parse(result.Tables[2].Rows[0][ColumnNames.InsulationTotal].ToString()); item.IsInsulation = bool.Parse(result.Tables[2].Rows[0][ColumnNames.IsInsulate].ToString()); } } catch (Exception ex) { Logger.LogException(ex); } return item; }
private static void SaveLineItemInsulationDetails(string quoteNubmer, int lineID, NewQuoteItemEntity currentLineItem) { try { List<SqlParameter> allParameters; allParameters = new List<SqlParameter>(); SqlParameter tempParameter = new SqlParameter() { ParameterName = "QuoteNumber", Value = quoteNubmer }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "LineID", Value = lineID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "GlassType1Index", Value = currentLineItem.GlassType1.GlassTypeID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Thickness1Index", Value = currentLineItem.GlassType1.ThicknessID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "IsTemp1", Value = currentLineItem.GlassType1.IsTempered }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Sqft", Value = currentLineItem.GlassType1.SqFt }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Total1", Value = currentLineItem.GlassType1.Total }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Total2", Value = currentLineItem.GlassType2.Total }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "GlassType2Index", Value = currentLineItem.GlassType2.GlassTypeID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Thickness2Index", Value = currentLineItem.GlassType2.ThicknessID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "IsTemp2", Value = currentLineItem.GlassType2.IsTempered }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "MaterialCost", Value = currentLineItem.MaterialCost }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "InsulationTier", Value = currentLineItem.InsulationTier }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "InsulationTierTotal", Value = currentLineItem.InsulationTierTotal }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "InsulationTotal", Value = currentLineItem.InsulationTotal }; allParameters.Add(tempParameter); var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.InsertLineItemInsulationDetails, allParameters.ToArray()); } catch (Exception ex) { Logger.LogException(ex); } }
private static void SaveLineItemCutoutDetails(string quoteNubmer, int lineID, NewQuoteItemEntity currentLineItem) { try { List<SqlParameter> allParameters; foreach (CutoutData item in currentLineItem._allCutoutData) { allParameters = new List<SqlParameter>(); SqlParameter tempParameter = new SqlParameter() { ParameterName = "QuoteNumber", Value = quoteNubmer }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "LineID", Value = lineID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Quantity", Value = item.Quantity }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Width", Value = item.Width }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Height", Value = item.Height }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Price", Value = item.Price }; allParameters.Add(tempParameter); var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.InsertLineCutoutDetails, allParameters.ToArray()); } } catch (Exception ex) { Logger.LogException(ex); } }
internal static void SaveQuoteItems(string quoteNumber, ObservableCollection<QuoteGridEntity> allQuoteData, ObservableCollection<NewQuoteItemEntity> allLineItems) { try { SqlParameter pQuoteNumber = new SqlParameter(); pQuoteNumber.ParameterName = "QuoteNumber"; pQuoteNumber.Value = quoteNumber; SqlParameter pLineID = null; SqlParameter pQuantity = null; SqlParameter pDescription = null; SqlParameter pDimension = null; SqlParameter pSqFt = null; SqlParameter pPricePerUnit = null; SqlParameter pTotal = null; SqlParameter pActualDescription = null; SqlParameter pActualDimension = null; SqlParameter pActualTotalSQFT = null; SqlParameter pIsLogo = null; SqlParameter pShape = null; SqlParameter pIsPolish = null; SqlParameter pIsDrills = null; SqlParameter pIsWaterjet = null; SqlParameter pIsTemper = null; SqlParameter pIsInsulate = null; int counter = 0; NewQuoteItemEntity currentLineItem = new NewQuoteItemEntity(); foreach (QuoteGridEntity item in allQuoteData) { pQuantity = new SqlParameter(); pQuantity.ParameterName = "Quantity"; pQuantity.Value = item.Quantity; pLineID = new SqlParameter(); pLineID.ParameterName = "LineID"; pLineID.Value = item.LineID; pDescription = new SqlParameter(); pDescription.ParameterName = "Description"; pDescription.Value = item.Description; pDimension = new SqlParameter(); pDimension.ParameterName = "Dimension"; pDimension.Value = item.Dimension; pSqFt = new SqlParameter(); pSqFt.ParameterName = "SqFt"; pSqFt.Value = double.Parse(item.TotalSqFt.ToString()); pPricePerUnit = new SqlParameter(); pPricePerUnit.ParameterName = "PricePerUnit"; pPricePerUnit.Value = double.Parse(item.UnitPrice); pTotal = new SqlParameter(); pTotal.ParameterName = "Total"; pTotal.Value = item.Total; pActualDescription = new SqlParameter(); pActualDescription.ParameterName = "ActualDescription"; pActualDescription.Value = item.ActualDescription ?? item.Description; pActualDimension = new SqlParameter(); pActualDimension.ParameterName = "ActualDimension"; pActualDimension.Value = item.ActualDimension ?? item.Dimension; pActualTotalSQFT = new SqlParameter(); pActualTotalSQFT.ParameterName = "ActualTotalSQFT"; pActualTotalSQFT.Value = item.ActualTotalSQFT.ToString("0.00") ?? item.TotalSqFt.ToString("0.00"); pIsLogo = new SqlParameter(); pIsLogo.ParameterName = "IsLogo"; pIsLogo.Value = item.IsLogo; pShape = new SqlParameter(); pShape.ParameterName = "Shape"; pShape.Value = item.Shape ?? "Square"; pIsPolish = new SqlParameter(); pIsPolish.ParameterName = "IsPolish"; pIsPolish.Value = item.IsPolish; pIsDrills = new SqlParameter(); pIsDrills.ParameterName = "IsDrills"; pIsDrills.Value = item.IsDrill; pIsWaterjet = new SqlParameter(); pIsWaterjet.ParameterName = "IsWaterjet"; pIsWaterjet.Value = item.IsWaterJet; pIsTemper = new SqlParameter(); pIsTemper.ParameterName = "IsTemper"; pIsTemper.Value = item.IsTemper; pIsInsulate = new SqlParameter(); pIsInsulate.ParameterName = "IsInsulate"; pIsInsulate.Value = item.IsInsulate; SQLHelper.ExecuteStoredProcedure(StoredProcedures.InsertQuoteLineItem, pLineID, pQuoteNumber, pQuantity, pDescription, pDimension, pSqFt, pPricePerUnit, pTotal, pActualTotalSQFT, pIsLogo, pShape , pIsPolish, pIsDrills, pIsWaterjet, pIsTemper, pIsInsulate); // Save line item details currentLineItem = allLineItems[counter]; SaveLineItemDetails(quoteNumber, item.LineID, currentLineItem); SaveLineItemCutoutDetails(quoteNumber, item.LineID, currentLineItem); SaveLineItemInsulationDetails(quoteNumber, item.LineID, currentLineItem); counter++; } } catch (Exception ex) { Logger.LogException(ex); } }
internal static void SaveLineItemDetails(string quoteNubmer, int lineID, NewQuoteItemEntity currentLineItem) { try { List<SqlParameter> allParameters = new List<SqlParameter>(); SqlParameter tempParameter = new SqlParameter() { ParameterName = "QuoteNumber", Value = quoteNubmer }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "LineID", Value = lineID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "SelectedGlassIndex", Value = currentLineItem.GlassTypeID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "SelectedThicknessIndex", Value = currentLineItem.ThicknessID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "IsLogo", Value = currentLineItem.IsLogoRequired }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "IsTempered", Value = currentLineItem.IsTempered }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "SelectedShapeIndex", Value = currentLineItem.ShapeID }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ActualWidth", Value = currentLineItem.GlassWidth }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ActualWidthFraction", Value = currentLineItem.GlassWidthFraction }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ActualHeight", Value = currentLineItem.GlassHeight }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ActualHeightFraction", Value = currentLineItem.GlassHeightFraction }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Quantity", Value = currentLineItem.Quantity }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ActualTotalSqft", Value = currentLineItem.TotalSqFT }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ChargedWidth", Value = currentLineItem.GlassWidthCharged }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ChargedHeight", Value = currentLineItem.GlassHeightCharged }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "ChargedTotal", Value = currentLineItem.TotalSqFTCharged }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "StraightTotalPolish", Value = currentLineItem.StraightPolishTotalInches }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "StraightLongSide", Value = currentLineItem.StraightPolishLongSide }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "StraightShortSide", Value = currentLineItem.StraightPolishShortSide }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "CustomTotalPolish", Value = currentLineItem.CustomPolishTotalInches }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "MiterTotalPolish", Value = currentLineItem.MiterTotalInches }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "MiterLongSide", Value = currentLineItem.MiterLongSide }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "MiterShortSide", Value = currentLineItem.MiterShortSide }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Notches", Value = currentLineItem.Notches }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Patches", Value = currentLineItem.Patches }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Holes", Value = currentLineItem.Holes }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "Hinges", Value = currentLineItem.Hinges }; allParameters.Add(tempParameter); tempParameter = new SqlParameter() { ParameterName = "CutoutTotal", Value = currentLineItem.CutoutTotal }; allParameters.Add(tempParameter); var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.InsertLineItemDetails, allParameters.ToArray()); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) return; } catch (Exception ex) { Logger.LogException(ex); } }