static void Main()
{
var computer = new Sale("Lenovo","12-12-2014", 650);
var dvd = new Sale("Philips", "12-12-2015", 300);
var tv = new Sale("Samsung", "12-12-2016", 620);
var john = new SalesEmployee(8120403565, "John", "Carera", 1500, Department.Production, dvd);
var ivan = new SalesEmployee(85264040262, "Ivan", "Smallhouse", 5200, Department.Sales, computer, tv);
var ludnica = new Project("gospodari.bg", "05-07-1947", "some details");
var web = new Project("home.bg", "04-04-1984", "deeeetails");
ludnica.CloseProject();
var doncho = new Developer(85012236461, "Doncho", "Donkov", 41500, Department.Production, web, ludnica);
var kiro = new Manager(7511119253, "Kiro", "Pora", john, ivan, doncho);
var listOfPeople = new List<IPerson> {kiro, doncho, ivan, john};
foreach (var person in listOfPeople)
{
Console.WriteLine(person);
Console.WriteLine("--------------------------------------------------------------------------------");
}
}
public ActionResult SalePayment(FormCollection values)
{
Sale order = new Sale();
TryUpdateModel(order);
try
{
var cart = ShoppingCart.GetCart(this.HttpContext);
order.UserID = 6;
order.Creation = DateTime.Now;
order.Total = cart.GetTotal();
//Save Order
db.Sales.AddObject(order);
db.SaveChanges();
//Process the order
cart.CreateSale(order);
return RedirectToAction("Complete", new { id = order.SaleID });
}
catch
{
//Invalid - redisplay with errors
var cart = ShoppingCart.GetCart(this.HttpContext);
ViewBag.Total = cart.GetTotal();
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Name", order.CustomerID);
ViewBag.TypePaymentID = new SelectList(db.TypePayments, "TypePaymentID", "Name", order.TypePaymentID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "Name", order.UserID);
return View(order);
}
}
public static void Main()
{
Manager manager1 = new Manager("000001", "Manager1", "Manager1 Last name", 123m, Department.Marketing);
Manager manager2 = new Manager("000002", "Manager2", "Manager2 Last name", 351.23m, Department.Production);
Manager manager3 = new Manager("000003", "Manager2", "Manager2 Last name", 421.53m, Department.Accounting);
SalesEmployee salesEmployee1 = new SalesEmployee("000004", "SalesEmployee1", "SalesEmployee1 Last name", 212m, Department.Marketing);
Developer developer1 = new Developer("000007", "Developer1", "Developer1 Last name", 2232m, Department.Marketing);
Developer developer2 = new Developer("000009", "Developer3", "Developer3 Last name", 104.23m, Department.Accounting);
Sale sale = new Sale("graphic card", DateTime.Now, 140m);
Project project = new Project("Php", "Php course", DateTime.Now);
manager1.AddEmployees(new HashSet<Employee> { salesEmployee1, developer2 });
salesEmployee1.AddSales(new HashSet<Sale> { sale });
developer1.AddProjects(new HashSet<Project> { project });
IList<Employee> employees = new List<Employee>
{
manager1,
manager2,
manager3,
salesEmployee1,
};
foreach (var employee in employees)
{
Console.WriteLine(employee);
}
}
public static IEnumerable<Sale> GetSalesFromFile(string fullFilePath)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(fullFilePath);
var xmlQueryString = "/sales/sale";
XmlNodeList nodesList = xmlDoc.SelectNodes(xmlQueryString);
var sales = new HashSet<Sale>();
foreach (XmlNode node in nodesList)
{
var date = node.SelectSingleNode("summary").Attributes["date"].Value;
var quantity = node.SelectSingleNode("summary").Attributes["quantity"].Value;
var unitPrice = node.SelectSingleNode("summary").Attributes["unit-price"].Value;
var vendorId = node.Attributes["vendorId"].Value;
var medicamentId = node.SelectSingleNode("summary").Attributes["medicamentId"].Value;
Sale newSale = new Sale()
{
Date = DateTime.Parse(date),
Quantity = int.Parse(quantity),
UnitPrice = decimal.Parse(unitPrice),
VendorId = int.Parse(vendorId),
MedicamentId = int.Parse(medicamentId)
};
sales.Add(newSale);
}
return sales;
}
//
// GET: /Sales/Create
public ActionResult Create()
{
ViewBag.PossibleClients = _clientRepository.All;
ViewBag.PossibleLotteries = _lotteryRepository.All;
var sale = new Sale {Date = DateTime.Now};
return View(sale);
}
public void sale_with_2_momogi_and_pepsi_should_be_totaled_6000()
{
var sale = new Sale();
sale.AddLineItem(momogi, 2);
sale.AddLineItem(pepsi);
Assert.AreEqual(6000m, sale.GetTotal());
}
public void DeleteRecord(Sale sale)
{
context.Sales.Detach(sale);
context.Sales.Attach(context.Sales.Single(c => c.SaleId == sale.SaleId));
context.Sales.DeleteObject(sale);
context.SaveChanges();
}
static Sale[] ReadSales()
{
int n = int.Parse(Console.ReadLine());
Sale[] sales = new Sale[n];
for (int i = 0; i < n; i++)
sales[i] = ReadSale();
return sales;
}
public SaleUpdateByEmployee(Sale sale, Employee employee, string message)
{
Sale = sale;
Employee = employee;
Date = DateTime.Now;
//will add this property to the database later :D
Message = message;
}
public void Buy_Book_Post_NotValidModelState()
{
Sale sale = new Sale { BookId = 1, Id = 3};
controller.ValidateModel(sale);
var view = controller.BuyBook(sale);
Assert.IsFalse(controller.ModelState.IsValid, "Валидная модель");
Assert.IsTrue(view is ViewResult, "Неправильный тип ViewResult");
Assert.IsNull(controller.ViewBag.Message, "Есть сообщение об успешной покупке");
}
static Sale ReadSale()
{
string[] data = Console.ReadLine().Split(' ').ToArray();
Sale sale = new Sale() { Town = data[0],
Product = data[1],
Price = decimal.Parse(data[2]),
Quantity = decimal.Parse(data[3]) };
return sale;
}
public void DeleteRecord(Sale sale, Item item, SaleDetail saleDetail)
{
context.Sales.Detach(sale);
context.SaleDetails.Detach(saleDetail);
context.Sales.Attach(context.Sales.Single(c => c.SaleId == sale.SaleId));
context.SaleDetails.Attach(context.SaleDetails.Single(sd => sd.SaleId == sale.SaleId && sd.ItemId == item.ItemId));
context.SaleDetails.DeleteObject(saleDetail);
context.SaveChanges();
}
public void AddSale(Sale sale, ICollection<SaleDetail> details)
{
bool correctTotal = ValidateSaleTotal(sale, details);
if (!correctTotal)
{
sale.SaleTotal = CalculateSaleTotal(sale, details);
}
Sale_Manager.AddRecord(sale, details);
}
public void Buy_Book_Post()
{
Sale sale = new Sale { BookId = 1, Id = 3, Quantity = 2, Date = DateTime.Now };
controller.ValidateModel(sale);
var view = controller.BuyBook(sale);
Assert.IsTrue(controller.ModelState.IsValid, "Инвалидная модель");
Assert.IsTrue(view is ViewResult, "Неправильный тип ViewResult");
Assert.IsNotNull(controller.ViewBag.Message, "Нет сообщения об успешной покупке");
}
public void sale_total_with_changing_product_price_should_remain_consistent()
{
var sale = new Sale();
sale.AddLineItem(momogi);
Assert.AreEqual(500m, sale.GetTotal());
momogi.UnitPrice = 0;
Assert.AreEqual(500m, sale.GetTotal());
}
public SaleDTO Create(Sale sale)
{
return new SaleDTO()
{
Url = urlbuilder.Link("GamingStoreRoute", new { id = sale.ID }),
TotalAmount = sale.TotalAmount,
Date= sale.Date
};
}
static Sale ReadSale()
{
string[] salesInput = Console.ReadLine().Split(' ');
Sale sale = new Sale() { Town = salesInput[0],
Product = salesInput[1],
Price = decimal.Parse(salesInput[2]),
Quantity = decimal.Parse(salesInput[3]) };
return sale;
}
public void AddRecord(Sale sale, ICollection<SaleDetail> saleDetails)
{
context.Sales.AddObject(sale);
foreach (var item in saleDetails)
{
item.SaleId = sale.SaleId;
context.SaleDetails.AddObject(item);
}
context.SaveChanges();
}
public void add_sli_with_same_product_will_change_quantity()
{
var sale = new Sale();
sale.AddLineItem(momogi, 2);
Assert.AreEqual(1, sale.LineItems.Count);
sale.AddLineItem(momogi);
Assert.AreEqual(1, sale.LineItems.Count);
var sli = sale.GetLineItem(momogi);
Assert.AreEqual(3, sli.Quantity);
}
public int CreateSale(string UserName, Sale newSale)
{
User user = GetUser(UserName);
if (user != null)
{
newSale.UserId = user.Id;
newSale.User = user;
modelContainer.Sales.Add(newSale);
}
return modelContainer.DbSaveChanges();
}
public ActionResult Add(Sale sale, FormCollection form, bool? convert)
{
bool isNew = false;
//write activity to the log
if (sale.ID == 0)
{
isNew = true;
sale.Status = SaleType.Prospecting;
}
if(!string.IsNullOrEmpty(form["Companies"]))
sale.CompanyID = Convert.ToInt32(form["Companies"]);
if(!string.IsNullOrEmpty(form["People"]))
sale.PersonID = Convert.ToInt32(form["People"]);
if(!string.IsNullOrEmpty(form["Members"]))
sale.OwnerID = new Guid(form["Members"]);
if (!string.IsNullOrEmpty(form["PriorityType"]))
sale.Priority = (PriorityType)Enum.Parse(typeof(CrumbCRM.PriorityType), form["PriorityType"], true);
_saleService.Save(sale);
if (!string.IsNullOrEmpty(form["Tags"]))
{
var current = _tagService.GetByArea(AreaType.Sale);
string[] tags = form["Tags"].Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
tags.ToList().ForEach(t =>
{
var tag = _tagService.GetByName(t);
if (tag == null)
{
tag = new Tag()
{
Name = t,
CreatedDate = DateTime.Now,
CreatedByID = _membershipService.GetCurrentMember().UserId
};
_tagService.Save(tag);
}
if(!current.Contains(tag))
_saleService.AssignTag(sale, tag);
});
}
if(isNew)
_activityService.Create("was added", AreaType.Sale, User.Identity.Name, sale.ID);
TempData.Add("StatusMessage", "Sale added");
return RedirectToAction("Index");
}
public ActionResult Create(Sale sale)
{
if (ModelState.IsValid) {
_saleRepository.InsertOrUpdate(sale);
_saleRepository.Save();
return RedirectToAction("Index");
}
ViewBag.PossibleClients = _clientRepository.All;
ViewBag.PossibleLotteries = _lotteryRepository.All;
return View(sale);
}
public ActionResult Create(Sale sale)
{
if (ModelState.IsValid)
{
db.Sales.AddObject(sale);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "FirstName", sale.ClientId);
ViewBag.ShippingAddress = new SelectList(db.Addresses, "AddressId", "Street", sale.ShippingAddress);
return View(sale);
}
public void CreateSale_Is_Idempotent()
{
// arrange
var sale = new Sale("s1", new SaleState());
// act
sale.Create("seller", new Values.Item { Id = "item-id", Name = "item-name" }, price: 10, stock: 5);
sale.Create("seller", new Values.Item { Id = "item-id", Name = "item-name" }, price: 10, stock: 5);
// assert
Assert.That(sale.Changes.Count(), Is.EqualTo(1));
Assert.That(sale.Changes.First().Payload, Is.InstanceOf<SaleCreated>());
}
public decimal CalculateSaleTotal(Sale sale, ICollection<SaleDetail> details)
{
decimal sum = 0;
decimal cost;
foreach (var item in details)
{
cost = Item_Manager.GetByID(item.ItemId).Cost;
sum += item.Quantity * cost;
cost = 0;
}
return sum;
}
public static Sale CreateSale(int? saleStock = null)
{
var stock = saleStock ?? 10;
var sale = new Sale("test-sale-id", new SaleState());
sale.Create("test-seller-id",
new Values.Item { Id = "item-id", Name = "item-name" },
price: 10,
stock: stock);
// create a new aggregate from the state, to ensure the aggregate doesn't come with changes
return AggregateFactory.For<Sale>().CreateFromState(sale.Id, sale.State);
}
public ActionResult Create(Sale sale)
{
if (ModelState.IsValid)
{
sale.Creation = DateTime.Now;
db.Sales.AddObject(sale);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "Name", sale.CustomerID);
ViewBag.TypePaymentID = new SelectList(db.TypePayments, "TypePaymentID", "Name", sale.TypePaymentID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "Name", sale.UserID);
return View(sale);
}
/// <summary>
/// Saves the sale or queues it for later
/// </summary>
/// <param name="sale"></param>
public virtual void Save(Sale sale)
{
//check if it's a scheduled sale
if (sale.Date > DateTime.Now)
{
_repository.Schedule(sale);
sale.State = Sale.SaleState.Reserved;
}
else
{
//otherwise save
_repository.Save(sale);
sale.State = Sale.SaleState.Finalized;
}
}
static void Main(string[] args)
{
var sale = new Sale();
var feature = Factory.Create<ISaleFeature>();
var bus = Factory.Kernel.Get<IEventService>();
bus.Subscribe<ExecuteEvent<Sale>>(x =>
{
Console.WriteLine("Event {0} on {1}", x.Action, x.Entity);
});
feature.Create(sale);
feature.Save(sale);
Console.ReadKey();
}
public ActionResult Create(Sale sale)
{
var adminInfo = db.Admins.Where(a => a.Username.Equals(User.Identity.Name)).First();
sale.AdminID = adminInfo.ID;
sale.Date = DateTime.Now;
sale.Returned = false;
if (ModelState.IsValid)
{
affectStorage(sale);
db.Sales.Add(sale);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.CatID = new SelectList(db.Categories, "ID", "Name", sale.CatID);
ViewBag.ProductID = new SelectList(db.Products, "ID", "Name", sale.ProductID);
ViewBag.StorageID = new SelectList(db.Storages, "ID", "Name", sale.StorageID);
return View(sale);
}
internal async Task <JsonResult> SaleInfo(Sale info)
{
SqlConnection cn = null;
try
{
cn = Connection.GetConnection();
SqlCommand smd = new SqlCommand("sales_order_info", cn)
{
CommandType = CommandType.StoredProcedure
};
smd.Parameters.Add("@sale_info_json", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.Add("@address", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output;
smd.Parameters.AddWithValue("@sales_order_no", info.SaleOrderNo);
// Execute the command
await smd.ExecuteNonQueryAsync().ConfigureAwait(false);
// Get the values
string sale_info = smd.Parameters["@sale_info_json"].Value.ToString();
string address = smd.Parameters["@address"].Value.ToString();
smd.Dispose();
Connection.CloseConnection(ref cn);
SaleInfoResponse saleInfoResponse = new SaleInfoResponse();
JArray Jaddress = JArray.Parse(address);
saleInfoResponse.Sales = JArray.Parse(sale_info);
if (Jaddress[0]["address_type"].ToString() == "Bil")
{
saleInfoResponse.BilTo = (JObject)Jaddress[0];
if (Jaddress.Count > 1)
{
saleInfoResponse.ShioTo = (JObject)Jaddress[1];
}
else
{
saleInfoResponse.ShioTo = (JObject)Jaddress[0];
}
}
else if (Jaddress.Count > 1)
{
saleInfoResponse.BilTo = (JObject)Jaddress[1];
saleInfoResponse.ShioTo = (JObject)Jaddress[0];
}
else
{
saleInfoResponse.BilTo = (JObject)Jaddress[0];
saleInfoResponse.ShioTo = (JObject)Jaddress[0];
}
return(new JsonResult(saleInfoResponse));
}
catch (Exception)
{
throw;
}
finally
{
Connection.CloseConnection(ref cn);
}
}
public void Update(Sale sale)
{
_saleDal.Update(sale);
}
public ActionResult StarSizing_Bind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Read(requestData, Sale.GetData(50))));
}
internal int Create(Sale sale)
{
id = _saleDal.Create(sale);
return(id);
}
public void MergeFrom(FolioCardSale other)
{
if (other == null)
{
return;
}
if (other.sale_ != null)
{
if (sale_ == null)
{
sale_ = new global::HOLMS.Types.Money.Cards.Transactions.PaymentCardSaleIndicator();
}
Sale.MergeFrom(other.Sale);
}
if (other.card_ != null)
{
if (card_ == null)
{
card_ = new global::HOLMS.Types.Folio.FolioGuestPaymentCard();
}
Card.MergeFrom(other.Card);
}
if (other.Purpose != 0)
{
Purpose = other.Purpose;
}
if (other.SaleState != 0)
{
SaleState = other.SaleState;
}
if (other.openAuthorized_ != null)
{
if (openAuthorized_ == null)
{
openAuthorized_ = new global::HOLMS.Types.Primitive.MonetaryAmount();
}
OpenAuthorized.MergeFrom(other.OpenAuthorized);
}
if (other.captured_ != null)
{
if (captured_ == null)
{
captured_ = new global::HOLMS.Types.Primitive.MonetaryAmount();
}
Captured.MergeFrom(other.Captured);
}
if (other.EntryMethod != 0)
{
EntryMethod = other.EntryMethod;
}
if (other.authorizedAt_ != null)
{
if (authorizedAt_ == null)
{
authorizedAt_ = new global::Google.Protobuf.WellKnownTypes.Timestamp();
}
AuthorizedAt.MergeFrom(other.AuthorizedAt);
}
if (other.capturedAt_ != null)
{
if (capturedAt_ == null)
{
capturedAt_ = new global::Google.Protobuf.WellKnownTypes.Timestamp();
}
CapturedAt.MergeFrom(other.CapturedAt);
}
if (other.ApplicationLabel.Length != 0)
{
ApplicationLabel = other.ApplicationLabel;
}
if (other.AID.Length != 0)
{
AID = other.AID;
}
if (other.ApplicationCrypto.Length != 0)
{
ApplicationCrypto = other.ApplicationCrypto;
}
if (other.ApprovalCode.Length != 0)
{
ApprovalCode = other.ApprovalCode;
}
if (other.receivedBy_ != null)
{
if (receivedBy_ == null)
{
receivedBy_ = new global::HOLMS.Types.IAM.StaffMemberIndicator();
}
ReceivedBy.MergeFrom(other.ReceivedBy);
}
if (other.finalAuthorizedAmount_ != null)
{
if (finalAuthorizedAmount_ == null)
{
finalAuthorizedAmount_ = new global::HOLMS.Types.Primitive.MonetaryAmount();
}
FinalAuthorizedAmount.MergeFrom(other.FinalAuthorizedAmount);
}
}
private void btnRecord_Click(object sender, EventArgs e)
{
if (btnRecord.Text == "OK")
{
((frmControlHost)this.Parent).Close();
return;
}
if (gridViewItemLayout.Rows.Count == 0)
{
Helper.ShowMessage("Sale must contain at least one product",
"Sale Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//if (!UtilityClass.ValidateTexBox(txtAmountPaid))
// return;
try
{
Product product;
SaleDetail salesDetails;
Sale sales = new Sale();
string InvoiceNo = txtInvoiceNo.Text;
string AmountPaid = txtAmountPaid.Text;
string subTotalAmt = txtSubTotal.Text;
DateTime?SaleDate = dtpSaleDate.Value;
decimal tax = txtSalTax.Text.ToDecimal();
int locationID = cmbLocation.SelectedValue.ToInt();
decimal saletax = _sale.CalculateTax(subTotalAmt.ToDecimal(), tax);
decimal totalAmount = txtTotalAmt.Text.ToDecimal();
sales.CustomerID = txtCustomer.Tag.ToString();
sales.Amount = totalAmount;
sales.SubTotal = decimal.Parse(subTotalAmt);
sales.InvoiceDate = SaleDate.Value;
sales.InvoiceNumber = InvoiceNo;
sales.StoreID = DEFAULT_LOCALSTOREID; //arbituary value, to bo replaced
sales.Tax = Math.Round(saletax, 2);
sales.PaymentModeID = int.Parse(cmbPaymentMode.SelectedValue.ToString());
//sales.Discount = txtSaleDiscount.Text == "" ? 0 : txtSaleDiscount.Text.ToDecimal();
sales.AmountPaid = 0;
sales.Balance = 0;
sales.DateClosed = null;
//sales.SaleTypeID = (int)SaleStatus.Order;
sales.SaleStatusID = (int)SaleStatuses.Order;//_sale.GetSaleStatus(totalAmount, AmountPaid.ToDecimal());
sales.EmployeeID = txtSalesPerson.Tag == null ? DEFAULT_SALESPERSONID : txtSalesPerson.Tag.ToString();
sales.Discount = txtSaleDiscount.Text == "" ? 0 : decimal.Parse(txtSaleDiscount.Text);
sales.VoidSale = false;
sales.LocationID = cmbLocation.SelectedValue.ToInt();
try
{
sales = _sale.GetSingle(new Sale {
SaleID = _sale.Add(sales)
});
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "ucOrder", "btnRecord");
Helper.ShowMessage("An error occured " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
foreach (DataGridViewRow dr in gridViewItemLayout.Rows)
{
if (dr.Cells[0].Value == null)
{
return;
}
salesDetails = new SaleDetail();
product = new Product();
salesDetails.SaleID = sales.SaleID;
salesDetails.Quantity = int.Parse(dr.Cells["ColQty"].Value.ToString());
salesDetails.ProductID = dr.Cells["ColItmNumber"].Value.ToString();
salesDetails.UnitPrice = decimal.Parse(dr.Cells["ColPrice"].Value.ToString());
salesDetails.Discount = decimal.Parse(dr.Cells["ColDiscount"].Value.ToString());
salesDetails.Tax = decimal.Parse(dr.Cells["ColTax"].Value.ToString());
salesDetails.InvoiceNumber = InvoiceNo;
salesDetails.LineTotal = decimal.Parse(dr.Cells["ColTotal"].Value.ToString());
salesDetails.LocationID = cmbLocation.SelectedValue.ToInt();
try
{
_saleDetail.Add(salesDetails);
}
catch
{
_sale.RollBackSaleTransaction(InvoiceNo);
Helper.ShowMessage("Transaction was not completed, An error occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
int qty = int.Parse(dr.Cells["ColQty"].Value.ToString());
int productID = dr.Cells["ColItmNumber"].Value.ToInt();
try
{
_product.ReduceInventory(qty, productID, locationID);
}
catch (Exception ex)
{
_sale.RollBackSaleTransaction(InvoiceNo);
_logger.LogError(ex, "An error occurred", "ucOrder", "btnRecord");
}
}
txtInvoiceNo.Tag = false;
txtSubTotal.Tag = null;
txtTotalAmt.Tag = null;
Helper.ClearForm(this);
gridViewItemLayout.Rows.Clear();
lblStatus.Text = "Order recorded successfully";
GetInvoiceNo();
}
catch (Exception ex)
{
Helper.ShowMessage("An error occured sale has been cancelled \n" + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Assign "Payment Method" form for sale object
/// </summary>
/// <param name="sale"></param>
public void SetSale(Sale sale)
{
this.sale = sale;
lblBalanceNo.Text = sale.getBalance().ToString("C");
this.Show();
}
public IActionResult PostPublisherDetails()
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var publisher = new Publisher
{
PublisherName = "Tom Cruise",
State = "NY",
Country = "USA",
City = "New York"
};
var book1 = new Book
{
Title = "Sushi, Anyone?",
PublishedDate = DateTime.Now
};
var book2 = new Book
{
Title = "Sushi2, Anyone?",
PublishedDate = DateTime.Now
};
var sales1 = new Sale
{
Quantity = 10,
StoreId = "6380",
PayTerms = "Net 60",
OrderNum = "6871",
OrderDate = DateTime.Now,
};
var sales2 = new Sale
{
Quantity = 20,
StoreId = "6380",
PayTerms = "Net 61",
OrderNum = "6872",
OrderDate = DateTime.Now,
};
book1.Sales.Add(sales1);
book2.Sales.Add(sales2);
publisher.Books.Add(book1);
publisher.Books.Add(book2);
_context.Publishers.Add(publisher);
_context.SaveChanges();
if (publisher == null)
{
return(NotFound());
}
return(Ok(publisher));
}
public Sale Add(Sale sale)
{
return(_saleDal.Add(sale));
}
public bool Save(Sale t)
{
return(saleRepository.Save(t));
}
public bool Update(Sale t)
{
return(saleRepository.Update(t));
}
public bool Delete(Sale t)
{
return(saleRepository.Delete(t));
}
private void SeedSale(BreadingBreadDbContext context)
{
var sales = new Sale[]
{
new Sale
{
IdUserSale = 1,
IdStore = 1,
Total = 20,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 1,
IdStore = 2,
Total = 30,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 1,
IdStore = 3,
Total = 30,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 2,
IdStore = 1,
Total = 20,
Visited = System.DateTime.Now.AddDays(-1),
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 3,
IdStore = 2,
Total = 20,
Visited = System.DateTime.Now.AddDays(-1),
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
};
foreach (var sale in sales)
{
context.Sale.Add(sale);
context.SaveChanges();
}
}
public void Update(Sale sale)
{
_context.Entry(sale).State = EntityState.Modified;
_context.SaveChanges();
}
}//Check_ForBackorders
public List <Part> Place_Order(string username, int couponid, FinalTotalPOCO totals, string paymethod)
{
using (var context = new eBikeContext())
{
//Get the customers id
int customerid = (from x in context.OnlineCustomers
where x.UserName.Equals(username)
select x.OnlineCustomerID).FirstOrDefault();
if (customerid == 0)
{
throw new Exception("You do not have a shopping cart, please add items to place an order");
}
else
{
//Create and populate a new Sale
Sale newsale = new Sale();
newsale.SaleDate = DateTime.Now;
newsale.UserName = username;
newsale.EmployeeID = 10;
newsale.TaxAmount = totals.GST;
newsale.SubTotal = totals.SubTotal;
//Check if a coupon has been selected (FK constraint)
if (couponid == 0)
{
newsale.CouponID = null;
}
else
{
newsale.CouponID = couponid;
}
newsale.PaymentType = paymethod;
newsale.PaymentToken = Guid.NewGuid();
//Add the new Sale to database
newsale = context.Sales.Add(newsale);
//Get the customers shopping cart id
int shoppingcartid = (from x in context.ShoppingCarts
where x.OnlineCustomerID.Equals(customerid)
select x.ShoppingCartID).FirstOrDefault();
//Get a list of all items in the customers shopping cart
List <ShoppingCartItem> useritems = (from x in context.ShoppingCartItems
where x.ShoppingCart.ShoppingCartID.Equals(shoppingcartid)
select x).ToList();
//Create a list of parts to be filled with backordered parts
List <Part> backorderedparts = new List <Part>();
//Create a Sale Detail for each item
foreach (ShoppingCartItem item in useritems)
{
//Get the corresponding part info
Part part = (from x in context.Parts
where x.PartID.Equals(item.PartID)
select x).FirstOrDefault();
//Check the remaining quantity of the part
if (item.Quantity > part.QuantityOnHand)
{
//Create a backordered sale detail
SaleDetail boitem = new SaleDetail();
boitem.SaleID = newsale.SaleID;
boitem.PartID = part.PartID;
boitem.Quantity = item.Quantity;
boitem.SellingPrice = part.SellingPrice;
boitem.Backordered = true;
boitem.ShippedDate = null;
//Add the backordered part to return list
backorderedparts.Add(part);
//Add the backordered sale detail to database
context.SaleDetails.Add(boitem);
}
else
{
//Create a regular sale detail
SaleDetail saleitem = new SaleDetail();
saleitem.SaleID = newsale.SaleID;
saleitem.PartID = part.PartID;
saleitem.Quantity = item.Quantity;
saleitem.SellingPrice = part.SellingPrice;
saleitem.Backordered = false;
saleitem.ShippedDate = DateTime.Now;
//Update QuantityOnHand for the part
part.QuantityOnHand = part.QuantityOnHand - item.Quantity;
//Make change to QOH in the database
context.Entry(part).Property(y => y.QuantityOnHand).IsModified = true;
//Add the new sale detail
context.SaleDetails.Add(saleitem);
}
//Delete the ShoppingCartItem from users ShoppingCart
context.ShoppingCartItems.Remove(item);
}//foreach item in useritems
//Find and delete the users ShoppingCart
var existingItem = context.ShoppingCarts.Find(shoppingcartid);
context.ShoppingCarts.Remove(existingItem);
//Save changes
context.SaveChanges();
//Return any backordered parts for display to user
return(backorderedparts);
}
}
}//Place_Order
public void AddSale(Sale sale)
{
dataAccess.AddSale(sale);
}
internal bool Edit(Sale sale)
{
status = _saleDal.Edit(sale);
return(status);
}
public void Apply(Campaign campaign, Sale sale)
{
Console.WriteLine(campaign.CampaignName + " kampanyası " + campaign.Detail + " olacak şekilde " + sale.GameName + " satışına uygulanmıştır.");
}
internal Sale GetById(int?id)
{
Sale sale = _saleDal.GetById(id);
return(sale);
}
/// <summary>
/// Method to suspend a sale
/// </summary>
/// <param name="saleType">Sale type</param>
/// <param name="shareSusp">Share suspended sale or not</param>
/// <param name="sale">Sale</param>
/// <param name="userCode">User code</param>
public void SuspendSale(string saleType, bool shareSusp, Sale sale, string userCode)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,SuspendedSaleService,SuspendSale,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
var uHead = new DataTable();
var uLine = new DataTable();
var uReason = new DataTable();
SqlDataAdapter adapHead;
SqlDataAdapter adapLine;
SqlDataAdapter adapReason;
var tillConnection = new SqlConnection(GetConnectionString(DataSource.CSCTills));
if (tillConnection.State == ConnectionState.Closed)
{
tillConnection.Open();
}
if (shareSusp)
{
adapHead = new SqlDataAdapter("select * from SusHead", tillConnection);
adapHead.Fill(uHead);
adapLine = new SqlDataAdapter("select * from SusLine", tillConnection);
adapLine.Fill(uLine);
adapReason = new SqlDataAdapter("select * from SusReas", tillConnection);
adapReason.Fill(uReason);
}
else
{
adapHead = new SqlDataAdapter("select * from SusHead where SusHead.TILL=" + sale.TillNumber, tillConnection);
adapHead.Fill(uHead);
adapLine = new SqlDataAdapter("select * from SusLine where SusLine.TILL_NUM=" + sale.TillNumber, tillConnection);
adapLine.Fill(uLine);
adapReason = new SqlDataAdapter("select * from SusReas where SusReas.TILL_NUM=" + sale.TillNumber, tillConnection);
adapReason.Fill(uReason);
}
var sTmpCardSales = GetRecords("select * from CardSales where TILL_NUM=" + sale.TillNumber + " AND SALE_NO = " + sale.Sale_Num, DataSource.CSCCurSale);
var sCardSales = new DataTable();
_adapter = new SqlDataAdapter("select * from CardSales where TILL_NUM=" + sale.TillNumber, tillConnection);
_adapter.Fill(sCardSales);
foreach (DataRow dataRow in sTmpCardSales.Rows)
{
var newRow = sCardSales.NewRow();
newRow["TILL_NUM"] = sale.TillNumber;
newRow["SALE_NO"] = dataRow["SALE_NO"];
newRow["LINE_NUM"] = dataRow["LINE_NUM"];
newRow["CardType"] = dataRow["CardType"];
newRow["CardNum"] = dataRow["CardNum"];
newRow["CardBalance"] = dataRow["CardBalance"];
newRow["PointBalance"] = dataRow["PointBalance"];
newRow["SaleAmount"] = dataRow["SaleAmount"];
newRow["SaleType"] = dataRow["SaleType"];
newRow["ExpDate"] = dataRow["ExpDate"];
newRow["RefNum"] = dataRow["RefNum"];
newRow["Response"] = dataRow["Response"];
sCardSales.Rows.Add(newRow);
}
var builder = new SqlCommandBuilder(_adapter);
_adapter.InsertCommand = builder.GetInsertCommand();
_adapter.Update(sCardSales);
_adapter?.Dispose();
DataRow uRow = uHead.NewRow();
uRow["SALE_NO"] = sale.Sale_Num;
uRow["Till"] = sale.TillNumber;
uRow["Regist"] = sale.Register;
uRow["User"] = userCode;
uRow["Client"] = sale.Customer.Code;
uRow["T_type"] = sale.Sale_Type; // Nicolette added
uRow["Reason"] = sale.Return_Reason.Reason;
uRow["Reason_Type"] = sale.Return_Reason.RType;
uRow["Disc_Type"] = sale.Sale_Totals.Invoice_Discount_Type;
uRow["Invc_Disc"] = sale.Sale_Totals.Invoice_Discount;
uRow["Discount_Percent"] = sale.Sale_Totals.Discount_Percent;
uRow["Void_No"] = sale.Void_Num;
uRow["LoyaltyCard"] = sale.Customer.LoyaltyCard;
uRow["LoyaltyExpDate"] = sale.Customer.LoyaltyExpDate;
if (!string.IsNullOrEmpty(sale.CouponID))
{
if (sale.CouponTotal < 0)
{
uRow["CouponID"] = sale.CouponID;
}
}
uRow["Upsell"] = sale.Upsell;
uHead.Rows.Add(uRow);
builder = new SqlCommandBuilder(adapHead);
adapHead.InsertCommand = builder.GetInsertCommand();
adapHead.Update(uHead);
adapHead.Dispose();
var ln = (short)0;
foreach (Sale_Line tempLoopVarSl in sale.Sale_Lines)
{
var sl = tempLoopVarSl;
ln++;
var uLineRow = uLine.NewRow();
uLineRow["sale_no"] = sale.Sale_Num;
uLineRow["Line_Num"] = ln;
uLineRow["PLU_Code"] = sl.PLU_Code;
uLineRow["Quantity"] = sl.Quantity;
uLineRow["price"] = sl.price;
uLineRow["Discount"] = sl.Line_Discount;
uLineRow["Disc_Type"] = sl.Discount_Type;
uLineRow["Disc_Adj"] = sl.Discount_Adjust;
uLineRow["Disc_Code"] = sl.Discount_Code;
uLineRow["Disc_Rate"] = sl.Discount_Rate;
uLineRow["DiscountName"] = sl.DiscountName; //
uLineRow["Loyl_Save"] = sl.Loyalty_Save;
uLineRow["Units"] = sl.Units;
uLineRow["Serial_No"] = sl.Serial_No;
uLineRow["User"] = sl.User;
uLineRow["pumpID"] = sl.pumpID;
uLineRow["PositionID"] = sl.PositionID;
uLineRow["GradeID"] = sl.GradeID;
uLineRow["Gift_Cert"] = sl.Gift_Certificate;
uLineRow["GC_Num"] = sl.Gift_Num;
uLineRow["Till_Num"] = sale.TillNumber;
uLineRow["ManualFuel"] = sl.ManualFuel;
uLineRow["TaxExempt"] = sl.IsTaxExemptItem;
uLineRow["Amount"] = sl.Amount;
if (sl.PromoID != "")
{
uLineRow["PromoID"] = sl.PromoID;
}
uLineRow["Upsell"] = sl.Upsell;
uLineRow["ScalableItem"] = sl.ScalableItem;
uLine.Rows.Add(uLineRow);
foreach (Return_Reason tempLoopVarRr in sl.Return_Reasons)
{
var reasonRow = uReason.NewRow();
reasonRow["Till_Num"] = sale.TillNumber;
reasonRow["sale_no"] = sale.Sale_Num;
reasonRow["Line_Num"] = ln;
reasonRow["Reason"] = tempLoopVarRr.Reason;
reasonRow["Reason_Type"] = tempLoopVarRr.RType;
uReason.Rows.Add(reasonRow);
builder = new SqlCommandBuilder(adapReason);
adapReason.InsertCommand = builder.GetInsertCommand();
adapReason.Update(uReason);
}
adapReason.Dispose();
builder = new SqlCommandBuilder(adapLine);
adapLine.InsertCommand = builder.GetInsertCommand();
adapLine.Update(uLine);
}
adapLine.Dispose();
tillConnection.Close();
Execute("Delete from CurrentSale Where SaleNumber = " + Convert.ToString(sale.Sale_Num), DataSource.CSCCurSale);
Execute("Delete FROM CardSales WHERE CardSales.SALE_NO = " + Convert.ToString(sale.Sale_Num), DataSource.CSCCurSale);
_performancelog.Debug($"End,SuspendedSaleService,SuspendSale,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
}
/// <summary>
/// Process a payment
/// </summary>
/// <param name="processPaymentRequest">Payment info required for an order processing</param>
/// <returns>Process payment result</returns>
public ProcessPaymentResult ProcessPayment(ProcessPaymentRequest processPaymentRequest)
{
var result = new ProcessPaymentResult();
var customer = _customerService.GetCustomerById(processPaymentRequest.CustomerId);
if (customer == null)
{
throw new Exception("Customer cannot be loaded");
}
try
{
var apiContext = PaypalHelper.GetApiContext(_paypalDirectPaymentSettings);
var currency = _currencyService.GetCurrencyById(_currencySettings.PrimaryStoreCurrencyId);
var payment = new Payment()
{
#region payer
payer = new Payer()
{
payment_method = "credit_card",
#region credit card info
funding_instruments = new List <FundingInstrument>
{
new FundingInstrument
{
credit_card = new CreditCard
{
type = processPaymentRequest.CreditCardType.ToLowerInvariant(),
number = processPaymentRequest.CreditCardNumber,
cvv2 = processPaymentRequest.CreditCardCvv2,
expire_month = processPaymentRequest.CreditCardExpireMonth,
expire_year = processPaymentRequest.CreditCardExpireYear
}
}
},
#endregion
#region payer info
payer_info = new PayerInfo
{
#region billing address
billing_address = customer.BillingAddress == null ? null : new Address
{
country_code = customer.BillingAddress.Country != null ? customer.BillingAddress.Country.TwoLetterIsoCode : null,
state = customer.BillingAddress.StateProvince != null ? customer.BillingAddress.StateProvince.Abbreviation : null,
city = customer.BillingAddress.City,
line1 = customer.BillingAddress.Address1,
line2 = customer.BillingAddress.Address2,
phone = customer.BillingAddress.PhoneNumber,
postal_code = customer.BillingAddress.ZipPostalCode
},
#endregion
email = customer.BillingAddress != null ? customer.BillingAddress.Email : null,
first_name = customer.BillingAddress != null ? customer.BillingAddress.FirstName : null,
last_name = customer.BillingAddress != null ? customer.BillingAddress.LastName : null
}
#endregion
},
#endregion
#region transaction
transactions = new List <Transaction>()
{
new Transaction
{
#region amount
amount = new Amount
{
total = processPaymentRequest.OrderTotal.ToString("N", new CultureInfo("en-US")),
currency = currency != null ? currency.CurrencyCode : null
},
#endregion
#region shipping address
item_list = customer.ShippingAddress == null ? null : new ItemList
{
shipping_address = new ShippingAddress
{
country_code = customer.ShippingAddress.Country != null ? customer.ShippingAddress.Country.TwoLetterIsoCode : null,
state = customer.ShippingAddress.StateProvince != null ? customer.ShippingAddress.StateProvince.Abbreviation : null,
city = customer.ShippingAddress.City,
line1 = customer.ShippingAddress.Address1,
line2 = customer.ShippingAddress.Address2,
phone = customer.ShippingAddress.PhoneNumber,
postal_code = customer.ShippingAddress.ZipPostalCode,
recipient_name = string.Format("{0} {1}", customer.ShippingAddress.FirstName, customer.ShippingAddress.LastName)
}
},
#endregion
invoice_number = processPaymentRequest.OrderGuid != Guid.Empty ? processPaymentRequest.OrderGuid.ToString() : null
}
},
#endregion
intent = _paypalDirectPaymentSettings.TransactMode == TransactMode.Authorize ? "authorize" : "sale",
}.Create(apiContext);
if (payment.transactions[0].related_resources.Any() && payment.transactions[0].related_resources[0] != null)
{
if (_paypalDirectPaymentSettings.TransactMode == TransactMode.Authorize)
{
var authorization = payment.transactions[0].related_resources[0].authorization;
if (authorization != null)
{
if (authorization.fmf_details != null && !string.IsNullOrEmpty(authorization.fmf_details.filter_id))
{
result.AuthorizationTransactionResult = string.Format("Authorization is {0}. Based on fraud filter: {1}. {2}",
authorization.fmf_details.filter_type, authorization.fmf_details.name, authorization.fmf_details.description);
result.NewPaymentStatus = GetPaymentStatus(Authorization.Get(apiContext, authorization.id).state);
}
else
{
result.AuthorizationTransactionResult = authorization.state;
result.NewPaymentStatus = GetPaymentStatus(authorization.state);
}
result.AuthorizationTransactionId = authorization.id;
}
}
else
{
var sale = payment.transactions[0].related_resources[0].sale;
if (sale != null)
{
if (sale.fmf_details != null && !string.IsNullOrEmpty(sale.fmf_details.filter_id))
{
result.CaptureTransactionResult = string.Format("Sale is {0}. Based on fraud filter: {1}. {2}",
sale.fmf_details.filter_type, sale.fmf_details.name, sale.fmf_details.description);
result.NewPaymentStatus = GetPaymentStatus(Sale.Get(apiContext, sale.id).state);
}
else
{
result.CaptureTransactionResult = sale.state;
result.NewPaymentStatus = GetPaymentStatus(sale.state);
}
result.CaptureTransactionId = sale.id;
result.AvsResult = sale.processor_response != null ? sale.processor_response.avs_code : string.Empty;
}
}
}
else
{
result.AddError("PayPal error");
}
}
catch (PayPal.PayPalException exc)
{
if (exc is PayPal.ConnectionException)
{
var error = JsonFormatter.ConvertFromJson <Error>((exc as PayPal.ConnectionException).Response);
if (error != null)
{
result.AddError(string.Format("PayPal error: {0} ({1})", error.message, error.name));
if (error.details != null)
{
error.details.ForEach(x => result.AddError(string.Format("{0} {1}", x.field, x.issue)));
}
}
}
//if there are not the specific errors add exception message
if (result.Success)
{
result.AddError(exc.InnerException != null ? exc.InnerException.Message : exc.Message);
}
}
return(result);
}
/// <summary>
/// Method to get suspended sale
/// </summary>
/// <param name="tillNumber">Till number</param>
/// <param name="saleNumber">Sale number</param>
/// <param name="shareSusp">Share suspended sale</param>
/// <returns>Sale</returns>
public Sale GetSuspendedSale(int tillNumber, int saleNumber, bool shareSusp)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,SuspendedSaleService,GetSuspendedSale,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
var sale = new Sale();
DataTable uHead;
DataTable uLine;
if (shareSusp)
{
uHead = GetRecords("select * from SusHead WHERE SALE_NO=" + Convert.ToString(saleNumber), DataSource.CSCTills);
uLine = GetRecords("select * from SusLine WHERE SALE_NO=" + Convert.ToString(saleNumber) + " ORDER BY SusLine.Line_Num ", DataSource.CSCTills);
}
else
{
uHead = GetRecords("select * from SusHead where TILL=" + tillNumber + " AND SALE_NO=" + Convert.ToString(saleNumber), DataSource.CSCTills);
uLine = GetRecords("select * from SusLine where TILL_NUM=" + tillNumber + " AND SALE_NO=" + Convert.ToString(saleNumber) + " ORDER BY SusLine.Line_Num ", DataSource.CSCTills);
}
if (uHead.Rows.Count > 0)
{
sale.Sale_Num = CommonUtility.GetIntergerValue(uHead.Rows[0]["SALE_NO"]);
sale.TillNumber = (byte)tillNumber;
sale.Register = CommonUtility.GetByteValue(uHead.Rows[0]["Regist"]);
sale.Customer.Code = CommonUtility.GetStringValue(uHead.Rows[0]["Client"]);
sale.Sale_Type = CommonUtility.GetStringValue(uHead.Rows[0]["T_type"]);
sale.Return_Reason.Reason = CommonUtility.GetStringValue(uHead.Rows[0]["Reason"]);
sale.Return_Reason.RType = CommonUtility.GetStringValue(uHead.Rows[0]["Reason_Type"]);
sale.Sale_Totals.Invoice_Discount_Type = CommonUtility.GetStringValue(uHead.Rows[0]["Disc_Type"]);
sale.Sale_Totals.Invoice_Discount = CommonUtility.GetDecimalValue(uHead.Rows[0]["Invc_Disc"]);
sale.Sale_Totals.Discount_Percent = CommonUtility.GetFloatValue(uHead.Rows[0]["Discount_Percent"]);
sale.Void_Num = CommonUtility.GetIntergerValue(uHead.Rows[0]["Void_No"]);
sale.Customer.LoyaltyCard = CommonUtility.GetStringValue(uHead.Rows[0]["LoyaltyCard"]);
sale.Customer.LoyaltyExpDate = CommonUtility.GetStringValue(uHead.Rows[0]["LoyaltyExpDate"]);
sale.CouponID = CommonUtility.GetStringValue(uHead.Rows[0]["CouponID"]);
sale.Upsell = CommonUtility.GetBooleanValue(uHead.Rows[0]["Upsell"]);
var ln = (short)0;
foreach (DataRow row in uLine.Rows)
{
ln++;
var sl = new Sale_Line
{
Sale_Num = CommonUtility.GetStringValue(row["sale_no"]),
Till_Num = sale.TillNumber
};
sale.Sale_Num = CommonUtility.GetIntergerValue(row["sale_no"]);
sl.Line_Num = ln;
sl.PLU_Code = CommonUtility.GetStringValue(row["PLU_Code"]);
sl.Quantity = CommonUtility.GetFloatValue(row["Quantity"]);
sl.price = CommonUtility.GetDoubleValue(row["price"]);
sl.Amount = CommonUtility.GetDecimalValue(row["Amount"]);
sl.Line_Discount = CommonUtility.GetDoubleValue(row["Discount"]);
sl.Discount_Type = CommonUtility.GetStringValue(row["Disc_Type"]);
sl.Discount_Adjust = CommonUtility.GetDoubleValue(row["Disc_Adj"]);
sl.Discount_Code = CommonUtility.GetStringValue(row["Disc_Code"]);
sl.Discount_Rate = CommonUtility.GetFloatValue(row["Disc_Rate"]);
sl.DiscountName = CommonUtility.GetStringValue(row["DiscountName"]);
sl.Price_Type = CommonUtility.GetCharValue(row["Price_Type"]);
sl.Loyalty_Save = CommonUtility.GetFloatValue(row["Loyl_Save"]);
sl.Units = CommonUtility.GetStringValue(row["Units"]);
sl.Serial_No = CommonUtility.GetStringValue(row["Serial_No"]);
sl.User = CommonUtility.GetStringValue(row["User"]);
sl.pumpID = CommonUtility.GetByteValue(row["pumpID"]);
sl.PositionID = CommonUtility.GetByteValue(row["PositionID"]);
sl.GradeID = CommonUtility.GetByteValue(row["GradeID"]);
sl.Gift_Certificate = CommonUtility.GetBooleanValue(row["Gift_Cert"]);
sl.Gift_Num = CommonUtility.GetStringValue(row["GC_Num"]);
sale.TillNumber = (byte)tillNumber;
sl.ManualFuel = CommonUtility.GetBooleanValue(row["ManualFuel"]);
sl.IsTaxExemptItem = CommonUtility.GetBooleanValue(row["TaxExempt"]);
var strPromo = CommonUtility.GetStringValue(row["PromoID"]);
if (!string.IsNullOrEmpty(strPromo))
{
sl.PromoID = strPromo;
}
sl.Upsell = CommonUtility.GetBooleanValue(row["Upsell"]);
sl.ScalableItem = CommonUtility.GetBooleanValue(row["ScalableItem"]);
DataTable uReason;
if (shareSusp)
{
uReason =
GetRecords(
"select * from SusReas WHERE SALE_NO=" + Convert.ToString(saleNumber) +
" AND LINE_Num = " + ln + " ORDER BY SusReas.Line_Num", DataSource.CSCTills);
}
else
{
uReason =
GetRecords(
"select * from SusReas where TILL_NUM=" + tillNumber + " AND SALE_NO=" +
Convert.ToString(saleNumber) + " AND LINE_Num = " + ln +
" ORDER BY SusReas.Line_Num", DataSource.CSCTills);
}
var returnReason = new Return_Reason();
foreach (DataRow dataRow in uReason.Rows)
{
if (CommonUtility.GetStringValue(dataRow["Reason"]) != "" &
CommonUtility.GetStringValue(dataRow["Reason_Type"]) != "")
{
returnReason.Reason = CommonUtility.GetStringValue(dataRow["Reason"]);
returnReason.RType = CommonUtility.GetStringValue(dataRow["Reason_Type"]);
}
sl.Return_Reasons.Add(returnReason.Reason, returnReason.RType, ln.ToString());
}
sale.Sale_Lines.AddLine(ln, sl, "");
}
_performancelog.Debug($"End,SuspendedSaleService,GetSuspendedSale,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
return(sale);
}
_performancelog.Debug($"End,SuspendedSaleService,GetSuspendedSale,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
return(new Sale());
}
private static void Seed(SalesContext db)
{
Customer customer = new Customer
{
Name = "Gosho",
Email = "*****@*****.**",
CreditCardNumber = "123",
};
Customer customer2 = new Customer
{
Name = "Ivan",
Email = "*****@*****.**",
CreditCardNumber = "567",
};
db.Add(customer2);
db.Add(customer);
Sale sale = new Sale
{
Date = DateTime.Now,
ProductId = 1,
CustomerId = 1,
StoreId = 2,
};
db.AddRange(sale);
Sale sale2 = new Sale
{
Date = DateTime.Now,
ProductId = 2,
CustomerId = 2,
StoreId = 1,
};
db.Add(sale2);
Sale sale3 = new Sale
{
Date = DateTime.Now,
ProductId = 1,
CustomerId = 1,
StoreId = 2,
};
db.Add(sale3);
Product product = new Product
{
Name = "Sirene",
Quantity = 15,
Price = 120,
Description = "Unikalno",
};
product.Sales.Add(sale);
product.Sales.Add(sale2);
Product product2 = new Product
{
Name = "Salam",
Quantity = 5,
Price = 13,
Description = "Vkusno",
};
product2.Sales.Add(sale);
product2.Sales.Add(sale2);
db.Add(product2);
Store store = new Store
{
Name = "Metro"
};
store.Sales.Add(sale3);
db.Add(store);
db.SaveChanges();
}
public async Task <dynamic> SendSale(Sale sale)
{
return(await _apiBase.AppendPathSegment("sales").PostJsonAsync(sale).ReceiveJson());
}
public override int GetHashCode()
{
int hash = 1;
if (sale_ != null)
{
hash ^= Sale.GetHashCode();
}
if (card_ != null)
{
hash ^= Card.GetHashCode();
}
if (Purpose != 0)
{
hash ^= Purpose.GetHashCode();
}
if (SaleState != 0)
{
hash ^= SaleState.GetHashCode();
}
if (openAuthorized_ != null)
{
hash ^= OpenAuthorized.GetHashCode();
}
if (captured_ != null)
{
hash ^= Captured.GetHashCode();
}
if (EntryMethod != 0)
{
hash ^= EntryMethod.GetHashCode();
}
if (authorizedAt_ != null)
{
hash ^= AuthorizedAt.GetHashCode();
}
if (capturedAt_ != null)
{
hash ^= CapturedAt.GetHashCode();
}
if (ApplicationLabel.Length != 0)
{
hash ^= ApplicationLabel.GetHashCode();
}
if (AID.Length != 0)
{
hash ^= AID.GetHashCode();
}
if (ApplicationCrypto.Length != 0)
{
hash ^= ApplicationCrypto.GetHashCode();
}
if (ApprovalCode.Length != 0)
{
hash ^= ApprovalCode.GetHashCode();
}
if (receivedBy_ != null)
{
hash ^= ReceivedBy.GetHashCode();
}
if (finalAuthorizedAmount_ != null)
{
hash ^= FinalAuthorizedAmount.GetHashCode();
}
return(hash);
}
public void Delete(Sale sale)
{
_saleDal.Delete(sale);
}
public void Insert(Sale sale)
{
_contextEf.Sales.Add(sale);
_contextEf.SaveChanges();
}
public bool Add(Sale sale)
{
return(_saleRepository.Add(sale));
}
protected override void Seed(SalesContext context)
{
// Products
var product1 = new Product()
{
Name = "Cheese",
Quantity = 150,
Price = 6.90m,
};
context.Products.Add(product1);
var product2 = new Product()
{
Name = "Milk",
Quantity = 50,
Price = 2.50m,
};
context.Products.Add(product2);
var product3 = new Product()
{
Name = "Bread",
Quantity = 60,
Price = 0.90m,
};
context.Products.Add(product3);
var product4 = new Product()
{
Name = "Chicken",
Quantity = 99,
Price = 9.99m,
};
context.Products.Add(product4);
var product5 = new Product()
{
Name = "Fur",
Quantity = 99,
Price = 9.99m,
};
context.Products.Add(product5);
// Products
// Customers
var customer1 = new Customer()
{
Name = "Pesho",
Email = "*****@*****.**",
CreditCardNumber = "IBN231231675"
};
context.Customers.Add(customer1);
var customer2 = new Customer()
{
Name = "Goshko",
Email = "*****@*****.**",
CreditCardNumber = "IBN6967MVC75"
};
context.Customers.Add(customer2);
var customer3 = new Customer()
{
Name = "Sashko",
Email = "*****@*****.**",
CreditCardNumber = "IBN231231675"
};
context.Customers.Add(customer3);
var customer4 = new Customer()
{
Name = "Vlado",
Email = "*****@*****.**",
CreditCardNumber = "IBN6997316757"
};
context.Customers.Add(customer4);
var customer5 = new Customer()
{
Name = "John Cena",
Email = "*****@*****.**",
CreditCardNumber = "IBN6997316757"
};
context.Customers.Add(customer5);
// Customers
// Stores
var storeLocation1 = new StoreLocation()
{
LocationName = "Barcelona"
};
context.StoreLocations.Add(storeLocation1);
var storeLocation2 = new StoreLocation()
{
LocationName = "Madrid"
};
context.StoreLocations.Add(storeLocation2);
var storeLocation3 = new StoreLocation()
{
LocationName = "London"
};
context.StoreLocations.Add(storeLocation3);
var storeLocation4 = new StoreLocation()
{
LocationName = "Sofia"
};
context.StoreLocations.Add(storeLocation4);
var storeLocation5 = new StoreLocation()
{
LocationName = "Plovdiv"
};
context.StoreLocations.Add(storeLocation5);
// Locations
// Sales
var sale1 = new Sale()
{
Customer = customer3,
Product = product1,
StoreLocation = storeLocation5,
Date = Convert.ToDateTime("01/08/2016"),
};
context.Sales.Add(sale1);
var sale2 = new Sale()
{
Customer = customer1,
Product = product2,
StoreLocation = storeLocation4,
Date = Convert.ToDateTime("05/08/2016")
};
context.Sales.Add(sale2);
var sale3 = new Sale()
{
Customer = customer5,
Product = product4,
StoreLocation = storeLocation2,
Date = Convert.ToDateTime("12/02/2017")
};
context.Sales.Add(sale3);
var sale4 = new Sale()
{
Customer = customer1,
Product = product2,
StoreLocation = storeLocation3,
Date = Convert.ToDateTime(DateTime.Now)
};
context.Sales.Add(sale4);
var sale5 = new Sale()
{
Customer = customer1,
Product = product5,
StoreLocation = storeLocation2,
Date = Convert.ToDateTime("1/03/2017")
};
context.Sales.Add(sale5);
base.Seed(context);
}
public void Add(Sale sale)
{
_context.Add(sale);
_context.SaveChanges();
}
