public object GetStockList()
{
var table1 = db.GetTable <TProductGroup>();
var tab2 = db.GetTable <TInStock>();
var tab3 = db.GetTable <TLocation>();
//db.GetTable<TInStock>();
var prodQuery = (from stock in tab2
join p in table1 on stock.BarcodeID equals p.Barcode
join d in tab3 on stock.LocationID equals d.LocationID
select new
{
p.Name,
stock.StockID,
stock.BarcodeID,
stock.Quantity,
LocationName = d.Name,
TotalValue = "$" + p.Price * stock.Quantity,
stock.LocationID
}).ToList();
//var query = db.ExecuteQuery(@"
// SELECT BarcodeID, Name, Quantity FROM TInStock
// LEFT JOIN TProductGroup ON
// TInStock.BarcodeID = TProductGroup.Barcode");
return(prodQuery);
}
private void BtnLoggin_Click(object sender, EventArgs e)
{
string userManager = emailTxt.Text;
string passwordmanager = passwordTxt.Text;
using (DataLinqToSQLDataContext user = new DataLinqToSQLDataContext())
{
// Getting managers table
var managerTable = user.GetTable <TManagerInventory>();
var authManager = managerTable.Where(x => x.ManagerEmail == userManager && x.Password == passwordmanager).ToList();
// Checking if user is valid
if (authManager.Count > 0)
{
// This information is going to be sent to the main form
SetManager = emailTxt.Text;
MessageBox.Show("Welcome " + userManager, "Inventory Management", MessageBoxButtons.OK, MessageBoxIcon.None);
MainInventoryForm authForm = new MainInventoryForm();
authForm.Show();
this.Hide();
}
else
{
MessageBox.Show("You enter wrong credentials!", "Inventory Management", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public object GetReturnList()
{
var table1 = db.GetTable <TProductGroup>();
var tab2 = db.GetTable <TReturned>();
var tab3 = db.GetTable <TLocation>();
//db.GetTable<TInStock>();
var prodQuery = (from returned in tab2
join p in table1 on returned.BarcodeID equals p.Barcode
join d in tab3 on returned.LocationID equals d.LocationID
select new
{
returned.BarcodeID,
p.Name,
returned.Quantity,
LocationName = d.Name,
returned.LocationID
}).ToList();
return(prodQuery);
}
