public ActionResult TrialBal(FormCollection fc) { GenHelper g = new GenHelper(); DataSet ds = new DataSet(); String repname = "TrialBalance"; String Tblname = "mytrialbal"; DBClass.NonQuery("drop table " + Tblname); Reports rp = new Reports(); String Mon = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToInt32(fc["mon"])); String Stdate = fc["year"] + "-" + fc["mon"] + "-" + "01"; DateTime sd = DateTime.Parse(Stdate); DateTime ed = sd.AddMonths(1); ed = ed.AddDays(-1); String edate = g.SqlDate(ed.ToString()); DataTable trbal = rp.PrepareTraialBal(Tblname, Stdate, edate); String SumQry = "select sum(receipts) as TotalCredits,sum(payments) as TotalDebits from " + Tblname; DataTable sumdt = DBClass.GetData(SumQry); ds.Tables.Add(trbal); ds.Tables.Add(sumdt); float[] cols = new float[] { 60f, 180f, 65f, 65f, 65f, 65f }; String path = Server.MapPath("/pdfs/trialbalance.pdf"); String[] rephead = new String[] { "N.EW.K.R.T.C Hubli", "Trial Balance For the Month of " + Mon + " " + fc["year"] }; String[] tblhead = new string[] { "Account Number", "Account Name", "Opening Balance", "Receipts", "Payments", "Closing Balance" }; pdf ph = new pdf(ds, cols, rephead, tblhead, path, repname, Tblname); ph.GenerateReport(); //String DropQry = "drop table " + Tblname; //DBClass.NonQuery(DropQry); return(File(path, "application/pdf")); }
public async Task <ActionResult <pdf> > Postpdf(pdf pdf) { _context.pdfs.Add(pdf); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(Getpdf), new pdf { Id = pdf.Id }, pdf)); }
public IActionResult Editor(string editor) { pdf modeldata = new pdf(); modeldata.body = editor; return(new ViewAsPdf("_pdfPartial", modeldata) { FileName = "MyPdfFile.pdf" }); }
public async Task <IActionResult> Putpdf(long id, pdf pdf) { if (id != pdf.Id) { return(BadRequest()); } _context.Entry(pdf).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); }
public ActionResult pdf() { DataSet ds = new DataSet(); int[] sumcolindex = { 3, 4, 5, 6 }; float[] cols = new float[] { 35f, 40f, 220f, 50f, 50f, 50f, 50f, 50f }; String path = Server.MapPath("/pdfs/test.pdf"); String[] rephead = new String[] { "N.EW.K.R.T.C Hubli", "Account List " }; String[] tblhead = new String[] { "Account Id", "Account Number", "Account Name", "Parent Id", "Group Id", "Section Id", "Allow", "Active" }; DataTable dt = DBClass.GetData("select * from account_master"); ds.Tables.Add(dt); pdf ph = new pdf(ds, cols, rephead, tblhead, path); ph.GenerateReport(); return(File(path, "application/pdf")); }
public ActionResult printrp(FormCollection fc) { DataSet ds = new DataSet(); String repname = "ReceiptPayment"; Reports rs = new Reports(); GenHelper g = new GenHelper(); float[] cols = new float[] { 40f, 220f, 60f, 60f }; String path = Server.MapPath("/pdfs/receiptpayments.pdf"); String[] rephead = new String[] { "N.EW.K.R.T.C Hubli", "Receipts & Payments From " + fc["stdate"] + " To " + fc["edate"] }; String[] tblhead = new string[] { "Account Number", "Account Name", "Receipts", "Payments" }; DataTable dt = rs.GetRpData(fc["stdate"], fc["edate"]); ds.Tables.Add(dt); DataTable dt1 = DBClass.GetData("select sum(cramount) receipts,sum(dramount) payments from accounttrans where trdate>='" + g.SqlDate(fc["stdate"]) + "' and trdate<='" + g.SqlDate(fc["edate"]) + "' and divid=1"); ds.Tables.Add(dt1); pdf ph = new pdf(ds, cols, rephead, tblhead, path, repname); ph.GenerateReport(); return(File(path, "application/pdf")); }
public ActionResult pl() { Reports r = new Reports(); GenHelper g = new GenHelper(); DataSet ds = new DataSet(); String repname = "placc"; String Tblname = "mytrialbal"; DataTable tb = r.PrepareTraialBal(Tblname, "2018-06-01", "2018-06-30"); DataTable pltab = r.GetPLAccount(); String SumQry = "select (select sum(amount) from receipts ) as receipts,(select sum(amount) from payments) as payments"; DataTable sumdt = DBClass.GetData(SumQry); ds.Tables.Add(pltab); ds.Tables.Add(sumdt); float[] cols = new float[] { 65f, 120f, 65f, 65f, 120f, 65f }; String path = Server.MapPath("/pdfs/pandlaccount.pdf"); String[] rephead = new String[] { "N.EW.K.R.T.C Hubli", "Trial Balance For the Year " }; String[] tblhead = new string[] { "Account Number", "Account Name", "Amount", "Account Number", "Account Name", "Amount" }; pdf ph = new pdf(ds, cols, rephead, tblhead, path, repname, Tblname); ph.GenerateReport(); return(File(path, "application/pdf")); }
public Contents() { var s = new Label { HorizontalTextAlignment = Xamarin.Forms.TextAlignment.Center, Text = "Hertfordshire Primary Care", TextColor = Color.FromHex("1760ae"), Font = Font.SystemFontOfSize(20, FontAttributes.Bold) }; Title = "Hertfordshire primary care"; var t = new Label { HorizontalTextAlignment = Xamarin.Forms.TextAlignment.Center, Text = "Antibiotics Guidelines ", TextColor = Color.FromHex("1760ae"), Font = Font.SystemFontOfSize(20, FontAttributes.Bold) }; var u = new Label { Text = "", TextColor = Color.FromHex("1760ae"), FontSize = 10 }; // var u = new Label { Text = "Antibiotics Guidelines" , TextColor = Color.FromHex("1760ae"), FontSize = 10 }; // Title = "Contents"; NavigationPage.SetHasNavigationBar(this, true); // var pharm = database.GetContents(); // BackgroundColor = Color.White; BackgroundColor = Color.FromHex("bdd1f6"); var data = new List <GetFrontPage> { new GetFrontPage("Treatment Guidelines", "guidelines.png"), new GetFrontPage("What's new in this version", "whatsnew.png"), // new GetFrontPage ("About this app","about.png"), new GetFrontPage("Restricted Antibiotics", "restricted.png"), new GetFrontPage("Penicillin allergy", "penicillin.png"), new GetFrontPage("Principles of Treatment", "principles.png"), new GetFrontPage("About these guidelines", "about_guideline.png"), // new GetFrontPage ( "Full (pdf) version of the guidelines","pdf.png" ), new GetFrontPage("Feedback", "Feedback.png"), // new GetFrontPage ( "Clostridium difficile infection","cdiff.jpg" ), // new GetFrontPage ( "CRP testing","CRP.png" ), // new GetFrontPage ( "Specific Drug Warnings","warning.png" ), // new GetFrontPage( "(HCT) Guidance","HCT.png"), // new GetFrontPage( "(HCT) Start Smart Then Focus","startsmart.jpg" ), // new GetFrontPage ( "(HCT) Telephone Prescribing","telephone.jpg" ), // new GetFrontPage ( "(HCT) IV to oral stepdown","iv.jpg" ), // new GetFrontPage ( "(HCT) Gentamicin prescribing","gentamicin.jpg" ), //new GetFrontPage ( "(HCT) Gentamicin prescribing","icon.png" ), // new GetFrontPage ( "School Information","school.png"), }; _pharmacylist = new ListView { BackgroundColor = Color.FromHex("bdd1f6"), SeparatorColor = Color.FromHex("#ddd"), }; _pharmacylist.ItemsSource = data; var cell = new DataTemplate(typeof(ImageCell)); cell.SetValue(TextCell.TextColorProperty, Color.FromHex("1760ae")); // cell.SetValue(TextCell.TextProperty, ); cell.SetBinding(TextCell.TextProperty, "Name"); cell.SetBinding(ImageCell.ImageSourceProperty, "Image"); _pharmacylist.ItemTemplate = cell; // _pharmacylist.ItemTemplate = new DataTemplate(typeof(ImageCell)); // _pharmacylist.ItemTemplate.SetBinding(ImageCell.TextProperty, "Name"); // _pharmacylist.ItemTemplate.SetBinding(ImageCell.ImageSourceProperty, "Image"); // _pharmacylist.SetValue(TextCell.TextColorProperty, Color.White); // _pharmacylist.HeightRequest = 500; _pharmacylist.RowHeight = 65; var a = new StackLayout { Orientation = StackOrientation.Vertical, HorizontalOptions = LayoutOptions.CenterAndExpand // Padding = new Thickness (5, 5, 5, 5), }; if (Device.OS == TargetPlatform.Windows) { // Padding = new Thickness (5, 5, 5, 5), a.Children.Add(s); a.Children.Add(t); a.Children.Add(u); NavigationPage.SetHasNavigationBar(this, false); } else { a.Children.Add(t); a.Children.Add(u); } // var p = new StackLayout // { // Padding = 5, // Children = { title } // }; var logo = new StackLayout { Padding = new Thickness(5, 5, 5, 5), Orientation = StackOrientation.Horizontal, Children = { new Image { // BackgroundColor =Color.White, VerticalOptions = LayoutOptions.FillAndExpand, HorizontalOptions = LayoutOptions.StartAndExpand, HeightRequest = 30, // WidthRequest=90, // Aspect = Aspect.AspectFit,//.AspectFit//.Fill Source = ImageSource.FromFile("th.jpg") }, new Image { // BackgroundColor =Color.White, VerticalOptions = LayoutOptions.FillAndExpand, HorizontalOptions = LayoutOptions.EndAndExpand, HeightRequest = 30, // WidthRequest=90, // Aspect = Aspect.AspectFit,//.AspectFit//.Fill Source = ImageSource.FromFile("hbl.png") } } }; var k = new StackLayout { BackgroundColor = Color.FromHex("bdd1f6"), Padding = 5, // BackgroundColor = Color.White, Children = { a, _pharmacylist, logo } }; Content = k; _pharmacylist.ItemSelected += (sender, e) => { if (e.SelectedItem == null) { return; } var user = (GetFrontPage)e.SelectedItem; if (user.Name == "What's new in this version") { var tg = new whats_new(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Feedback") { var tg = new feedback(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Treatment Guidelines") { // var nav= new NavigationPage(new pharmacy(database)); // var nav= new NavigationPage(new area_page(database)); var tg = new area_page(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Restricted Antibiotics") { var tg = new newpage(1); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "About these guidelines") { var tg = new about_guideline(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Principles of Treatment") { var tg = new newpage(2); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Educational Resources") { var tg = new newpage(3); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Full (pdf) version of the guidelines") { var tg = new pdf(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Penicillin allergy") { var tg = new penicillin(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "CRP testing") { var tg = new newpage(5); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "School Information") { var tg = new newpage(6); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (user.Name == "Specific Drug Warnings") { // var tg = new specific_warnings(); // Navigation.PushAsync(tg); } if (user.Name == "(HCT) Guidance") { var tg = new hct_page(); Xamarin.Forms.Device.BeginInvokeOnMainThread(() => Navigation.PushAsync(tg)); } if (e.SelectedItem == null) { return; // don't do anything if we just de-selected the row } // do something with e.SelectedItem ((ListView)sender).SelectedItem = null; // de-select the row }; }