/// <summary> /// Miguel Santana /// Created: 2015/02/01 /// Opens UI for hotel guest operations /// </summary> /// <param name="selectedItem"></param> private void OpenHotelGuest(InvoiceDetails selectedItem = null) { try { if (selectedItem == null) { if (new AddEditHotelGuest().ShowDialog() == false) { return; } RefreshGuestList(); } else { if (new ViewInvoice(selectedItem).ShowDialog() == false) { return; } RefreshGuestList(); } } catch (Exception ex) { throw new WanderingTurtleException(this, ex); } }
protected void ddlStatus_SelectedIndexChanged(object sender, EventArgs e) { int nStatus = Convert.ToInt32(ddlStatus.SelectedValue); int nID = Convert.ToInt32(Request.QueryString["nid"]); InvoiceDetails obj = new InvoiceDetails(); int nRes = obj.updateStatus(nID, nStatus); string sDate = DateTime.Now.Month + "/" + DateTime.Now.Day + "/" + DateTime.Now.Year; int nStaff = Convert.ToInt32(ddlStaff.SelectedValue); if (nRes > 0) { switch (nStatus) { case 0: MessageBoxss.Show("Update successful !"); break; case 1: Delivery_Invoice objDelivery = new Delivery_Invoice(); objDelivery.insert(nStaff, sDate, nID, 0); MessageBoxss.Show("Add successful delivery bill !"); break; case 2: MessageBoxss.Show("Update successful !"); break; } } }
private void btnProductAdd_Click(object sender, EventArgs e) { if (!ProductInputControl()) { return; } decimal tax = Convert.ToDecimal(tbProductTax.Text); int count = (int)nudProductQuantity.Value; decimal total = (count * selectedProduct.UnitPrice) + (count * selectedProduct.UnitPrice * tax / 100); InvoiceDetails invoice = new InvoiceDetails(); invoice.InvoiceID = invoiceID; invoice.products = selectedProduct; InvoiceDetails product = invoiceDetails.FirstOrDefault(x => x.ProductID == selectedProduct.ProductID && x.InvoiceID == invoiceID); if (product == null) { invoice.ProductID = selectedProduct.ProductID; invoice.Qantity = count; } else { invoice = product; invoice.Qantity += count; } invoice.VATAmount = (int)tax; invoice.AmountWithVAT = Convert.ToInt32(selectedProduct.UnitPrice + (selectedProduct.UnitPrice * tax / 100)); invoiceDetails.Add(invoice); ProductInputClear(); }
public IHttpActionResult PutInvoiceDetails(int id, InvoiceDetails invoiceDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != invoiceDetails.FacturaDetailID) { return(BadRequest()); } db.Entry(invoiceDetails).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!InvoiceDetailsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
protected void OnBtnSaveClicked(object sender, EventArgs e) { InvoiceDetailsRepository repo = new InvoiceDetailsRepository(); InvoicesRepository repoInv = new InvoicesRepository(); if (!string.IsNullOrEmpty(Request.QueryString["InvoiceDetailId"])) { string[] key = Request.QueryString["InvoiceDetailId"].Split('-'); int idFactNumber = int.Parse(key[0]); string type = key[1]; int idYear = int.Parse(key[2]); int idLigneNumber = int.Parse(key[3]); IList<InvoiceDetails> invDetailList = repo.GetInvoiceDetailsOfInvoice( idFactNumber, type, idYear, idLigneNumber); if (invDetailList.Count == 1) { InvoiceDetails invDetail = invDetailList[0]; invDetail.Description = txtDescription.Text; invDetail.Quantity = txtQuantity.Value; invDetail.UnitPriceEuro = txtUnitPrice.Value; invDetail.AmountEuro = (invDetail.Quantity.HasValue ? invDetail.Quantity.Value : 0) * (invDetail.UnitPriceEuro.HasValue ? invDetail.UnitPriceEuro.Value : 0); invDetail.VatCode = int.Parse(ddlVAT.SelectedValue); repo.UpdateInvoiceDetails(invDetail); repoInv.ReComputeAmountOfInvoice(idFactNumber, type, idYear); } } else if (!string.IsNullOrEmpty(Request.QueryString["InvoiceIdPK"])) { string[] key = Request.QueryString["InvoiceIdPK"].Split('-'); int idFactNumber = int.Parse(key[0]); string type = key[1]; int idYear = int.Parse(key[2]); int? idLigneNumber = repo.GetMaxInvoiceDetailOrderNumber(idFactNumber, type, idYear); if (!idLigneNumber.HasValue) idLigneNumber = 1; else idLigneNumber += 1; InvoiceDetails invDetail = new InvoiceDetails(); invDetail.IdFactNumber = idFactNumber; invDetail.IdTypeInvoice = type; invDetail.IdYear = idYear; invDetail.IdLigneNumber = idLigneNumber.Value; invDetail.Description = txtDescription.Text; invDetail.Quantity = txtQuantity.Value; invDetail.UnitPriceEuro = txtUnitPrice.Value; invDetail.AmountEuro = (invDetail.Quantity.HasValue ? invDetail.Quantity.Value : 0) * (invDetail.UnitPriceEuro.HasValue ? invDetail.UnitPriceEuro.Value : 0); invDetail.VatCode = int.Parse(ddlVAT.SelectedValue); repo.InserNewInvoiceDetails(invDetail); repoInv.ReComputeAmountOfInvoice(idFactNumber, type, idYear); } string script = "<script type=\"text/javascript\">"; script += " OnBtnSaveClientClicked();"; script += " </script>"; if (!ClientScript.IsClientScriptBlockRegistered("saveAndCloseWindow")) ClientScript.RegisterStartupScript(this.GetType(), "saveAndCloseWindow", script); }
public ExpensesDetails ViewAllExpenses(int hId) { try { SqlParameter[] sqlparam; sqlparam = new SqlParameter[2]; sqlparam[0] = new SqlParameter("@Flag", "1"); //sqlparam[1] = new SqlParameter("@MedicineId", 0); sqlparam[1] = new SqlParameter("@HospitalId", hId); DataSet ds = CommonFunction.GetDataSet("USP_Get_ExpancesDetails", sqlparam, ""); ExpensesDetails ED = new ExpensesDetails(); List <ExpensesDetails> lst = new List <ExpensesDetails>(); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { ExpensesDetails Model = new ExpensesDetails(); CommonFunction.ReflectSingleData(Model, dr); lst.Add(Model); } } //Income List <IncomeDetails> Inclst = new List <IncomeDetails>(); if (ds != null && ds.Tables[1].Rows.Count > 0) { DataTable dt = ds.Tables[1]; foreach (DataRow dr in dt.Rows) { IncomeDetails Model = new IncomeDetails(); CommonFunction.ReflectSingleData(Model, dr); Inclst.Add(Model); } } //Invoice List <InvoiceDetails> Invclst = new List <InvoiceDetails>(); if (ds != null && ds.Tables[2].Rows.Count > 0) { DataTable dt = ds.Tables[2]; foreach (DataRow dr in dt.Rows) { InvoiceDetails Model = new InvoiceDetails(); CommonFunction.ReflectSingleData(Model, dr); Invclst.Add(Model); } } ED.Invlst = Invclst.OrderByDescending(x => x.Date).ToList(); ED.Inclst = Inclst.OrderByDescending(x => x.Date).ToList(); ED.lst = lst.OrderByDescending(x => x.ExId).ToList(); return(ED); } catch (Exception Ex) { throw Ex; } }
public void TestAddInvoiceDetails() { InvoiceDB db = new InvoiceDB(); Invoice i = db.Invoices.First(); ((IObjectContextAdapter)db).ObjectContext.Detach(i); //http://stackoverflow.com/questions/4168073/entity-framework-code-first-no-detach-method-on-dbcontext Assert.NotNull(i); InvoiceDetailsController idc = new InvoiceDetailsController(); idc.ControllerContext = new ControllerContext() { HttpContext = new MockHttpContext() }; InvoiceDetails id = new InvoiceDetails(); id.TimeStamp = DateTime.Now; id.Invoice = i; id.Qty = 1; id.Price = 100; id.VAT = 18; id.Article = "Invoice details test"; //get System.Web.Mvc.ActionResult resultAddView = idc.Create(i.InvoiceID); Assert.IsInstanceOf(typeof(System.Web.Mvc.ViewResult), resultAddView); //post System.Web.Mvc.ActionResult resultAdd = idc.Create(id); Assert.IsInstanceOf(typeof(System.Web.Mvc.PartialViewResult), resultAdd); Assert.AreEqual(((System.Web.Mvc.PartialViewResult)resultAdd).ViewName, "Index"); }
private static bool CreateInvoiceDetailsRecord(int InvoicesId, string InvoiceNumber, DateTime?InvoiceDate, DateTime?DueDate) { try { using (FreightBillDataClassesDataContext fbdb = new FreightBillDataClassesDataContext()) { InvoiceDetails detail = new InvoiceDetails() { InvoicesId = InvoicesId, InvoiceNumber = InvoiceNumber, InvoiceDate = InvoiceDate, DueDate = DueDate }; fbdb.InvoiceDetails.InsertOnSubmit(detail); fbdb.SubmitChanges(); } return(true); } catch (Exception ex) { writelog(String.Format("error! CreateInvoiceDetailsRecord {0}", InvoiceNumber)); writelog(ex.Message); return(false); } }
protected void lbtCheckOut_Click(object sender, EventArgs e) { DataTable dt = (DataTable)Session["giohang"]; try { Invoice objInvoice = new Invoice(); InvoiceDetails objDetail = new InvoiceDetails(); int nUserID = Convert.ToInt32(lblUserID.Text); int sNowMonth = DateTime.Now.Month; int day = DateTime.Now.Day; string ngay = ""; if (day < 10) { ngay = "0" + day; } else { ngay = day.ToString(); } string thang = ""; if (sNowMonth < 10) { thang = "0" + sNowMonth; } else { thang = sNowMonth.ToString(); } string sDate = thang + "/" + ngay + "/" + DateTime.Now.Year; string sInvoiceID = "0"; string sRequipments = txtComment.Text; for (int i = 0; i < rptCart.Items.Count; i++) { int nNumber = int.Parse("0" + (rptCart.Items[i].FindControl("txtQuantity") as TextBox).Text); int nProductID = Convert.ToInt32(dt.Rows[i]["ID"]); float fPrice = float.Parse(dt.Rows[i]["Price"].ToString()); float fTotal = nNumber * fPrice; int nResult = objInvoice.insertInvoice(nProductID, sDate, nNumber, fTotal, 0); if (nResult > 0) { dtb = objInvoice.getByProductID(nProductID, sDate); int nID = Convert.ToInt32(dtb.Rows[0]["InvoiceID"]); sInvoiceID += "," + nID.ToString(); } } objDetail.insert(sInvoiceID, sDate, 0, nUserID, sRequipments); Session["giohang"] = null; Response.Redirect("CheckOutSuccessful.aspx"); } catch (Exception ex) { Response.Write("Error: " + ex.Message); } }
private void BindataToRpt() { InvoiceDetails obj = new InvoiceDetails(); rptInvoiceDetails.DataSource = obj.getAll(); rptInvoiceDetails.DataBind(); }
private void DoubleClick_Open(object sender, MouseButtonEventArgs e) { if (CompanyDataGrid.SelectedItem != null && invoiceOpen) { if (InvoiceCorrections.IsChecked != true) { Invoice inv = CompanyDataGrid.SelectedItem as Invoice; InvoiceDetails invoiceDetails = new InvoiceDetails(inv, inv.Id, inv.IdCompany); invoiceDetails.Show(); } else { InvoiceCorrection invoiceCorrection = CompanyDataGrid.SelectedItem as InvoiceCorrection; EditedInvoiceDetails edited = new EditedInvoiceDetails(invoiceCorrection); edited.Show(); } } else if (CompanyDataGrid.SelectedItem != null && StorageOpen) { Product prd = CompanyDataGrid.SelectedItem as Product; StorageAdditionalOperations storageAdditionalOperations = new StorageAdditionalOperations(prd); storageAdditionalOperations.Show(); storageAdditionalOperations.Closed += (s, eventarg) => { LoadProductsList(); }; } else { MessageBox.Show("Wybierz pozycję z listy!"); } }
protected void SaveInvoiceDetails(Invoice objinvoice, InvoiceDetails objinvoicedetails) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } SqlCommand cmdInvoice = new SqlCommand(); cmdInvoice.Connection = connection; cmdInvoice.CommandText = "spCreateInvoice_New"; cmdInvoice.CommandType = CommandType.StoredProcedure; cmdInvoice.Parameters.AddWithValue("@InvoiceNumber", objinvoice.InvoiceNumber); cmdInvoice.Parameters.AddWithValue("@InvoiceDate", objinvoice.InvoiceDate); cmdInvoice.Parameters.AddWithValue("@ClientID", objinvoice.ClientID); cmdInvoice.Parameters.AddWithValue("@TotalAmount", objinvoice.TotalAmount); cmdInvoice.Parameters.AddWithValue("@CreatedDate", objinvoice.CreatedDate); cmdInvoice.Parameters.AddWithValue("@UpdatedDate", DBNull.Value); cmdInvoice.Parameters.AddWithValue("@Notes", objinvoice.Note); cmdInvoice.Parameters.AddWithValue("@Desc", objinvoicedetails.Description); cmdInvoice.Parameters.AddWithValue("@Hours", objinvoicedetails.Hours.ToString()); cmdInvoice.Parameters.AddWithValue("@Rate", objinvoicedetails.Rate.ToString()); cmdInvoice.Parameters.AddWithValue("@Amount", objinvoicedetails.Amount.ToString()); cmdInvoice.ExecuteNonQuery(); } }
private void LoadData() { string sFrom = Request.QueryString["datefrom"].ToString(); string sTo = Request.QueryString["dateto"].ToString(); lblDateFrom.Text = sFrom; lblDateTo.Text = sTo; DataTable dtbOverview = new DataTable(); dtbOverview.Columns.Add("ProductID", typeof(int)); dtbOverview.Columns.Add("ProductCategoryName", typeof(string)); dtbOverview.Columns.Add("Price", typeof(double)); dtbOverview.Columns.Add("ProductName", typeof(string)); dtbOverview.Columns.Add("Number", typeof(int)); dtbOverview.Columns.Add("Total", typeof(double)); dtbOverview.Columns.Add("Date_Create", typeof(string)); dtbOverview.Columns.Add("FullName", typeof(string)); dtbOverview.Columns.Add("Phone", typeof(string)); dtbOverview.Columns.Add("Address", typeof(string)); Invoice objInvoice = new Invoice(); DataTable dtbInvoice = new DataTable(); InvoiceDetails obj = new InvoiceDetails(); DataTable dtb = new DataTable(); dtb = obj.ReportbyDate(sFrom, sTo); int nCount = dtb.Rows.Count; for (int i = 0; i < nCount; i++) { string nInvoiceID = dtb.Rows[i]["InvoiceID"].ToString(); string sDate = dtb.Rows[i]["Date_Create"].ToString(); int UserID = Convert.ToInt32(dtb.Rows[i]["UserID"]); string sName = dtb.Rows[i]["FullName"].ToString(); string sAddress = dtb.Rows[i]["Address"].ToString(); string sPhone = dtb.Rows[i]["Phone"].ToString(); dtbInvoice = objInvoice.getMultipleID(nInvoiceID); int nCountInvoice = dtbInvoice.Rows.Count; for (int j = 0; j < nCountInvoice; j++) { int nNumber = Convert.ToInt32(dtbInvoice.Rows[j]["Number"]); double dTotal = Convert.ToDouble(dtbInvoice.Rows[j]["Total"]); int nProductID = Convert.ToInt32(dtbInvoice.Rows[j]["ProductID"]); string sProductName = dtbInvoice.Rows[j]["ProductName"].ToString(); double fPrice = Convert.ToDouble(dtbInvoice.Rows[j]["Price"]); string sCategoryName = dtbInvoice.Rows[j]["ProductCategoryName"].ToString(); dtbOverview.Rows.Add(nProductID, sCategoryName, fPrice, sProductName, nNumber, dTotal, sDate, sName, sPhone, sAddress); } } rptReportSale.DataSource = dtbOverview; rptReportSale.DataBind(); }
private void ProductInputClear() { selectedInvoiceDetail = null; nudProductQuantity.Value = 1; tbProductTax.Text = ""; dgvNewInvoice.DataSource = invoiceDetails.ToList(); }
// // GET: /InvoiceDetails/Create //Optional: Invoice ID public ActionResult Create(int? id) { ViewBag.InvoiceID = new SelectList(db.Invoices, "InvoiceID", "Notes"); Invoice invoice = null; InvoiceDetails i = null; if (id.HasValue) { invoice = (from ii in db.Invoices where ii.InvoiceID == id select ii).FirstOrDefault(); if (invoice != null) { i = new InvoiceDetails(); i.InvoiceID = id.Value; i.Invoice = invoice; i.Qty = 1; i.TimeStamp = DateTime.Now; if (invoice.InvoiceDetails.Count == 0) { //if this is the first line, we may want to name it as the invoice. i.Article = invoice.Notes; } ViewBag.InvoiceID = new SelectList(db.Invoices, "InvoiceID", "Notes", id.Value); } } if (Request.IsAjaxRequest()) { return PartialView("Create", i); } else { return View("Create", i); } }
public InvoiceDetails selectDataAdapter(string sqlstr, int tableIndex) { QueryLogger("-selectDataTable->" + sqlstr); InvoiceDetails dsInvoiceDetails = new InvoiceDetails(); try { using (SQLiteConnection con = new SQLiteConnection(ConnectionString)) { con.Open(); using (SQLiteCommand com = new SQLiteCommand(con)) { com.CommandText = sqlstr; da = new SQLiteDataAdapter(com); if (tableIndex == 1) { da.Fill(dsInvoiceDetails.invoiceBill); } } con.Close(); } } catch (SQLiteException ex) { MessageBox.Show("Something went wrong :" + ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(dsInvoiceDetails); }
public Int32 UpdateInvDetail(InvoiceDetails invoiceDetails) { using (var sqlquerygenerator = new SqlQueryGenerator <InvoiceDetails>()) { return(dapperService.Insert <InvoiceDetails>(sqlquerygenerator.GetUpdate(), invoiceDetails)); } }
private void SaveInvoiceButton_Click(object sender, RoutedEventArgs e) { try { using (SmallBusinessDBEntities context = new SmallBusinessDBEntities()) { this.detailsList.ForEach(d => { InvoiceDetails dummy = new InvoiceDetails { invoiceID = d.InvoiceID, productID = d.ProductID, quantity = d.Quantity, price = d.Price }; context.InvoiceDetails.Add(dummy); }); context.SaveChanges(); this.detailsList.Clear(); this.LoadInvoices(this.newInvoice.date); this.MainOrdersShowRow.Height = this.AddNewOrderRow.Height; this.AddNewOrderRow.Height = new GridLength(0); AddNewProductRow.Height = new GridLength(0); }//using } catch (Exception ex) { MessageBox.Show(ex.Message); }//catch }
public void TestAddInvoiceDetails() { InvoiceDB db = new InvoiceDB(); Invoice i = db.Invoices.First(); ((IObjectContextAdapter)db).ObjectContext.Detach(i); //http://stackoverflow.com/questions/4168073/entity-framework-code-first-no-detach-method-on-dbcontext Assert.NotNull(i); InvoiceDetailsController idc = new InvoiceDetailsController(); idc.ControllerContext = new ControllerContext() { HttpContext=new MockHttpContext() }; InvoiceDetails id = new InvoiceDetails(); id.TimeStamp = DateTime.Now; id.Invoice = i; id.Qty = 1; id.Price = 100; id.VAT = 18; id.Article = "Invoice details test"; //get System.Web.Mvc.ActionResult resultAddView = idc.Create(i.InvoiceID); Assert.IsInstanceOf(typeof(System.Web.Mvc.ViewResult), resultAddView); //post System.Web.Mvc.ActionResult resultAdd = idc.Create(id); Assert.IsInstanceOf(typeof(System.Web.Mvc.PartialViewResult), resultAdd); Assert.AreEqual(((System.Web.Mvc.PartialViewResult)resultAdd).ViewName, "Index"); }
// // GET: /InvoiceDetails/Edit/5 public ActionResult Edit(int id) { InvoiceDetails invoicedetails = db.InvoiceDetails.Find(id); ViewBag.InvoiceID = new SelectList(db.Invoices, "InvoiceID", "Notes", invoicedetails.InvoiceID); return(PartialView(invoicedetails)); }
private void LoadData() { string sAction = Request.QueryString["action"].ToString(); int nID = Convert.ToInt32(Request.QueryString["nid"]); Delivery_Invoice obj = new Delivery_Invoice(); DataTable dtb = new DataTable(); dtb = obj.getByID(nID); lblStaffID.Text = dtb.Rows[0]["StaffID"].ToString(); ddlStaff.SelectedValue = dtb.Rows[0]["StaffID"].ToString(); lblDate.Text = dtb.Rows[0]["Date"].ToString(); int nInvoiceDetailID = Convert.ToInt32(dtb.Rows[0]["InvoiceDetailsID"]); lblIInoiveDetails.Text = nInvoiceDetailID.ToString(); InvoiceDetails objDetails = new InvoiceDetails(); dtb = objDetails.getByID(nInvoiceDetailID); string sInvoiceID = dtb.Rows[0]["InvoiceID"].ToString(); Invoice objInvoice = new Invoice(); dtb = objInvoice.getMultipleID(sInvoiceID); rptProducts.DataSource = dtb; rptProducts.DataBind(); }
public InvoiceViewModel(Invoice invoice) { IdInvoice = invoice.IdInvoice; Subtotal = invoice.Subtotal; TotalIva = invoice.TotalIva; Total = invoice.Total; PaymentMethod = invoice.PaymentMethod; SaleDate = invoice.SaleDate; DueDate = invoice.DueDate; IdClient = invoice.IdClient; Client = new ClientInputModel(); Client = new ClientViewModel(invoice.Client); foreach (InvoiceDetail detail in invoice.InvoiceDetails) { InvoiceDetailModel detailModel = new InvoiceDetailModel(); detailModel.IdDetail = detail.IdDetail; detailModel.UnitValue = detail.UnitValue; detailModel.Quantity = detail.Quantity; detailModel.Discount = detail.Discount; detailModel.TolalDetail = detail.TolalDetail; detailModel.IdInvoice = detail.IdInvoice; detailModel.IdProduct = detail.IdProduct; detailModel.Product = new ProductInputModel(); detailModel.Product = new ProductViewModel(detail.Product); InvoiceDetails.Add(detailModel); } }
public static InvoiceDetails GetInvoiceData(eStoreDbContext db, int id) { var inv = db.RegularInvoices.Include(c => c.Customer).Include(c => c.PaymentDetail).ThenInclude(c => c.CardDetail).Where(c => c.RegularInvoiceId == id).FirstOrDefault(); if (inv == null) { return(null); } var saleitem = db.RegularSaleItems.Include(c => c.Salesman).Include(c => c.ProductItem).Where(c => c.InvoiceNo == inv.InvoiceNo).ToList(); InvoiceDetails iDetails = new InvoiceDetails { Invoice = SaleInvoiceView.CopyTo(inv, saleitem), Error = "OK", Msg = "Data Present" }; if (iDetails.Invoice.PaymentMode == "Card") { iDetails.IsCardPayment = true; } else { iDetails.IsCardPayment = false; } return(iDetails); }
public async Task <IActionResult> PutInvoiceDetails(int id, InvoiceDetails invoiceDetails) { if (id != invoiceDetails.Id) { return(BadRequest()); } _context.Entry(invoiceDetails).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!InvoiceDetailsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <InvoiceDetails> > PostInvoiceDetails(InvoiceDetails invoiceDetails) { _context.InvoiceDetails.Add(invoiceDetails); await _context.SaveChangesAsync(); return(CreatedAtAction("GetInvoiceDetails", new { id = invoiceDetails.Id }, invoiceDetails)); }
public void AddCheckedOutItemtoBill(int[] ItemIdArray) { List <CheckedoutProduct> products = new List <CheckedoutProduct>(); double price = 0; foreach (var item in ItemIdArray) { var p = worker.CheckedoutProducts.GetById(item); if (p != null) { price = p.Price; products.Add(p); } else { throw new ArgumentException($"Item-id {item} not present in cart"); } } InvoiceDetails newInvoiceDetail = new InvoiceDetails() { BilledProducts = products, Price = price, Time = DateTime.Now }; if (newInvoiceDetail.BilledProducts.Count > 0) { worker.InvoiceDetails.Add(newInvoiceDetail); } else { throw new ArgumentException($"Nothing Added from cart"); } }
public void Invoice() { ProcessOrder po = new ProcessOrder() { ProductImage = "https://www.google.co.in/search?q=product+images&tbm=isch&source=iu&ictx=1&fir=Ys6s1aKrzB6hrM%253A%252ChoD76SE7hB_ZTM%252C_&usg=AI4_-kRULqtxH-vZZChrfKQOclXWU2y_hw&sa=X&ved=2ahUKEwjIsurpndjeAhVKQY8KHVJ6CvkQ9QEwAnoECAAQCA#imgrc=Ys6s1aKrzB6hrM:", Title = "EarPhones", Price = 1200, Quantity = 5, ReorderLevel = 10, Description = "Nice EarPhones", CategoryId = 62, SubCategoryId = 64, ProductId = 129, sum = 6000 }; List <ProcessOrder> lst = new List <ProcessOrder>(); lst.Add(po); FinalOrder finalOrder = new FinalOrder() { products = lst, CustomerId = 100, PaymentMode = "COD" }; var result = bookingController.Invoice(finalOrder) as OkObjectResult; InvoiceDetails details = (InvoiceDetails)result.Value; InvoiceNo = details.InvoiceNo; Assert.IsInstanceOfType(result.Value, typeof(InvoiceDetails)); }
private void DefineRates(InvoiceDetails ret, OperationResult <ExchangeRateResult> rates, string currency) { var rate = rates.Entity.ConversionRates[ret.Currency.ToUpperInvariant()]; ret.Amount /= (decimal)rate; ret.Currency = currency.ToUpperInvariant(); }
public IActionResult CreateDetail(DetailModel model) { try { var repo = _uow.GetService <InvoiceDetailDomains>(); var newDetail = new InvoiceDetails { IdPro = model.IdPro, IdInvoice = model.IdInvoide, Quantity = model.Quantity, Total = model.Total, }; repo.Create(newDetail); _uow.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest(new ApiResult() { Code = 400, Detail = ex.Message })); } }
/// <summary> /// Tony Noel /// Created: 2015/03/04 /// A form used to cancel a booking. Displays the information about the booking. /// </summary> /// <param name="booking">Requires an input of a BookingDetails object /// (received from the ViewInvoice form- lvCustomerBookings ) /// </param> /// <param name="invoice">input received from ViewInvoice</param> public CancelBooking(BookingDetails booking, InvoiceDetails invoice) { InitializeComponent(); CurrentBooking = booking; CurrentInvoice = invoice; Title = "Canceling Booking: " + CurrentBooking.EventItemName; PopulateText(); }
public IActionResult GetInvoiceDetails(int invoiceId) { var invoice = _invoiceManager.GetInvoice(invoiceId); var response = InvoiceDetails.MapFromObject(invoice); return(Ok(response)); }
public void Update(InvoiceDetails entity) { if (entity != null) { _context.Update(entity); _context.SaveChanges(); } }
public InvoiceDetails SaveInvoiceDetails(InvoiceDetails dtls) { SqlServerConnection conn = new SqlServerConnection(); dtls.Id = conn.SqlServerUpdate("DECLARE @idnt INT=" + dtls.Id + ", @invs INT=" + dtls.Invoice.Id + ", @item INT=" + dtls.Item.Id + ", @user INT=" + dtls.CreatedBy.Id + ", @notes NVARCHAR(MAX)='" + dtls.Notes + "'; IF NOT EXISTS (SELECT id_idnt FROM InvoiceDetails WHERE id_idnt=@idnt OR id_bill_item=@item) BEGIN INSERT INTO InvoiceDetails (id_invoice, id_bill_item, id_added_by, id_notes) output INSERTED.id_idnt VALUES (@invs, @item, @user, @notes) END ELSE BEGIN UPDATE InvoiceDetails SET id_notes=@notes output INSERTED.id_idnt WHERE id_idnt=@idnt END"); return(dtls); }
public ActionResult Create(InvoiceDetails invoicedetails) { if (ModelState.IsValid) { db.InvoiceDetails.Add(invoicedetails); db.SaveChanges(); ViewBag.Invoice = (from i in db.Invoices where i.InvoiceID == invoicedetails.InvoiceID select i).FirstOrDefault(); return PartialView("Index", db.InvoiceDetails.Where(i => i.InvoiceID == invoicedetails.InvoiceID)); } ViewBag.InvoiceID = new SelectList(db.Invoices, "InvoiceID", "Notes", invoicedetails.InvoiceID); this.Response.StatusCode = 400; return PartialView("Create", invoicedetails); }
protected void Pay_Click(object sender, EventArgs e) { var records = (InvoiceDetails[])Session["records"]; var recordsForSend = new Collection<InvoiceDetails>(); foreach (var item in records) { if (item.chkValue && item.Invoice_Unbilled_Amount > 0) { var idet = new InvoiceDetails(); idet.Invoice_Unbilled_Amount = item.Invoice_Unbilled_Amount; idet.Invoice_Ref_Number = item.Invoice_Ref_Number; recordsForSend.Add(idet); } } try { if (recordsForSend.Count > 0) { var p = new Pay(); LoginHelper loginHelper = new LoginHelper(); info = loginHelper.GetLoginInfoPage(Page); var customer = loginHelper.GetProfile(info); customer.eMail = txtEmail.Text; if (customer.eMail != string.Empty) { //ToDo Da se sredi //Provider.ProfileUpdate(info, customer); } p.PayInvoicesCaSyS(recordsForSend, info, "MK", txtEmail.Text); } } catch (ThreadAbortException) { } catch (Exception ex) { //Utils.LogError(ex); } }
static void Main() { Handle.GET("/invoicedemo", () => { MasterPage master; if (Session.Current != null && Session.Current.Data != null) { master = (MasterPage)Session.Current.Data; } else { master = new MasterPage(); if (Session.Current != null) { master.Html = "/InvoiceDemo/LauncherWrapperPage.html"; master.Session = Session.Current; } else { master.Html = "/InvoiceDemo/MasterPage.html"; master.Session = new Session(SessionOptions.PatchVersioning); } master.RecentInvoices = new InvoicesPage() { Html = "/InvoiceDemo/InvoicesPage.html" }; } ((InvoicesPage)master.RecentInvoices).RefreshData(); master.FocusedInvoice = null; return master; }); Handle.GET("/invoicedemo/new-invoice", () => { MasterPage master = Self.GET<MasterPage>("/invoicedemo"); master.FocusedInvoice = Db.Scope(() => { var page = new InvoiceDetails() { Html = "/InvoiceDemo/InvoiceDetailsPage.html", Data = new Invoice() }; page.Items = Db.SQL<InvoiceRow>("SELECT r FROM InvoiceRow r WHERE r.Invoice=?", page.Data); page.TaxSource.Add(new Json("0")); page.TaxSource.Add(new Json("5")); page.TaxSource.Add(new Json("7")); page.TaxSource.Add(new Json("22")); page.TaxSource.Add(new Json("23")); page.Pagination.Buttons.PreviousName = "<"; page.Pagination.Buttons.NextName = ">"; page.Pagination.RowsLimit.Add(new Json("10")); page.Pagination.RowsLimit.Add(new Json("25")); page.Pagination.RowsLimit.Add(new Json("50")); page.Pagination.RowsLimit.Add(new Json("100")); page.Pagination.RowsPage = page.Pagination.RowsLimit[0].IntegerValue; page.Saved += (s, a) => { ((InvoicesPage)master.RecentInvoices).RefreshData(); }; page.Deleted += (s, a) => { ((InvoicesPage)master.RecentInvoices).RefreshData(); }; return page; }); return master; }); Handle.GET("/invoicedemo/invoices/{?}", (int InvoiceNo) => { MasterPage master = Self.GET<MasterPage>("/invoicedemo"); master.FocusedInvoice = Db.Scope<InvoiceDetails>(() => { var page = new InvoiceDetails() { Html = "/InvoiceDemo/InvoiceDetailsPage.html", Data = Db.SQL<Invoice>("SELECT i FROM Invoice i WHERE InvoiceNo = ?", InvoiceNo).First }; //SIMPLE CODE TO MIGRATE OLD DATA //WITH DEFUALT ROWINDEX EQUALS 0 var isToUpdateRow = Db.SQL<long>("SELECT COUNT(r) FROM InvoiceRow r WHERE r.Invoice=? AND r.RowIndex=?", page.Data, 0).First; if (isToUpdateRow > 1) { //page.UpdateAllRows(page.Data); } page.InvoiceNo = InvoiceNo; page.Pagination.RowsLimit.Add(new Json("10")); page.Pagination.RowsLimit.Add(new Json("25")); page.Pagination.RowsLimit.Add(new Json("50")); page.Pagination.RowsLimit.Add(new Json("100")); page.Pagination.RowsPage = page.Pagination.RowsLimit[0].IntegerValue; page.Pagination.Buttons.PreviousName = "<"; page.Pagination.Buttons.NextName = ">"; page.TaxSource.Add(new Json("0")); page.TaxSource.Add(new Json("5")); page.TaxSource.Add(new Json("7")); page.TaxSource.Add(new Json("22")); page.TaxSource.Add(new Json("23")); page.Saved += (s, a) => { ((InvoicesPage)master.RecentInvoices).RefreshData(); }; page.Deleted += (s, a) => { ((InvoicesPage)master.RecentInvoices).RefreshData(); }; page.RefreshInvoiceData(); return page; }); return master; }); Handle.GET("/invoicedemo/app-name", () => { return new AppName(); }); Handle.GET("/invoicedemo/app-icon", () => { return new Page() { Html = "/InvoiceDemo/AppIconPage.html" }; }); Handle.GET("/invoicedemo/menu", () => { return new Page() { Html = "/InvoiceDemo/AppMenuPage.html" }; }); UriMapping.Map("/invoicedemo/menu", UriMapping.MappingUriPrefix + "/menu"); UriMapping.Map("/invoicedemo/app-name", UriMapping.MappingUriPrefix + "/app-name"); UriMapping.Map("/invoicedemo/app-icon", UriMapping.MappingUriPrefix + "/app-icon"); }
public ActionResult Edit(InvoiceDetails invoicedetails) { if (ModelState.IsValid) { db.Entry(invoicedetails).State = EntityState.Modified; db.SaveChanges(); var invoice = (from i in db.Invoices where i.InvoiceID == invoicedetails.InvoiceID select i).FirstOrDefault(); ViewBag.Invoice = invoice; ViewBag.IsProposal = invoice.IsProposal; return PartialView("Index", db.InvoiceDetails.Where(i => i.InvoiceID == invoicedetails.InvoiceID)); } ViewBag.InvoiceID = new SelectList(db.Invoices, "InvoiceID", "Notes", invoicedetails.InvoiceID); this.Response.StatusCode = 400; return PartialView("Edit", invoicedetails); }