private void btnLastBillPrint_Click(object sender, EventArgs e) { try { DataSet dsLastBillDetails = new BillingRepository().GetLastBill(daySequenceID, billObj.LastBillID); Bill LastBillObj = Utility.GetBill(dsLastBillDetails); rptBill rpt = new rptBill(LastBillObj.dtBillDetails, LastBillObj.dtMopValues); rpt.Parameters["GSTIN"].Value = "37AADFV6514H1Z2"; rpt.Parameters["FSSAI"].Value = "10114004000548"; rpt.Parameters["Address"].Value = Utility.branchinfo.BranchAddress; rpt.Parameters["BillDate"].Value = DateTime.Now; rpt.Parameters["BillNumber"].Value = LastBillObj.BillNumber; rpt.Parameters["BranchName"].Value = Utility.branchinfo.BranchName; rpt.Parameters["CounterName"].Value = Utility.branchinfo.BranchCounterName; rpt.Parameters["Phone"].Value = Utility.branchinfo.PhoneNumber; rpt.Parameters["UserName"].Value = Utility.logininfo.UserFullName; rpt.Parameters["RoundingFactor"].Value = LastBillObj.Rounding; rpt.Parameters["IsDuplicate"].Value = true; rpt.Print(); txtItemCode.Focus(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
public static void Get() { IBillingRepository <Shipper> shippers = new BillingRepository <Shipper>(Help.Context); IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context); DataTable rawData = Help.OpenExcel("Shippers"); int N = 0; foreach (DataRow row in rawData.Rows) { int oldId = Help.getInteger(row, 0); string zip = Help.getString(row, 1); Town town = towns.Get().FirstOrDefault(x => x.Zip == zip); Shipper ship = new Shipper() { Name = Help.getString(row, 2), Address = Help.getString(row, 3), Town = town }; N++; shippers.Insert(ship); shippers.Commit(); Help.dicShip.Add(oldId, ship.Id); } Console.WriteLine(N); }
public List <ReportViewModel> GetReportData(string identification, string entity) { billing = new BillingRepository(); var list = billing.GetReportBaseonParameters(identification, entity); return(list); }
public static void Get() { IBillingRepository <Procurement> procurements = new BillingRepository <Procurement>(Help.Context); IBillingRepository <Supplier> suppliers = new BillingRepository <Supplier>(Help.Context); IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context); DataTable rawData = Help.OpenExcel("Procurements"); int N = 0; foreach (DataRow row in rawData.Rows) { Supplier supplier = suppliers.Get(Help.dicSupp[Help.getInteger(row, 2)]); Product product = products.Get(Help.dicProd[Help.getInteger(row, 3)]); Procurement procurement = new Procurement() { Document = Help.getString(row, 0), Date = Help.getDate(row, 1), Supplier = supplier, Product = product, Quantity = Help.getInteger(row, 4), Price = Help.getDouble(row, 5) }; N++; procurements.Insert(procurement); } procurements.Commit(); Console.WriteLine(N); }
public static void Get() { IBillingRepository <Customer> customers = new BillingRepository <Customer>(Help.Context); IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context); DataTable rawData = Help.OpenExcel("Customers"); int N = 0; foreach (DataRow row in rawData.Rows) { try { int oldId = Help.getInteger(row, 0); string zip = Help.getString(row, 2); Customer customer = new Customer() { Name = Help.getString(row, 1), Address = Help.getString(row, 3), Town = towns.Get().FirstOrDefault(x => x.Zip == zip) }; customers.Insert(customer); customers.Commit(); N++; Help.dicCust.Add(oldId, customer.Id); } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine(N); }
protected void btnAddBillingItem_Click(object sender, EventArgs e) { int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text)); BillingRepository repo = new BillingRepository(); var arrCodeMap = ddlAddCode.SelectedValue.Split(','); decimal billingAmount = 0; decimal payoutAmount = 0; string errorMsg = string.Empty; int codeId = 0; if (bookingId < Constants.InitBookingId) { errorMsg = string.Format("ERROR!!! Invalid bookingId={0}.", bookingId); AlertMessage(errorMsg); } else if (arrCodeMap == null || arrCodeMap.Count() == 0 || !int.TryParse(arrCodeMap[0], out codeId)) { errorMsg = string.Format("ERROR!!! Parsing AccountingCode from input."); AlertMessage(errorMsg); } else if (!decimal.TryParse(txtAddBillingAmount.Text, out billingAmount) || !decimal.TryParse(txtAddPayoutAmount.Text, out payoutAmount)) { errorMsg = string.Format("ERROR!!! INVALID Billing={0} or Payout={1}.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text); AlertMessage(errorMsg); } else if (payoutAmount > billingAmount) { errorMsg = string.Format("ERROR!!! Payout={1} cannot greater than Billing={0} amount.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text); AlertMessage(errorMsg); } else if (billingAmount <= 0 || payoutAmount < 0) { errorMsg = string.Format("ERROR!!! Billing={0} or Payout={1} invalid amount.", txtAddBillingAmount.Text, txtAddPayoutAmount.Text); AlertMessage(errorMsg); } else if (ddlAddVendor.SelectedValue == "0") { errorMsg = string.Format("ERROR!!! Need to choose a vendor."); AlertMessage(errorMsg); } else { if (repo.InsertBillingItem(bookingId, int.Parse(arrCodeMap[0]), 1, txtAddDescription.Text, billingAmount, payoutAmount, int.Parse(ddlAddVendor.SelectedValue.ToString()))) { gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId); gvInvoice.DataBind(); ddlAddCode.SelectedIndex = -1; txtAddDescription.Text = ""; txtAddBillingAmount.Text = ""; txtAddBillingAmount.Enabled = true; txtAddPayoutAmount.Text = ""; txtAddPayoutAmount.Enabled = true; } } }
public static void Get() { IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context); DataTable rawData = Help.OpenExcel("Towns"); int N = 0; foreach (DataRow row in rawData.Rows) { try { Town town = new Town() { Zip = Help.getString(row, 0), Name = Help.getString(row, 1), Region = (Region)Help.getInteger(row, 2) }; N++; towns.Insert(town); } catch (Exception ex) { Console.WriteLine(ex.Message); } } towns.Commit(); Console.WriteLine(N); }
public static void Get() { IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context); DataTable rawData = Help.OpenExcel("Categories"); int N = 0; foreach (DataRow row in rawData.Rows) { try { int oldId = Help.getInteger(row, 0); Category cat = new Category() { Name = Help.getString(row, 1) }; N++; categories.Insert(cat); categories.Commit(); Help.dicCatt.Add(oldId, cat.Id); } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine(N); }
public static void Get() { IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context); IBillingRepository <Shipper> shippers = new BillingRepository <Shipper>(Help.Context); IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context); IBillingRepository <Customer> customers = new BillingRepository <Customer>(Help.Context); DataTable rawData = Help.OpenExcel("Invoices"); int N = 0; foreach (DataRow row in rawData.Rows) { Shipper shipper = shippers.Get(Help.dicShip[Help.getInteger(row, 3)]); Agent agent = agents.Get(Help.dicAgen[Help.getInteger(row, 4)]); Customer customer = customers.Get(Help.dicCust[Help.getInteger(row, 5)]); Invoice invoice = new Invoice() { InvoiceNo = Help.getString(row, 0), Date = Help.getDate(row, 1), ShippedOn = Help.getDate(row, 2), Shipper = shipper, Agent = agent, Customer = customer, Vat = Help.getDouble(row, 6), Shipping = Help.getDouble(row, 7) }; N++; invoices.Insert(invoice); } invoices.Commit(); Console.WriteLine(N); }
public static void Get() { IBillingRepository <Item> items = new BillingRepository <Item>(Help.Context); IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context); IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context); DataTable rawData = Help.OpenExcel("Items"); int N = 0; foreach (DataRow row in rawData.Rows) { string invoiceNo = Help.getString(row, 0); Invoice invoice = invoices.Get().FirstOrDefault(x => x.InvoiceNo == invoiceNo); Product product = products.Get(Help.dicProd[Help.getInteger(row, 1)]); Item item = new Item() { Invoice = invoice, Product = product, Quantity = Help.getInteger(row, 2), Price = Help.getDouble(row, 3) }; N++; items.Insert(item); } items.Commit(); Console.WriteLine(N); }
public static void Get() { IBillingRepository <Event> histories = new BillingRepository <Event>(Help.Context); IBillingRepository <Invoice> invoices = new BillingRepository <Invoice>(Help.Context); int N = 0; DataTable rawData = Help.OpenExcel("Histories"); foreach (DataRow row in rawData.Rows) { try { string invoiceNo = Help.getString(row, 0); Event item = new Event() { Invoice = invoices.Get().FirstOrDefault(x => x.InvoiceNo == invoiceNo), Date = Help.getDate(row, 1), Status = (Status)Help.getInteger(row, 2) }; histories.Insert(item); N++; } catch (System.Exception ex) { System.Console.WriteLine(ex.Message); } } histories.Commit(); Console.WriteLine(N); }
private void btnSave_Click(object sender, EventArgs e) { try { int dayClosureid = new BillingRepository().SaveDayClosure(Utility.branchinfo.BranchCounterID, gcDenomination.DataSource as DataTable, gcMOP.DataSource as DataTable, Utility.logininfo.UserID, txtRefundAmount.EditValue, daySequenceID); DayClosed = true; DataSet ds = new BillingRepository().GetDayClosureForReport(dayClosureid); rptDayClosure rpt = new rptDayClosure(ds); rpt.Parameters["Address"].Value = Utility.branchinfo.BranchAddress; rpt.Parameters["Phone"].Value = Utility.branchinfo.PhoneNumber; rpt.Parameters["CounterName"].Value = Utility.branchinfo.BranchCounterName; rpt.Parameters["UserName"].Value = Utility.logininfo.UserName; rpt.Print(); rpt.Print(); SplashScreenManager.ShowForm(null, typeof(frmWaitForm), true, true, false); Utility.StartSync(null); SplashScreenManager.CloseForm(); this.Close(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
public static void Get() { IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context); IBillingRepository <Stock> stocks = new BillingRepository <Stock>(Help.Context); IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context); DataTable rawData = Help.OpenExcel("Products"); int N = 0; foreach (DataRow row in rawData.Rows) { int oldId = Help.getInteger(row, 0); Product prod = new Product() { Name = Help.getString(row, 1), Unit = Help.getString(row, 2), Price = Help.getDouble(row, 4), Category = categories.Get(Help.dicCatt[Help.getInteger(row, 3)]) }; N++; products.Insert(prod); products.Commit(); stocks.Insert(new Stock() { Id = prod.Id }); products.Commit(); Help.dicProd.Add(oldId, prod.Id); } Console.WriteLine(N); }
public static void Get() { IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context); IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context); DataTable rawData = Help.OpenExcel("Agents"); int N = 0; foreach (DataRow row in rawData.Rows) { int oldId = Help.getInteger(row, 0); Agent agent = new Agent() { Name = Help.getString(row, 1) }; N++; string[] Zone = Help.getString(row, 2).Split('.'); foreach (string Z in Zone) { Region R = (Region)Convert.ToInt32(Z); var area = towns.Get().Where(x => x.Region == R).ToList(); foreach (var city in area) { agent.Towns.Add(city); } } agents.Insert(agent); agents.Commit(); Help.dicAgen.Add(oldId, agent.Id); } Console.WriteLine(N); }
public static DataTable GetBillingItems(double giffiRef) { int bookingId = DataUtil.GetBookingIdFromGiffiId(giffiRef); BillingRepository billRepo = new BillingRepository(); return(billRepo.GetBillingItem(bookingId)); }
protected void SelectedSearch_Click(object sender, EventArgs e) { double giffiRef = -1; BillingRepository repo = new BillingRepository(); if (!string.IsNullOrEmpty(txtSearchBox.Text) && double.TryParse(txtSearchBox.Text, out giffiRef) && giffiRef > 10000) { lblGiffiRef.Text = txtSearchBox.Text; lblGiffiRef.DataBind(); int bookingId = DataUtil.GetBookingIdFromGiffiId(giffiRef); hfBookingId.Value = bookingId.ToString(); Company c = GetCompanyInfo(bookingId); Booking b = GetBookingInfo(bookingId); string cityZip = string.Join(", ", c.City.Trim(), c.State.Trim(), c.ZipCode.Trim()); string cpInfo = string.Join("</br>", c.CompanyName, c.Address, cityZip, c.Country); lblBillTo.Text = cpInfo; lblBillTo.DataBind(); lblDescription.Text = b.Commodity.Trim(); lblYourRef.Text = b.ShipperRefNo; lblInvoiceDate.Text = b.CreatedTime.ToString("d"); lblVoyage.Text = b.Voyage; lblOrigin.Text = b.Origin; lblDestination.Text = b.Destination; gvInvoice.DataSource = DataUtil.GetBillingItems(giffiRef); gvInvoice.DataBind(); Dictionary <string, string> codes = GetAcctCodeMapIdWithName(); codes.Add("--Select--", "0"); ddlAddCode.DataSource = codes.OrderByDescending(x => x.Key); ddlAddCode.DataTextField = "Key"; ddlAddCode.DataValueField = "Key"; ddlAddCode.DataBind(); ddlAddVendor.DataSource = GetVendorInfo(); ddlAddVendor.DataTextField = "Value"; ddlAddVendor.DataValueField = "Key"; ddlAddVendor.DataBind(); tbAddBilling.Visible = true; tbAddBilling.DataBind(); btnPreviewInvoice.Visible = true; btnPayoutPreview.Visible = true; txtSearchBox.Text = string.Empty; } }
public static void Get() { IBillingRepository <ApiUser> apiUsers = new BillingRepository <ApiUser>(Help.Context); apiUsers.Insert(new ApiUser() { Name = "Billing", AppId = "R2lnaVNjaG9vbA==", Secret = "TWlzdHJhbFRhbGVudHM=" }); apiUsers.Commit(); }
void WhenAFileDoesNotExist_ThenAnEmptyObjectShouldBeReturned() { // Arrange var id = 0; var expected = new Bill(); var repository = new BillingRepository(); // Act var actual = repository.Get(id); // Assert Assert.Null(actual); }
void WhenABillIsRequested_ThenABillShouldBeReturned() { // Arrange var id = 1; var expected = new Bill(); var repository = new BillingRepository(); // Act var actual = repository.Get(id); // Assert Assert.NotNull(actual.Statement.Due); }
protected void gvInvoice_RowDeleting(object sender, GridViewDeleteEventArgs e) { int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text)); int billingItemId = (int)gvInvoice.DataKeys[e.RowIndex].Value; BillingRepository repo = new BillingRepository(); repo.DeleteItem(billingItemId, bookingId); gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId); gvInvoice.EditIndex = -1; gvInvoice.DataBind(); }
public frmDayClosure(int daySeqID) { InitializeComponent(); DataSet dsDayClosure = new BillingRepository().GetDayClosure(); gcDenomination.DataSource = dsDayClosure.Tables[0]; gcMOP.DataSource = dsDayClosure.Tables[1]; gvDenomination.FocusedRowHandle = 0; gvDenomination.FocusedColumn = gcQuantity; txtRefundAmount.EditValue = dsDayClosure.Tables[2].Rows[0]["REFUNDAMOUNT"]; updateSummary(); daySequenceID = daySeqID; this.gvDenomination.Appearance.FocusedCell.BackColor = System.Drawing.Color.SaddleBrown; this.gvDenomination.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvDenomination.Appearance.FocusedCell.ForeColor = System.Drawing.Color.White; this.gvDenomination.Appearance.FocusedCell.Options.UseBackColor = true; this.gvDenomination.Appearance.FocusedCell.Options.UseFont = true; this.gvDenomination.Appearance.FocusedCell.Options.UseForeColor = true; this.gvDenomination.Appearance.FocusedRow.BackColor = System.Drawing.Color.White; this.gvDenomination.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvDenomination.Appearance.FocusedRow.Options.UseBackColor = true; this.gvDenomination.Appearance.FocusedRow.Options.UseFont = true; this.gvDenomination.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold); this.gvDenomination.Appearance.FooterPanel.Options.UseFont = true; this.gvDenomination.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvDenomination.Appearance.HeaderPanel.Options.UseFont = true; this.gvDenomination.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvDenomination.Appearance.Row.Options.UseFont = true; this.gvMOP.Appearance.FocusedCell.BackColor = System.Drawing.Color.SaddleBrown; this.gvMOP.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvMOP.Appearance.FocusedCell.ForeColor = System.Drawing.Color.White; this.gvMOP.Appearance.FocusedCell.Options.UseBackColor = true; this.gvMOP.Appearance.FocusedCell.Options.UseFont = true; this.gvMOP.Appearance.FocusedCell.Options.UseForeColor = true; this.gvMOP.Appearance.FocusedRow.BackColor = System.Drawing.Color.White; this.gvMOP.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvMOP.Appearance.FocusedRow.Options.UseBackColor = true; this.gvMOP.Appearance.FocusedRow.Options.UseFont = true; this.gvMOP.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold); this.gvMOP.Appearance.FooterPanel.Options.UseFont = true; this.gvMOP.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvMOP.Appearance.HeaderPanel.Options.UseFont = true; this.gvMOP.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvMOP.Appearance.Row.Options.UseFont = true; }
public bool Bill(int customer, int seller, string articles) { billing = new BillingRepository(); var list = (articles.Split(',').Select(x => int.Parse(x))).ToArray(); var bill = billing.BillCustomer(customer, seller, list); if (bill != null) { try { var client = new Contabilidad.ContabilidadClient(); var debito = new entradaContableDet(); var credito = new entradaContableDet(); debito.monto = (float)bill.Amount; credito.monto = (float)bill.Amount; credito.cuentaContable = "6"; debito.cuentaContable = "13"; credito.tipoMovimiento = "CR"; debito.tipoMovimiento = "DB"; entradaContableDet[] lise = new entradaContableDet[2]; lise[0] = debito; lise[1] = credito; Contabilidad.entradaContable asiento = new Contabilidad.entradaContable(); asiento.auxiliar = "3"; asiento.descripcion = "Grupo de Jose Agustin Reinoso"; asiento.entradasContables = lise; var response = client.crearAsiento(asiento); } catch (Exception e) { return(false); } } return(true); }
public static void Get() { IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context); IBillingRepository <Category> categories = new BillingRepository <Category>(Help.Context); IBillingRepository <Stock> stocks = new BillingRepository <Stock>(Help.Context); Random r = new Random(); DataTable rawData = Help.OpenExcel("Products"); int N = 0; foreach (DataRow row in rawData.Rows) { try { int oldId = Help.getInteger(row, 0); Category category = categories.Get(Help.dicCatt[Help.getInteger(row, 3)]); Product product = new Product() { Name = Help.getString(row, 1), Unit = Help.getString(row, 2), Price = Help.getDouble(row, 4), Category = category, }; N++; products.Insert(product); products.Commit(); stocks.Insert(new Stock() { Id = product.Id, Input = r.Next(100, 300), Output = r.Next(0, 100) }); products.Commit(); Help.dicProd.Add(oldId, product.Id); } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine(N); }
protected void gvInvoice_RowUpdating(object sender, GridViewUpdateEventArgs e) { string erroMsg = string.Empty; GridViewRow row = gvInvoice.Rows[e.RowIndex]; int billingItemId = (int)gvInvoice.DataKeys[e.RowIndex].Value; int bookingId = DataUtil.GetBookingIdFromGiffiId(double.Parse(lblGiffiRef.Text)); BillingItem bi = null; try { bi = new BillingItem { Id = billingItemId, BookingId = bookingId, CodeId = int.Parse((row.FindControl("txtCodeId") as TextBox).Text.Trim()), Description = (row.FindControl("txtDescription") as TextBox).Text.Trim(), BillingAmount = decimal.Parse((row.FindControl("txtBillingAmount") as TextBox).Text.Trim()), PayoutAmount = decimal.Parse((row.FindControl("txtPayoutAmount") as TextBox).Text.Trim()) }; BillingRepository repo = new BillingRepository(); if (repo.UpdateBillingItem(bi)) { gvInvoice.EditIndex = -1; gvInvoice.DataSource = DataUtil.GetBillingItems(bookingId); gvInvoice.DataBind(); } } catch (SqlException se) { erroMsg = string.Format("Unable to insert freight to database. SQLException={0}", bookingId, se.Message); AlertMessage(erroMsg); } catch (Exception ex) { erroMsg = string.Format("Unable to insert freight due to an invalid entry. Exception={0}", bookingId, ex.Message); AlertMessage(erroMsg); } }
public static void Get() { IBillingRepository <Agent> agents = new BillingRepository <Agent>(Help.Context); IBillingRepository <Town> towns = new BillingRepository <Town>(Help.Context); int N = 0; DataTable rawData = Help.OpenExcel("Agents"); foreach (DataRow row in rawData.Rows) { try { int oldId = Help.getInteger(row, 0); Agent agent = new Agent() { Name = Help.getString(row, 1) }; string[] zones = Help.getString(row, 2).Split(','); foreach (string zone in zones) { Region r = (Region)Convert.ToInt32(zone); var areas = towns.Get().Where(x => x.Region == r).ToList(); foreach (var city in areas) { agent.Towns.Add(city); } } agents.Insert(agent); agents.Commit(); N++; Help.dicAgen.Add(oldId, agent.Id); } catch (Exception ex) { Console.WriteLine(ex.Message); } } Console.WriteLine(N); }
public frmDraftList(int daySequenceID) { InitializeComponent(); DataTable dtDraftBills = new BillingRepository().GetDraftBills(daySequenceID); gcDraftBills.DataSource = dtDraftBills; this.gvDraftBills.Appearance.FocusedCell.BackColor = System.Drawing.Color.White; this.gvDraftBills.Appearance.FocusedCell.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvDraftBills.Appearance.FocusedCell.Options.UseBackColor = true; this.gvDraftBills.Appearance.FocusedCell.Options.UseFont = true; this.gvDraftBills.Appearance.FocusedRow.BackColor = System.Drawing.Color.White; this.gvDraftBills.Appearance.FocusedRow.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.gvDraftBills.Appearance.FocusedRow.Options.UseBackColor = true; this.gvDraftBills.Appearance.FocusedRow.Options.UseFont = true; this.gvDraftBills.Appearance.FooterPanel.Font = new System.Drawing.Font("Arial", 14F, System.Drawing.FontStyle.Bold); this.gvDraftBills.Appearance.FooterPanel.Options.UseFont = true; this.gvDraftBills.Appearance.HeaderPanel.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvDraftBills.Appearance.HeaderPanel.Options.UseFont = true; this.gvDraftBills.Appearance.Row.Font = new System.Drawing.Font("Arial", 9F, System.Drawing.FontStyle.Bold); this.gvDraftBills.Appearance.Row.Options.UseFont = true; }
public ApplicationService(AccountRepository accountRepository, BillingRepository billingRepository) { _accountRepository = accountRepository; _billingRepository = billingRepository; }
private static void UseSqlServer() { var dbOptions = new DbContextOptionsBuilder <ApplicationContext>().UseSqlServer("Data Source=LAPTOP-7KC3O54G\\RECEPTION; Initial Catalog = Billing8; User Id = sa; Password = sa@12345;"); Repository = new BillingRepository(dbOptions); }
public BillingController() { _repository = new BillingRepository(); }
public static DataTable GetPayoutItems(int bookingId) { BillingRepository repo = new BillingRepository(); return(repo.GetPayoutItems(bookingId)); }
public static DataTable GetBillingItems(int bookingId) { BillingRepository billRepo = new BillingRepository(); return(billRepo.GetBillingItem(bookingId)); }