Example #1
0
        //Get Bank Update
        public ActionResult Get_UpdateBanks(FM_GeneralReference_Bank model, int BankID)
        {
            BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();

            model.getBankColumns.BankName = tblBank.BankName;
            return(PartialView("Banks/_UpdateBankTable", model));
        }
Example #2
0
        public void UpdateUI()
        {
            var timeNow = DateTime.Now;

            if ((DateTime.Now - previousTime).Milliseconds <= 50)
            {
                return;
            }

            synchronizationContext.Post(new SendOrPostCallback(o =>
            {
                PopulateCompanyTable();
                PopulateResourceTable();

                PeopleTable.RowCount = ic.AIList.Count + 1;
                PeopleTable.Invalidate();

                if (ShareSaleTable.Visible)
                {
                    PopulateShareSaleTable();
                }

                BankTable.RowCount = ic.bankList.Count + 1;
                BankTable.Invalidate();

                UpdateChart();

                LabourCost.Text = "" + Math.Round(ic.population.labourCost, 3);
                Population.Text = "" + ic.population.people;
                PrintToConsole();
            }), value);

            previousTime = timeNow;
        }
Example #3
0
        //Delete Bank
        public ActionResult DeleteBank(FM_GeneralReference_Bank model, int BankID)
        {
            BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();

            TOSSDB.BankTables.Remove(tblBank);
            TOSSDB.SaveChanges();
            return(RedirectToAction("Index"));
        }
        //Delete Barangay Name
        public ActionResult DeleteBankName(FM_Bank model, int BankID)
        {
            BankTable tblBarangayName = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();

            TOSSDB.BankTables.Remove(tblBarangayName);
            TOSSDB.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #5
0
        //Update Bank
        public ActionResult UpdateBanks(FM_GeneralReference_Bank model)
        {
            BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == model.BankID select e).FirstOrDefault();

            tblBank.BankName = model.getBankColumns.BankName;
            TOSSDB.Entry(tblBank);
            TOSSDB.SaveChanges();
            return(PartialView("Banks/_UpdateBankTable", model));
        }
Example #6
0
        //Add Bank Type
        public JsonResult AddBank(FM_GeneralReference_Bank model)
        {
            BankTable tblBank = new BankTable();

            tblBank.BankName = GlobalFunction.ReturnEmptyString(model.getBankColumns.BankName);
            TOSSDB.BankTables.Add(tblBank);
            TOSSDB.SaveChanges();
            return(Json(tblBank));
        }
        //Get Barangay Name
        public ActionResult Get_UpdateBankName(FM_Bank model, int BankID)
        {
            BankTable tblBarangayName = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();

            model.getBankColumns.BankID      = tblBarangayName.BankID;
            model.getBankColumns.BankName    = tblBarangayName.BankName;
            model.getBankColumns.BankCode    = tblBarangayName.BankCode;
            model.getBankColumns.BankAddress = tblBarangayName.BankAddress;
            return(PartialView("Bank/_UpdateBank", model));
        }
        public JsonResult AddBankName(FM_Bank model)
        {
            BankTable tblBarangayName = new BankTable();

            tblBarangayName.BankName    = model.getBankColumns.BankName;
            tblBarangayName.BankCode    = model.getBankColumns.BankCode;
            tblBarangayName.BankAddress = model.getBankColumns.BankAddress;
            TOSSDB.BankTables.Add(tblBarangayName);
            TOSSDB.SaveChanges();
            return(Json(tblBarangayName));
        }
        public ActionResult UpdateBankName(FM_Bank model)
        {
            BankTable tblBarangayName = (from e in TOSSDB.BankTables where e.BankID == model.getBankColumns.BankID select e).FirstOrDefault();

            tblBarangayName.BankName    = model.getBankColumns.BankName;
            tblBarangayName.BankCode    = model.getBankColumns.BankCode;
            tblBarangayName.BankAddress = model.getBankColumns.BankAddress;
            TOSSDB.Entry(tblBarangayName);
            TOSSDB.SaveChanges();
            return(PartialView("Bank/_UpdateBank", model));
        }
Example #10
0
 public UnitOfWork()
 {
     _database              = new Entities();
     User                   = new UserTables(_database.Users);
     SecurityQuestion       = new SecurityQuestionTables(_database.SecurityQuestions);
     Role                   = new RoleTable(_database.Roles);
     OrganisationTable      = new OrganisationTable(_database.OrganisationDetails);
     BranchTable            = new BranchTable(_database.BrancheDetails);
     BankTable              = new BankTable(_database.BankDetails);
     EmployeeTable          = new EmployeeTable(_database.Employees);
     EmployeeLocationTable  = new EmployeeLocationTable(_database.EmployeeLocations);
     CustomerTable          = new CustomerTable(_database.Customers);
     AccountTable           = new AccountTable(_database.Accounts);
     AccountTypeTable       = new AccountTypeTable(_database.AccountTypes);
     AccessLevelTable       = new AccountAccessLevelTable(_database.AccessLevels);
     UserAccountAccessTable = new UserAccountAccessTable(_database.UserAccountAccesses);
     AccoutTransactionTable = new AccoutTransactionTable(_database.Transactions);
 }
