public bool DeleteSaleItem(SaleItems item)
{
try
{
SalesDAO salesDAO = new SalesDAO();
SaleItemsDAO itemsDAO = new SaleItemsDAO();
ProductsDAO productsDAO = new ProductsDAO();
UserDAO userDAO = new UserDAO();
if (item != null)
{
if (userDAO.CheckLogin(item.Sale.User) == null)
{
return(false);
}
if (!salesDAO.CheckUserPermission(item.Sale))
{
return(false);
}
itemsDAO.DeleteSaleItem(item);
return(true);
}
return(false);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool addProductToShoppingCart()
{
try
{
using (IDbConnection connection = new SqlConnection(ConnectionString))
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
string query = "INSERT INTO SaleItems([idProduct],[amount],[idSale]) VALUES(@IdProduct,@Amount,@IdSale)";
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("@IdProduct", this.saleItems.idProduct);
dictionary.Add("@Amount", this.saleItems.amount);
dictionary.Add("@IdSale", this.saleItems.idSale);
var result = connection.Execute(query, new DynamicParameters(dictionary));
connection.Close();
this.saleItems = null;
return(true);
}
}
catch (Exception)
{
this.saleItems = null;
return(false);
}
}
public void UpdateSaleItem(SaleItems saleItem)
{
NpgsqlConnection connection = Database.openConnection();
try
{
string sql = "UPDATE negocio.itensvenda SET precounit = @unitPrice, qtd = @qtd WHERE idvenda = @idSale AND idproduto = @idProduct";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id));
cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id));
cmd.Parameters.Add(new NpgsqlParameter("@unitPrice", saleItem.UnitPrice));
cmd.Parameters.Add(new NpgsqlParameter("@qtd", saleItem.Qtd));
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (NpgsqlException npgEx)
{
throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + npgEx.Message);
}
catch (Exception e)
{
throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + e.Message);
}
finally
{
connection.Close();
}
}
public void InsertSaleItem(SaleItems saleItem)
{
NpgsqlConnection connection = Database.openConnection();
try
{
string sql = "INSERT INTO negocio.itensvenda (precounit, qtd, idproduto, idvenda) VALUES (@unitPrice, @qtd, @idProduct, @idSale)";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
cmd.Parameters.Add(new NpgsqlParameter("@unitPrice", saleItem.UnitPrice));
cmd.Parameters.Add(new NpgsqlParameter("@qtd", saleItem.Qtd));
cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id));
cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id));
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (NpgsqlException npgEx)
{
throw new Exception("Erro ao inserir o item da venda no banco de dados! " + npgEx.Message);
}
catch (Exception e)
{
throw new Exception("Erro ao inserir o item da venda no banco de dados! " + e.Message);
}
finally
{
connection.Close();
}
}
public void DeleteSaleItem(SaleItems saleItem)
{
NpgsqlConnection connection = Database.openConnection();
try
{
string sql = "DELETE FROM negocio.itensvenda WHERE idvenda = @idSale AND idproduto = @idProduct";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id));
cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id));
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (NpgsqlException npgEx)
{
throw new Exception("Erro ao deletar o item da venda no banco de dados! " + npgEx.Message);
}
catch (Exception e)
{
throw new Exception("Erro ao deletar o item da venda no banco de dados! " + e.Message);
}
finally
{
connection.Close();
}
}
public Int32 IncreaseQtdSaleItem(SaleItems saleItem)
{
NpgsqlConnection connection = Database.openConnection();
try
{
string sql = "UPDATE negocio.itensvenda SET qtd = qtd + 1 WHERE idvenda = @idSale AND idproduto = @idProduct";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id));
cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id));
Int32 count = cmd.ExecuteNonQuery();
cmd.Dispose();
return(count);
}
catch (NpgsqlException npgEx)
{
throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + npgEx.Message);
}
catch (Exception e)
{
throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + e.Message);
}
finally
{
connection.Close();
}
}
public void AddSale(string productCode, int productCount)
{
List <SaleItems> items = new List <SaleItems>();
var saleitem = new SaleItems();
Sales sales = new Sales();
var sale = sales;
Products product = Product.Find(p => p.Code == productCode);
if (product != null)
{
product = Product.Find(p => p.Quantity >= productCount);
if (product != null)
{
saleitem.Products = product;
saleitem.Number = items.Count + 1;
items.Add(saleitem);
sale.Id = _sales.Count + 1;
sale.Amount += productCount * product.price;
sale.Date = DateTime.Now;
sale.saleItems = items;
_sales.Add(sale);
Sales satiw = new Sales();
SaleItems item = new SaleItems();
}
else
{
Console.WriteLine("daxil etdiyiniz say qeder mehsul yoxdur.");
}
}
else
{
Console.WriteLine("daxil etdiyiniz codda mehsul yoxdur.yeniden ceh etmeye caliwin");
}
}
internal ActionResult DeleteItemInternal(int productId)
{
_saleItems.Remove(SaleItems.FirstOrDefault(i => i.Product.Id == productId));
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
public FormSaleItemDialog(SaleItems saleItem, UnitOfWork unitOfWork)
{
_saleItem = saleItem;
_unitOfWork = unitOfWork;
InitializeComponent();
InitializeDialog();
InitializeComboBox();
}
//private void txtCbo1_TextChanged(object sender, TextChangedEventArgs e)
//{
// //var txt = sender as TextBox;
// //if (string.IsNullOrWhiteSpace(txt.Text)) return;
// //var index = firstPanel.Children.IndexOf(txt);
// //var cbo = firstPanel.Children[index - 1] as ComboBox;
// //var selectedItem = cbo.SelectedItem as MDCafe.item;
// //var totalAmount = string.IsNullOrWhiteSpace(txtTotalAmt1.Text) ? 0 : decimal.Parse(txtTotalAmt1.Text);
// //txtTotalAmt1.Text = (totalAmount + selectedItem.CurrentPrice * int.Parse(txt.Text)).ToString();
//}
private void ClearValues(SaleItems saleItems)
{
saleItems.CustomerId = -1;
foreach (var item in saleItems.SaleItemsDetailsCollection)
{
item.ItemQty = 0;
item.SelectedItemItem = null;
item.PreviousSelectedItem = null;
item.PrevItemQty = 0;
}
}
public ActionResult DeleteItem(int productId)
{
if (IsPaid || IsCancelled)
{
return(new ActionResult(isSuccess: false, "Cannot delete items from paid or cancelled sales"));
}
_saleItems.Remove(SaleItems.FirstOrDefault(i => i.Product.Id == productId));
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
private SaleItems GenerateSaleItem()
{
int ListProdIndex = listBoxProducts.SelectedIndex;
Products product = (Products)FormMain.listProducts[ListProdIndex];
SaleItems item = new SaleItems
{
Product = product,
Sale = sale
};
return(item);
}
private void OnButtonDeleteClick(object sender, EventArgs e)
{
if (lvSaleItems.SelectedItems.Count != 1)
{
MessageBox.Show("Please select one sale item.", Constant.StoreAppName);
return;
}
SaleItems item = (SaleItems)lvSaleItems.SelectedItems[0].Tag;
_unitOfWork.SaleItems.Remove(item);
lvSaleItems.SelectedItems[0].Remove();
}
internal ActionResult SetItemQuantityInternal(int productId, int newQuantity)
{
var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == productId);
if (existingItem is null)
{
return(new ActionResult(isSuccess: false, $"ProductId {productId} not found in sale items."));
}
ReplaceItem(existingItem, new SaleItem(existingItem.Product, newQuantity));
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
private SaleItems CheckSaleItem()
{
try
{
if (listViewSaleItems.SelectedItems.Count > 0)
{
ListViewItem item = listViewSaleItems.SelectedItems[0];
SaleItems itemSale = new SaleItems();
bool error = false;
if (int.TryParse(item.SubItems[0].Text, out int qtdItem))
{
itemSale.Qtd = qtdItem;
}
else
{
error = true;
}
if (double.TryParse(item.SubItems[1].Text, out double unitPrice))
{
itemSale.UnitPrice = unitPrice;
}
else
{
error = true;
}
itemSale.Product.Name = item.SubItems[2].Text;
if (!error)
{
return(itemSale);
}
else
{
MessageBox.Show("Item inválido!");
return(null);
}
}
else
{
MessageBox.Show("Selecione um item.");
return(null);
}
}
catch (Exception)
{
throw;
}
}
public void addSaleItemTest()
{
SaleItems s = new SaleItems(); // TODO: 初始化为适当的值
s.Price = 10;
s.SaleId = 1;
s.BookId = 1;
s.Count = 3;
int expected = 1; // TODO: 初始化为适当的值
int actual;
actual = SaleService.addSaleItem(s);
Assert.AreEqual(expected, actual);
// Assert.Inconclusive("验证此测试方法的正确性。");
}
private void OnButtonAddClick(object sender, EventArgs e)
{
var item = new SaleItems();
var dialog = new FormSaleItemDialog(item, _unitOfWork);
DialogResult result = dialog.ShowDialog();
if (result != DialogResult.OK)
{
return;
}
_sale.SaleItems.Add(item);
UpdateListView(item, ListViewAction.Add, Constant.IndexNone);
}
internal void AddItemInternal(SaleItem newItem)
{
var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id);
if (existingItem != null)
{
newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity);
ReplaceItem(existingItem, newItem);
}
else
{
_saleItems.Add(newItem);
}
UpdateAmounts();
}
public SaleRequestDetailPage(SaleItems saleItem)
{
InitializeComponent();
mSaleItem = saleItem;
lbl_title.Text = mSaleItem.building_name;
img_building.Source = mSaleItem.img_url;
month_excome.Text = mSaleItem.monthly_balance;
int month_balance = 0;
bool is_success = int.TryParse(mSaleItem.monthly_balance, out month_balance);
if (is_success)
{
year_excome.Text = (month_balance * 12).ToString();
}
current_excome.Text = mSaleItem.income;
excome.Text = mSaleItem.excome;
}
public List <SaleItems> ListSaleItems(Sales sale)
{
NpgsqlConnection connection = Database.openConnection();
List <SaleItems> listSaleItems;
SaleItems saleItems;
Products product;
try
{
string sql = "SELECT precounit, qtd, idproduto, idvenda FROM negocio.itensvenda WHERE idvenda = @idSale";
NpgsqlCommand cmd = new NpgsqlCommand(sql, connection);
cmd.Parameters.Add(new NpgsqlParameter("@idSale", sale.Id));
NpgsqlDataReader dataReader = cmd.ExecuteReader();
listSaleItems = new List <SaleItems>();
while (dataReader.Read())
{
product = new Products
{
Id = dataReader.GetInt32(dataReader.GetOrdinal("idproduto"))
};
saleItems = new SaleItems
{
UnitPrice = dataReader.GetDouble(dataReader.GetOrdinal("precounit")),
Qtd = dataReader.GetInt32(dataReader.GetOrdinal("qtd")),
Product = product
};
listSaleItems.Add(saleItems);
}
cmd.Dispose();
return(listSaleItems);
}
catch (NpgsqlException npgEx)
{
throw new Exception("Erro ao listar os itens da venda do banco de dados! " + npgEx.Message);
}
catch (Exception e)
{
throw new Exception("Erro ao listar os itens da venda do banco de dados! " + e.Message);
}
finally
{
connection.Close();
}
}
internal ActionResult AddItemInternal(SaleItem newItem)
{
var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id);
if (existingItem != null)
{
newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity);
ReplaceItem(existingItem, newItem);
}
else
{
_saleItems.Add(newItem);
}
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
private void BtnIncreaseProd_Click(object sender, EventArgs e)
{
try
{
SaleItems item = GenerateSaleItem();
if (webService.IncreaseQtdSaleItem(item))
{
MessageBox.Show("Item incrementado com sucesso!");
}
else
{
MessageBox.Show("Erro na incrementação do item!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult SetItemQuantity(int productId, int newQuantity)
{
if (IsPaid || IsCancelled)
{
return(new ActionResult(isSuccess: false, "Cannot change item quantity on paid or cancelled sales"));
}
var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == productId);
if (existingItem is null)
{
return(new ActionResult(isSuccess: false, $"ProductId {productId} not found in sale items."));
}
ReplaceItem(existingItem, new SaleItem(existingItem.Product, newQuantity));
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
// SaleItem
public bool SaveSaleItem(SaleItems item)
{
try
{
SalesDAO salesDAO = new SalesDAO();
SaleItemsDAO itemsDAO = new SaleItemsDAO();
ProductsDAO productsDAO = new ProductsDAO();
UserDAO userDAO = new UserDAO();
Products p;
if (item != null)
{
if (userDAO.CheckLogin(item.Sale.User) == null)
{
return(false);
}
if (!salesDAO.CheckUserPermission(item.Sale))
{
return(false);
}
p = productsDAO.SelectProduct(item.Product);
if (p == null)
{
return(false);
}
if (item.Qtd < 1)
{
item.Qtd = 1;
}
if (itemsDAO.ChangeQtdSaleItem(item, item.Qtd) == 0)
{
item.UnitPrice = p.Price;
itemsDAO.InsertSaleItem(item);
return(true);
}
}
return(false);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
private void BtnSaveItem_Click(object sender, EventArgs e)
{
try
{
SaleItems item = GenerateSaleItem();
item.Qtd = 1;
if (webService.InsertSaleItem(item))
{
MessageBox.Show("Item salvo com sucesso!");
}
else
{
MessageBox.Show("Erro durante o cadastro do item!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void OnButtonEditClick(object sender, EventArgs e)
{
if (lvSaleItems.SelectedItems.Count != 1)
{
MessageBox.Show("Please select one sale item.", Constant.StoreAppName);
return;
}
SaleItems item = (SaleItems)lvSaleItems.SelectedItems[0].Tag;
var dialog = new FormSaleItemDialog(item, _unitOfWork);
DialogResult result = dialog.ShowDialog();
if (result != DialogResult.OK)
{
return;
}
UpdateListView(item, ListViewAction.Update, lvSaleItems.SelectedItems[0].Index);
}
private void UpdateListView(SaleItems saleItem, ListViewAction action, int index)
{
ListViewItem item = new ListViewItem(saleItem.Products.ProductName);
// Use InvariantCulture to format the decimal with dot instead of comma.
item.SubItems.Add(saleItem.SalePrice.ToString("0.00",
System.Globalization.CultureInfo.InvariantCulture));
item.SubItems.Add(saleItem.Amount.ToString());
item.Tag = saleItem;
if (action == ListViewAction.Add)
{
lvSaleItems.Items.Add(item);
}
if (action == ListViewAction.Update && index > Constant.IndexNone)
{
lvSaleItems.Items[index] = item;
}
}
public void Initialize()
{
AddHandler(System.Windows.Controls.Validation.ErrorEvent, new RoutedEventHandler(OnErrorEvent));
_modelContext = _viewModel.ModelContext;
Panel1cboCustomer1.DataContext = _modelContext.customers.OrderBy(s => s.Name).ToList();
//btnDone.CommandBindings.Add(new CommandBinding(ApplicationCommands.Print, BtnDoneExecuted, BtnDoneCanExecute));
var saleItems = new SaleItems();
saleItems.ItemsCollection = _modelContext.items.OrderBy(s => s.Name).ToList();
Panel1.DataContext = saleItems;
//List<Items> lst = new List<Items>();
//var connString = "server=127.0.0.1;user id=root;database=MDCafe";
//using (var conn = new MySqlConnection(connString))
//{
// var cmdText = "select * from items";
// using (var command = new MySqlCommand(cmdText,conn))
// {
// conn.Open();
// using (var reader = command.ExecuteReader())
// {
// while (reader.Read())
// {
// lst.Add(new Items()
// {
// Code = reader.GetString("code"),
// Name = reader.GetString("Name"),
// Description = reader.GetString("Description"),
// currentPrice = reader.GetDecimal("currentPrice"),
// Category = reader.GetString("Category")
// }
// );
// }
// }
// }
//}
//this.DataContext = lst;
}
public ActionResult AddItem(SaleItem newItem)
{
if (IsPaid || IsCancelled)
{
return(new ActionResult(isSuccess: false, "Cannot add items to paid or cancelled sales"));
}
var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id);
if (existingItem != null)
{
newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity);
ReplaceItem(existingItem, newItem);
}
else
{
_saleItems.Add(newItem);
}
UpdateAmounts();
return(new ActionResult(isSuccess: true));
}
private IEnumerator LoadItems()
{
string url = "https://gist.githubusercontent.com/sampletext32/e7dfdf2602b59ba798b882be520d9364/raw/1cf374aded0128f8cf2bf7d03b48c960ac9beca9/farm_data.json";
UnityWebRequest webRequest = UnityWebRequest.Get(url);
var asyncOperation = webRequest.SendWebRequest();
yield return(asyncOperation);
if (webRequest.isNetworkError || webRequest.isHttpError)
{
Debug.Log(webRequest.error);
}
else
{
Debug.Log("Request successful");
var jsonData = webRequest.downloadHandler.text;
Debug.Log(jsonData);
_saleItems = JsonConvert.DeserializeObject <SaleItems>(jsonData);
StartCoroutine(SpawnMenuItems());
}
}
