public ActionResult PharmacyBillReport(string date_from, string date_to) { List <BillDetails> BillList = new List <BillDetails>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "GetBillRecord"; p.Condition1 = date_from; p.Condition2 = date_to; ds = dl.GetBillReport_sp(p); try { foreach (DataRow item in ds.Tables[0].Rows) { BillDetails m = new BillDetails(); m.BillNo = item["BillNo"].ToString(); m.Date = item["Date"].ToString(); m.EmployeeId = item["EmployeeId"].ToString(); m.FullName = item["FullName"].ToString(); m.Name = item["Name"].ToString(); m.Total = item["Total"].ToString(); BillList.Add(m); } ViewBag.BillList = BillList; } catch (Exception ex) { } return(View()); }
public PDC() { SysDate = DateTime.Now; BillDetails = new BillDetails(); references = new TRNReferences(); country = new Country(); }
public IActionResult SaveBill(CustomModelBag modelBag) { int outletId = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.Actor)?.Value); int staffid = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.PrimarySid)?.Value); Bill newbill = new Bill(); newbill.BillId = (int)DateTime.Now.GetHashCode(); newbill.Date = DateTime.Now; newbill.TotalPayable = TotalAmount; newbill.PaymentMethod = "Sold"; newbill.StaffId = staffid; newbill.BuyerId = BuyerId; db.Bill.Add(newbill); db.SaveChanges(); BillDetails billDetails = new BillDetails(); foreach (var item in billdetails) { billDetails.Id = DateTime.Now.GetHashCode() + staffid.GetHashCode(); billDetails.BillId = newbill.BillId; billDetails.ProductId = item.ProductId; billDetails.Quantity = item.Quantity; billDetails.Amount = item.Amount; db.BillDetails.Add(billDetails); db.SaveChanges(); } billdetails.Clear(); TotalAmount = 0; return(RedirectToAction("Index")); }
private void CreateDatabaseOrModifyDatabase(List <VehicleDetails> vehicleList) { DeleteDatabase(FuelDB.Singleton.DBPath); FuelDB.Singleton.CreateTable <VehicleDetails>(); FuelDB.Singleton.CreateTable <BillDetails>(); //FuelDB.Singleton.CreateDatabase<Fuel>(); var details = vehicleList?.First(); vehicleList.RemoveAt(0); var billDetails = new BillDetails { AvailableLiters = details.VID, BillCurrentNumber = details.DriverID_PK, BillPrefix = details.RegNo, DeviceStatus = details.DriverName }; AppPreferences.SaveString(this, Utilities.DEVICESTATUS, billDetails.DeviceStatus); AppPreferences.SaveBool(this, Utilities.IsDownloaded, true); FuelDB.Singleton.InsertValues(vehicleList); btnDownloadData.Clickable = false; FuelDB.Singleton.InsertBillDetails(billDetails); }
public async Task <IActionResult> PutBillDetail(int id, BillDetails billDetail) { if (id != billDetail.id) { return(BadRequest()); } _context.Entry(billDetail).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BillDetailExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
// GET: Invoices/Details/5 public ActionResult Details(int id) { List <DataPoint> dataPoints = new List <DataPoint>(); BillDetails res = CallApi.Get(Request.Cookies["jwt"], "bills/details", id.ToString()).Content.ReadAsAsync <BillDetails>().Result; Dictionary <string, double> keyValuePairs = new Dictionary <string, double>(); foreach (ProductDetails productDetails in res.ProductDetails) { foreach (WasteDiscount productWaste in productDetails.WasteDiscounts) { if (!keyValuePairs.ContainsKey(productWaste.Waste.Name)) { keyValuePairs.Add(productWaste.Waste.Name, productWaste.DiscountedAmount * productWaste.Waste.RecyclingPrice); } else { keyValuePairs[productWaste.Waste.Name] += productWaste.DiscountedAmount * productWaste.Waste.RecyclingPrice; } } } foreach (var x in keyValuePairs) { dataPoints.Add(new DataPoint(x.Key, x.Value)); } ViewBag.DataPoints = JsonConvert.SerializeObject(dataPoints); return(View(res)); }
public async Task <BillDetails> FetchBillDetailsAsync(string billSlug) { HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Add("X-API-Key", "hxY9fxmPmO7Ev1UT6KUlbYaPVKM5v619B2DWRjIY"); var url = $"https://api.propublica.org/congress/v1/116/bills/{billSlug}.json"; var results = await client.GetAsync(url); var stringResults = await results.Content.ReadAsStringAsync(); var propublicaBillDetails = JsonConvert.DeserializeObject <PropublicaBillDetails>(stringResults); var billDetails = new BillDetails { BillId = propublicaBillDetails.Results[0].BillId, BillNumber = propublicaBillDetails.Results[0].Number, BillTitle = propublicaBillDetails.Results[0].Title, IntroducedDate = propublicaBillDetails.Results[0].IntroducedDate, HousePassage = propublicaBillDetails.Results[0].HousePassage, SenatePassage = propublicaBillDetails.Results[0].SenatePassage, Enacted = propublicaBillDetails.Results[0].Enacted, Vetoed = propublicaBillDetails.Results[0].Vetoed, SummaryShort = propublicaBillDetails.Results[0].SummaryShort, Summary = propublicaBillDetails.Results[0].Summary, CongressdotgovUrl = propublicaBillDetails.Results[0].CongressdotgovUrl, GovtrackUrl = propublicaBillDetails.Results[0].GovtrackUrl, BillUri = propublicaBillDetails.Results[0].BillUri }; return(billDetails); }
public ActionResult AddSubCategoryToCategory(BillDetailViewModel model) { List <BillDetails> details = new List <BillDetails>(); for (int i = 0; i < model.lstDetails.Count; i++) { for (int j = 0; j < model.lstDetails[i].lstSubCategory.Count; j++) { if (model.lstDetails[i].lstSubCategory[j].Quantity == 0 || model.lstDetails[i].lstSubCategory[j].Quantity == null) { } else { BillDetails billdetails = new BillDetails(); billdetails.ChallanId = model.ChallanId; billdetails.BillId = model.BillId; billdetails.CategoryId = model.lstDetails[i].CategoryId; billdetails.SubCategoryId = model.lstDetails[i].lstSubCategory[j].SubCategoryId; billdetails.Quantity = Convert.ToDecimal(model.lstDetails[i].lstSubCategory[j].Quantity); details.Add(billdetails); } } } challanDAL.AddSubCategory(details); TempData["SuccessMsg"] = "Bill Created Successfully"; return(RedirectToAction("Index")); }
/// <summary> /// Instantiate all objects used globally /// </summary> public FunctionalTest() { _bill = new BillDetails { Title = "Electricity Bill", Catagory = BillCategory.Office, Amount = 5000, DateOfEntry = DateTime.Now, DueDate = DateTime.Now.AddDays(15), PaymentMode = BillPaymentMode.Bank_Transfer, Status = BillStatus.Unpaid }; _user = new User { UserName = "******", Password = "******", ConfirmPassword = "******", Email = "*****@*****.**", UserType = UserType.Visitor }; config = new ConfigurationBuilder().AddJsonFile("appsettings.test.json").Build(); _server = new TestServer(new WebHostBuilder() .UseStartup <Startup>()); _client = _server.CreateClient(); }
public BillDetails CreateBill(BillDetails bill) { var entity = new Entities.Bill() { Created = bill.Created, Partner = bill.Partner != null?Partners .Single(x => x.Id == bill.Partner.Id) : null, Condominium = bill.Condominium != null?Condominiums .Single(x => x.Id == bill.Condominium.Id) : null, Description = bill.Description, Serial = bill.Serial, PaymentDeadline = bill.PaymentDeadline, Done = bill.Done, Items = bill.Items .Select(x => new Entities.BillItem() { Description = x.Description, Price = x.Price }) .ToList(), Tags = bill.Tags .Select(x => new BillTag() { Label = x.Label, Ratio = x.Rate }) .ToList() }; DbContext.Add(entity); DbContext.Add(entity.Tags); DbContext.Add(entity.Items); DbContext.SaveChanges(); return(entity.ToModelWithItems()); }
public BoundaryTest() { _bill = new BillDetails { Title = "Electricity Bill", Catagory = BillCategory.Office, Amount = 1000, DateOfEntry = DateTime.Now, DueDate = DateTime.Now.AddDays(30), PaymentMode = BillPaymentMode.Bank_Transfer, Status = BillStatus.Unpaid }; _user = new User { UserName = "******", Password = "******", ConfirmPassword = "******", Email = "*****@*****.**", UserType = UserType.Visitor }; _userLogin = new UserLogin { UserName = "******", Password = "******", }; MongoDBUtility mongoDBUtility = new MongoDBUtility(); context = mongoDBUtility.MongoDBContext; _userRepository = new UserRepository(context); _billRepository = new BillRepository(context); _userService = new UserService(_userRepository); _billService = new BillService(_billRepository); config = new ConfigurationBuilder().AddJsonFile("appsettings.test.json").Build(); }
public async Task <ActionResult <object> > GetBillDetails(int id) { var bill = await _context.Bills.FindAsync(id); if (bill == null) { return(NotFound()); } var result = new BillDetails { Bill = bill, ProductDetails = _context.BillProducts.Where(x => x.BillId == bill.BillId) .Select(y => new ProductDetails { Product = y.Product, Amount = y.Amount, WasteDiscounts = _context.BillProductWastes.Where(z => z.BillProductId == y.Id) .Select(z => new WasteDiscount { Waste = z.Waste, DiscountedAmount = z.DiscountedAmount }).ToList() }).ToList(), }; return(result); }
private void endToolStripMenuItem_Click(object sender, EventArgs e) { ListViewItem item = listviewitem.SelectedItems[0]; cId = int.Parse(item.SubItems[0].Text); Bill bill = new Bill(); bill.ComputerId = cId; billBLL.GetBillId(bill); string dateTime = DateTime.Now.ToShortTimeString(); Bill bills = new Bill(); bills.EndTime = DateTime.Parse(dateTime); bills.BillID = StaticClass.BillID; billBLL.GetEndTime(bills); Computer pc = new Computer(); pc.ComputerID = cId; computers.IsActiveFalse(pc); BillDetails bd = new BillDetails(); bd.ShowDialog(); }
public void CreateDatabaseOrModifyDatabase(List <VehicleDetails> vehicleList) { DeleteDatabase(FuelDB.Singleton.DBPath); FuelDB.Singleton.CreateTable <VehicleDetails>(); FuelDB.Singleton.CreateTable <BillDetails>(); var details = vehicleList?.First(); vehicleList.RemoveAt(0); var billDetails = new BillDetails { AvailableLiters = details.VID, BillCurrentNumber = details.DriverID_PK, BillPrefix = details.RegNo, DeviceStatus = details.DriverName }; AppPreferences.SaveString(this, Utilities.DEVICESTATUS, billDetails.DeviceStatus); AppPreferences.SaveBool(this, Utilities.IsDownloaded, true); FuelDB.Singleton.InsertValues(vehicleList); btnDownloadData.Clickable = false; FuelDB.Singleton.InsertBillDetails(billDetails); RunOnUiThread(() => { loader.Visibility = Android.Views.ViewStates.Gone; mainHolder.Alpha = 1f; Window.ClearFlags(Android.Views.WindowManagerFlags.NotTouchable); Toast.MakeText(this, "success..", ToastLength.Short).Show(); btnDownloadData.Clickable = false; AppPreferences.SaveBool(this, Utilities.IsDownloaded, true); }); ExceptionLog.LogDetails(this, "Database created successfully"); }
public async Task <ActionResult <BillDetails> > PostBillDetail(BillDetails billDetails) { _context.BillDetails.Add(billDetails); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBillDetail", new { id = billDetails.id }, billDetails)); }
public static bool ThemChiTietHoaDon(BillDetails cthd) { bool kq; string sql = string.Format("insert into BillDetails values ({0}, {1}, {2}, {3}. {4}, {5})", cthd.Id_bill, cthd.Id_pro, cthd.Qty, cthd.Price, cthd.Discount, cthd.Amount); kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
// POST: api/DownloadCopy public IHttpActionResult Post([FromBody] BillDetails bills, [FromUri] string domainType) { //List<BillDetails> lst = new List<BillDetails>(); //List<BillDetails> downloadedBills = new List<BillDetails>(); string strBaseFilePath = null; byte[] Filebytes = null; List <FileData> lstActualData = new List <FileData>(); try { GoGreenService service = new GoGreenService(); IEnumerable <FileData> lstFileData = service.GetBillFiles(bills.billNumber, ""); foreach (FileData data in lstFileData) { try { strBaseFilePath = null; Filebytes = null; string[] SplitFilePath = data.FilePath.Replace('\\', '/').Split('/'); strBaseFilePath = data.PhysicalBasePath; string NodeType = StringExtensions.GetNodeType(data.NodeType); if (NodeType == "") { NodeType = "UNCATEGORIZED"; } if (File.Exists(strBaseFilePath + data.FilePath)) { Filebytes = File.ReadAllBytes(strBaseFilePath + data.FilePath); } FileData fileObject = new FileData(); fileObject.FileName = SplitFilePath[SplitFilePath.Length - 1]; fileObject.BasePathId = data.BasePathId; fileObject.FilePath = data.FilePath.Replace('\\', '/'); fileObject.NodeType = NodeType; fileObject.FileContent = Filebytes; lstActualData.Add(fileObject); service.UpdateBillStatus(bills.companyId, bills.billNumber, bills.LawFirmId); } catch (Exception ex) { log.Error("Error" + ex.Message + ex.StackTrace); } } return(Ok(lstActualData)); } catch (Exception ex) { log.Error("Error" + ex.Message + ex.StackTrace); return(Ok(lstActualData)); } }
public BillDetails CreateBill(BillDetails bill) { if (bill == null) { throw new ArgumentNullException("bill"); } bill.Id = _nextId++; Bills.Add(bill); return(bill); }
public void Delete(BillDetails obj) { ClearParameter(); AddParameter("@billid", obj.BillId); AddParameter("@menuitemid", obj.MenuItemId); FetchData("sp_Delete_TempBillDetails"); }
public BillDetails Post([FromBody] BillDetails bill) { Console.WriteLine(bill); Console.WriteLine("bill/post"); if (bill.Created is null) { bill.Created = DateTime.Now; } return(BillService.CreateBill(bill)); }
public static void CreateBill(BillDetails billDetails) { string FileName = @"./DataManagement/Bills/"; FileName += billDetails.bill.BillId.ToString() + ".bin"; Stream SaveFileStream = File.Create(FileName); BinaryFormatter serializer = new BinaryFormatter(); serializer.Serialize(SaveFileStream, billDetails); SaveFileStream.Close(); }
public override int InsertOrUpdate(BillDetails obj) { try { new DalBillDetails().InsertOrUpdate(obj); return(1); } catch (Exception) { return(0); } }
public int DeleteData(BillDetails obj) { try { new DalTempBillDetails().Delete(obj); return(1); } catch (Exception) { return(0); } }
public BillDetails GetOwnerUIControl() { BillDetails ret = null; if (UIControl != null) { if (UIControl is BillDetails) { ret = (BillDetails)UIControl; } } return(ret); }
public async Task <ActionResult <bool> > GenerateBill(BillDetails billDetails) { try { var result = await _billService.SaveBillAsync(billDetails); return(result); } catch (Exception exception) { return(BadRequest(exception.ToString())); } }
private void txtid_KeyPress(object sender, KeyPressEventArgs e) { if (e != null && e.KeyChar == 13) { string pid = txtid.Text; if (bus.checkExistProduct(pid) == true) { Product p = bus.getProduct(pid); BillDetailWithTotal d = new BillDetailWithTotal(); d.ProductCode = p.ProductCode; //d.ProductCode = p.ProductName; d.UnitPrice = p.PriceHistories.Last().Price; d.Number = int.Parse(nud_Number.Text); d.Subtotal = d.Number * d.UnitPrice; BillDetails.Add(d); lstManageBillIn.DataSource = null; lstManageBillIn.DataSource = BillDetails; lstManageBillIn.Columns["Bill"].Visible = false; lstManageBillIn.Columns["Product"].Visible = false; lstManageBillIn.Columns["BallotNum"].Visible = false; lstManageBillIn.Columns["ProductCode"].HeaderText = "Tên sản phẩm"; lstManageBillIn.Columns["UnitPrice"].HeaderText = "Đơn giá"; lstManageBillIn.Columns["Number"].HeaderText = "Số lượng"; lstManageBillIn.Columns["Subtotal"].HeaderText = "Thành tiền"; lstManageBillIn.Columns["Subtotal"].DisplayIndex = 4; txtid.Text = ""; nud_Number.Text = "1"; } else { MessageBox.Show("Vui lòng nhập đúng mã sản phẩm"); } } //tính thành tiền int sc = lstManageBillIn.Rows.Count; double thanhtien = 0; for (int i = 0; i < sc; i++) { thanhtien += double.Parse(lstManageBillIn.Rows[i].Cells["Subtotal"].Value.ToString()); } txt_Total.Text = Convert.ToString(thanhtien); //tính tổng số lượng int numproduct = 0; for (int j = 0; j < sc; j++) { numproduct += int.Parse(lstManageBillIn.Rows[j].Cells["Number"].Value.ToString()); } txt_TotalNum.Text = Convert.ToString(numproduct); }
private void btnUpdate_Click(object sender, EventArgs e) { try { btnUpdate.Enabled = false; cmbMenuItem.Enabled = true; BillDetails billDetails = new BillDetails(); billDetails.BillId = _billId; billDetails.MenuItemId = Convert.ToInt32(ListView1.FocusedItem.SubItems[1].Text); billDetails.Quantity = Convert.ToInt32(txtSaleQty.Text); billDetails.UnitPrice = Convert.ToDecimal(ListView1.FocusedItem.SubItems[3].Text); billDetails.IsDiscountAvailable = false; billDetails.TotalPrice = Convert.ToDecimal(txtTotalAmount.Text); billDetails.ReceivedBy = BaseObject.User_ID; billDetails.IsDeleted = false; new BllTempBillDetails().InsertOrUpdate(billDetails); for (int j = 0; j <= ListView1.Items.Count - 1; j++) { if (ListView1.Items[j].SubItems[1].Text == ListView1.FocusedItem.SubItems[1].Text) { ListView1.Items[j].SubItems[3].Text = txtPrice.Text; ListView1.Items[j].SubItems[4].Text = txtSaleQty.Text; ListView1.Items[j].SubItems[5].Text = txtTotalAmount.Text; txtSubTotal.Text = subtot().ToString(); Calculate(); BillInfo billInfo = createBillInfoObject(); new BllBillInfo().InsertOrUpdate(billInfo); cmbMenuItem.Text = ""; txtPrice.Text = ""; txtSaleQty.Text = ""; txtTotalAmount.Text = ""; //cmbMenuItem.Focus(); txtMenuCode.Focus(); return; } } } catch (Exception ex) { KryptonMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void InsertOrUpdate(BillDetails obj) { ClearParameter(); AddParameter("@billdetailid", obj.BillDetailId); AddParameter("@billid", obj.BillId); AddParameter("@menuitemid", obj.MenuItemId); AddParameter("@quantity", obj.Quantity); AddParameter("@unitprice", obj.UnitPrice); AddParameter("@isdiscountavailable", obj.IsDiscountAvailable); AddParameter("@totalprice", obj.TotalPrice); AddParameter("@receivedby", 1); FetchData("sp_InsertUpdate_BillDetails"); }
public override BillDetails LoadFromReader(DataTableReader reader) { var temp = new BillDetails(); if (reader != null && !reader.IsClosed) { temp.BillDetailId = reader.GetInt32(0); if (!reader.IsDBNull(1)) { temp.BillId = reader.GetInt32(1); } if (!reader.IsDBNull(2)) { temp.MenuItemId = reader.GetInt32(2); } if (!reader.IsDBNull(3)) { temp.Quantity = reader.GetInt32(3); } if (!reader.IsDBNull(4)) { temp.UnitPrice = reader.GetDecimal(4); } if (!reader.IsDBNull(5)) { temp.IsDiscountAvailable = reader.GetBoolean(5); } if (!reader.IsDBNull(6)) { temp.TotalPrice = reader.GetDecimal(6); } if (!reader.IsDBNull(7)) { temp.ReceivedBy = reader.GetInt32(7); } if (!reader.IsDBNull(8)) { temp.IsDeleted = reader.GetBoolean(8); } if (!reader.IsDBNull(9)) { temp.MenuItemName = reader.GetString(9); } } return(temp); }
private void InsertUpadatedBillDetails() { var bill = FuelDB.Singleton.GetBillDetails(); var billall = bill.First(); var billDetails = new BillDetails { AvailableLiters = ConstantValues.ZERO, BillCurrentNumber = (Convert.ToInt32(billall.BillCurrentNumber) + 1).ToString(), BillPrefix = billall.BillPrefix, DeviceStatus = billall.DeviceStatus }; FuelDB.Singleton.DeleteTable <BillDetails>(); FuelDB.Singleton.CreateTable <BillDetails>(); FuelDB.Singleton.InsertBillDetails(billDetails); availableFuel = 0f; }