public ISoldProductModel FindById(int id)
{
SoldProduct item = _db.SoldProducts.Find(id);
ISoldProductModel model = MapTheSoldProductObject(item);
return(model);
}
public void EntryWithTwoPreviousEntries()
{
_entries = new List <RaffleEntry>();
Guid serial = Guid.NewGuid();
SoldProduct soldProduct = new SoldProduct {
SerialNumber = serial
};
_products = new List <SoldProduct> {
soldProduct
};
RaffleEntry entry1 = getEntry();
entry1.SoldProduct = soldProduct;
RaffleEntry entry2 = getEntry();
entry2.SoldProduct = soldProduct;
_entries.Add(entry1);
_entries.Add(entry2);
_entry = getEntry();
_entry.SoldProduct = soldProduct;
bool validEntry = _validator.ValidateEntry(_products.AsQueryable(), _entries.AsQueryable(), _entry);
Assert.False(validEntry, "Entry got validated with 2 previous entries with the same serial number.");
}
public void CompletePurchase()
{
//Do transaction
if (ProductsInBasket.Count > 0)
{
Transaction transaction = new Transaction(this.ProductsInBasket.ToList());
transaction.ExecuteTransaction();
//Move products to soldproducts
List <SoldProduct> soldList = new List <SoldProduct>();
foreach (List <Product> x in this.ProductsInBasket.ToList())
{
foreach (Product product in x)
{
SoldProduct soldproduct = new SoldProduct(product);
soldproduct.transactionid = transaction.id;
soldList.Add(soldproduct);
}
}
AddSoldProductsToDatabase(soldList);
RemoveProductsInBasketFromDatabase(ProductsInBasket.ToList());
notifyUserAboutCompletedPurchase(transaction.id, transaction.sum);
}
else
{
PopupService.PopupMessage("Der er ikke blevet tilføjet nogen produkter til kurven.", "Ingen produkter");
}
}
public static Invoice IssuedInvoiceValidWithoutShippingCompanyWithAddresseeLegalPerson()
{
Invoice invoice = new Invoice();
invoice.Id = 1;
invoice.OperationNature = "Venda";
invoice.EntryDate = DateTime.Now;
invoice.IssueDate = DateTime.Now;
invoice.AcessKey = "BAJDSA0123IU43I249206954";
invoice.Issuer = IssuerValidWithoutIdAndWithAddress();
invoice.Addressee = AddresseePessoaJuridicaValida(AddressValid());
invoice.ShippingCompany = null;
List <SoldProduct> productsSold = new List <SoldProduct>();
for (int i = 0; i < 20; i++)
{
SoldProduct soldProduct = SoldProductValidWithoutId();
soldProduct.Product.Code = i.ToString();
productsSold.Add(soldProduct);
}
invoice.SoldProducts = productsSold;
invoice.InvoiceTax = new InvoiceTax();
invoice.CalculateTax();
invoice.InvoiceTax.ShippingValue = 10;
return(invoice);
}
private void btnAdd_Click(object sender, System.EventArgs e)
{
if (CurrentProduct == null)
{
return;
}
var productInGrid = new SoldProduct
{
Id = -1,
CategoryId = CurrentProduct.CategoryId,
CreditId = CurrentCredit == null ? -1 : CurrentCredit.Id,
Name = CurrentProduct.Name,
AddAmount = string.IsNullOrEmpty(tbAdd.Text) ? 0 : Convert.ToDecimal(tbAdd.Text.Replace('.', ',')),
Total = string.IsNullOrEmpty(tbTotalForTovar.Text) ? 0 : Convert.ToDecimal(tbTotalForTovar.Text.Replace('.', ',')),
Price = string.IsNullOrEmpty(tbPrice.Text) ? 0 : Convert.ToDecimal(tbPrice.Text.Replace('.', ',')),
Discount = string.IsNullOrEmpty(tbDiscount.Text) ? 0 : Convert.ToDecimal(tbDiscount.Text.Replace('.', ','))
};
var row = new DataGridViewRow();
row.Tag = productInGrid;
for (int i = 0; i < 5; i++)
{
row.Cells.Add(new DataGridViewTextBoxCell());
}
row.Cells[0].Value = productInGrid.Name;
row.Cells[1].Value = productInGrid.Price.ToString("#.00");
row.Cells[2].Value = productInGrid.AddAmount.ToString("#.00");
row.Cells[3].Value = productInGrid.Discount.ToString("#.00");
row.Cells[4].Value = productInGrid.Total.ToString("#.00");
gridProducts.Rows.Add(row);
}
public async void NoDuplicateSoldProduct()
{
Guid serial = Guid.NewGuid();
SoldProduct product = new SoldProduct {
SerialNumber = serial
};
RaffleDbContext context = getDb("NoDupe");
context.SoldProducts.Add(product);
await context.SaveChangesAsync();
RaffleEntry entry = getEntry();
entry.SoldProduct.SerialNumber = serial;
RaffleApiController controller = new RaffleApiController(
context,
new EntryValidator());
IStatusCodeActionResult result = await controller.PostRaffleEntry(entry);
StatusCodeResult statusResult = Assert.IsType <StatusCodeResult>(result);
Assert.Equal((int)HttpStatusCode.OK, statusResult.StatusCode);
Assert.Equal(1, await context.SoldProducts.CountAsync());
}
public static void InitializeRaffle(RaffleDbContext context)
{
context.Database.EnsureCreated();
if (!context.SoldProducts.Any())
{
SoldProduct[] products = new SoldProduct[100];
for (int i = 0; i < 100; i++)
{
products[i] = new SoldProduct {
SerialNumber = Guid.NewGuid()
};
}
context.SoldProducts.AddRange(products);
context.SaveChanges();
using (StreamWriter writer = File.CreateText("SerialNumbers.txt"))
{
foreach (SoldProduct product in products)
{
writer.WriteLine(product.SerialNumber.ToString());
}
}
}
}
public void EntryGetsNewProductReference()
{
_entries = new List <RaffleEntry>();
Guid serial = Guid.NewGuid();
SoldProduct targetProduct = new SoldProduct {
SerialNumber = serial, SoldProductId = 2
};
_products = new List <SoldProduct>
{
new SoldProduct {
SerialNumber = Guid.NewGuid(), SoldProductId = 1
},
targetProduct,
new SoldProduct {
SerialNumber = Guid.NewGuid(), SoldProductId = 3
},
};
_entry = new RaffleEntry();
_entry.SoldProduct = new SoldProduct {
SerialNumber = serial
};
_validator.ValidateEntry(_products.AsQueryable(), _entries.AsQueryable(), _entry);
Assert.Equal(targetProduct.SoldProductId, _entry.SoldProduct.SoldProductId);
}
public void registerProduits(ObservableCollection <TableProduct> ProduitsCollection, Transaction transaction)
{
using (var context = new bourseContainer())
{
foreach (var produit in ProduitsCollection)
{
//update the product if it exists
if (!String.IsNullOrEmpty(produit.Code) && context.ProductSet.Any(p => p.code == produit.Code))
{
Product product = context.ProductSet.Single(p => p.code == produit.Code);
product.title = produit.Titre;
product.type = produit.Type;
product.editor = produit.Editeur;
product.author = produit.Auteur;
context.Entry(product).State = EntityState.Modified;
context.SaveChanges();
context.Entry(product).State = EntityState.Detached;
}
//otherwise, add it
if (!String.IsNullOrEmpty(produit.Code) && !context.ProductSet.Any(p => p.code == produit.Code))
{
Product product = new Product
{
author = produit.Auteur,
code = produit.Code,
editor = produit.Editeur,
title = produit.Titre,
type = produit.Type
};
context.Entry(product).State = EntityState.Added;
context.SaveChanges();
context.Entry(product).State = EntityState.Detached;
}
decimal productPrice = 0;
decimal.TryParse(produit.Prix, out productPrice);
SoldProduct soldProduct = new SoldProduct
{
price = productPrice,
inStock = produit.Reassort == ReassortTypeEnum.REASSORTI.ToString() ? true : false,
datetime = DateTime.Now,
Transaction = transaction,
author = produit.Auteur,
code = produit.Code,
editor = produit.Editeur,
title = produit.Titre,
type = produit.Type
};
context.Entry(soldProduct).State = EntityState.Added;
context.SaveChanges();
context.Entry(soldProduct).State = EntityState.Detached;
}
}
}
public void EntryWithOnePreviousEntry()
{
_entries = new List <RaffleEntry>();
Guid serial = Guid.NewGuid();
SoldProduct soldProduct = new SoldProduct {
SerialNumber = serial
};
_products = new List <SoldProduct> {
soldProduct
};
RaffleEntry entry1 = getEntry();
entry1.SoldProduct = soldProduct;
_entries.Add(entry1);
_entry = getEntry();
_entry.SoldProduct = soldProduct;
bool validEntry = _validator.ValidateEntry(_products.AsQueryable(), _entries.AsQueryable(), _entry);
Assert.True(validEntry, "Entry got rejected even though there has only been 1 previous entry with the same serial number.");
}
public int UpdateSoldProduct(SoldProduct soldProduct)
{
using (db)
{
db.Entry(soldProduct).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(1);
}
}
public static SoldProduct SoldProductValidWithId()
{
SoldProduct soldProduct = new SoldProduct();
soldProduct.Id = 1;
soldProduct.Product = ProductValidWithId();
soldProduct.Quantity = 2;
return(soldProduct);
}
public static SoldProduct MakeInstance(SoldProduct soldProduct)
{
SoldProduct soldProduct1 = ScriptableObject.CreateInstance("SoldProduct") as SoldProduct;
soldProduct1.name = soldProduct.name;
soldProduct1.parentProduct = soldProduct.parentProduct;
soldProduct1.amount = soldProduct.amount;
return(soldProduct1);
}
public int DeleteSoldProduct(int id)
{
using (db)
{
SoldProduct soldProducts = db.SoldProducts.Find(id);
db.SoldProducts.Remove(soldProducts);
db.SaveChanges();
return(1);
}
}
public static SoldProductDTO ToSoldProductDTO(SoldProduct model)
{
return(model == null ? null : new SoldProductDTO()
{
Id = model.Id,
Client = ToClientDTO(model.Client),
Manager = ToManagerDTO(model.Manager),
Product = ToProductDTO(model.Product),
Date = model.Date
});
}
public void AddOrUpdate(SoldProduct soldProduct)
{
if (GetSoldProducts().Any(p => p.Id == soldProduct.Id))
{
string sql = "UPDATE SoldProduct SET " +
"CategoryId=" + soldProduct.CategoryId +
", CreditId='" + soldProduct.CreditId +
"',Name='" + soldProduct.Name +
"',Price='" + soldProduct.Price.ToString().Replace(',', '.') +
"',Discount='" + soldProduct.Discount.ToString().Replace(',', '.') +
"',Total='" + soldProduct.Total.ToString().Replace(',', '.') +
"',AddAmount='" + soldProduct.AddAmount.ToString().Replace(',', '.') +
"' WHERE Id=" + soldProduct.Id;
using (SqlCeConnection conn = new SqlCeConnection(Storage.ConnectionString))
{
try
{
conn.Open();
}
catch
{
MessageBox.Show("Невозможно установить соединение с базой данных!", "Ошибка подключения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
SqlCeCommand command = new SqlCeCommand(sql, conn);
command.ExecuteScalar();
}
}
else
{
string sql = "INSERT INTO SoldProduct (CategoryId, CreditId, Name, Price, AddAmount, Discount, Total) Values (" +
soldProduct.CategoryId + "," +
soldProduct.CreditId + ",'" +
soldProduct.Name + "','" +
soldProduct.Price.ToString().Replace(',', '.') + "','" +
soldProduct.AddAmount.ToString().Replace(',', '.') + "','" +
soldProduct.Discount.ToString().Replace(',', '.') + "','" +
soldProduct.Total.ToString().Replace(',', '.') + "')";
using (SqlCeConnection conn = new SqlCeConnection(Storage.ConnectionString))
{
try
{
conn.Open();
}
catch
{
MessageBox.Show("Невозможно установить соединение с базой данных!", "Ошибка подключения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
SqlCeCommand command = new SqlCeCommand(sql, conn);
command.ExecuteScalar();
}
}
}
public int CreateSoldProduct(SoldProduct SoldProduct)
{
using (db)
{
long id = db.SoldProducts.Max(x => x.Id);
SoldProduct.Id = id + 1;
db.SoldProducts.Add(SoldProduct);
db.SaveChanges();
return(1);
}
}
public async Task DeleteSoldProduct(SoldProduct id)
{
var soldProduct = this.soldProductRepository.Find(id.Id);
var product = this.productRepository.Find(soldProduct.ProductId);
product.Sum = product.Sum + (soldProduct.SoldQty * product.SinglePrice);
product.Qty += soldProduct.SoldQty;
await this.soldProductRepository.SaveChangesAsync();
this.soldProductRepository.Delete(soldProduct);
await this.productRepository.SaveChangesAsync();
}
public static SoldProduct SoldProductValidWithoutId()
{
SoldProduct soldProduct = new SoldProduct();
soldProduct.Product = ProductValidWithId();
soldProduct.Product.Tax = new ProductTax()
{
IcmsAliquot = 4, IpiAliquot = 10
};
soldProduct.Quantity = 2;
return(soldProduct);
}
public void SoldProduct_NotDamaged_CanClaimMoneyBack()
{
var rules = new List <Func <SoldProduct, bool> >()
{
product => (DateTime.Now - product.Sold).TotalDays < 30,
product => !product.Damaged
};
var soldProduct = new SoldProduct(1, "Some product", DateTime.Now, rules);
var canClaimMoneyBack = soldProduct.CanClaimMoneyBack();
Assert.IsTrue(canClaimMoneyBack);
}
public void Create(ISoldProductModel model)
{
SoldProduct item = new SoldProduct();
item.Name = model.Name;
item.CategoryID = model.CategoryID;
item.TableID = model.TableID;
item.Price = model.Price;
item.Detail = model.Detail;
_db.SoldProducts.Add(item);
_db.SaveChanges();
}
private void btnEdit_Click(object sender, System.EventArgs e)
{
if (gridProducts.SelectedRows.Count == 0)
{
return;
}
CurrentProduct = gridProducts.SelectedRows[0].Tag as SoldProduct;
if (CurrentProduct != null)
{
DisplayCurrentProduct();
cbProduct.SelectedItem = cbProduct.Items.Cast <Product>().FirstOrDefault(p => p.Name == CurrentProduct.Name);
gridProducts.Rows.Remove(gridProducts.SelectedRows[0]);
}
}
private ISoldProductModel MapTheSoldProductObject(SoldProduct item)
{
ISoldProductModel model = Factory.InstanceSoldProductModel();
model.ID = item.ID;
model.Name = item.Name;
model.CategoryID = item.CategoryID;
model.Category.ID = item.CategoryID;
model.Category.Name = _db.Categories.Where(x => x.ID == item.CategoryID).FirstOrDefault().Name;
model.TableID = item.TableID;
model.Table.ID = item.TableID;
model.Price = item.Price;
model.Detail = item.Detail;
return(model);
}
private void EFTBuying()
{
lblResult.Visible = true;
lblResult.Text = "Bankayla iletişime geçiliyor...";
Refresh();
Thread.Sleep(1000);
lblResult.Text = "Hesap bilgileri kontrol ediliyor...";
Refresh();
Thread.Sleep(1000);
lblResult.Text = "Hesap bakiyesi kontrol ediliyor...";
Refresh();
Thread.Sleep(1000);
lblResult.Text = "Ödeme işlemi tamamlanıyor...";
Refresh();
Thread.Sleep(1000);
DialogResult dr = new DialogResult();
dr = MessageBox.Show(product.Name + " x " + txtProductAdet.Text + " = " + (product.Price * int.Parse(txtProductAdet.Text) + "\nAlışverişi tamamlamak istiyor musunuz??"), "Uyarı !!!", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
lblResult.Text = "Satın alma başarılı bir şekilde yapıldı.";
Refresh();
SoldProduct sp = new SoldProduct();
sp.SoldID = dataHolder.SoldProducts[dataHolder.SoldProducts.Count - 1].SoldID + 1;
sp.Adet = int.Parse(txtProductAdet.Text);
sp.Category = product.Category;
sp.Product = product;
sp.Toplam = product.Price * int.Parse(txtProductAdet.Text);
sp.User = dataHolder.CurrentUser;
sp.PaymentType = rbKK.Checked ? "KK" : "EFT";
dataHolder.SoldProducts.Add(sp);
saveuserForm.SoldsLoad();
Thread.Sleep(1000);
saveuserForm.Show();
Dispose();
}
else
{
lblResult.Text = "Satın alma iptal edildi...";
Refresh();
Thread.Sleep(1000);
}
}
private void cbProduct_SelectedValueChanged(object sender, EventArgs e)
{
if (cbProduct.SelectedItem is Product)
{
var tempProduct = cbProduct.SelectedItem as Product;
CurrentProduct = new SoldProduct();
CurrentProduct.AddAmount = tempProduct.AddAmount;
CurrentProduct.CategoryId = tempProduct.CategoryId;
CurrentProduct.CreditId = CurrentCredit == null ? -1 : CurrentCredit.Id;
CurrentProduct.Discount = tempProduct.Discount;
CurrentProduct.Id = tempProduct.Id;
CurrentProduct.Price = tempProduct.Price;
CurrentProduct.Total = tempProduct.Total;
CurrentProduct.Name = tempProduct.Name;
}
DisplayCurrentProduct();
}
public SoldProductDTO AddRecord(CsvRecord record)
{
SoldProduct soldProduct;
lock (_sync)
{
soldProduct = new SoldProduct()
{
Client = GetClient(record.Client),
Product = GetProduct(record.Product, record.Price),
Manager = GetManager(record.Manager),
Date = record.Date
};
SoldProductRepository.Add(soldProduct);
//(SoldProductRepository as SoldProductRepository)?.DetachModels(soldProduct);
}
return(DataMapper.ToSoldProductDTO(soldProduct));
}
private void gridProducts_MouseClick(object sender, MouseEventArgs e)
{
try
{
if (e.Button == MouseButtons.Right)
{
int currentMouseOverRow = gridProducts.HitTest(e.X, e.Y).RowIndex;
CurrentProduct = gridSchedule.Rows[currentMouseOverRow].Tag as SoldProduct;
if (CurrentProduct != null)
{
gridContextMenu.Show(gridProducts, e.Location);
}
}
}
catch
{
//nothing to do, wait for the next user actions
}
}
private List <SoldProduct> saveAsSoldProduct() // kullanılan parçanın satıldı olarak veritabanına gönderilmesi
{
List <SoldProduct> soldProducts = new List <SoldProduct>();
for (int i = 0; i < gv_urunler.RowCount; i++)
{
SoldProduct solds = new SoldProduct() //parça nesnesi oluşturuluyor
{
productSold_customerID = customer_id,
productSold_productID = Convert.ToInt32(gv_urunler.GetRowCellDisplayText(i, "product_ID")),
productSold_totalPrice = Convert.ToInt32(gv_urunler.GetRowCellDisplayText(i, "product_saleprice")),
productSold_unit = 1,
productSold_reasonID = 2,
productSold_soldDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))
};
soldProducts.Add(solds); // kullanılan ürün satıldı olarak veritabanına ekleniyor.
}
return(soldProducts);
}
public void Delete(SoldProduct soldProduct)
{
string sql = "DELETE FROM SoldProduct WHERE Id=" + soldProduct.Id;
using (SqlCeConnection conn = new SqlCeConnection(Storage.ConnectionString))
{
try
{
conn.Open();
}
catch
{
MessageBox.Show("Невозможно установить соединение с базой данных!", "Ошибка подключения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
SqlCeCommand command = new SqlCeCommand(sql, conn);
command.ExecuteScalar();
}
}
public async Task AddSellingProduct(Product product, decimal sellingQty, DateTime crOn)
{
var soldProduct = new SoldProduct()
{
Id = Guid.NewGuid(),
ProductId = product.Id,
SoldQty = sellingQty,
};
soldProduct.CreatedOn = crOn;
product.Qty = product.Qty - sellingQty;
product.Sum = product.Sum - (product.SinglePrice * sellingQty);
await this.soldProductRepository.AddAsync(soldProduct);
await this.soldProductRepository.SaveChangesAsync();
this.productRepository.Update(product);
await this.productRepository.SaveChangesAsync();
}
