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);
}
}
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());
}
}
}
