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