private void DeleteUnitBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteConvUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
try
{
string where = "Code = " + TheCode_txt.Text;
Classes.DeleteRows(where, "Units_Conversion");
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
Classes.LogTable(Classes.MyComm.CommandText.ToString(), TheCode_txt.Text, "Units_Conversion", "Delete");
BtnRecipeUnit2.IsEnabled = false;
BtnRecipeUnit.IsEnabled = false;
SaveUNitBtn.IsEnabled = false;
UpdateUnitBtn.IsEnabled = false;
DeleteUnitBtn.IsEnabled = false;
RecipeUnit_DGV.DataContext = null;
LoadAllCOnv();
ClearUIFields();
MainUiFormat();
}
MessageBox.Show("Deleted Successfully");
}
}
public MainWindow()
{
InitializeComponent();
Classes.TheConnectionString();
Classes.GetWS();
Classes.GetDateFormate();
Classes.GetDateTimeFormate();
//DateTime DatetimeNow = new DateTime();
//DatetimeNow = DateTime.Now;
//if (DatetimeNow.Date > Convert.ToDateTime("11/1/2020"))
//{
// MessageBox.Show("Please Check The Licence");
// System.Windows.Application.Current.Shutdown();
// return;
//}
Classes.UpdateDateFormat();
Classes.Language();
//Calculation.Calculate();
NameofForm.Text = "Food Cost";
//int num = (DateTime.Now.Hour* DateTime.Now.Day) +0x21;
Classes.RetrieveTheYearAndMonth();
//Check_Month();
LogIn logIn = new LogIn();
logIn.ShowDialog();
if (logIn.CheckToLogin == false)
{
System.Windows.Application.Current.Shutdown();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
LogIn logIn = new LogIn();
logIn.Owner = this;
logIn.ShowDialog();
}
public PurchaseOrder()
{
if (MainWindow.AuthenticationData.Count != 0)
{
if (MainWindow.AuthenticationData.ContainsKey("Purchase"))
{
Authenticated = MainWindow.AuthenticationData["Purchase"];
if (Authenticated.Count == 0)
{
MessageBox.Show("You Havent a Privilage to Open this Page");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
InitializeComponent();
LoadTheMainRestaurant();
DateTime now = DateTime.Now;
MainUiFormat();
}
}
}
else
{
MessageBox.Show("You should Login First !");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
} //Done
private void UpdateUnitBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("UpdateConvUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
try
{
string FiledSelection = "BaseUnit_ID,BaseUnit_Name,Value,SecondUnit_ID,SecondUnit_Name,Last_modifiled_Date";
string Values = string.Format("(select Code From Units where Name='{0}'),N'{0}','{1}',(select Code From Units where Name='{2}'),'{2}',GETDATE()", BaseUnit.Text, ConvUnit2.Text, Secondunit.Text);
string Where = "Code=" + TheCode_txt.Text;
Classes.UpdateRow(FiledSelection, Values, Where, "Units_Conversion");
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
{
RecipeUnit_DGV.DataContext = null;
MessageBox.Show("Saved Sussesfully !");
Classes.LogTable(Classes.MyComm.CommandText.ToString(), TheCode_txt.Text, "Units_Conversion", "Update");
SaveUNitBtn.IsEnabled = false;
BtnRecipeUnit2.IsEnabled = false;
BtnRecipeUnit.IsEnabled = false;
UpdateUnitBtn.IsEnabled = false;
LoadAllCOnv();
BaseUnit.Text = "";
Secondunit.Text = "";
ConvUnit2.Text = "";
ClearUIFields();
MainUiFormat();
}
}
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveUsersAuthentication") == -1 && Authenticated.IndexOf("CheckAllUsersAuthentication") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (UserClassIDtxt.Text == "")
{
MessageBox.Show("Please enter ID Field");
return;
}
if (Nametxt.Text == "")
{
MessageBox.Show("Please enter Name Field");
return;
}
try
{
string FiledSelection = "UserClass_ID,Name,Active,CreateDate,User_ID,WS";
string Values = string.Format("'{0}',N'{1}','{2}',GETDATE(),'{3}','{4}'", UserClassIDtxt.Text, Nametxt.Text, Active_chbx.IsChecked.ToString(), MainWindow.UserID, Classes.WS);
Classes.InsertRow("UserClass_tbl", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
Classes.LogTable(Classes.MyComm.CommandText.ToString(), UserClassIDtxt.Text, "UserClass_tbl", "New");
MainUIFormat();
MessageBox.Show("Saved Successfully");
LoadUserClasses();
}
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (Code_txt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty");
return;
}
try
{
string FiledSelection = "Code,Name,IsActive,Create_Date,User_ID,WS";
string Values = string.Format("'{0}',N'{1}','{2}',GETDATE(),'{3}','{4}'", Code_txt.Text, Name_txt.Text, Active_chbx.IsChecked.ToString(), MainWindow.UserID, Classes.WS);
Classes.InsertRow("Units", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Code_txt.Text, "Units", "New");
MainUiFormat();
Unit_DGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Saved Successfully");
}
}
public Transfer_Kitchens()
{
if (MainWindow.AuthenticationData.Count != 0)
{
if (MainWindow.AuthenticationData.ContainsKey("TransferKitchen"))
{
Authenticated = MainWindow.AuthenticationData["TransferKitchen"];
if (Authenticated.Count == 0)
{
MessageBox.Show("You Havent a Privilage to Open this Page");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
InitializeComponent();
transfer_No.Text = Classes.InCrementTransactionSerial("Transfer_Kitchens", "Transfer_Serial");
}
}
}
else
{
MessageBox.Show("You should Login First !"); LogIn logIn = new LogIn(); logIn.ShowDialog();
}
} //Done
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveTheInventory") == -1 && Authenticated.IndexOf("CheckAllPhysicalInventory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
if (Serial_Inventory_NO.Text.Equals(""))
{
MessageBox.Show("First You should Enter The Serial !");
return;
}
if (Inventory_NO.Text.Equals(""))
{
MessageBox.Show("First You should Enter The Manual Number !");
return;
}
if (Typecbx.Text.Equals(""))
{
MessageBox.Show("First You should Choose The Type !");
return;
}
if (InventoryDate.Text.Equals(""))
{
MessageBox.Show("First You should Choose The Date !");
return;
}
SaveInfoANdData();
}
} //Done
public AdjacmentInventory()
{
if (MainWindow.AuthenticationData.Count != 0)
{
if (MainWindow.AuthenticationData.ContainsKey("AddjacmentItems"))
{
Authenticated = MainWindow.AuthenticationData["AddjacmentItems"];
if (Authenticated.Count == 0)
{
MessageBox.Show("You Havent a Privilage to Open this Page");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
InitializeComponent();
LoadAllResturant();
}
}
}
else
{
MessageBox.Show(" You Should Logined First !"); LogIn logIn = new LogIn(); logIn.ShowDialog();
}
} //Done
private void DeleteBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
try
{
string where = "Code = " + Code_txt.Text;
Classes.DeleteRows(where, "Units");
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
MainUiFormat();
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Code_txt.Text, "Units", "Delete");
Unit_DGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Deleted Successfully");
}
}
public KitcheItemsn()
{
if (MainWindow.AuthenticationData.ContainsKey("KitchenItems"))
{
Authenticated = MainWindow.AuthenticationData["KitchenItems"];
if (Authenticated.Count == 0)
{
MessageBox.Show("You Havent a Privilage to Open this Page");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
InitializeComponent();
LoadAllOutlet();
SaveBtn.IsEnabled = false;
dt.Columns.Add("Code");
dt.Columns.Add("Manual Code");
dt.Columns.Add("Name");
dt.Columns.Add("Name2");
dt.Columns.Add("Shelf");
dt.Columns.Add("Min Qty");
dt.Columns.Add("Max Qty");
dt.Columns.Add("Unit");
}
}
}
private void SaveUNitBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveConvUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
try
{
string FiledSelection = "Code,BaseUnit_ID,BaseUnit_Name,Value,SecondUnit_ID,SecondUnit_Name,Create_Date,User_ID,WS";
string Values = string.Format("'{5}',(select Code from Units where Name='{0}'),N'{0}','{1}',(select Code from Units where Name='{2}'),N'{2}',GETDATE(),'{3}','{4}'", BaseUnit.Text, ConvUnit2.Text, Secondunit.Text, MainWindow.UserID, Classes.WS, TheCode_txt.Text);
Classes.InsertRow("Units_Conversion", FiledSelection, Values);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
finally
{
MessageBox.Show("Saved Sussesfully !");
RecipeUnit_DGV.DataContext = null;
LoadAllCOnv();
ClearUIFields();
Classes.LogTable(Classes.MyComm.CommandText.ToString(), TheCode_txt.Text, "Units_Conversion", "New");
SaveUNitBtn.IsEnabled = false;
BtnRecipeUnit2.IsEnabled = false;
BtnRecipeUnit.IsEnabled = false;
}
}
}
public Users()
{
if (MainWindow.AuthenticationData.Count != 0)
{
if (MainWindow.AuthenticationData.ContainsKey("Users"))
{
Authenticated = MainWindow.AuthenticationData["Users"];
if (Authenticated.Count == 0)
{
MessageBox.Show("You Havent a Privilage to Open this Page");
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
InitializeComponent();
FillDGV();
MainUiFormat();
}
}
}
else
{
MessageBox.Show("You Should Logined First !"); LogIn logIn = new LogIn(); logIn.ShowDialog();
}
}
private void UpdateBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("UpdateUsers") == -1 && Authenticated.IndexOf("CheckAllUsers") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
try
{
string FiledSelection = "Name,UserName,Password,UserClass_ID,Mobile,Adress,Email,Active,ModifiedDate";
string Values = string.Format("N'{0}','{1}','{2}',(select UserClass_ID FROM UserClass_tbl Where Name='{3}'),'{4}',N'{5}','{6}','{7}',GETDATE()", Nametxt.Text, UserNametxt.Text, passwordtxt.Password, jobTitle.Text, phone.Text, Addresstxt.Text, Mailtxt.Text, Active_chbx.IsChecked.ToString());
string Where = "ID = " + userIDtxt.Text;
Classes.UpdateRow(FiledSelection, Values, Where, "Users");
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
MainUiFormat();
Classes.LogTable(Classes.MyComm.CommandText.ToString(), userIDtxt.Text, "Users", "Update");
UsersDGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Updated Successfully");
}
}
private void UpdateBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("UpdateUnits") == -1 && Authenticated.IndexOf("CheckAllUnits") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
try
{
string FiledSelection = "Name,IsActive,Last_modifiled_Date";
string Values = string.Format("N'{0}','{1}',GETDATE()", Name_txt.Text, Active_chbx.IsChecked);
string Where = "Code = " + Code_txt.Text;
Classes.UpdateRow(FiledSelection, Values, Where, "Units");
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Code_txt.Text, "Units", "Update");
MainUiFormat();
Unit_DGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Updated Successfully");
}
}
private void GenerateBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("GenertaeGenerate") == -1 && Authenticated.IndexOf("CheckAllGenerateBatch") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
CountofRecipeItemData = 0;
CountofRecipesData = 0;
if (QtyofRecipetxt.Text == "")
{
MessageBox.Show("Please Enter Qty of Recipe"); return;
}
string UnitQty = ""; string Unit = "";
SqlConnection con = new SqlConnection(Classes.DataConnString);
SqlDataReader reader = null;
SqlCommand cmd = new SqlCommand();
try
{
con.Open();
string s = "SELECT UnitQty,Unit FROM Setup_Recipes WHERE Code=" + valofRecipe;
cmd = new SqlCommand(s, con);
reader = cmd.ExecuteReader();
while (reader.Read())
{
UnitQty = reader["UnitQty"].ToString();
Unit = reader["Unit"].ToString();
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{ con.Close(); }
bool boolianCheck = ItsRecipe(valofRecipe, UnitQty, Unit);
if (boolianCheck == true && ToFinishFunction == false)
{
UpddateQty();
MessageBox.Show("Recipe Generated Succesfuly");
}
else if ((boolianCheck == false && ToFinishFunction == true) && isParent == false)
{
MessageBoxResult result = MessageBox.Show("Can't Genertare this Recipe Because Item Can't Complete It , You wan't to Order ?", "Confirmation",
MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (result == MessageBoxResult.OK)
{
UserControl usc = new Food_Cost.OrderRequesation(valofStore, ValOfKitchen);
//Parent.Children.Clear();
//Parent.Children.Add(usc);
}
}
UserControl us = new Food_Cost.GenerateBatch();
//Parent.Children.Clear();
//Parent.Children.Add(us);
}
} //Done
private void DeleteSubBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteRecipeSubCatgoey") == -1 && Authenticated.IndexOf("CheckAllRecipeCategory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
SqlConnection con = new SqlConnection(Classes.DataConnString);
string checkRecipe = "";
try
{
con.Open();
string s = "SELECT SubCategory_ID FROM Setup_Recipes Where SubCategory_ID=" + CodeSub_txt.Text;
SqlCommand cmd = new SqlCommand(s, con);
if (cmd.ExecuteScalar() != null)
{
checkRecipe = cmd.ExecuteScalar().ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
if (checkRecipe != CodeSub_txt.Text)
{
try
{
con.Open();
string q = "Delete Setup_RecipeSubCategories Where Code=" + CodeSub_txt.Text;
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiSubFormat();
FillSubDGV();
}
MessageBox.Show("Deleted Successfully");
}
else
{
MessageBox.Show("Can't delete this Sub Category");
checkRecipe = "";
}
}
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveAddjacmentReasons") == -1 && Authenticated.IndexOf("CheckAllAddjacmentReasons") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
if (Code_txt.Text != "1")
{
if (Code_txt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty");
return;
}
for (int i = 0; i < ReasonsDGV.Items.Count; i++)
{
if (Code_txt.Text == ((DataRowView)ReasonsDGV.Items[i]).Row.ItemArray[0].ToString())
{
MessageBox.Show("This Code Is Not Avaliable");
return;
}
}
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
con.Open();
string s = "insert into Setup_AdjacmentReasons_tbl(Code, Name, Name2, Active) values (" + Code_txt.Text + ",N'" + Name_txt.Text + "',N'" + Name2_txt.Text + "','" + Active_chbx.IsChecked + "')";
SqlCommand cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiFormat();
ReasonsDGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Saved Successfully");
}
else
{
MessageBox.Show("You can't Update This Reason");
}
}
}
} //Done
private void AddRecipeBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("AddRecipes") == -1 && Authenticated.IndexOf("CheckAllRecipes") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
AllRecipes allRecipes = new AllRecipes(this); allRecipes.ShowDialog();
}
} //Done
private void PackIcon_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (Authenticated.IndexOf("UsersAuth") == -1 && Authenticated.IndexOf("CheckAllUsers") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
UserAuth w = new UserAuth();
w.ShowDialog();
}
}
} //Done
private void AddRecipeBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("AddItemTransferReasturant") == -1 && Authenticated.IndexOf("CheckAllTransferResturant") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
AllRecipes TheRecipes = new AllRecipes(this);
TheRecipes.ShowDialog();
}
}
} //Done Finall Function
private void AddItemBtn_Click(object sender, RoutedEventArgs e)
{
//AllRecipesDGV.SelectedItem = null;
if (Authenticated.IndexOf("AddItemRecipes") == -1 && Authenticated.IndexOf("CheckAllRecipes") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
Items items = new Items(this); items.ShowDialog();
}
} //Done Finall Function
} //Done
private void AddBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("AddItemTransferReasturant") == -1 && Authenticated.IndexOf("CheckAllTransferResturant") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
Items itemswindow = new Items(this);
itemswindow.ShowDialog();
}
} //Done
} //Done
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("OrderPO") == -1 && Authenticated.IndexOf("CheckAllPO") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (!DoSomeChecks())
{
return;
}
SqlConnection con = new SqlConnection(Classes.DataConnString);
SqlConnection con2 = new SqlConnection(Classes.DataConnString);
try
{
con2.Open();
string s = string.Format("select PO_Serial From PO WHere PO_Serial='{0}'", Serial_PO_NO.Text);
SqlCommand cmd = new SqlCommand(s, con2);
if (cmd.ExecuteScalar() == null)
{
try
{
Save_PO_Items(con);
Save_PO_Details(con);
}
catch { return; }
}
else
{
try
{
s = string.Format("delete From PO_Items where PO_Serial='{0}'", Serial_PO_NO.Text);
cmd = new SqlCommand(s, con2);
cmd.ExecuteNonQuery();
try
{
Save_PO_Items(con);
Edit_PO_Details(con);
}
catch { return; }
}
catch { return; }
}
}
catch { }
MainUiFormat();
ClearFields();
MessageBox.Show("Saved Successfully");
}
} //Done
} //Done
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveResturants") == -1 && Authenticated.IndexOf("CheckAllResturants") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (Code_txt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty");
return;
}
for (int i = 0; i < Stores_DGV.Items.Count; i++)
{
if (Code_txt.Text == ((DataRowView)Stores_DGV.Items[i]).Row.ItemArray[0].ToString())
{
MessageBox.Show("This Code Is Not Avaliable");
return;
}
}
if (IsMain.IsChecked == true)
{
try
{
DataTable IsMain = Classes.RetrieveData("IsMain", "IsMain='True'", "Setup_Restaurant");
if (IsMain.Rows.Count != 0)
{
MessageBox.Show("Can't be More than Main Resturant !");
return;
}
}
catch { }
}
try
{
string FiledSelection = "Code,Name,Name2,IsMain,IsActive,Create_Date,WS,UserID";
string values = string.Format("'{0}', N'{1}', N'{2}', '{3}','{4}',{5},'{6}','{7}'", Code_txt.Text, Name_txt.Text, Name2_txt.Text, IsMain.IsChecked, Active_chbx.IsChecked, "GETDATE()", Classes.WS, MainWindow.UserID);
Classes.InsertRow("Setup_Restaurant", FiledSelection, values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Code_txt.Text, "Setup_Restaurant", "New");
MainUiFormat();
Stores_DGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Saved Successfully");
}
} //Done
private void DeleteBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteKitchenItems") == -1 && Authenticated.IndexOf("CheckAllKitchenItems") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
con.Open();
string H = "SELECT Item_Code FROM Setup_RecipeItems WHere Item_Code='" + ValtoDelete + "'";
SqlCommand cmd = new SqlCommand(H, con);
if (cmd.ExecuteScalar() == null)
{
try
{
H = "Delete Setup_KitchenItems Where ItemID=" + ValtoDelete + " And RestaurantID=" + ValOfResturant + " AND KitchenID=" + ValOfKitchen;
cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
//H = "Delete Items Where ItemID=" + ValtoDelete + " And RestaurantID=" + ValOfResturant + " AND KitchenID=" + ValOfKitchen;
//cmd = new SqlCommand(H, con);
//cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
LoadDatatoGrid();
MessageBox.Show("Items are deleteed ");
}
}
else
{
MessageBox.Show("Can't Delete this Item");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
}
} //el mafrood ntcheck lw el item da m4 equal 0 yb2a can not delete
} //DOne
private void RemoveItemBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteAddjacment") == -1 && Authenticated.IndexOf("CheckAllAddjacment") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
DataTable ToDelete = ItemsDGV.DataContext as DataTable;
ToDelete.Rows.RemoveAt(ItemsDGV.SelectedIndex);
ItemsDGV.DataContext = ToDelete;
}
} //Done
} //Done
private void TheInventoryDetails_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("StartTheInventory") == -1 && Authenticated.IndexOf("CheckAllPhysicalInventory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
con.Open();
string s = string.Format("select Inventory_ID,Inventory_Type From PhysicalInventory_tbl where Inventory_Type='Open'");
SqlCommand cmd = new SqlCommand(s, con);
if (cmd.ExecuteScalar() != null)
{
MessageBoxResult result = MessageBox.Show("You Hve an Opened Physical Inventory , You wan't to Open It ?", "Confirmation",
MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (result == MessageBoxResult.OK)
{
string W = string.Format("select Top(1)Inventory_ID From PhysicalInventory_tbl ORDER BY Inventory_ID DESC");
cmd = new SqlCommand(W, con);
StartInventory();
LoadOpenPhysicalInventory(cmd.ExecuteScalar().ToString());
}
}
else
{
if (Outletcbx.Text.Equals(""))
{
MessageBox.Show("you Shoud Choose The Resturant first !");
return;
}
else if (Kitchencbx.Text.Equals(""))
{
MessageBox.Show("you Shoud Choose The Kitchen first !");
return;
}
DeleteDataAtQtyOnHand();
GetCodeofResturantAndKitchen();
InsertToONHandTable();
StartInventory();
GetInventoryID();
LoadAllItems();
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
con.Close();
}
} //Done
} //Done
private void AddItemBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("AddItemAddjacment") == -1 && Authenticated.IndexOf("CheckAllAddjacment") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
ValOfResturant = ValOfResturant;
ValOfKitchen = ValOfKitchen;
Items itemswindow = new Items(this);
itemswindow.ShowDialog();
}
} //Done
