void PopulateDatagridviewData()
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
var dgvQuery = (from Items in db.Inventory_Item
join Price in db.Inventory_Price
on Items.Inventory_Item_ID equals Price.Inventory_Item_ID
join Type in db.Inventory_Item_Type
on Items.Inventory_Item_Type_ID equals Type.Inventory_Item_Type_ID
//where ed.Employee_Details_Name.Contains(txtESearch.Text)
select new { Items.Inventory_Item_ID, Items.Inventory_Item_Barcode, Items.Inventory_Item_Name, Price.Inventory_Price1, Type.Inv_Item_Type_Description }
).ToList();
//dgvInventoryItem.DataSource = db.Inventory_Item.ToList<Inventory_Item>();
//dgvInventoryItem.DataSource = db.Inventory_Price.ToList<Inventory_Price>();
//dgvInventoryItem.DataSource = db.Inventory_Item_Type.ToList<Inventory_Item_Type>();
dgvInventoryItem.Columns.Clear();
dgvInventoryItem.DataSource = dgvQuery;
dgvInventoryItem.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvInventoryItem.Columns[0].HeaderText = "Inventory ID";
dgvInventoryItem.Columns[1].HeaderText = "Inventory Barcode";
dgvInventoryItem.Columns[1].Width = 100;
dgvInventoryItem.Columns[2].HeaderText = "Inventory Name";
dgvInventoryItem.Columns[2].Width = 100;
dgvInventoryItem.Columns[3].HeaderText = "Discount";
dgvInventoryItem.Columns[4].HeaderText = "Price (Per Unit)";
dgvInventoryItem.Columns[4].Width = 100;
dgvInventoryItem.Columns[5].HeaderText = "Type";
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
var dgvQuery = (from Items in db.Inventory_Item
where Items.Inventory_Item_Name.Contains(txtSearchInventoryItem.Text)
select new { Items.Inventory_Item_ID, Items.Inventory_Item_Name, Items.Inventory_Item_Quantity }
).ToList();
dgvInventoryStockTake.Columns.Clear();
dgvInventoryStockTake.DataSource = dgvQuery;
dgvInventoryStockTake.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvInventoryStockTake.Columns[0].HeaderText = "Inventory ID";
dgvInventoryStockTake.Columns[1].HeaderText = "Inventory Name";
dgvInventoryStockTake.Columns[1].Width = 100;
dgvInventoryStockTake.Columns[2].HeaderText = "Quantity";
dgvInventoryStockTake.Columns[2].Width = 100;
}
}
catch (Exception myErr)
{
MessageBox.Show("Error: " + myErr.Message);
}
}
void PopulateInvDGV()
{
try
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
var dgvQuery = (from Items in db.Inventory_Item
select new { Items.Inventory_Item_ID, Items.Inventory_Item_Name, Items.Inventory_Item_Quantity }
).ToList();
dgvInventoryStockTake.Columns.Clear();
dgvInventoryStockTake.DataSource = dgvQuery;
dgvInventoryStockTake.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvInventoryStockTake.Columns[0].HeaderText = "Inventory ID";
dgvInventoryStockTake.Columns[1].HeaderText = "Inventory Name";
dgvInventoryStockTake.Columns[1].Width = 100;
dgvInventoryStockTake.Columns[2].HeaderText = "Quantity";
dgvInventoryStockTake.Columns[2].Width = 100;
}
}
catch (Exception myErr)
{
MessageBox.Show("Error: " + myErr.Message);
}
}
void PopSecurityQuestionCbx()
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
var cbxQuery = (from secQ in db.Security_Question
select new { secQ.Security_Question_Description }
).ToList();
cbxSecQuest.DataSource = cbxQuery;
cbxSecQuest.DisplayMember = "Security_Question_Description";
}
}
private void btnFinaliseSale_Click(object sender, EventArgs e)
{
//POSForm frmSale = new POSForm("","",1, txtSalesDescription.Text, txtSalesQuantity.Text, txtSalesPrice.Text,txtSalesDiscount.Text,"","","","");
//frmSale.Show();
#region Saving to database
Invmodel.Inventory_Item_Name = txtSalesDescription.Text.Trim();
//Invmodel.Inventory_Item_Barcode = txtBarcode.text.trim();
Invmodel.Inventory_Item_Quantity = Convert.ToInt32(txtSalesQuantity.Text.Trim());
Pricemodel.Inventory_Price1 = Convert.ToDecimal(txtSalesPrice.Text.Trim());
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
db.Inventory_Item.Add(Invmodel);
db.Inventory_Price.Add(Pricemodel);
db.Inventory_Item_Type.Add(TypeModel);
db.SaveChanges();
}
}
private void btnChangePassword_Click(object sender, EventArgs e)
{
try
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
db.spChangeEmployeePassword(txtPassword.Text, txtEmail.Text, DateTime.Today.Date, DateTime.Now.TimeOfDay, txtName.Text, "Change of Password", "Password was changed.");
db.SaveChanges();
MessageBox.Show("You have successfully changed your password.");
}
}
catch (Exception ex)
{
MessageBox.Show("There was an error in chnaging the password. Error:" + ex);
}
}
public bool CanLogin()
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
bool CanLogin = false;
int ExisQuery = (from el in db.Employees
where el.Employee_Name.Equals(txtName.Text.Trim())
select new { el.Employee_ID, el.Employee_Name, el.Employee_Login_Password, el.Employee_Picture }
).Count();
if (ExisQuery > 0)
{
var LoginQuery = (from et in db.Employee_Type
join ua in db.Employee_Access_Level
on et.Employee_Access_Level_ID equals ua.Employee_Access_Level_ID
join emp in db.Employees
on et.Employee_Type_ID equals emp.Employee_Type_ID
where emp.Employee_Name.Equals(txtName.Text.Trim())
select new { emp.Employee_ID, emp.Employee_Name, emp.Employee_Login_Password, emp.Employee_Picture, ua.Employee_Access_Level_ID }
).First();
Employee_Access_Level = LoginQuery.Employee_Access_Level_ID;
Employee_ID = LoginQuery.Employee_ID;
Employee_Name = LoginQuery.Employee_Name;
Employee_Password = LoginQuery.Employee_Login_Password;
Employee_Picture = LoginQuery.Employee_Picture;
if (LoginQuery.Employee_Name == txtName.Text.Trim() && Convert.ToBase64String(LoginQuery.Employee_Login_Password) == PasswordHash(txtPassword.Text.Trim()))
{
CanLogin = true;
}
else
{
CanLogin = false;
MessageBox.Show("Error: Incorrect UserName or Password, Please Check Spelling");
}
}
return(CanLogin);
}
}
public bool ChangePassword()
{
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
bool ChangePassword = false;
int ExisQuery = (from el in db.Employees
where el.Employee_Email.Equals(txtEmail.Text.Trim())
select new { el.Employee_ID, el.Employee_Email, el.Security_Question }
).Count();
if (ExisQuery > 0)
{
var LoginQuery = (from sq in db.Security_Question
join emp in db.Employees
on sq.Security_Question_ID equals emp.Security_Question_ID
where emp.Employee_Name.Equals(txtName.Text.Trim())
select new { emp.Employee_ID, emp.Employee_Name, emp.Employee_Email, sq.Security_Question_Description, emp.Employee_Security_Answer }
).First();
if (LoginQuery.Employee_Name == txtName.Text.Trim() && LoginQuery.Employee_Email == txtEmail.Text.Trim() && LoginQuery.Security_Question_Description == cbxSecQuest.Text.Trim() && LoginQuery.Employee_Security_Answer == txtAnswer.Text)
{
ChangePassword = true;
Employee_ID = LoginQuery.Employee_ID;
}
else
{
ChangePassword = false;
MessageBox.Show("Error: Incorrect details or not entered details. Please reconfirm all the details on the form.");
}
}
else
{
ChangePassword = false;
MessageBox.Show("Error: Incorrect email or security question response, Please Check Spelling");
}
return(ChangePassword);
}
}
private void btnUpdateQuantity_Click(object sender, EventArgs e)
{
//if (MessageBox.Show("Are you sure you want to update this quantity?","Confirmation",MessageBoxButtons.YesNo) == "Yes"
using (NatiSupermarketandTakeawayFinalEntities db = new NatiSupermarketandTakeawayFinalEntities())
{
try
{
int id = Convert.ToInt32(dgvInventoryStockTake.SelectedRows[0]);
var UpdateST = (from item in db.Inventory_Item
where id == item.Inventory_Item_ID
select item).First();
UpdateST.Inventory_Item_Quantity = Convert.ToInt32(nudQuantityST.Value);
db.SaveChanges();
PopulateInvDGV();
this.Close();
}
catch (Exception ss)
{
MessageBox.Show(ss.ToString());
}
}
}
