Example #1
0
        //reads the batch order file and returns
        //an array list of orders
        private ArrayList processFile(string fileName, out List <CustomError> alWarnings)
        {
            alWarnings = new List <CustomError>();
            bool bValid = true;

            ArrayList alOrders    = null;
            string    csvFileName = null;

            //no conversion needed if .csv
            if (fileName.Contains(".csv"))
            {
                csvFileName = fileName;
            }
            else
            {
                //convert to .csv
                ApplicationClass ExcelApp = null;
                try
                {
                    ExcelApp = new ApplicationClass();
                    Workbook uploadedWorkBook = ExcelApp.Workbooks.Open(fileName,
                                                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                                                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                                                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                                                                        Type.Missing, Type.Missing);

                    csvFileName = fileName + ".csv";
                    File.Delete(csvFileName);
                    uploadedWorkBook.SaveAs(csvFileName, XlFileFormat.xlCSV,
                                            Type.Missing, Type.Missing,
                                            Type.Missing, Type.Missing,
                                            XlSaveAsAccessMode.xlExclusive, Type.Missing,
                                            Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                    uploadedWorkBook.Close(false, csvFileName, false);
                }
                catch (Exception e)
                {
                    bValid = false;
                    Validators.Add(new CustomError("Error processing .xls file. Contact customer support. Error code 1"));
                    EventLog woeLog = new EventLog("WebOrderEntry");
                    woeLog.Source = "WebOrderEntryApp";
                    string errorMessage = "Message\r\n" + e.Message.ToString() + "\r\n\r\n";
                    errorMessage += "Source\r\n" + e.Source + "\r\n\r\n";
                    errorMessage += "Target site\r\n" + e.TargetSite.ToString() + "\r\n\r\n";
                    errorMessage += "Stack trace\r\n" + e.StackTrace + "\r\n\r\n";
                    errorMessage += "ToString()\r\n\r\n" + e.ToString();
                    woeLog.WriteEntry(errorMessage, EventLogEntryType.Error, 1);
                    return(null);
                }
                finally
                {
                    if (ExcelApp != null)
                    {
                        ExcelApp.Workbooks.Close();
                        ExcelApp.Quit();
                    }
                }
            }

            alOrders = new ArrayList();
            warehouse_shipping_ordersWarehouse_shipping_order eachOrder = null;
            OrderValidation orderValidation = null;
            int             iCurrentRow     = 1;
            string          sCurrentRow     = "1";

            // open the file which is a CSV file with no headers
            using (CsvReader csv = new CsvReader(new StreamReader(csvFileName), false))
            {
                int fieldCount = csv.FieldCount;
                //string[] headers = csv.GetFieldHeaders();

                while (csv.ReadNextRecord())
                {
                    string sEachSegment = csv[0].Trim();

                    switch (sEachSegment)
                    {
                    case "HDR":
                        #region validateHeader
                        // New Order
                        if (orderValidation != null)
                        {
                            eachOrder = orderValidation.getOrder(sCurrentRow);
                            if (eachOrder != null)
                            {
                                alOrders.Add(eachOrder);
                            }
                            else
                            {
                                bValid = false;
                                //Validators.Add(new CustomError("Invalid " + HDR + " field count=" + dr.FieldCount.ToString() + " should be " + HDR_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                                break;
                            }
                        }
                        orderValidation = new OrderValidation(Validators);

                        //set account id from session
                        if (Session["AccountId"] != null)
                        {
                            orderValidation.AccountId = (string)Session["AccountId"];
                        }

                        //process header record
                        //check field count
                        if (csv.FieldCount < HDR_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + HDR + " field count=" + csv.FieldCount.ToString() +
                                                           " should be " + HDR_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }

                        List <CustomError> eachOrderWarningList = orderValidation.validateHeader(csv, sCurrentRow, out bValid);

                        if (eachOrderWarningList.Count > 0)
                        {
                            foreach (CustomError warning in eachOrderWarningList)
                            {
                                alWarnings.Add(warning);
                            }
                        }
                        if (bValid == false)
                        {
                            break;
                        }

                        #endregion
                        break;

                    case "LOC":
                        #region validateLoc
                        //process address record
                        //check field count
                        if (csv.FieldCount < LOC_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + LOC + " field count=" + csv.FieldCount.ToString() + " should be " + LOC_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }
                        if (!orderValidation.validateLoc(csv, sCurrentRow))
                        {
                            bValid = false;
                            break;
                        }
                        #endregion
                        break;

                    case "DET":
                        #region validateDetail
                        //process detail record
                        //check field count
                        if (csv.FieldCount < DET_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + DET + " field count=" + csv.FieldCount.ToString() + " should be " + DET_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }
                        if (!orderValidation.validateDetail(csv, sCurrentRow))
                        {
                            bValid = false;
                            break;
                        }
                        #endregion
                        break;

                    case "ASN":
                        #region validateASN
                        //process asn record
                        //check field count
                        if (csv.FieldCount < ASN_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + ASN + " field count=" + csv.FieldCount.ToString() + " should be " + ASN_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }
                        if (!orderValidation.validateAsn(csv, sCurrentRow))
                        {
                            bValid = false;
                            break;
                        }
                        #endregion
                        break;

                    case "REF":
                        #region validateRefNbr
                        //process header reference record
                        //check field count
                        if (csv.FieldCount < REF_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + REF + " field count=" + csv.FieldCount.ToString() + " should be " + REF_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }
                        if (!orderValidation.validateRef(csv, sCurrentRow))
                        {
                            bValid = false;
                            break;
                        }
                        #endregion
                        break;

                    case "NTE":
                        #region validateRefNbr
                        //process note record
                        //check field count
                        if (csv.FieldCount < NTE_FIELDCOUNT)
                        {
                            bValid = false;
                            Validators.Add(new CustomError("Invalid " + NTE + " field count=" + csv.FieldCount.ToString() + " should be " + NTE_FIELDCOUNT.ToString() + " row " + iCurrentRow + " column A."));
                            break;
                        }
                        if (!orderValidation.validateNote(csv, sCurrentRow))
                        {
                            bValid = false;
                            break;
                        }
                        #endregion
                        break;

                    default:
                        bValid = false;
                        Validators.Add(new CustomError("Invalid Segment Name" + sEachSegment + " - row " + iCurrentRow + " column A."));
                        break;
                    }


                    iCurrentRow++;
                    sCurrentRow = Convert.ToString(iCurrentRow);
                }
            }

            //done with csv file, delete it
            File.Delete(csvFileName);

            //}
            //check/add the last order
            if (bValid)
            {
                eachOrder = orderValidation.getOrder(sCurrentRow);
                if (eachOrder != null)
                {
                    alOrders.Add(eachOrder);
                }
                else
                {
                    bValid = false;
                }
            }

            //return the validated orders arraylist
            if (bValid)
            {
                return(alOrders);
            }
            else
            {
                return(null);
            }
        }