private void home_Load(object sender, EventArgs e)
{
//comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//comboBox1.a
// comboBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
// AutoCompleteStringCollection combData = new AutoCompleteStringCollection();
//getData(combData);
// comboBox1.AutoCompleteCustomSource = combData;
_PhamaPOSEntities = _dbConnector.getConn();
var Ds = _PhamaPOSEntities.items;
// .Where(a => a.itemCode.ToString().Contains(comboBox1.Text) || a.itemDescription.Contains(comboBox1.Text))
var itemCount = Ds.Count();
if (itemCount > 0)
{
comboBox1.DataSource = Ds
.Select(a => new
{
value = a.itemCode,
desc = a.itemDescription + "-->" + a.itemCode
}).ToList();
comboBox1.ValueMember = "value";
comboBox1.DisplayMember = "desc";
}
}
private void getAllStat(DateTime dateFrom, DateTime dateTo)
{
_PhamaPOSEntities = _dbConnector.getConn();
List <saleBatch> allSaleBatches = new List <saleBatch>();
if (dateFrom == dateTo)
{
allSaleBatches = _PhamaPOSEntities.saleBatches.Where(a => EntityFunctions.TruncateTime(a.saleDate) == EntityFunctions.TruncateTime(dateFrom)).ToList();
}
else
{
allSaleBatches = _PhamaPOSEntities.saleBatches.Where(a => EntityFunctions.TruncateTime(a.saleDate) >= EntityFunctions.TruncateTime(dateFrom) && EntityFunctions.TruncateTime(a.saleDate) <= EntityFunctions.TruncateTime(dateTo)).ToList();
}
if (allSaleBatches.Count() > 0)
{
lbltotalSales.Text = string.Format("{0:n0}", allSaleBatches.Sum(a => a.subTotal).ToString("#,##0"));
lblNettSales.Text = string.Format("{0:n0}", allSaleBatches.Sum(a => a.grandTotal).ToString("#,##0"));
lblProfit.Text = string.Format("{0:n0}", allSaleBatches.Sum(a => a.discountedAmount).ToString("#,##0"));
}
else
{
lbltotalSales.Text = "N/A";
lblNettSales.Text = "N/A";
lblProfit.Text = "N/A";
}
}
private void FillDetailsByBatchId()
{
int batchId;
bool result = int.TryParse(drpBatch.SelectedValue.ToString(), out batchId);
if (result)
{
_PhamaPOSEntities = _dbConnector.getConn();
var batchData = _PhamaPOSEntities.stocks.Where(a => a.stockId == batchId).FirstOrDefault();
if (batchData != null)
{
txtQty.Text = batchData.runningQuantity.ToString();
txtUnitPrice.Text = batchData.itemUnitPriceSelling.ToString();
txtEDate.Value = batchData.stockExpDate;
}
else
{
MessageBox.Show("No Stock found..");
}
}
else
{
MessageBox.Show("Invalid Selection..");
}
}
private void getAllItems()
{
_PhamaPOSEntities = _dbConnector.getConn();
List <item> _itemList = new List <item>();
tblItems.Rows.Clear();
grdItem.DataSource = tblItems;
_itemList = _PhamaPOSEntities.items.ToList();
foreach (item i in _itemList)
{
DataRow dr = tblItems.NewRow();
dr["Item Code"] = i.itemCode.ToString().PadLeft(4, '0');
dr["Item Name"] = i.itemDescription;
dr["Item Description"] = i.itemCallingName;
dr["Item Unit"] = i.unit.unitCode;
dr["Item Status"] = i.itemStatus == true ? "Available" : "Not Available";
dr["Stock Available"] = i.stocks.Sum(a => a.runningQuantity);
// dr["Stock Value"] =i.stocks.Count!=0? ((int)(i.stocks.Average(a => a.itemUnitPriceSelling) * i.stocks.Sum(a => a.runningQuantity))):0.00;
dr["Stock Value"] = i.stocks.Count != 0 ? (
i.stocks.Select(a => new
{
value = a.itemUnitPriceSelling * a.runningQuantity
}).Sum(a => a.value)
) : (decimal)0.00;
dr["Stock Cost"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceBuying) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Expiry Date"] = i.stocks.Count != 0 ? i.stocks.OrderByDescending(a => a.stockExpDate).FirstOrDefault().stockExpDate:DateTime.MinValue;
tblItems.Rows.Add(dr);
}
LoadAllStockValue();
grdItem.Refresh();
}
public login()
{
InitializeComponent();
_dbConnector = new dbConnector();
_phamaPOSEntities = _dbConnector.getConn();
}
private void LoadAllStockValue()
{
_PhamaPOSEntities = _dbConnector.getConn();
decimal ttlVal =
_PhamaPOSEntities.stocks.Select(a => new
{
value = a.itemUnitPriceSelling * a.runningQuantity
}).Sum(a => a.value);
label2.Text = "Total Stock Value : " + ttlVal.ToString("#,##0");
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
textBox1.Text = "";
checkBox2.Checked = false;
checkBox3.Checked = false;
_PhamaPOSEntities = _dbConnector.getConn();
List <item> _itemList = new List <item>();
tblItems.Rows.Clear();
grdItem.DataSource = tblItems;
_itemList = _PhamaPOSEntities.items
.Where(a => a.stocks.Count > 0 && a.stocks.OrderByDescending(b => b.stockExpDate).FirstOrDefault().stockExpDate < EntityFunctions.AddMonths(DateTime.Now, 6) && a.itemStatus == true)
.OrderBy(a => a.stocks.OrderBy(b => b.stockId).FirstOrDefault().stockExpDate)
.ToList();
foreach (item i in _itemList)
{
DataRow dr = tblItems.NewRow();
dr["Item Code"] = i.itemCode.ToString().PadLeft(4, '0');
dr["Item Name"] = i.itemDescription;
dr["Item Description"] = i.itemCallingName;
dr["Item Unit"] = i.unit.unitCode;
dr["Item Status"] = i.itemStatus == true ? "Available" : "Not Available";
dr["Stock Available"] = i.stocks.Sum(a => a.runningQuantity);
// dr["Stock Value"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceSelling) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Stock Value"] = i.stocks.Count != 0 ? (
i.stocks.Select(a => new
{
value = a.itemUnitPriceSelling * a.runningQuantity
}).Sum(a => a.value)
) : (decimal)0.00;
dr["Stock Cost"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceBuying) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Expiry Date"] = i.stocks.Count != 0 ? i.stocks.OrderByDescending(a => a.stockExpDate).FirstOrDefault().stockExpDate : DateTime.MinValue;
tblItems.Rows.Add(dr);
}
grdItem.Sort(this.grdItem.Columns["Expiry Date"], ListSortDirection.Ascending);
grdItem.Refresh();
}
else
{
getAllItems();
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
string searchString = textBox1.Text;
checkBox1.Checked = false;
checkBox2.Checked = false;
checkBox3.Checked = false;
_PhamaPOSEntities = _dbConnector.getConn();
tblItems.Rows.Clear();
List <item> _itemList = new List <item>();
grdItem.DataSource = tblItems;
if (searchString.Length > 0)
{
_itemList = _PhamaPOSEntities.items.Where(a => a.itemDescription.ToLower().Contains(searchString.ToLower())).ToList();
}
else
{
_itemList = _PhamaPOSEntities.items.ToList();
}
foreach (item i in _itemList)
{
DataRow dr = tblItems.NewRow();
dr["Item Code"] = i.itemCode.ToString().PadLeft(4, '0');
dr["Item Name"] = i.itemDescription;
dr["Item Description"] = i.itemCallingName;
dr["Item Unit"] = i.unit.unitCode;
dr["Item Status"] = i.itemStatus == true ? "Available" : "Not Available";
dr["Stock Available"] = i.stocks.Sum(a => a.runningQuantity);
//dr["Stock Value"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceSelling) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Stock Value"] = i.stocks.Count != 0 ? (
i.stocks.Select(a => new {
value = a.itemUnitPriceSelling * a.runningQuantity
}).Sum(a => a.value)
) : (decimal)0.00;
dr["Stock Cost"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceBuying) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Expiry Date"] = i.stocks.Count != 0 ? i.stocks.OrderByDescending(a => a.stockExpDate).FirstOrDefault().stockExpDate : DateTime.MinValue;
tblItems.Rows.Add(dr);
}
grdItem.Refresh();
}
private void getData(AutoCompleteStringCollection dataCollection)
{
_PhamaPOSEntities = _dbConnector.getConn();
var Ds = _PhamaPOSEntities.items;
var itemCount = Ds.Count();
if (itemCount > 0)
{
foreach (item item in Ds.ToList())
{
dataCollection.Add(item.itemCode + "-->" + item.itemDescription);
}
}
//string connetionString = null;
//SqlConnection connection;
//SqlCommand command;
//SqlDataAdapter adapter = new SqlDataAdapter();
//DataSet ds = new DataSet();
//connetionString = "Data Source=.;Initial Catalog=pubs;User ID=sa;password=zen412";
//string sql = "SELECT DISTINCT [fname] FROM [employee]";
//connection = new SqlConnection(connetionString);
//try
//{
// connection.Open();
// command = new SqlCommand(sql, connection);
// adapter.SelectCommand = command;
// adapter.Fill(ds);
// adapter.Dispose();
// command.Dispose();
// connection.Close();
// foreach (DataRow row in ds.Tables[0].Rows)
// {
// dataCollection.Add(row[0].ToString());
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show("Can not open connection ! ");
//}
}
private void FillDetailsByBatchId()
{
if (radioUpdate.Checked)
{
int batchId;
bool result = int.TryParse(drpBatch.SelectedValue.ToString(), out batchId);
if (result)
{
_PhamaPOSEntities = _dbConnector.getConn();
var batchData = _PhamaPOSEntities.stocks.Where(a => a.stockId == batchId).FirstOrDefault();
txtQty.Text = batchData.runningQuantity.ToString();
txtUnitPrice.Text = batchData.itemUnitPriceBuying.ToString();
txtSellingPrice.Text = batchData.itemUnitPriceSelling.ToString();
txtAddingDate.Value = batchData.stockReceivedDate;
txtEDate.Value = batchData.stockExpDate;
txtMDate.Value = (DateTime)batchData.stockMfdDate;
}
else
{
MessageBox.Show("Invalid Selection..");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (radioAddNew.Checked)
{
string code = txtItemCode.Text;
string Quantity = txtQty.Text;
string UnitPrice = txtUnitPrice.Text;
string SellingPrice = txtSellingPrice.Text;
DateTime addedDate = txtAddingDate.Value.Date;
DateTime expDate = txtEDate.Value.Date;
DateTime mfDate = txtMDate.Value.Date;
int icode = Convert.ToInt32(code);
if (code != "" && Quantity != "" && UnitPrice != "" && SellingPrice != "")
{
_PhamaPOSEntities = _dbConnector.getConn();
int itemId = _PhamaPOSEntities.items.Where(a => a.itemCode == icode).FirstOrDefault().itemId;
stock _stock = new stock();
_stock.itemId = itemId;
_stock.isAvailable = true;
_stock.entryDate = DateTime.Now;
_stock.entryBy = _user.userName;
_stock.itemUnitPriceBuying = Convert.ToDecimal(UnitPrice);
_stock.itemUnitPriceSelling = Convert.ToDecimal(SellingPrice);
_stock.runningQuantity = Convert.ToInt32(Quantity);
_stock.stockExpDate = expDate;
_stock.stockMfdDate = mfDate;
_stock.StockQuantity = Convert.ToInt32(Quantity);
_stock.stockReceivedDate = addedDate;
_PhamaPOSEntities.stocks.Add(_stock);
_PhamaPOSEntities.SaveChanges();
ClearFields();
MessageBox.Show("Stock Successfully added..");
if (itemCode != null)
{
this.Dispose();
addItem i = new addItem(_user);
i.Show();
}
else
{
this.Dispose();
}
}
else
{
MessageBox.Show("Please Fill All the mandetary fields..");
}
}
else
{
string code = txtItemCode.Text;
string Quantity = txtQty.Text;
string UnitPrice = txtUnitPrice.Text;
string SellingPrice = txtSellingPrice.Text;
DateTime addedDate = txtAddingDate.Value.Date;
DateTime expDate = txtEDate.Value.Date;
DateTime mfDate = txtMDate.Value.Date;
int batchId = Convert.ToInt32(drpBatch.SelectedValue);
int icode = Convert.ToInt32(code);
if (code != "" && Quantity != "" && UnitPrice != "" && SellingPrice != "")
{
_PhamaPOSEntities = _dbConnector.getConn();
var _stock = _PhamaPOSEntities.stocks.Where(a => a.stockId == batchId).FirstOrDefault();
_stock.stockExpDate = expDate;
_stock.runningQuantity = Convert.ToInt32(Quantity);
_stock.itemUnitPriceBuying = Convert.ToDecimal(UnitPrice);
_stock.itemUnitPriceSelling = Convert.ToDecimal(SellingPrice);
_stock.stockMfdDate = mfDate;
_stock.StockQuantity = Convert.ToInt32(Quantity);
_PhamaPOSEntities.stocks.Attach(_stock);
var entry = _PhamaPOSEntities.Entry(_stock);
entry.Property(a => a.runningQuantity).IsModified = true;
entry.Property(a => a.itemUnitPriceBuying).IsModified = true;
entry.Property(a => a.itemUnitPriceSelling).IsModified = true;
entry.Property(a => a.stockExpDate).IsModified = true;
entry.Property(a => a.stockMfdDate).IsModified = true;
entry.Property(a => a.StockQuantity).IsModified = true;
_PhamaPOSEntities.SaveChanges();
MessageBox.Show("Stock Successfully updated..");
ClearFields();
this.Hide();
}
else
{
MessageBox.Show("Please Fill All the mandetary fields..");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error Occured.. Please Retry.. " + ex.Message);
}
}
private void GetMostSoldItems(DateTime dateFrom, DateTime dateTo)
{
_PhamaPOSEntities = new PhamaPOSEntities();
_PhamaPOSEntities = _dbConnector.getConn();
tblMostSold.Rows.Clear();
if (dateFrom == dateTo)
{
var sales = _PhamaPOSEntities.sales
.Where(a => EntityFunctions.TruncateTime(a.saleBatch.entryDate) == EntityFunctions.TruncateTime(dateTo))
.GroupBy(a => new { a.stock.item })
.OrderByDescending(a => a.Sum(b => b.soldQuantity))
.Take(100)
.Select(a => new
{
a.FirstOrDefault().stock.item.itemDescription,
soldQuantity = a.Sum(b => b.soldQuantity),
soldValue = a.Sum(b => b.amount)
}).Distinct();
foreach (var rowObj in sales)
{
DataRow dr = tblMostSold.NewRow();
dr["Item Name"] = rowObj.itemDescription;
dr["Item Quantity"] = rowObj.soldQuantity;
dr["Value"] = rowObj.soldValue;
tblMostSold.Rows.Add(dr);
}
grdMostSold.DataSource = tblMostSold;
grdMostSold.RowHeadersVisible = false;
grdMostSold.Sort(this.grdMostSold.Columns["Item Quantity"], ListSortDirection.Descending);
grdMostSold.Refresh();
}
else
{
var sales = _PhamaPOSEntities.sales
.Where(a => EntityFunctions.TruncateTime(a.saleBatch.entryDate) <= EntityFunctions.TruncateTime(dateTo) && EntityFunctions.TruncateTime(a.saleBatch.entryDate) >= EntityFunctions.TruncateTime(dateFrom))
.GroupBy(a => new { a.stock.item })
.OrderByDescending(a => a.Sum(b => b.soldQuantity))
.Take(100)
.Select(a => new
{
a.FirstOrDefault().stock.item.itemDescription,
soldQuantity = a.Sum(b => b.soldQuantity),
soldValue = a.Sum(b => b.amount)
}).Distinct();
foreach (var rowObj in sales)
{
DataRow dr = tblMostSold.NewRow();
dr["Item Name"] = rowObj.itemDescription;
dr["Item Quantity"] = rowObj.soldQuantity;
dr["Value"] = rowObj.soldValue;
tblMostSold.Rows.Add(dr);
}
//grdMostSold.Rows.Clear();
grdMostSold.DataSource = tblMostSold;
grdMostSold.RowHeadersVisible = false;
grdMostSold.Sort(this.grdMostSold.Columns["Item Quantity"], ListSortDirection.Descending);
grdMostSold.Refresh();
}
}
private void GetExistingItemBatchs()
{
int iCode;
bool result = int.TryParse(txtItemCode.Text, out iCode);
if (result)
{
_PhamaPOSEntities = _dbConnector.getConn();
var Ds = _PhamaPOSEntities.items.Where(a => a.itemCode == iCode);
var itemCount = Ds.Count();
if (itemCount > 0)
{
lblItemName.Text = Ds.FirstOrDefault().itemDescription;
var Ds1 = Ds
.FirstOrDefault().stocks
.Where(a => a.isAvailable == true);
drpBatch.DataSource = null;
drpBatch.Items.Clear();
if (Ds1.Count() > 0)
{
if (!radioAddNew.Checked)
{
drpBatch.DataSource = Ds1
.Reverse()
.Select(a => new
{
a.stockId,
a.stockReceivedDate
}).ToList();
drpBatch.ValueMember = "stockId";
drpBatch.DisplayMember = "stockReceivedDate";
FillDetailsByBatchId();
}
else
{
Dictionary <string, string> comboSource = new Dictionary <string, string>();
comboSource.Add("0", "New Batch");
drpBatch.DataSource = new BindingSource(comboSource, null);
drpBatch.DisplayMember = "Value";
drpBatch.ValueMember = "Key";
}
}
else
{
Dictionary <string, string> comboSource = new Dictionary <string, string>();
comboSource.Add("0", "New Batch");
drpBatch.DataSource = new BindingSource(comboSource, null);
drpBatch.DisplayMember = "Value";
drpBatch.ValueMember = "Key";
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItemCode.Text = "";
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItemCode.Text = "";
}
}
private void GetAllTransactions(DateTime dateFrom, DateTime dateTo)
{
_PhamaPOSEntities = new PhamaPOSEntities();
_PhamaPOSEntities = _dbConnector.getConn();
tblTransactions.Rows.Clear();
grdAllTransactions.DataSource = null;
tblTransactionsDetails.Rows.Clear();
if (dateFrom == dateTo)
{
var sales = _PhamaPOSEntities.saleBatches
.Where(a => EntityFunctions.TruncateTime(a.entryDate) == EntityFunctions.TruncateTime(dateFrom))
.Select(a => new
{
a.saleBatchId,
a.entryDate,
a.entryBy,
a.discountedAmount,
a.grandTotal,
a.subTotal
}).Distinct();
foreach (var rowObj in sales)
{
DataRow dr = tblTransactions.NewRow();
dr["BatchId"] = rowObj.saleBatchId;
dr["Sale Date"] = rowObj.entryDate;
dr["User"] = rowObj.entryBy;
dr["Discount"] = rowObj.discountedAmount;
dr["Gross Amount"] = rowObj.grandTotal;
dr["Nett Amount"] = rowObj.subTotal;
tblTransactions.Rows.Add(dr);
}
grdAllTransactions.DataSource = tblTransactions;
grdAllTransactions.Columns[0].Visible = false;
grdAllTransactions.RowHeadersVisible = false;
grdAllTransactions.Sort(this.grdAllTransactions.Columns["Sale Date"], ListSortDirection.Descending);
grdAllTransactions.Refresh();
}
else
{
var sales = _PhamaPOSEntities.saleBatches
.Where(a => EntityFunctions.TruncateTime(a.entryDate) <= EntityFunctions.TruncateTime(dateTo) && EntityFunctions.TruncateTime(a.entryDate) >= EntityFunctions.TruncateTime(dateFrom))
.Select(a => new
{
a.saleBatchId,
a.entryDate,
a.entryBy,
a.discountedAmount,
a.grandTotal,
a.subTotal
}).Distinct();
foreach (var rowObj in sales)
{
DataRow dr = tblTransactions.NewRow();
dr["BatchId"] = rowObj.saleBatchId;
dr["Sale Date"] = rowObj.entryDate;
dr["User"] = rowObj.entryBy;
dr["Discount"] = rowObj.discountedAmount;
dr["Gross Amount"] = rowObj.grandTotal;
dr["Nett Amount"] = rowObj.subTotal;
tblTransactions.Rows.Add(dr);
}
grdAllTransactions.DataSource = tblTransactions;
grdAllTransactions.Columns[0].Visible = false;
grdAllTransactions.RowHeadersVisible = false;
grdAllTransactions.Sort(this.grdAllTransactions.Columns["Sale Date"], ListSortDirection.Descending);
grdAllTransactions.Refresh();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var contex = new PhamaPOSEntities())
{
using (var dbContextTransaction = contex.Database.BeginTransaction())
{
try
{
saleBatch sb = new saleBatch();
sb.entryBy = _user.userName;
sb.entryDate = DateTime.Now;
sb.saleDate = DateTime.Now;
sb.discountedAmount = Convert.ToDecimal(_txtDiscAmt);
sb.grandTotal = Convert.ToDecimal(_grandTotal);
sb.subTotal = Convert.ToDecimal(_subTotal);
contex.saleBatches.Add(sb);
contex.SaveChanges();
foreach (DataRow dr in _tblItems.Rows)
{
Int64 batchID = Convert.ToInt64(dr["Item Sock"]);
int quantity = Convert.ToInt32(dr["Quantity"]);
//update stock
stock s = new stock();
s = contex.stocks.Where(a => a.stockId == batchID).FirstOrDefault();
if (s.runningQuantity == quantity)
{
s.runningQuantity = 0;
s.isAvailable = false;
s.stockClearedDate = DateTime.Now;
contex.stocks.Attach(s);
var entry = contex.Entry(s);
entry.Property(a => a.runningQuantity).IsModified = true;
entry.Property(a => a.isAvailable).IsModified = true;
entry.Property(a => a.stockClearedDate).IsModified = true;
contex.SaveChanges();
}
else
{
s.runningQuantity = s.runningQuantity - quantity;
contex.stocks.Attach(s);
var entry = contex.Entry(s);
entry.Property(a => a.runningQuantity).IsModified = true;
contex.SaveChanges();
}
//update sale
sale sale = new sale();
sale.amount = Convert.ToDecimal(dr["Total"]);
sale.itemStockId = Convert.ToInt64(dr["Item Sock"]);
sale.saleBatchId = sb.saleBatchId;
sale.soldQuantity = Convert.ToInt64(dr["Quantity"]);
sale.unitPrice = Convert.ToDecimal(dr["Unit Price"]);
contex.sales.Add(sale);
contex.SaveChanges();
//form.Show();
}
dbContextTransaction.Commit();
MessageBox.Show("Payment Proceed Successfull..");
home form = new home(_user);
form.Show();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Error Occured.. Please Retry..");
dbContextTransaction.Rollback();
}
}
}
}
private void GetExistingItemBatchs()
{
int iCode;
bool result = int.TryParse(txtItem.Text, out iCode);
if (result)
{
_PhamaPOSEntities = _dbConnector.getConn();
var Ds = _PhamaPOSEntities.items.Where(a => a.itemCode == iCode);
var itemCount = Ds.Count();
if (itemCount > 0)
{
txtItemName.Text = Ds.FirstOrDefault().itemDescription;
txtItemDetails.Text = Ds.FirstOrDefault().itemCallingName;
// comboBox1.SelectedText = "";
comboBox1.Text = Ds.FirstOrDefault().itemDescription + "-->" + Ds.FirstOrDefault().itemCode;
var Ds1 = Ds
.FirstOrDefault().stocks
.Where(a => a.isAvailable == true && a.runningQuantity > 0)
.OrderBy(a => a.entryDate);
drpBatch.DataSource = null;
drpBatch.Items.Clear();
if (Ds1.Count() > 0)
{
drpBatch.DataSource = Ds1
.Select(a => new
{
a.stockId,
a.entryDate
}).ToList();
drpBatch.ValueMember = "stockId";
drpBatch.DisplayMember = "entryDate";
FillDetailsByBatchId();
}
else
{
Dictionary <string, string> comboSource = new Dictionary <string, string>();
comboSource.Add("0", "No Stocks Found");
drpBatch.DataSource = new BindingSource(comboSource, null);
drpBatch.DisplayMember = "Value";
drpBatch.ValueMember = "Key";
Clearfields();
// txtItem.Focus();
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItem.Text = "";
Clearfields();
// txtItem.Focus();
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItem.Text = "";
// txtItem.Focus();
}
}
private void btnAddToGrid_Click(object sender, EventArgs e)
{
int iCode;
bool result = int.TryParse(txtItem.Text, out iCode);
if (result)
{
_PhamaPOSEntities = _dbConnector.getConn();
var Ds = _PhamaPOSEntities.items.Where(a => a.itemCode == iCode);
var itemCount = Ds.Count();
if (itemCount > 0)
{
int batchId = Convert.ToInt32(drpBatch.SelectedValue);
if (batchId > 0)
{
int iQuantity;
bool resultQty = int.TryParse(txtQuantity.Text, out iQuantity);
if (resultQty)
{
if (iQuantity > 0)
{
long availableStock = Ds.FirstOrDefault().stocks.Where(a => a.stockId == batchId).FirstOrDefault().runningQuantity;
if (availableStock > 0)
{
if (iQuantity > availableStock)
{
MessageBox.Show("The Stock Quantity is Less Than Requested Quantity..");
}
else
{
bool isAvailable = false;
foreach (DataRow _dr in tblItems.Rows)
{
if (Convert.ToInt32(_dr["Item Code"]) == iCode && batchId == Convert.ToInt32(_dr["Item Sock"]))
{
if (availableStock >= Convert.ToInt32(_dr["Quantity"]) + iQuantity)
{
int UpdatedQty = Convert.ToInt32(_dr["Quantity"]) + iQuantity;
_dr["Quantity"] = UpdatedQty;
_dr["Total"] = UpdatedQty * Ds.FirstOrDefault().stocks.Where(a => a.stockId == batchId).FirstOrDefault().itemUnitPriceSelling;
}
else
{
MessageBox.Show("Quntity Exeed Available Stock..");
}
isAvailable = true;
break;
}
}
if (!isAvailable)
{
DataRow dr = tblItems.NewRow();
dr["item#"] = tblItems.Rows.Count + 1;
dr["Item Code"] = iCode;
dr["Item Sock"] = batchId;
dr["Item Name"] = Ds.FirstOrDefault().itemDescription;
dr["Unit Price"] = Ds.FirstOrDefault().stocks.Where(a => a.stockId == batchId).FirstOrDefault().itemUnitPriceSelling;
dr["Quantity"] = iQuantity;
dr["Total"] = iQuantity * Ds.FirstOrDefault().stocks.Where(a => a.stockId == batchId).FirstOrDefault().itemUnitPriceSelling;
tblItems.Rows.Add(dr);
dataGridView1.DataSource = tblItems;
}
else
{
dataGridView1.Refresh();
}
updateSubTotal();
txtItem.Focus();
}
}
else
{
MessageBox.Show("No Stocks Found For Item..");
}
}
else
{
MessageBox.Show("Invalid Quantity..");
}
}
else
{
MessageBox.Show("Invalid Quantity..");
}
}
else
{
MessageBox.Show("Invalid Stock for Item..");
txtItem.Text = "";
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItem.Text = "";
}
}
else
{
MessageBox.Show("Invalid Item Code...");
txtItem.Text = "";
}
}
