private void SaveSubBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveRecipeSubCategory") == -1 && Authenticated.IndexOf("CheckAllRecipeCategory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
int val = 0;
if (CodeSub_txt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty");
return;
}
if (Categorycbx.Text == "")
{
MessageBox.Show("Category Field Can't Be Empty");
return;
}
for (int i = 0; i < SubCategoryDGV.Items.Count; i++)
{
if (CodeSub_txt.Text == ((DataRowView)SubCategoryDGV.Items[i]).Row.ItemArray[0].ToString())
{
MessageBox.Show("This Code Is Not Avaliable");
return;
}
}
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
string s = "Select Code From Setup_RecipeCategory Where Name=N'" + Categorycbx.Text + "'";
con.Open();
SqlCommand cmd = new SqlCommand(s, con);
val = int.Parse(cmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
try
{
con.Open();
string q = "Insert into Setup_RecipeSubCategories (Code,Name,Name2,IsActive,Category_ID) values (" + CodeSub_txt.Text + ",N'" + NameSub_txt.Text + "',N'" + Name2Sub_txt.Text + "','" + ActiveSub_chbx.IsChecked + "','" + val + "')";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiSubFormat();
SubCategoryDGV.DataContext = null;
FillSubDGV();
}
MessageBox.Show("Saved Successfully");
}
}
private void UpdateSubBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("UpdateRecipeSubCategory") == -1 && Authenticated.IndexOf("CheckAllRecipeCategory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
int val = 0;
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
string s = "Select Code From Setup_RecipeCategory Where Name=N'" + Categorycbx.Text + "'";
con.Open();
SqlCommand cmd = new SqlCommand(s, con);
val = int.Parse(cmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
try
{
con.Open();
string q = "Update Setup_RecipeSubCategories SET Name=N'" + NameSub_txt.Text +
"',Name2=N'" + Name2Sub_txt.Text +
"',IsActive='" + ActiveSub_chbx.IsChecked +
"',Category_ID='" + val +
"' Where Code =" + CodeSub_txt.Text;;
SqlCommand cmd = new SqlCommand(q, con);
//SqlCommand cmd = new SqlCommand("UpdateSetup_SubCategory", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@Code", CodeSub_txt.Text);
//cmd.Parameters.AddWithValue("@Name", NameSub_txt.Text);
//cmd.Parameters.AddWithValue("@Name2", Name2Sub_txt.Text);
//cmd.Parameters.AddWithValue("@IsActive", ActiveSub_chbx.IsChecked);
//cmd.Parameters.AddWithValue("@Category", val);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiSubFormat();
SubCategoryDGV.DataContext = null;
FillSubDGV();
}
MessageBox.Show("Updated Successfully");
}
}
private void DeleteBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DeleteRecipeCatgoey") == -1 && Authenticated.IndexOf("CheckAllRecipeCategory") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
string checkRecipe = ""; string checkSubCat = "";
SqlConnection con = new SqlConnection(Classes.DataConnString);
try
{
con.Open();
string s = "SELECT Category_ID FROM Setup_Recipes Where Category_ID=" + Code_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();
}
try
{
con.Open();
string s = "SELECT Category_ID FROM Setup_RecipeSubCategories Where Category_ID=" + Code_txt.Text;
SqlCommand cmd = new SqlCommand(s, con);
if (cmd.ExecuteScalar() != null)
{
checkSubCat = cmd.ExecuteScalar().ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
if (checkRecipe != Code_txt.Text && checkSubCat != Code_txt.Text)
{
try
{
con.Open();
string s = "Delete Setup_RecipeCategory Where Code =" + Code_txt.Text;
SqlCommand cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiFormat();
CategoryDGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Deleted Successfully");
}
else
{
MessageBox.Show("Can't Delete this Category");
checkRecipe = "";
checkSubCat = "";
}
}
}
private void UpdateBtn_Click(object sender, RoutedEventArgs e)
{
string TheCommand = "";
if (Authenticated.IndexOf("UpdateUsersAuthentication") == -1 && Authenticated.IndexOf("CheckAllUsersAuthentication") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
int length = 0;
var Privilage = new StringBuilder();
SqlConnection con = new SqlConnection(Classes.DataConnString);
if (ListBox_UserPrivileges.IsVisible == true)
{
for (int i = 1; i < ListBox_UserPrivileges.Items.Count; i++)
{
TreeViewItem TreeName = (ListBox_UserPrivileges.Items[i] as TreeViewItem);
if (i != 2)
{
Privilage.Append((ListBox_UserPrivileges.Items[i] as TreeViewItem).Name);
Privilage.Append(":");
}
for (int j = 0; j < TreeName.Items.Count; j++)
{
if (TreeName.Items[j].GetType().Name == "CheckBox")
{
CheckBox valOfCheck = (TreeName.Items[j] as CheckBox);
if (valOfCheck.IsChecked == true)
{
Privilage.Append((TreeName.Items[j] as CheckBox).Name);
if (j < TreeName.Items.Count - 1)
{
Privilage.Append(",");
}
}
}
else if (TreeName.Items[j].GetType().Name == "ListView")
{
ListView Listview = (TreeName.Items[j] as ListView);
for (int k = 0; k < Listview.Items.Count; k++)
{
TreeViewItem SubTreeName = (Listview.Items[k] as TreeViewItem);
Privilage.Append((Listview.Items[k] as TreeViewItem).Name);
Privilage.Append(":");
for (int l = 0; l < SubTreeName.Items.Count; l++)
{
if (SubTreeName.Items[l].GetType().Name == "CheckBox")
{
CheckBox valOfCheck = (SubTreeName.Items[l] as CheckBox);
if (valOfCheck.IsChecked == true)
{
Privilage.Append((SubTreeName.Items[l] as CheckBox).Name);
if (l < SubTreeName.Items.Count - 1)
{
Privilage.Append(",");
}
}
}
}
length = Privilage.Length - 1;
if (Privilage[length] == ',')
{
Privilage.Remove(length, 1);
}
Privilage.Append(".");
}
length = Privilage.Length - 1;
if (Privilage[length] == ',')
{
Privilage.Remove(length, 1);
Privilage.Append(".");
}
}
}
length = Privilage.Length - 1;
if (Privilage[length] == ',')
{
Privilage.Remove(length, 1);
}
if (Privilage[Privilage.Length - 1] != '.')
{
Privilage.Append(".");
}
}
try
{
con.Open();
string s = string.Format("update UserPrivilages_tbl set ClassPrv='{0}', ModifiedDate=GETDATE() where UserClass_ID='{1}'", Privilage, UserClassIDtxt.Text);
SqlCommand cmd = new SqlCommand(s, con);
int IfExist = cmd.ExecuteNonQuery();
if (IfExist == 0)
{
s = string.Format("insert into UserPrivilages_tbl values ('{0}','{1}',GETDATE(),GETDATE(),'{2}')", UserClassIDtxt.Text, Privilage, MainWindow.UserID);
cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
}
try
{
con.Open();
TheCommand = "Update UserClass_tbl SET " + "Name = '" + Nametxt.Text + "', Active = '" + Active_chbx.IsChecked + "', ModifiedDate = GETDATE() Where UserClass_ID = " + UserClassIDtxt.Text;
SqlCommand cmd = new SqlCommand(TheCommand, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
Classes.LogTable(TheCommand, UserClassIDtxt.Text, "UserClass_tbl", "Update");
MessageBox.Show("Updated Successfully");
LoadUserClasses();
}
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveKitchenItems") == -1 && Authenticated.IndexOf("CheckAllKitchenItems") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
SqlConnection con = new SqlConnection(Classes.DataConnString);
DataTable DT = new DataTable();
DT = ItemsDGV.DataContext as DataTable;
for (int i = 0; i < DT.Rows.Count; i++)
{
if (DT.Rows[i].ItemArray.Contains(""))
{
MessageBox.Show(string.Format("item {0} has empty fields", DT.Rows[i].ItemArray[2]));
return;
}
}
con.Open();
for (int i = 0; i < DT.Rows.Count; i++)
{
string s = string.Format("update Setup_KitchenItems set shulfID='{0}',MinQty='{1}',MaxQty='{2}',Last_Modified_Date=GETDATE() where ItemID='{3}' and RestaurantID={4} and KitchenID={5}", DT.Rows[i]["Shelf"], DT.Rows[i]["Min Qty"], DT.Rows[i]["Max Qty"], DT.Rows[i]["Code"], ValOfResturant, ValOfKitchen);
SqlCommand cmd = new SqlCommand(s, con);
int n = cmd.ExecuteNonQuery();
if (n == 0)
{
string WhereFiltering = string.Format("RestaurantID='{0}' and KitchenID='{1}' and ItemID='{2}'", ValOfResturant, ValOfKitchen, DT.Rows[i]["Code"]);
DataTable Table = Classes.RetrieveData("ItemID", WhereFiltering, "Setup_KitchenItems");
if (Table.Rows.Count == 0)
{
string FiledSelection = "RestaurantID,KitchenID,ItemID,ShulfID,MinQty,MaxQty,Create_Date,WS,UserID";
string Values = string.Format("'{0}','{1}','{2}','{3}','{4}','{5}',GETDATE(),'{6}','{7}'", ValOfResturant, ValOfKitchen, DT.Rows[i]["Code"], DT.Rows[i]["Shelf"], DT.Rows[i]["Min Qty"], DT.Rows[i]["Max Qty"], Classes.WS, MainWindow.UserID);
Classes.InsertRow("Setup_KitchenItems", FiledSelection, Values);
}
WhereFiltering = string.Format("RestaurantID='{0}' and KitchenID='{1}' and ItemID='{2}'", ValOfResturant, ValOfKitchen, DT.Rows[i]["Code"]);
Table = Classes.RetrieveData("ItemID", WhereFiltering, "Items");
if (Table.Rows.Count == 0)
{
string FiledSelection = "KitchenID,ItemID,RestaurantID,Qty,Units,Last_Cost,Current_Cost,Net_Cost";
string Values = string.Format("'{0}','{1}','{2}','0','','','0',''", ValOfKitchen, DT.Rows[i]["Code"], ValOfResturant);
Classes.InsertRow("Items", FiledSelection, Values);
}
WhereFiltering = string.Format("Restaurant_ID='{0}' and Kitchen_ID='{1}' and ItemID='{2}' and Year='{3}'", ValOfResturant, ValOfKitchen, DT.Rows[i]["Code"], MainWindow.CurrentYear);
Table = Classes.RetrieveData("ItemID", WhereFiltering, "ItemsYear");
if (Table.Rows.Count == 0)
{
string FiledSelection = "ItemID,Restaurant_ID,Kitchen_ID,Year";
string Values = string.Format("'{0}','{1}','{2}','{3}'", DT.Rows[i]["Code"], ValOfResturant, ValOfKitchen, MainWindow.CurrentYear);
Classes.InsertRow("ItemsYear", FiledSelection, Values);
}
}
}
con.Close();
MessageBox.Show("Items saved successfuly");
SaveBtn.IsEnabled = false;
LoadDatatoGrid();
}
}
private void BulkItemsBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("DoProcessBulk") == -1 && Authenticated.IndexOf("CheckAllBulk") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
string ID = Classes.InCrementTransactionSerial("Process_BulkItems", "ProcessBulk_ID");
string BaseCode = ""; string BaseQty = ""; string SUBQty = ""; double BaseCost = 0; string BaseWeight = ""; double CalcQty = 0; double CalcCost = 0;
SqlConnection con = new SqlConnection(Classes.DataConnString);
SqlCommand cmd = new SqlCommand();
SqlConnection con2 = new SqlConnection(Classes.DataConnString);
SqlCommand cmd2 = new SqlCommand();
SqlDataReader reader = null;
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
if (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0].ToString() == "True")
{
BaseCode = ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[1].ToString();
BaseQty = ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4].ToString();
SUBQty = BaseQty;
BaseCost = Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6].ToString());
BaseWeight = (Classes.RetrieveData("Weight", "Code=" + BaseCode, "Setup_Items")).Rows[0][0].ToString();
con.Open();
try
{
string s = string.Format("select * from Setup_BulkItems where Item_Code='{0}'", BaseCode);
cmd = new SqlCommand(s, con);
reader = cmd.ExecuteReader();
while (reader.Read())
{
CalcQty = (((Convert.ToDouble(reader["WeightPrecentage"]) / 100) * Convert.ToDouble(BaseQty)) / Convert.ToDouble(BaseWeight));
CalcCost = (((Convert.ToDouble(reader["CostPrecentage"]) / 100) * Convert.ToDouble(BaseCost)) / Convert.ToDouble(BaseWeight));
try
{
con2.Open();
string w = string.Format("UPDATE Items set Qty=Qty+{0},Last_Cost=Current_Cost,Current_Cost=(((Qty*Current_Cost)+({0}*{4}))/(Qty+{0})) where ItemID='{1}' and RestaurantID={2} and KitchenID={3}", CalcQty, reader["Code"], CodeOfResturant, CodeOfKitchens, CalcCost);
cmd2 = new SqlCommand(w, con2);
int n = cmd2.ExecuteNonQuery();
if (n == 0)
{
w = string.Format("insert into Items(RestaurantID,KitchenID,ItemID,Qty,Current_Cost,Net_Cost) values({0},{1},'{2}',{3},{4},{5})", CodeOfResturant, CodeOfKitchens, reader["Code"], CalcQty, CalcCost, CalcCost * CalcQty);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
w = string.Format("Update ItemsYear set {0}={0}+{2},{1}=(({0}*{1})+({2}*{3})/({0}+{1})) where ItemID='{4}' and Restaurant_ID='{5}' and Kitchen_ID='{6}' and Year='{7}'", MainWindow.MonthQty, MainWindow.MonthCost, CalcQty, CalcCost, reader["Code"], CodeOfResturant, CodeOfKitchens, MainWindow.CurrentYear);
cmd2 = new SqlCommand(w, con2);
n = cmd2.ExecuteNonQuery();
if (n == 0)
{
w = string.Format("insert into ItemsYear(ItemID,Restaurant_ID,Kitchen_ID,Year,{0},{1}) values('{2}','{3}','{4}','{5}',{6},{7})", MainWindow.MonthQty, MainWindow.MonthCost, reader["Code"], CodeOfResturant, CodeOfKitchens, MainWindow.CurrentYear, CalcQty, CalcCost);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
SUBQty = (Convert.ToDouble(SUBQty) - CalcQty).ToString();
try
{
string w = string.Format("insert into Process_BulkItems_Items(ProcessBulk_ID,ParentItem_ID,ParentQty,ParentCost,ChiledItem_ID,ChiledQty,ChiledCost) values('{0}','{1}',{2},{3},{4},{5},{6})", ID, BaseCode, ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4].ToString(), ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6].ToString(), reader["Code"], BaseCost, BaseCost);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
con2.Close();
}
try
{
con2.Open();
string w = string.Format("update Items set Qty={0} where RestaurantID={1} and KitchenID={2} and ItemID='{3}' ", SUBQty, CodeOfResturant, CodeOfKitchens, BaseCode);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
try
{
string w = string.Format("update ItemsYear set {0}={1} Where ItemID='{2}' and Restaurant_ID='{3}' and Kitchen_ID='{4}' and Year='{5}'", MainWindow.MonthQty, SUBQty, BaseCode, CodeOfResturant, CodeOfKitchens, MainWindow.CurrentYear);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
try
{
string w = string.Format("insert into Process_BulkItems(ProcessBulk_ID,Process_Date,User_ID,Resturant_ID,KitchenID,Post_Date) values('{0}',GETDATE(),'{1}',{2},{3},GETDATE())", ID, MainWindow.UserID, CodeOfResturant, CodeOfKitchens);
cmd2 = new SqlCommand(w, con2);
cmd2.ExecuteNonQuery();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
con2.Close();
}
}
MessageBox.Show("Done");
}
BulkItems.IsEnabled = false;
}
} //Done
private void Adjact_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("AdjacmentAdjacment") == -1 && Authenticated.IndexOf("CheckAllAddjacment") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (Reasoncbx.Text != "Physical Inventory")
{
if (!DoSomeChecks())
{
return;
}
Save_Changes();
SqlConnection con = new SqlConnection(Classes.DataConnString);
con.Open();
try
{
string H = string.Format("Update Adjacment_tbl set Post='True' where Adjacment_ID = '{0}'", Serial_Adjacment_NO.Text);
SqlCommand cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
if ((bool)((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[9] == false)
{
H = string.Format("Update Items set Qty={0}, Current_Cost={4}, Net_Cost=({4} * {0}) where ItemID = '{1}' and RestaurantID ={2} and KitchenID={3}", Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), ValOfResturant, ValOfKitchen, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]));
cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
H = string.Format("update ItemsYear set {0}={1},{2}={3} where ItemID='{4}' and Restaurant_ID='{5}' and Kitchen_ID='{6}' and Year='{7}'", MainWindow.MonthQty, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), MainWindow.MonthCost, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]), (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), ValOfResturant, ValOfKitchen, MainWindow.CurrentYear);
cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
}
else
{
H = string.Format("Update RecipeQty set Qty={0}, Price={4} where Recipe_ID = '{1}' and Resturant_ID ={2} and Kitchen_ID={3}", Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), ValOfResturant, ValOfKitchen, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]));
cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
}
}
con.Close();
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{ MessageBox.Show("Edited Successfully"); }
}
else
{
SaveThePhyscialAdjacment();
}
Adjact.IsEnabled = false;
searchBtn.IsEnabled = false;
addItemBtn.IsEnabled = false;
RemoveItemBtn.IsEnabled = false;
SaveBtn.IsEnabled = false;
addRecipeBtn.IsEnabled = false;
}
} //DOne