Exemple #1
0
        public SmartDatabase.VedorName GetVendorName(int i)
        {
            var vn = new SmartDatabase.VedorName();

            if (i == 0)
            {
                vn = SmartDatabase.VedorName.CashPower;
            }
            else if (i == 1)
            {
                vn = SmartDatabase.VedorName.Ims;
            }

            return(vn);
        }
Exemple #2
0
        public string ExceuteVenusCreator()
        {
            var strMessage = string.Empty;

            try
            {
                //Everything happens here
                string   venusCashupSp = File.ReadAllText(string.Format("{0}settings\\venusCashupSP.txt", _settingFile));
                string[] vendors       = File.ReadAllText(string.Format("{0}settings\\vendors.txt", _settingFile)).Split(',');
                int      vendorCount   = vendors.Length;
                int      i             = 0;
                while (i < vendorCount)
                {
                    _stringList.Clear();

                    string vn = vendors[i];
                    switch (vn)
                    {
                    case "MangaungBP":
                        _transactionType     = 14;
                        _vendorName          = SmartDatabase.VedorName.MangaungBP;
                        _whereToAreFileFor   = "MBP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "BelaBela":
                        _transactionType     = 11;
                        _vendorName          = SmartDatabase.VedorName.BelaBela;
                        _whereToAreFileFor   = "BCP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "CashPower":
                        _transactionType     = 3;
                        _vendorName          = SmartDatabase.VedorName.CashPower;
                        _whereToAreFileFor   = "358115";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = true;
                        break;

                    case "Actaris":
                        _transactionType     = 10;
                        _vendorName          = SmartDatabase.VedorName.Actaris;
                        _whereToAreFileFor   = "APP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "IMS":
                        _transactionType     = 1;
                        _vendorName          = SmartDatabase.VedorName.Ims;
                        _whereToAreFileFor   = "178101";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = true;
                        break;

                    case "JHBBP":
                        _transactionType     = 7;
                        _vendorName          = SmartDatabase.VedorName.JHBBP;
                        _whereToAreFileFor   = "JBP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "EkurhuleniBP":
                        _transactionType     = 8;
                        _vendorName          = SmartDatabase.VedorName.EkurhuleniBP;
                        _whereToAreFileFor   = "EBP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = true;
                        break;

                    case "MadibengBP":
                        _transactionType     = 9;
                        _vendorName          = SmartDatabase.VedorName.MadibengBP;
                        _whereToAreFileFor   = "BPM";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "CityPowerCP":
                        _transactionType     = 2;
                        _vendorName          = SmartDatabase.VedorName.CityPowerCP;
                        _whereToAreFileFor   = "CPP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "Grintek":
                        _transactionType     = 6;
                        _vendorName          = SmartDatabase.VedorName.Grintek;
                        _whereToAreFileFor   = "GPP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "Syntell":
                        _transactionType     = 5;
                        _vendorName          = SmartDatabase.VedorName.Syntell;
                        _whereToAreFileFor   = "SPP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "Airtime":
                        _transactionType     = 12;
                        _vendorName          = SmartDatabase.VedorName.Airtime;
                        _whereToAreFileFor   = "SAT";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "CigiCell":
                        _transactionType     = 22;
                        _vendorName          = SmartDatabase.VedorName.CigiCell;
                        _whereToAreFileFor   = "CGC";
                        Form1.FileDefinition = _whereToAreFileFor;
                        _isEkur = false;
                        break;

                    case "KwaDukuza":
                        _transactionType = 15;
                        _vendorName      = SmartDatabase.VedorName.KwaDukuza;
                        _isEkur          = false;
                        _sqno            =
                            Convert.ToInt32(
                                File.ReadAllText(string.Format("{0}settings\\IlembeSequenceNumber.txt", _settingFile)));
                        _sqno++;
                        _ilembeSequenceNumber = _sqno < 10
                                ? string.Format("0{0}", _sqno)
                                : _sqno.ToString(CultureInfo.InvariantCulture);

                        _whereToAreFileFor   = "KBP";
                        Form1.FileDefinition = _whereToAreFileFor;
                        break;
                    }

                    List <string> strList;

                    var cashupList = _sdb.ExecuteVenusCashupStoredProcedure(venusCashupSp, _transactionType.ToString(CultureInfo.InvariantCulture), out strList);

                    Form1.strList = strList;

                    if (cashupList.Count > 0)
                    {
                        strMessage = "OK";
                        var tdl = GetTransactions(cashupList);

                        if (tdl.Count > 0)
                        {
                            CreateVenusFile(tdl);

                            new Reports().CreateReports(cashupList, tdl, _venusFileName,
                                                        _settingFile);
                        }

                        MarkAsProcessed(cashupList);

                        if (_vendorName == SmartDatabase.VedorName.KwaDukuza)
                        {
                            File.WriteAllText(string.Format("{0}settings\\IlembeSequenceNumber.txt", _settingFile),
                                              _sqno.ToString(CultureInfo.InvariantCulture));
                        }
                        tdl.Clear();
                    }
                    else
                    {
                        Form1.EmailNOEmails(vendors[0]);

                        if (!_iscashup)
                        {
                            if (i == vendorCount - 1)
                            {
                                Form1.NoCashups = true;
                                strMessage      = "OK";
                            }
                        }
                    }

                    cashupList.Clear();
                    i++;
                }
            }
            catch (Exception ex)
            {
                strMessage = ex.ToString();
            }

            return(strMessage);
        }