Example #11
0
        public FM_Bank()
        {
            getBank        = new List <BankTable>();
            getBankColumns = new BankTable();
            getBankList    = new List <BankList>();


            getAccountType        = new List <BankAccount_AccountType>();
            getAccountTypeColumns = new BankAccount_AccountType();
            getAccountTypeList    = new List <AccountTypeList>();


            getBankAccount        = new List <BankAccountTable>();
            getBankAccountColumns = new BankAccountTable();
            getBankAccountList    = new List <BankAccountList>();

            globalClasses = new GlobalClasses();
        }
Example #12
0
        private void ExportToPDF(DataSet ds)
        {
            BankTable        BT    = new BankTable();
            PDFFileOperation PDFop = new PDFFileOperation();
            GetDataToProcess GDTP  = new GetDataToProcess();

            //PdfPTable Table = null;
            //Table = new PdfPTable(4);
            Document pdfDoc = new Document(PageSize.A4, 0, 0, 35, 0);

            using (MemoryStream memoryStream = new MemoryStream())
            {
                PdfWriter writer = PdfWriter.GetInstance(pdfDoc, memoryStream);
                pdfDoc.Open();
                //pdfDoc.Add(Table);
                //PdfPTable BankTable = null;
                //BankTable = new PdfPTable(4);

                string FinancialYear = "2020";
                string District      = "Bangalore";
                string Zone          = "BLR";

                string FilePath = Server.MapPath("~/ApplicationProcessFiles/" + FinancialYear + "/ZM/") + "SE" + Zone + District + "_" + FinancialYear + DateTime.Now + ".pdf";
                //BankTable = PDFop.ExportToPDF( ds,  FilePath,  District);
                //pdfDoc.Add(BankTable);



                int          Center    = PdfPCell.ALIGN_CENTER;
                int          VCenter   = PdfPCell.ALIGN_MIDDLE;
                int          Left      = PdfPCell.ALIGN_LEFT;
                PDFCellPrint PCell     = new PDFCellPrint();
                PdfPCell     EmptyCell = new PdfPCell();
                EmptyCell = PCell.PrintCell("", "sans-serif", 10, iTextSharp.text.Font.BOLD, BaseColor.BLACK, 20f, Left, VCenter);
                PDFParagraph PDFP = new PDFParagraph();

                string BankName      = "SBI";
                string BankBranch    = "SBI branch";
                string city          = "Bangalore";
                string AccountNumber = "1111111";
                pdfDoc.Add(PDFP.SingleLineParagraph("\n\n\n\n\n\n\n", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("Date: " + DateTime.Now.ToString("dd MMMM yyyy"), "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_RIGHT, VCenter));
                pdfDoc.Add(PDFP.ToAddressBlock(BankName, BankBranch, city, "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("\n", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("Sir/Madam,", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("\n", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("Sub :- Transfer of amount to the beneficiaries", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_CENTER, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph(" SB Accounts through RTGF/NEFT-reg", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_CENTER, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("***************", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_CENTER, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("\n", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.MainBlock(BankName, BankBranch, "1", AccountNumber, "Arial", 16, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, Left, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("     Thank You,", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_LEFT, VCenter));
                pdfDoc.Add(PDFP.SingleLineParagraph("Your Faithfully     ", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_RIGHT, VCenter));



                pdfDoc.SetPageSize(new Rectangle(1100f, 850f));
                pdfDoc.SetMargins(0, 0, 10, 0);
                pdfDoc.NewPage();

                ReportTableHeading HT           = new ReportTableHeading();
                PdfPTable          HeadingTable = null;
                HeadingTable = new PdfPTable(4);
                //pdfDoc.Add(PDFP.SingleLineParagraph("***************", "Arial", 14, iTextSharp.text.Font.NORMAL, BaseColor.BLACK, PdfPCell.ALIGN_CENTER, VCenter));
                HeadingTable = HT.GenerateHeading(HeadingTable, "Self Employment Loan", FinancialYear, District, Zone);
                pdfDoc.Add(HeadingTable);
                pdfDoc.Add(PDFop.ZMBankTable(GDTP.GetData("spPrintExcel", "SEZMAPPROVEDPRINT", "Bengaluru Dakshina", "Approved List"), "3523"));//print


                pdfDoc.Close();
                byte[] bytes = memoryStream.ToArray();
                memoryStream.Close();
                Response.Clear();

                SaveFile SV = new SaveFile();
                //Arivu_Kalaburgi_Bidar_2020-21_30-03-2021
                SV.SavingFileOnServer(Server.MapPath("~/ApplicationProcessFiles/" + FinancialYear + "/ZM/"), "SE" + Zone + District + "_" + FinancialYear + string.Format("{0:dd-MM-yyyy}", DateTime.Now) + ".pdf", bytes);
                if (File.Exists(FilePath))
                {
                    //SendSMSEmail();
                }
                Response.ContentEncoding = System.Text.Encoding.UTF8;
                Response.AddHeader("Content-Disposition", "attachment; filename=" + "ZM" + "_" + "ZM" + ".pdf");
                Response.ContentType = "application/pdf";
                Response.Buffer      = true;
                Response.Cache.SetCacheability(HttpCacheability.NoCache);
                Response.BinaryWrite(bytes);
                Response.End();
                Response.Close();
            }
        }