//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));
}
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;
}
//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"));
}
//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));
}
//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));
}
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);
}
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();
}
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();
}
}