private int AddUpdateSalesItem()
{
if (salesItem != null && salesItem.Id > 0 && salesItem.SalesId > 0)
{
salesItem.ProductId = productsIds[cmbProduct.SelectedIndex];
salesItem.PurchaseHItemId = productItems[cmbSalesItem.SelectedIndex];
salesItem.BrandId = productItemStock[cmbSalesItem.SelectedIndex].BrandId;
salesItem.Quntity = int.Parse(txtQuantity.Text);
salesItem.Price = Convert.ToDecimal(txtSUnitPrice.Text);
salesItem.UpdatedBy = userId;
return(SalesOrderItemDataAccess.UpdateSalesItems(salesItem));
}
else
{
var salesItem = new SalesItemDTO
{
SalesId = salesId,
ProductId = productsIds[cmbProduct.SelectedIndex],
BrandId = productItemStock[cmbSalesItem.SelectedIndex].BrandId,
PurchaseHItemId = productItems[cmbSalesItem.SelectedIndex],
Quntity = int.Parse(txtQuantity.Text),
Price = Convert.ToDecimal(txtSUnitPrice.Text),
CreatedBy = userId
};
return(SalesOrderItemDataAccess.AddSalesItems(salesItem));
}
}
private void btnViewItems_Click(object sender, EventArgs e)
{
if (salesOrderGridView.SelectedRows.Count > 0)
{
DataGridViewRow dataRow = salesOrderGridView.SelectedRows[0];
int.TryParse(dataRow.Cells["id"].Value.ToString(), out int id);
if (id < 0)
{
return;
}
DataTable dt = SalesOrderItemDataAccess.GetSalesItems(id);
if (dt != null && dt.Rows.Count > 0)
{
var frmSalesItems = new frmSalesItems(this, userId, id, dt);
frmSalesItems.ShowDialog();
}
else
{
MessageBox.Show("Order doesn't have any item to view");
return;
}
}
else
{
MessageBox.Show("Please select an order to view items");
}
}
public void frmSalesItems_Load(object sender, EventArgs e)
{
//if (salesItemTable == null || salesItemTable.Rows.Count < 0)
//{
// salesItemTable = .GetOrderItems(orderId);
//}
salesItemTable = SalesOrderItemDataAccess.GetSalesItems(orderId);
this.salesItemGridView.DataSource = salesItemTable;
FormatGrid(ref this.salesItemGridView);
}
private void ViewSalesItemInfo()
{
salesItem = SalesOrderItemDataAccess.GetSalesItemsById(itemId, salesId);
if (salesItem != null)
{
cmbProduct.SelectedIndex = productsIds.FindIndex(x => x == salesItem.ProductId);
//cmbSalesItem.Text = brands[salesItem.BrandId].ToString();
//cmbOrderItem.Text = brands[salesItem.PurchaseHItemId].ToString();
//cmbSalesItem.Text = salesItem.Brand + " | Price - " + salesItem.UnitPrice + " Avalilable - " + item.AvailableItemCounts;
txtQuantity.Text = salesItem.Quntity.ToString();
txtSUnitPrice.Text = string.Format("{0: 0.00}", salesItem.Price);
}
}
private void cmbProduct_SelectedIndexChanged(object sender, EventArgs e)
{
int productId = cmbProduct.SelectedIndex + 1;
productItemStock = SalesOrderItemDataAccess.GetProductItemsForSales(productId);
cmbSalesItem.Items.Clear();
productItems.Clear();
if (productItemStock != null && productItemStock.Any())
{
foreach (var item in productItemStock)
{
cmbSalesItem.Items.Add(item.Brand + " | Price - " + item.UnitPrice + " Avalilable - " + item.AvailableItemCount);
productItems.Add(item.PurchaseId);
}
}
if (itemId > 0 && salesId > 0)
{
}
}
