private void Check_Out_Stock_Item_Load(object sender, EventArgs e)
{
int id = Globals.MStockpassing;
Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id);
Stock_Price priceEdit = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id);
Stock_Type stockType = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_ID == itemEdited.Stock_Type_ID);
txtStockItemID.Text = Convert.ToString(itemEdited.Stock_ID);
txtStockItemNamee.Text = itemEdited.Stock_Item_Name;
var customers = from p in db.Check_Out_Line
select new
{
CheckInLineID = p.Check_Out_Line_ID,
StockItemName = p.Stock_Item_Name,
Quantity = p.Quaantity,
CheckOutID = p.Check_Out_ID,
StockItemID = p.Stock_ID,
};
dgvCheckOut.DataSource = customers.ToList();
dgvCheckOut.ClearSelection();
txtStockItemID.Enabled = false;
txtStockItemNamee.Enabled = false;
}
private void Maintain_Stock_Item_Load(object sender, EventArgs e)
{
int id = Globals.MStockpassing;
Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id);
Stock_Price priceEdit = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id);
Stock_Type stockType = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_ID == itemEdited.Stock_Type_ID);
txtStockItemNameMaint.Text = itemEdited.Stock_Item_Name;
txtStockItemDescriptionMaint.Text = itemEdited.Stock_Item_Description;
txtCostPrice.Text = Convert.ToString(priceEdit.Stock_Price1);
cmbSTypeMaint.Text = stockType.Stock_Type_Description;
}
private void Take_Stock_Item_Load(object sender, EventArgs e)
{
int id = Globals.MStockpassing;
Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id);
Stock_Price priceEdit = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id);
Stock_Type stockType = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_ID == itemEdited.Stock_Type_ID);
txtStockItemID.Text = Convert.ToString(itemEdited.Stock_ID);
txtStockItemNamee.Text = itemEdited.Stock_Item_Name;
txtStockItemID.Enabled = false;
txtStockItemNamee.Enabled = false;
}
private void button1_Click(object sender, EventArgs e)
{
string phrase = txtCostPrice.Text;
double number;
bool isNumeric = double.TryParse(phrase, out number);
if ((phrase.Length < 9) && isNumeric == true)
{
int id = Globals.MStockpassing;
Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id);
Stock_Price priceEdit = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id);
itemEdited.Stock_Item_Name = txtStockItemNameMaint.Text;
itemEdited.Stock_Item_Description = txtStockItemDescriptionMaint.Text;
priceEdit.Stock_Price1 = Convert.ToDouble(txtCostPrice.Text);
if (cmbSTypeMaint.Text == "Ingredient")
{
Stock_Type idTracker = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_Description == "Ingredient");
itemEdited.Stock_Type_ID = idTracker.Stock_Type_ID;
}
else if (cmbSTypeMaint.Text == "Product")
{
Stock_Type idTracker = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_Description == "Product");
itemEdited.Stock_Type_ID = idTracker.Stock_Type_ID;
}
db.SaveChanges();
MessageBox.Show("Stock item updated successfully");
Globals.refresher = true;
this.Close();
}
else
{
MessageBox.Show("Error: Price value entered is not in correct format or value too large");
}
}
private void button1_Click(object sender, EventArgs e)
{
string phrase = txtStockItemPrice.Text;
double number;
bool isNumeric = double.TryParse(phrase, out number);
if ((phrase.Length < 9) && isNumeric == true)
{
if (cmbStockItemType.Text == "Ingredient")
{
Stock_Price newPrice = new Stock_Price();
newPrice.Stock_Price1 = Convert.ToDouble(txtStockItemPrice.Text);
db.Stock_Price.Add(newPrice);
newPrice.Stock_Price1 = Convert.ToDouble(txtStockItemPrice.Text);
db.Stock_Price.Add(newPrice);
Stock_Item newItem = new Stock_Item();
Stock_Type idTracker = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_Description == "Ingredient");
newItem.Stock_Item_Name = txtStockItemnName.Text;
newItem.Stock_Item_Description = txtStockItemDescription.Text;
newItem.Stock_Item_Quantity = 0;
newItem.Stock_Type_ID = idTracker.Stock_Type_ID;
newItem.Stock_Price_ID = newPrice.Stock_Price_ID;
db.Stock_Item.Add(newItem);
db.SaveChanges();
MessageBox.Show("Stock item added successfully");
Globals.refresher = true;
txtStockItemnName.Text = "";
txtStockItemDescription.Text = "";
txtStockItemPrice.Text = "";
cmbStockItemType.Text = "";
}
if ((phrase.Length < 9) && cmbStockItemType.Text == "Product")
{
Stock_Price newPrice = new Stock_Price();
newPrice.Stock_Price1 = Convert.ToDouble(txtStockItemPrice.Text);
db.Stock_Price.Add(newPrice);
newPrice.Stock_Price1 = Convert.ToDouble(txtStockItemPrice.Text);
db.Stock_Price.Add(newPrice);
Stock_Item newItem = new Stock_Item();
Stock_Type idTracker = db.Stock_Type.FirstOrDefault(c => c.Stock_Type_Description == "Product");
newItem.Stock_Item_Name = txtStockItemnName.Text;
newItem.Stock_Item_Description = txtStockItemDescription.Text;
newItem.Stock_Item_Quantity = 0;
newItem.Stock_Type_ID = idTracker.Stock_Type_ID;
newItem.Stock_Price_ID = newPrice.Stock_Price_ID;
db.Stock_Item.Add(newItem);
db.SaveChanges();
MessageBox.Show("Stock item added successfully");
Globals.refresher = true;
txtStockItemnName.Text = "";
txtStockItemDescription.Text = "";
txtStockItemPrice.Text = "";
cmbStockItemType.Text = "";
}
}
else
{
MessageBox.Show("Error: Price value entered is not in correct format or too large");
}
}
