public List <SalesViewModel> GetSalesBetweenTwoDates(string fromDate, string toDate)
{
DateTime fd;
DateTime td;
DateTime.TryParse(fromDate, out fd);
DateTime.TryParse(toDate, out td);
string query = "SELECT Company,Item,Quantity FROM GetAllSalesView WHERE Type='Sold' AND DATE BETWEEN '" + fd.Date + "' AND '" + td.Date + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <SalesViewModel> salesViewModels = new List <SalesViewModel>();
while (Reader.Read())
{
SalesViewModel salesViewModel = new SalesViewModel();
salesViewModel.Item = Reader["Item"].ToString();
salesViewModel.Company = Reader["Company"].ToString();
salesViewModel.Quantity = Convert.ToInt32(Reader["Quantity"]);
salesViewModels.Add(salesViewModel);
}
Connection.Close();
return(salesViewModels);
}
public ActionResult MonthlySalesData(int?Branch_Id = null)
{
IEnumerable <SalesModel> model = dao.GetMonthlySalesTotal();
if (Branch_Id != null)
{
model = model.Where(x => x.Branch_Id == Branch_Id);
}
//this makes a dictionary where month int is the key and the val is the list of objects which share that month val.
var monthDict = model.GroupBy(x => x.Month, x => x, (key, g) => new { Month = key, vals = g.ToList() }).OrderBy(x => x.Month);
List <SalesViewModel> result = new List <SalesViewModel>();
//converting the month data into the viewmodel for the chart
foreach (var group in monthDict)
{
SalesViewModel tmp = new SalesViewModel();
tmp.name = months[group.Month - 1];
tmp.x = group.vals.Select(x => x.Branch_Province).ToArray();
tmp.y = group.vals.Select(x => x.Sales).ToArray();
result.Add(tmp);
}
return(Json(result.ToArray <SalesViewModel>(), JsonRequestBehavior.AllowGet));
}
public ActionResult Purchase(SalesViewModel model)
{
Sales carToBuy = new Sales();
carToBuy.FirstName = model.FirstName;
carToBuy.LastName = model.LastName;
carToBuy.Phone = model.Phone;
carToBuy.Email = model.Email;
carToBuy.Street1 = model.Street1;
carToBuy.Street2 = model.Street2;
carToBuy.State = model.State;
carToBuy.City = model.City;
carToBuy.Date = DateTime.Now;
if (model.ZipCode == 0)
{
ModelState.AddModelError("ZipCode", " five digit zip is required!");
}
carToBuy.ZipCode = model.ZipCode;
carToBuy.PurchasePrice = model.PurchasePrice.Value;
carToBuy.PurchaseType = model.PurchaseType;
carToBuy.VehicleId = model.VehicleId;
ctxs.PurchaseVehicle(carToBuy);
return(RedirectToAction("Sales"));
}
private void Payment_IsOpenChanged(object sender, RoutedEventArgs e)
{
Paytxt.Text = string.Empty;
Paymodetxt.Text = string.Empty;
Log.Info("Before: To set data context in ItemsalesAdd_IsOpenChanged ItemSalesAdd");
if (this.Payment.IsOpen)
{
SalesViewModel _s = new SalesViewModel();
this.DataContext = _s;
List <Sale> _lst = _s.Purchase.ToList <Sale>();
List <Sale> _lst1 = _s.Sales.ToList <Sale>();
_mlst = _lst1.Concat(_lst).ToList <Sale>();
_customerlst = _s.Customerlist.Where <Customer>(x => x.Type == 0 || x.Type == 2).ToList();
_dealerlst = _s.Customerlist.Where <Customer>(x => x.Type == 1 || x.Type == 2).ToList();
if (Recievedpicker.IsChecked == true)
{
_lst = _s.Purchase.ToList <Sale>();
showCustomer.ItemsSource = _customerlst;
}
}
else
{
Recievedpicker.IsChecked = true;
showCustomer.ItemsSource = _customerlst;
}
}
/// <summary>
/// Update Customers information
/// </summary>
/// <param name="user"></param>
/// <param name="ProfileMedia"></param>
/// <returns></returns>
public bool UpdateCustomers(SalesViewModel salesViewModel)
{
bool status = false;
try
{
//var _usrsaltdetails = _Context.Users.FirstOrDefault(x => x.Id == user.Id);
var _customerDetails = _Context.tblProductSolds.Find(salesViewModel.Id);
if (_customerDetails != null)
{
Mapper.Map(salesViewModel, _customerDetails);
_customerDetails.ProductId = salesViewModel.ProductId;
_customerDetails.CustomerId = salesViewModel.CustomerId;
_customerDetails.StoreId = salesViewModel.StoreId;
_customerDetails.ModifiedDate = DateTime.Now;
_Context.Configuration.ValidateOnSaveEnabled = false;
_Context.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
}
// for new users
return(status);
}
public ActionResult Add()
{
SalesViewModel salesViewModel = new SalesViewModel();
salesViewModel.CustomerSelectListItems = _customerManager
.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}
).ToList();
salesViewModel.CategorySelectListItems = _categoryManager
.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}
).ToList();
return(View(salesViewModel));
}
protected void SetListViewData(object o, EventArgs e)
{
int Id = salesList.Count + 1;
getQuantityData ea = (getQuantityData)e;
decimal _TotalPrice = 60.30m * ea.quantity;
var getSVMfromModal = new SalesViewModel {
ProductDetailName = productDetailBtn.Text.ToString(), Quantity = ea.quantity, TotalPrice = _TotalPrice, ProductId = Id
};
//SalesViewModel getDatafromList = null;
//if (salesList.Count > 0)
//{
// getDatafromList = new SalesViewModel();
// getDatafromList = salesList.SingleOrDefault(f => f.ProductDetailName == getSVMfromModal.ProductDetailName);
//}
//if(getDatafromList!=null)
//{
// salesList.Remove(getDatafromList);
// getSVMfromModal.Quantity = getDatafromList.Quantity + getSVMfromModal.Quantity;
// getSVMfromModal.TotalPrice = getSVMfromModal.Quantity * _TotalPrice;
//}
salesList.Add(getSVMfromModal);
salesList.GroupBy(f => f.ProductDetailName);
PopulateListView();
//productDetailBtn.IsEnabled = true;
}
public async Task <IActionResult> GetSales([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var sales = await _context.Sales.FindAsync(id);
if (sales == null)
{
return(NotFound());
}
var customer = await _context.Customers.FindAsync(sales.CustomerId);
var product = await _context.Products.FindAsync(sales.ProductId);
var store = await _context.Stores.FindAsync(sales.StoreId);
var dateSold = sales.DateSold.ToString("MM/dd/yyyy");
var saleEntry = new SalesViewModel {
Id = sales.Id, DateSold = dateSold, CustomerId = sales.CustomerId, ProductId = sales.ProductId, StoreId = sales.StoreId,
CustomerName = customer.Name, ProductName = product.Name, StoreName = store.Name
};
return(Ok(saleEntry));
}
public SalesViewModel UpdateSales(SalesViewModel data)
{
try
{
var dbrecord = _dbContext.Sales.Where(e => e.SalesId.Equals(data.Id)).FirstOrDefault();
dbrecord.IsActive = false;
//updating the old record with IsActive False;
_dbContext.Sales.Update(dbrecord);
//Adding new record with updated values sales record..................................
data.Id = 0;
var newRecord = ConstructSalesAsPerContext(data);
_dbContext.Sales.Add(newRecord);
_dbContext.SaveChanges();
//return the new record to the UI......
data = ConstructSalesViewModelFromPerContext(newRecord);
}
catch (Exception)
{
throw;
}
return(data);
}
/// <summary>
/// Save Users
/// </summary>
/// <param name="customer"></param>
/// <param name="logId"></param>
/// <param name="validateOnSaveEnabled"></param>
/// <param name="mailBodyTemplate"></param>
/// <returns></returns>
public bool SaveSales(SalesViewModel salesViewModel)
{
bool status = false;
tblProductSold product = new tblProductSold();
Mapper.Map(salesViewModel, product);
product.ProductId = salesViewModel.ProductId;
product.CustomerId = salesViewModel.CustomerId;
product.StoreId = salesViewModel.StoreId;
product.DateSold = salesViewModel.PurchasedDate;
product.IsActive = true;
product.CreatedDate = DateTime.Now;
product.ModifiedDate = DateTime.Now;
product.CreatedBy = "101";
product.ModifiedBy = "101";
_Context.tblProductSolds.Add(product);
_Context.Configuration.ValidateOnSaveEnabled = true;
_Context.SaveChanges();
status = true;
return(status);
// for new users
}
public ActionResult Entry(SalesViewModel salesViewModel)
{
if (ModelState.IsValid)
{
_salesCustomer.CustomerId = salesViewModel.CustomerId;
_salesCustomer.Date = salesViewModel.Date;
_salesCustomer.LoyaltyPoint = salesViewModel.LoyaltyPoint;
_salesCustomer.PayableAmounth = salesViewModel.PayableAmounth;
_salesCustomer.SalesDetails = salesViewModel.SalesDetails;
if (_salesManager.Entry(_salesCustomer))
{
ViewBag.Message = "Saved";
salesViewModel.CustomerSelectListItems = _customerManager.GetAll().Select(c => new SelectListItem()
{
Value = c.ID.ToString(),
Text = c.Name
});
salesViewModel.ProductSelectListItems = _productManager.GetAll().Select(c => new SelectListItem()
{
Value = c.ID.ToString(),
Text = c.Name
});
return(View(salesViewModel));
}
}
return(View(salesViewModel));
}
//Satışlar:Geçmiş siparişler, Güncel siparişler
public IActionResult Sales(int num)
{
if (num > 3)
{
num = 1;
}
SalesViewModel model = new SalesViewModel();
var result = from c in _context.Customers
join o in _context.Orders
on c.CustomerID equals o.Customer.CustomerID
join s in _context.ShippedStatusses
on o.ShippedStatus.ShippedStatusID equals s.ShippedStatusID
where s.ShippedStatusID == num
select new { o, c, s };
model.SalesInformationModels = new List <SalesInformationModel>();
foreach (var item in result)
{
model.SalesInformationModels.Add(new SalesInformationModel
{
Customer = item.c,
Order = item.o,
Status = item.s
});
}
return(View(model));
}
public JsonResult GetCustomerList()
{
SalesViewModel salesViewModel = new SalesViewModel();
salesViewModel.CustomerList = _iDropDownService.GetCustomerList().ToList();
return(Json(new { CustomerList = salesViewModel.CustomerList }));
}
public static List <SalesViewModel> GetSales(int salesYear)
{
SalesViewModel viewmodel = new SalesViewModel();
List <SalesViewModel> ad = new List <SalesViewModel>();
if (salesYear == 2017)
{
viewmodel.SalesName = "John";
viewmodel.SalesAmount = 100000000;
viewmodel.SalesYear = 2017;
ad.Add(viewmodel);
viewmodel = new SalesViewModel();
viewmodel.SalesName = "Train";
viewmodel.SalesAmount = 200000000;
viewmodel.SalesYear = 2016;
ad.Add(viewmodel);
viewmodel = new SalesViewModel();
viewmodel.SalesName = "AD";
viewmodel.SalesAmount = 800000000;
viewmodel.SalesYear = 2015;
ad.Add(viewmodel);
}
return(ad);
}
public List <SalesViewModel> GetSalesForDate(SalesViewModel sale)
{
query = "SELECT * FROM SalesViewModel WHERE created_at BETWEEN @FromDate AND @ToDate ";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@FromDate", sale.FromDate);
command.Parameters.AddWithValue("@ToDate", sale.ToDate);
connection.Open();
reader = command.ExecuteReader();
List <SalesViewModel> salesViewModel = new List <SalesViewModel>();
while (reader.Read())
{
SalesViewModel aSale = new SalesViewModel();
aSale.Id = Convert.ToInt32(reader["id"]);
aSale.ItemName = reader["item_name"].ToString();
aSale.SalesQuantity = Convert.ToInt32(reader["sales_quantity"]);
aSale.CreatedAt = (DateTime)reader["created_at"];
salesViewModel.Add(aSale);
}
reader.Close();
connection.Close();
return(salesViewModel);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="salesController">An ISalesController implementation.</param>
public MainViewModel(ISalesController salesController)
{
_salesController = salesController;
NumpadViewModel = new NumpadViewModel();
TabViewModel = new TabViewModel(salesController, NumpadViewModel);
SalesViewModel = new SalesViewModel(salesController);
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.SalesView);
vm = ViewModel as SalesViewModel;
ActionBar.Hide();
//GCM TEST
/*Log.Debug("SalesView", "InstanceID token: " + FirebaseInstanceId.Instance.Token);
* if (Intent.Extras != null)
* {
* foreach (var key in Intent.Extras.KeySet())
* {
* var value = Intent.Extras.GetString(key);
* Log.Debug("SalesView", "Key: {0} Value: {1}", key, value);
* Log.Debug("SalesView", "google app id: " + Resource.String.google_app_id);
* }
* }
* FirebaseMessaging.Instance.SubscribeToTopic("promotion");
* Log.Debug("SalesView", "Subscribed to remote notification");*/
//GCM TEST END
ImageView syncButton = FindViewById <ImageView>(Resource.Id.btnSync);
syncButton.Click += delegate
{
var progressDialog = ProgressDialog.Show(this, "Please wait...", "Sync is in progress...", true);
new Thread(new ThreadStart(async delegate
{
await vm.CmdSync();
vm.refresh();
RunOnUiThread(() => progressDialog.Dismiss());
})).Start();
};
}
public List <SalesViewModel> GetAllSales()
{
query = "SELECT * FROM SalesViewModel";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
List <SalesViewModel> salesViewModel = new List <SalesViewModel>();
while (reader.Read())
{
SalesViewModel aSale = new SalesViewModel();
aSale.Id = Convert.ToInt32(reader["id"]);
aSale.ItemName = reader["item_name"].ToString();
aSale.SalesQuantity = Convert.ToInt32(reader["sales_quantity"]);
aSale.CreatedAt = (DateTime)reader["created_at"];
salesViewModel.Add(aSale);
}
reader.Close();
connection.Close();
return(salesViewModel);
}
public ActionResult Sales()
{
var model = new SalesViewModel();
try
{
using (var dbContext = new Bookshop_DBContext())
{
dbContext.Sales.ForEach(sale => model.Sales.Add(new Sale
{
Book = new Book
{
book_name = sale.Book.book_name,
Author = new Author
{
first_name = sale.Book.Author.first_name,
last_name = sale.Book.Author.last_name
}
},
sale_date = sale.sale_date,
books_count = sale.books_count,
price = sale.price
}));
}
}
catch (SqlException e)
{
model.ErrorMessage = e.Message;
return(View(model));
}
return(View(model));
}
public ActionResult Add(Sales sales)
{
string message = "";
if (_salesManager.Add(sales))
{
message = "Sales Saved";
}
else
{
message = "Not saved";
}
ViewBag.Message = message;
SalesViewModel salesViewModel = new SalesViewModel();
salesViewModel.CustomerSelectListItems = _customerManager.
GetAll().Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
salesViewModel.CategorySelectListItems = _categoryManager.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
ViewBag.Category = salesViewModel.CategorySelectListItems;
return(View(salesViewModel));
}
public ActionResult Show()
{
SalesViewModel salesViewModel = new SalesViewModel();
salesViewModel.Salses = _salesManager.GetallSaleses();
return(View(salesViewModel));
}
public ActionResult Index(SalesViewModel model)
{
if (Convert.ToDateTime(model.ProductSold.DateSold) > DateTime.Now)
{
return(Json(false));
}
if (model.ProductSold.Id > 0)
{
ProductSold ps = db.ProductSolds.Where(c => c.Id == model.ProductSold.Id).SingleOrDefault();
ps.CustomerId = model.ProductSold.CustomerId;
ps.ProductId = model.ProductSold.ProductId;
ps.StoreId = model.ProductSold.StoreId;
ps.DateSold = model.ProductSold.DateSold;
db.SaveChanges();
}
else
{
ProductSold ps = new ProductSold()
{
CustomerId = model.ProductSold.CustomerId,
ProductId = model.ProductSold.ProductId,
StoreId = model.ProductSold.StoreId,
DateSold = model.ProductSold.DateSold
};
db.ProductSolds.Add(ps);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public async Task <SalesViewModel> Get(int id)
{
var entity = await _repository.GetAsync(id);
var viewModel = new SalesViewModel()
{
Id = entity.Id,
BillDate = entity.OrderDate.Value,
BillNumber = entity.Id.ToString(),
CustomerName = entity.Customer.CompanyName,
CustomerAddress = entity.Customer.Address,
CustomerPhone = entity.Customer.Phone
};
foreach (var item in entity.OrderDetails)
{
OrderDetailsModel detail = new OrderDetailsModel()
{
ProductName = item.Product.ProductName,
UnitPrice = item.UnitPrice,
Quantity = item.Quantity
};
viewModel.OrderDetails.Add(detail);
}
return(viewModel);
}
private void ItemsalesAdd_IsOpenChanged(object sender, RoutedEventArgs e)
{
totalcaltxt.Text = string.Empty;
Log.Info("Before: To set data context in ItemsalesAdd_IsOpenChanged ItemSalesAdd");
if (this.ItemsalesAdd.IsOpen)
{
SalesViewModel _s = new SalesViewModel();
this.DataContext = _s;
lst = _s.Products.ToList <Products>();
List <Customer> _customerlst = _s.Customerlist.Where <Customer>(x => x.Type == 0 || x.Type == 2).ToList();
showCustomer.ItemsSource = _customerlst;
Log.Info("Before: To get list of Billing in ItemsalesAdd_IsOpenChanged ItemSalesAdd");
List <Billing> _blist = Queries.GetAllData <Billing>();
Log.Info("After: To get list of Billing in ItemsalesAdd_IsOpenChanged ItemSalesAdd");
if (_blist.Count == 0)
{
billnumber = 1001;
}
else
{
var bp = _blist.Last();
billnumber = bp.BillNo + 1;
}
Log.Info("After: To set data context in ItemsalesAdd_IsOpenChanged ItemSalesAdd");
}
billlbl.Content = "Bill No: " + billnumber;
showProduct.ItemsSource = lst;
showCustomer.IsEnabled = true;
datalist.Items.Clear();
mrplbl.Content = string.Empty;
vattxt.Text = discounttxt.Text = TotalAmount.Text = Price.Text = Qty.Text = Advanced.Text = string.Empty;
}
private void searchSalesButton_Click(object sender, EventArgs e)
{
SalesViewModel aSale = new SalesViewModel();
aSale.FromDate = fromDateDateTimePicker.Value;
aSale.ToDate = toDateDateTimePicker.Value;
salesListView.Items.Clear();
int count = 0;
List <SalesViewModel> allSales = aSalesManager.GetSalesForDateManager(aSale);
foreach (SalesViewModel sale in allSales)
{
count++;
ListViewItem salesList = new ListViewItem(count.ToString());
salesList.SubItems.Add(sale.ItemName);
salesList.SubItems.Add(sale.SalesQuantity.ToString());
salesList.SubItems.Add(sale.CreatedAt.ToLongDateString());
salesListView.Items.Add(salesList);
}
}
public SalesView()
{
InitializeComponent();
vm = new SalesViewModel();
BindingContext = vm;
}
// Save new Record
public JsonResult SaveRecord(SalesViewModel model)
{
var result = false;
try
{
if (model.Ps_Id > 0)
{
var record = db.ProductsSolds.SingleOrDefault(x => x.Ps_Id == model.Ps_Id);
record.Ps_CustomerId = model.Ps_CustomerId;
record.Ps_ProductId = model.Ps_ProductId;
record.Ps_StoreId = model.Ps_StoreId;
record.DateSold = model.DateSold;
db.SaveChanges();
result = true;
}
else
{
var record = new ProductsSold();
record.Ps_CustomerId = model.Ps_CustomerId;
record.Ps_ProductId = model.Ps_ProductId;
record.Ps_StoreId = model.Ps_StoreId;
record.DateSold = model.DateSold;
db.ProductsSolds.Add(record);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult FindItemForSale(string search, int ItemTypeId)
{
// try
// {
if (Session["UserId"] != null)
{
User user = (User)Session["user"];
var sales = new List <sale>();
var itemsForSale = Db.Items_for_sale.Where(i => i.user_id == user.user_id && (i.item_name.Contains(search) || search == null) && i.item_type_id == ItemTypeId).ToList();
var carsForSale = Db.Cars.Where(c => c.user_id == user.user_id && (c.model.Contains(search) || search == null) && c.car_type_id == ItemTypeId).ToList();
var houseForSale = Db.Houses.Where(h => h.user_id == user.user_id && (h.house_name.Contains(search) || search == null) && h.house_type_id == ItemTypeId).ToList();
foreach (var item in itemsForSale)
{
sales.Add(item);
}
foreach (var car in carsForSale)
{
sales.Add(car);
}
foreach (var house in houseForSale)
{
sales.Add(house);
}
List <sale> sortedSales = sales.OrderBy(o => o.sales_id).ToList();
List <CommentViewModel> cm = new List <CommentViewModel>();
foreach (var mitem in sortedSales)
{
List <Comment> comments = Db.Comments.Where(c => c.sales_id == mitem.sales_id).ToList();
cm.Add(new CommentViewModel()
{
item = mitem,
});
}
var saleViewModel = new SalesViewModel
{
User = user,
ItemsForSale = sortedSales
};
ViewBag.ItemTypeId = new SelectList(Db.Item_type, "item_type_id", "item_type_name");
return(View(saleViewModel));
}
else
{
return(RedirectToAction("Login", "User"));
}
// }
// catch (Exception e)
// {
// return RedirectToAction("Login","User");
// }
return(View());
}
public async Task <IActionResult> Sales(string shopName, string billDate, int id = 1)
{
var currentDate = DateTime.Now.AddMonths(-1);
if (string.IsNullOrEmpty(billDate))
{
billDate = currentDate.ToString("yyyy-MM-dd");
}
var tempDate = DateTime.Parse(billDate);
var fristDate = new DateTime(tempDate.Year, tempDate.Month, 1); //当月第一天
var lastDate = fristDate.AddMonths(1).AddDays(-1); // 当月最后一天
var beginDate = new DateTime(2018, 1, 1);
List <SelectListItem> selectListItem = new List <SelectListItem>();
for (DateTime dt = beginDate; dt < currentDate; dt = dt.AddMonths(1))
{
selectListItem.Add(new SelectListItem
{
Value = dt.ToString("yyyy-MM-dd"),
Text = dt.ToString("yyyy年MM月")
});
}
var list = from o in _context.OrderRecords
where o.Status == 10 && (o.OrderDate > fristDate && o.OrderDate < lastDate)
group o by o.ShopId into g
select new
{
ShopId = g.Key,
SaleCount = g.Sum(sc => sc.Num),
TotalAmount = g.Sum(ta => ta.TotalAmount)
};
var queryable = from s in _context.Shops
join o in list on s.Id equals o.ShopId
where 1 == 1 && (string.IsNullOrEmpty(shopName) || s.Name.StartsWith(shopName))
select new ShopSaleViewModel
{
ShopId = s.Id,
ShopName = s.Name,
SaleCount = o.SaleCount,
TotalAmount = o.TotalAmount
};
var res = await queryable.ToListAsync();
var sales = new SalesViewModel()
{
ShopName = shopName,
BillDate = fristDate.ToString("yyyy-MM-dd"),
BillDateList = selectListItem,
ShopSales = res
};
return(View(sales));
}
public SalesView()
{
InitializeComponent();
vm = ContainerHelper.Container.Resolve <SalesViewModel>();
((App)Application.Current).SalesViewModel = vm;
DataContext = ((App)Application.Current).SalesViewModel;
InitPayment();
}
public void Setup()
{
_fakeSalesController = Substitute.For<ISalesController>();
_uut = new SalesViewModel(_fakeSalesController);
_fakeSalesController.PropertyChanged += _uut.OnCurrentOrderChanged;
}
public void Setup()
{
_fakeSalesController = Substitute.For <ISalesController>();
_uut = new SalesViewModel(_fakeSalesController);
_fakeSalesController.PropertyChanged += _uut.OnCurrentOrderChanged;
}
public MvvmLine()
{
InitializeComponent();
Sales = new SalesViewModel();
DataContext = this;
Chart.AxisY.LabelFormatter = x => x + ".00k items";
Chart.DataToolTip = new SalesTooltip();
}
public ViewResult Index()
{
List<Sale> sales = new List<Sale>();
using (SalesDBEntities context = new SalesDBEntities())
{
sales = context.Sales
.Include(s => s.Employee)
.Include(s => s.Customer)
.Include(s => s.Product)
.Take(100).ToList<Sale>();
SalesViewModel viewModel = new SalesViewModel();
viewModel.Sales = sales;
return View(viewModel);
}
}
public async Task<ActionResult> Sales()
{
var model = new SalesViewModel
{
Items = await db.WebOrders.Select(o =>
new SalesOrderViewModel
{
OrderNumber = o.Id,
Username = o.Member.UserAccount.UserName,
Quantity = o.OrderItems.Sum(oi => oi.Quantity),
Subtotal = o.OrderSubtotal,
Shipping = o.ShippingCost,
Tax = o.TaxAmount,
OrderTotal = o.OrderSubtotal + o.ShippingCost + o.TaxAmount
}).OrderBy(o => o.OrderNumber)
.ToListAsync()
};
return View(model);
}
public async Task<ActionResult> Sales(DateTime start, DateTime? end)
{
end = SetToEndOfDayIfInPast(end);
var model = new SalesViewModel
{
StartDate = start,
EndDate = end,
Items = await db.WebOrders.Where(o => o.OrderDate >= start && o.OrderDate <= end)
.Select(o => new SalesOrderViewModel
{
OrderNumber = o.Id,
Username = o.Member.UserAccount.UserName,
Quantity = o.OrderItems.Sum(oi => oi.Quantity),
Subtotal = o.OrderSubtotal,
Shipping = o.ShippingCost,
Tax = o.TaxAmount,
OrderTotal = o.OrderSubtotal + o.ShippingCost + o.TaxAmount
}).OrderBy(o => o.OrderNumber)
.ToListAsync()
};
return View(model);
}
