示例#1
0
        public void Insert4Outs(List <CheckModel> _listCheck, frmMain _mainform)
        {
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_listCheck, _mainform._batchfile);

            db.SaveToMDB(_listCheck, _mainform._batchfile);
        }
示例#2
0
        //string outputForlder = "\\\\192.168.0.254\\captive\\Auto\\IslaBank\\Test";
        public void PackingText(List <CheckModel> _checksModel, frmMain _mainForm)
        {
            StreamWriter file;
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_checksModel, _mainForm._batchfile);
            var listofcheck = _checksModel.Select(e => e.ChkType).ToList();

            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "A")
                {
                    string packkingListPath = outputForlder + "\\Regular Checks\\PackingA.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "PERSONAL", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "B")
                {
                    string packkingListPath = outputForlder + "\\Regular Checks\\PackingB.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "COMMERCIAL", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "MC")
                {
                    string packkingListPath = outputForlder + "\\MC\\PackingM.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "MANAGER'S CHECK", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "MC_CONT")
                {
                    string packkingListPath = outputForlder + "\\MC\\PackingMC.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "MANAGER'S CHECK CONTINUES", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }

            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "SR")
                {
                    string packkingListPath = outputForlder + "\\Self_Responding_Ticket\\PackingS.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "SELF RESPONDING TICKET", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string Scheck in listofcheck)
            {
                if (Scheck == "TD")
                {
                    string packkingListPath = outputForlder + "\\Time_Deposit\\PackingT.txt";
                    if (File.Exists(packkingListPath))
                    {
                        File.Delete(packkingListPath);
                    }
                    var checks = _checksModel.Where(a => a.ChkType == Scheck).Distinct().ToList();
                    file = File.CreateText(packkingListPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(packkingListPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToPackingList(checks, "TIME DEPOSIT", _mainForm);

                        file.WriteLine(output);
                    }
                }
            }
        }
示例#3
0
        public void PrinterFile(List <CheckModel> _checkModel, frmMain _mainForm)
        {
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_checkModel, _mainForm._batchfile);
            StreamWriter file;

            var listofchecks = _checkModel.Select(e => e.ChkType).Distinct().ToList();

            foreach (string checktype in listofchecks)
            {
                if (checktype == "A")
                {
                    string printerFilePathA = Application.StartupPath + "\\Output\\Regular Checks\\ISL" + _mainForm._batchfile.Substring(0, 4) + "P." + DateTime.Now.ToString("yy") + "P";
                    var    check            = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePathA))
                    {
                        File.Delete(printerFilePathA);
                    }

                    file = File.CreateText(printerFilePathA);
                    file.Close();

                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePathA, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }
            foreach (string checktype in listofchecks)
            {
                if (checktype == "B")
                {
                    string printerFilePath = Application.StartupPath + "\\Output\\Regular Checks\\ISL" + _mainForm._batchfile.Substring(0, 4) + "C." + DateTime.Now.ToString("yy") + "P";
                    var    check           = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePath))
                    {
                        File.Delete(printerFilePath);
                    }

                    file = File.CreateText(printerFilePath);
                    file.Close();
                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePath, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }
            foreach (string checktype in listofchecks)
            {
                if (checktype == "MC")
                {
                    string printerFilePath = Application.StartupPath + "\\Output\\MC\\MC" + _mainForm._batchfile.Substring(0, 4) + "M." + DateTime.Now.ToString("yy") + "P";
                    var    check           = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePath))
                    {
                        File.Delete(printerFilePath);
                    }

                    file = File.CreateText(printerFilePath);
                    file.Close();
                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePath, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }
            foreach (string checktype in listofchecks)
            {
                if (checktype == "MC_CONT")
                {
                    string printerFilePath = Application.StartupPath + "\\Output\\MC\\MC" + _mainForm._batchfile.Substring(0, 4) + "MC." + DateTime.Now.ToString("yy") + "P";
                    var    check           = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePath))
                    {
                        File.Delete(printerFilePath);
                    }

                    file = File.CreateText(printerFilePath);
                    file.Close();
                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePath, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }
            foreach (string checktype in listofchecks)
            {
                if (checktype == "SR")
                {
                    string printerFilePath = Application.StartupPath + "\\Output\\Self_Responding_Ticket\\ISL" + _mainForm._batchfile.Substring(0, 4) + "S." + DateTime.Now.ToString("yy") + "P";
                    var    check           = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePath))
                    {
                        File.Delete(printerFilePath);
                    }

                    file = File.CreateText(printerFilePath);
                    file.Close();
                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePath, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }

            foreach (string checktype in listofchecks)
            {
                if (checktype == "TD")
                {
                    string printerFilePath = Application.StartupPath + "\\Output\\Time_Deposit\\ISL" + _mainForm._batchfile.Substring(0, 4) + "T." + DateTime.Now.ToString("yy") + "P";
                    var    check           = _checkModel.Where(e => e.ChkType == checktype).ToList();
                    if (File.Exists(printerFilePath))
                    {
                        File.Delete(printerFilePath);
                    }

                    file = File.CreateText(printerFilePath);
                    file.Close();
                    for (int a = 0; a < check.Count; a++)
                    {
                        using (file = new StreamWriter(File.Open(printerFilePath, FileMode.Append)))
                        {
                            string output = ChecOutputServices.ConvertToPrinterFormat1(check[a].BRSTN, check[a].AccountNo, long.Parse(check[a].StartSeries), check[a].Qty, check[a].Name1, check[a].Name2, check[a].Address1, check[a].Address2, check[a].Address3, check[a].Address4, check[a].Address5, check[a].Address6, check[a].Address1, "A");

                            file.WriteLine(output);
                        }
                    }
                    ZipFileServices.CopyPrinterFile(checktype, _mainForm);
                    ZipFileServices.CopyPackingDBF(checktype, _mainForm);
                }
            }
        }
示例#4
0
        public void SavePackingDBF(List <CheckModel> _list, frmMain _mainForm)
        {
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_list, _mainForm._batchfile);
        }
示例#5
0
        // string outputForlder = "\\\\192.168.0.254\\captive\\Auto\\IslaBank\\Test";
        public void ProcessCheck(List <CheckModel> _checkm, frmMain _mainForm)
        {
            string       doBlockPath;
            StreamWriter file;
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_checkm, _mainForm._batchfile);
            var chkList = _checkm.Select(e => e.ChkType).Distinct().ToList();

            foreach (string chk in chkList)
            {
                doBlockPath = Application.StartupPath + "\\Output\\Regular Checks\\BlockP.txt";

                if (chk == "A")
                {
                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    var chkA = _checkm.Where(e => e.ChkType == chk).ToList();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkA, "PERSONAL", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string chk in chkList)
            {
                if (chk == "B")
                {
                    var chkB = _checkm.Where(e => e.ChkType == chk).ToList();
                    doBlockPath = Application.StartupPath + "\\Output\\Regular Checks\\BlockC.txt";
                    //    db.GetAllData(_checkModel, _mainForm._batchfile);
                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkB, "COMMERCIAL", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string chk in chkList)
            {
                if (chk == "MC")
                {
                    var chkB = _checkm.Where(e => e.ChkType == chk).ToList();
                    doBlockPath = Application.StartupPath + "\\Output\\MC\\BlockM.txt";
                    //db.GetAllData(_checkModel, _mainForm._batchfile);
                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkB, "MANAGER'S CHECK", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string chk in chkList)
            {
                if (chk == "MC_CONT")
                {
                    var chkB = _checkm.Where(e => e.ChkType == chk).ToList();
                    doBlockPath = Application.StartupPath + "\\Output\\MC\\BlockMC.txt";
                    //   db.GetAllData(_checkModel, _mainForm._batchfile);
                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkB, "MANAGER'S CHECK CONTINUES", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string chk in chkList)
            {
                if (chk == "SR")
                {
                    // db.GetAllData(_checkModel, _mainForm._batchfile);
                    var chkB = _checkm.Where(e => e.ChkType == chk).ToList();
                    doBlockPath = Application.StartupPath + "\\Output\\Self_Responding_Ticket\\BlockS.txt";

                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkB, "SELF RESPONDING TICKET", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
            foreach (string chk in chkList)
            {
                if (chk == "TD")
                {
                    var chkB = _checkm.Where(e => e.ChkType == chk).ToList();
                    doBlockPath = Application.StartupPath + "\\Output\\Time_Deposit\\BlockT.txt";
                    //  db.GetAllData(_checkModel, _mainForm._batchfile);
                    if (File.Exists(doBlockPath))
                    {
                        File.Delete(doBlockPath);
                    }

                    file = File.CreateText(doBlockPath);
                    file.Close();

                    using (file = new StreamWriter(File.Open(doBlockPath, FileMode.Append)))
                    {
                        string output = ChecOutputServices.ConvertToBlockText(chkB, "TIME DEPOSIT", _mainForm._batchfile, _mainForm.deliveryDate, frmLogIn._userName, _mainForm.fileName);

                        file.WriteLine(output);
                    }
                }
            }
        }
示例#6
0
        public void SaveToPackingDBF(List <CheckModel> _checks, string _batchNumber, frmMain _mainForm)
        {
            string dbConnection;
            string tempCheckType = "";
            int    blockNo = 0, blockCounter = 0;
            DatabaseConnectionsServices db = new DatabaseConnectionsServices();

            db.GetAllData(_checks, _mainForm._batchfile);

            var listofchecks = _checks.Select(e => e.ChkType).Distinct().ToList();

            foreach (string checktype in listofchecks)
            {
                if (checktype == "A" || checktype == "B")
                {
                    dbConnection = "Provider=VfpOleDB.1; Data Source=" + Application.StartupPath + "\\Output\\Regular Checks\\Packing.dbf" + "; Mode=ReadWrite;";

                    //Check if packing file exists
                    //if (!File.Exists(_filepath))
                    //{
                    OleDbConnection oConnect = new OleDbConnection(dbConnection);
                    OleDbCommand    oCommand;
                    oConnect.Open();
                    oCommand = new OleDbCommand("DELETE FROM PACKING", oConnect);
                    oCommand.ExecuteNonQuery();
                    foreach (var check in _checks)
                    {
                        if (tempCheckType != check.ChkType)
                        {
                            blockNo = 1;
                        }

                        tempCheckType = check.ChkType;

                        if (blockCounter < 4)
                        {
                            blockCounter++;
                        }
                        else
                        {
                            blockCounter = 1;
                            blockNo++;
                        }

                        string sql = "INSERT INTO PACKING (BATCHNO, BLOCK, RT_NO, BRANCH, ACCT_NO, ACCT_NO_P, CHKTYPE, ACCT_NAME1, ACCT_NAME2," +
                                     "NO_BKS, CK_NO_P, CK_NO_B, CK_NOE, CK_NO_E, DELIVERTO, M) VALUES('" + _batchNumber + "'," + blockNo.ToString() + ",'" + check.BRSTN + "','" + check.BranchName +
                                     "','" + check.AccountNo + "','" + check.AccountNo + "','" + check.ChkType + "','" + check.Name1.Replace("'", "''") + "','" + check.Name2.Replace("'", "''") + "',1," +
                                     check.StartSeries + ",'" + check.StartSeries + "'," + check.EndSeries + ",'" + check.EndSeries + "','R', '')";

                        oCommand = new OleDbCommand(sql, oConnect);

                        oCommand.ExecuteNonQuery();
                    }
                    oConnect.Close();
                }
            }
            foreach (string checktype in listofchecks)
            {
                if (checktype == "MC" || checktype == "MC_CONT")
                {
                    dbConnection = "Provider=VfpOleDB.1; Data Source=" + Application.StartupPath + "\\Output\\MC\\Packing.dbf" + "; Mode=ReadWrite;";

                    //Check if packing file exists
                    //if (!File.Exists(_filepath))
                    //{
                    OleDbConnection oConnect = new OleDbConnection(dbConnection);
                    OleDbCommand    oCommand;
                    oConnect.Open();
                    oCommand = new OleDbCommand("DELETE FROM PACKING", oConnect);
                    oCommand.ExecuteNonQuery();
                    foreach (var check in _checks)
                    {
                        if (tempCheckType != check.ChkType)
                        {
                            blockNo = 1;
                        }

                        tempCheckType = check.ChkType;

                        if (blockCounter < 4)
                        {
                            blockCounter++;
                        }
                        else
                        {
                            blockCounter = 1;
                            blockNo++;
                        }

                        string sql = "INSERT INTO PACKING (BATCHNO, BLOCK, RT_NO, BRANCH, ACCT_NO, ACCT_NO_P, CHKTYPE, ACCT_NAME1, ACCT_NAME2," +
                                     "NO_BKS, CK_NO_P, CK_NO_B, CK_NOE, CK_NO_E, DELIVERTO, M) VALUES('" + _batchNumber + "'," + blockNo.ToString() + ",'" + check.BRSTN + "','" + check.BranchName +
                                     "','" + check.AccountNo + "','" + check.AccountNo + "','" + check.ChkType + "','" + check.Name1.Replace("'", "''") + "','" + check.Name2.Replace("'", "''") + "',1," +
                                     check.StartSeries + ",'" + check.StartSeries + "'," + check.EndSeries + ",'" + check.EndSeries + "','R', '')";

                        oCommand = new OleDbCommand(sql, oConnect);

                        oCommand.ExecuteNonQuery();
                    }
                    oConnect.Close();
                }
            }

            foreach (string checktype in listofchecks)
            {
                if (checktype == "SR")
                {
                    dbConnection = "Provider=VfpOleDB.1; Data Source=" + Application.StartupPath + "\\Output\\Self_Responding_Ticket\\Packing.dbf" + "; Mode=ReadWrite;";

                    //Check if packing file exists
                    //if (!File.Exists(_filepath))
                    //{
                    OleDbConnection oConnect = new OleDbConnection(dbConnection);
                    OleDbCommand    oCommand;
                    oConnect.Open();
                    oCommand = new OleDbCommand("DELETE FROM PACKING", oConnect);
                    oCommand.ExecuteNonQuery();
                    foreach (var check in _checks)
                    {
                        if (tempCheckType != check.ChkType)
                        {
                            blockNo = 1;
                        }

                        tempCheckType = check.ChkType;

                        if (blockCounter < 4)
                        {
                            blockCounter++;
                        }
                        else
                        {
                            blockCounter = 1;
                            blockNo++;
                        }

                        string sql = "INSERT INTO PACKING (BATCHNO, BLOCK, RT_NO, BRANCH, ACCT_NO, ACCT_NO_P, CHKTYPE, ACCT_NAME1, ACCT_NAME2," +
                                     "NO_BKS, CK_NO_P, CK_NO_B, CK_NOE, CK_NO_E, DELIVERTO, M) VALUES('" + _batchNumber + "'," + blockNo.ToString() + ",'" + check.BRSTN + "','" + check.BranchName +
                                     "','" + check.AccountNo + "','" + check.AccountNo + "','" + check.ChkType + "','" + check.Name1.Replace("'", "''") + "','" + check.Name2.Replace("'", "''") + "',1," +
                                     check.StartSeries + ",'" + check.StartSeries + "'," + check.EndSeries + ",'" + check.EndSeries + "','R', '')";

                        oCommand = new OleDbCommand(sql, oConnect);

                        oCommand.ExecuteNonQuery();
                    }
                    oConnect.Close();
                }
            }

            foreach (string checktype in listofchecks)
            {
                if (checktype == "TD")
                {
                    dbConnection = "Provider=VfpOleDB.1; Data Source=" + Application.StartupPath + "\\Output\\Time_Deposit\\Packing.dbf" + "; Mode=ReadWrite;";

                    //Check if packing file exists
                    //if (!File.Exists(_filepath))
                    //{
                    OleDbConnection oConnect = new OleDbConnection(dbConnection);
                    OleDbCommand    oCommand;
                    oConnect.Open();
                    oCommand = new OleDbCommand("DELETE FROM PACKING", oConnect);
                    oCommand.ExecuteNonQuery();
                    foreach (var check in _checks)
                    {
                        if (tempCheckType != check.ChkType)
                        {
                            blockNo = 1;
                        }

                        tempCheckType = check.ChkType;

                        if (blockCounter < 4)
                        {
                            blockCounter++;
                        }
                        else
                        {
                            blockCounter = 1;
                            blockNo++;
                        }

                        string sql = "INSERT INTO PACKING (BATCHNO, BLOCK, RT_NO, BRANCH, ACCT_NO, ACCT_NO_P, CHKTYPE, ACCT_NAME1, ACCT_NAME2," +
                                     "NO_BKS, CK_NO_P, CK_NO_B, CK_NOE, CK_NO_E, DELIVERTO, M) VALUES('" + _batchNumber + "'," + blockNo.ToString() + ",'" + check.BRSTN + "','" + check.BranchName +
                                     "','" + check.AccountNo + "','" + check.AccountNo + "','" + check.ChkType + "','" + check.Name1.Replace("'", "''") + "','" + check.Name2.Replace("'", "''") + "',1," +
                                     check.StartSeries + ",'" + check.StartSeries + "'," + check.EndSeries + ",'" + check.EndSeries + "','R', '')";

                        oCommand = new OleDbCommand(sql, oConnect);

                        oCommand.ExecuteNonQuery();
                    }
                    oConnect.Close();
                }
            }
        }