private void insert()
{
string where = "Year = '" + Year.Text + "'";
Classes.DeleteRows(where, "Setup_Fiscal_Period");
int n = 12;
if (MonthType_cbx.SelectedIndex == 1)
{
n = 13;
}
for (int i = 0; i < n; i++)
{
DatePicker From = FindName("from" + (i + 1)) as DatePicker;
DatePicker To = FindName("to" + (i + 1)) as DatePicker;
string values = "'" + Year.Text + "','" + (i + 1).ToString() + "','" + MonthType_cbx.Text + "','";
values += Convert.ToDateTime(From.Text) + "','" + Convert.ToDateTime(To.Text).AddHours(23.9999) + "','" + "0'";
Classes.InsertRow("Setup_Fiscal_Period", values);
}
if (!CBCreatedYears.Items.Contains(Year.Text))
{
CBCreatedYears.Items.Add(Year.Text);
}
MessageBox.Show("Saved");
}
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");
}
}
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;
}
}
}
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();
}
}
public static void CloseMonth(DataRow DRCurrentMonth)
{
try
{
cols = "Year varchar(50),Month varchar(50),FromDate datetime,ToDate datetime,Restaurant_ID int,Kitchen_ID int,Item_ID varchar(50),Qty bigint,Cost float";
Classes.CreateTable("BeginningEndingMonth", cols);
where = "Month = '" + DRCurrentMonth["Month"].ToString() + "' AND Year = '" + DRCurrentMonth["Year"].ToString() + "'";
Classes.DeleteRows(where, "BeginningEndingMonth");
DataTable Items = Classes.RetrieveData("Code", "Setup_Items");
DataTable DTTop = new DataTable();
DataTable Kitchens = Classes.RetrieveData("*", "Setup_Kitchens");
string Dvalues = "('" + DRCurrentMonth["Year"] + "','" + DRCurrentMonth["Month"].ToString() + "','" + Convert.ToDateTime(DRCurrentMonth["From"]).ToString(Classes.sysDateTimeFormat) + "','" + Convert.ToDateTime(DRCurrentMonth["To"]).ToString(Classes.sysDateTimeFormat) + "'";
foreach (DataRow KitName in Kitchens.Rows)
{
values = "";
string Dkitchen = ",'" + KitName["Name"].ToString() + "'";
for (int i = 0; i < Items.Rows.Count; i++)
{
where = " _Date <= '" + Convert.ToDateTime(DRCurrentMonth["To"]).ToString(Classes.sysDateTimeFormat) + "' AND Item_ID = '" + Items.Rows[i][0].ToString() + "' AND KitchenName = '" + KitName["Name"].ToString() + "' order by _DATE DESC";
DTTop = Classes.RetrieveData("top 1 * ", where, "TransActions");
if (DTTop.Rows.Count != 0)
{
Qty = double.Parse(DTTop.Rows[0]["Current_Qty"].ToString());
Cost = double.Parse(DTTop.Rows[0]["CurrentCost"].ToString());
}
else
{
Qty = 0;
Cost = 0;
}
string DQtyCost = ",'" + Items.Rows[i][0].ToString() + "','" + Qty.ToString() + "','" + Cost.ToString() + "'";
string RestKitchen = ",'" + KitName["RestaurantID"].ToString() + "','" + KitName["Code"].ToString() + "'";
values += Dvalues + RestKitchen + DQtyCost + "),";
if (i % 999 == 0 || i == Items.Rows.Count - 1)
{
Classes.InsertRow("BeginningEndingMonth", values.Substring(1, values.Length - 3));
values = "";
}
}
}
//MessageBox.Show("Month Closed Successfully");
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
} //Done
private void Save_TIK()
{
try
{
string FiledSelection = "Transfer_Serial,Manual_Transfer_No,Transfer_Date,Comment,From_Resturant_ID,To_Resturant_ID,From_Kitchen_ID,To_Kitchen_ID,Create_Date,Type,UserID,WS,Status,Total_Cost";
string values = string.Format("'{0}', '{1}', '{2}', '{3}', (select Code from Setup_Restaurant where Name = '{4}'),(select Code from Setup_Restaurant where Name = '{5}'),(select Code from Setup_Kitchens where Name = '{6}' and RestaurantID=(select Code From Setup_Restaurant where Name='{4}')),(select Code from Setup_Kitchens where Name = '{7}' and RestaurantID=(select Code From Setup_Restaurant where Name='{5}')), GETDATE(),'{8}','{9}','{10}','{11}','{12}'", transfer_No.Text, Manual_transfer_No.Text, Convert.ToDateTime(Transfer_dt.Text).ToString("MM-dd-yyyy"), commenttxt.Text, From_Resturant.Text, ToResturant.Text, From_Kitchen.Text, To_Kitchen.Text, "Transfer_Resturant", MainWindow.UserID, Classes.WS, Statustxt.Text, Total_Price.Text);
Classes.InsertRow("Transfer_Kitchens", FiledSelection, values);
Classes.LogTable(Classes.MyComm.CommandText.ToString(), transfer_No.Text, "Transfer_Kitchens", "New");
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
} //Done
} //Done
//
private void Save_PO_Details(SqlConnection con)
{
try
{
con.Open();
string FiledSelection = "PO_Serial,PO_No,Ship_ToRestaurant,Ship_ToKitchen,Vendor_ID,Create_Date,Delivery_Date,WS,Comment,Total_Price,Restaurant_ID,Kitchen_ID,UserID,Status";
string values = string.Format("'{0}','{1}',{2},{3},(select Code from Vendors where Name = N'{4}'),GETDATE(),'{5}','{6}',N'{7}','{8}',{9},'{10}','{11}','{12}'", Serial_PO_NO.Text, PO_NO.Text, RestaurantCode, KitchenCode, Vendor.Text, Convert.ToDateTime(Delivery_dt.Text).ToString("MM-dd-yyyy"), Classes.WS, commenttxt.Text, Total_Price_With_Tax.Text, RestaurantCode, KitchenCode, MainWindow.UserID, Statustxt.Text);
Classes.InsertRow("PO", FiledSelection, values);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
finally { con.Close(); }
} //Done
} // Done Finall Function
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
string Where = string.Format("Parent_Item='{0}'", CodeOfparent);
Classes.DeleteRows(Where, "Setup_ParentItems");
for (int i = 0; i < ParentItemsDGV.Items.Count; i++)
{
string Values = string.Format("'{0}','{1}'", ((DataRowView)ParentItemsDGV.Items[i]).Row.ItemArray[0], CodeOfparent);
Classes.InsertRow("Setup_ParentItems", Values);
}
MessageBox.Show("Saved Sucsseful");
}
} //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
} //DOne
private void Save_Changes()
{
if (!DoSomeChecks())
{
return;
}
if (CheckIfTransactionExist() == true)
{
string Where = string.Format("Adjacment_ID='{0}'", Serial_Adjacment_NO.Text);
Classes.DeleteRows(Where, "Adjacment_Items");
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string FiledSelection = "Adjacment_ID,Item_ID,Qty,AdjacmentableQty,Variance,Cost,Recipe";
string Values = string.Format("'{0}','{1}','{2}','{3}','{4}','{5}','{6}'", Serial_Adjacment_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[5]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]), (bool)((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[9]);
Classes.InsertRow("Adjacment_Items", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Serial_Adjacment_NO.Text, "Adjacment_tbl", "Update");
}
else
{
try
{
string FiledSelection = "Adjacment_ID,Adjacment_Num,Adjacment_Reason,Adjacment_Date,Comment,Resturant_ID,KitchenID,Create_Date,User_ID,WS,Total_Cost";
string Values = string.Format("'{0}',{1},(select Code From Setup_AdjacmentReasons_tbl where Name='{2}'),'{3}','{4}',{5},{6},GETDATE(),'{7}','{8}','{9}'", Serial_Adjacment_NO.Text, Adjacment_NO.Text, Reasoncbx.Text, Convert.ToDateTime(Adjacment_Date.Text).ToString("MM-dd-yyyy"), commenttxt.Text, ValOfResturant, ValOfKitchen, MainWindow.UserID, Classes.WS, Total_Price.Text);
Classes.InsertRow("Adjacment_tbl", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string FiledSelection = "Adjacment_ID,Item_ID,Qty,AdjacmentableQty,Variance,Cost,Recipe";
string Values = string.Format("'{0}','{1}','{2}','{3}','{4}','{5}','{6}'", Serial_Adjacment_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[5]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]), (bool)((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[9]);
Classes.InsertRow("Adjacment_Items", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Serial_Adjacment_NO.Text, "Adjacment_tbl", "New");
}
} //Done
} //Done
private void Save_PO_Items(SqlConnection con)
{
try
{
con.Open();
DataTable Dat = ItemsDGV.DataContext as DataTable;
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string FiledSelection = "Item_ID,PO_Serial,Qty,Unit,Serial,Price_Without_Tax,Tax,Price_With_Tax,Net_Price,Tax_Included";
string Values = "'" + Dat.Rows[i]["Code"] + "','" + Serial_PO_NO.Text + "'," + Dat.Rows[i]["Qty"] + ",N'" + Dat.Rows[i]["Unit"] + "'," + i + "," + Dat.Rows[i]["Unit Price Without Tax"] + "," + Dat.Rows[i]["Tax"].ToString().Substring(0, Dat.Rows[i]["Tax"].ToString().Length - 1) + "," + Dat.Rows[i]["Unit Price With Tax"] + "," + Dat.Rows[i]["Total Price With Tax"] + ",'" + Dat.Rows[i]["Tax Included"].ToString() + "'";
Classes.InsertRow("PO_Items", FiledSelection, Values);
}
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
finally { con.Close(); }
} //Done
} //Done
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveVendors") == -1 && Authenticated.IndexOf("CheckAllVendors") == -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 < Vendors_DGV.Items.Count; i++)
{
if (((DataRowView)Vendors_DGV.Items[i]).Row.ItemArray[0].ToString().Equals(Code_txt.Text))
{
MessageBox.Show("This Code Is Not Avaliable");
return;
}
if (((DataRowView)Vendors_DGV.Items[i]).Row.ItemArray[1].ToString().Equals(Name_txt.Text))
{
MessageBox.Show("Please Change The Name"); return;
}
}
try
{
string FiledSelection = "Code,Name,IsActive,CreateDate,UserID,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("Vendors", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
Classes.LogTable(Classes.MyComm.CommandText.ToString(), Code_txt.Text, "Vendors", "New");
MainUiFormat();
Vendors_DGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Saved Successfully");
}
}
private void Save_TIK_Items()
{
try
{
DataTable dt = ItemsDGV.DataContext as DataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
float NetCost = float.Parse(dt.Rows[i]["Qty"].ToString()) * float.Parse(dt.Rows[i][7].ToString());
string Values = "'" + dt.Rows[i]["Code"] + "','" + transfer_No.Text + "','" + dt.Rows[i]["Qty"] + "','" + dt.Rows[i]["Unit"] + "','" + i + "','" + dt.Rows[i][7] + "','" + NetCost + "','" + dt.Rows[i][ToResturant.Text + " Qty"] + "','" + dt.Rows[i][ToResturant.Text + " Unit Cost"] + "','" + dt.Rows[i][From_Resturant.Text + " Qty"] + "','" + dt.Rows[i][From_Resturant.Text + " Unit Cost"] + "'";
Classes.InsertRow("Transfer_Kitchens_Items", Values);
Classes.LogTable(Classes.MyComm.CommandText.ToString(), transfer_No.Text, "Transfer_Kitchens_Items", "New");
}
}
catch
{ MessageBox.Show("Items Input Error"); }
} //Done
} //Done
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
//Michael's UPdate
string Where = ""; string Values = "";
if (CheckToSave() == true)
{
Where = string.Format("Item_Code='{0}'", ItemCode);
Classes.DeleteRows(Where, "Setup_BulkItems");
for (int i = 0; i < BulkItemsDGV.Items.Count; i++)
{
DataRowView Items = BulkItemsDGV.Items[i] as DataRowView;
Values = string.Format("'{0}',{1},{2},'{3}'", Items.Row.ItemArray[0], Items.Row.ItemArray[3], Items.Row.ItemArray[4], ItemCode);
Classes.InsertRow("Setup_BulkItems", Values);
}
FillDGV(ItemCode);
MessageBox.Show("Saved Sucssfully");
}
} //Done
private static void Insert(int k)
{
values = "";
cols = "_DATE,Restaurant_ID,Kitchen_ID,KitchenName,Trantype,ID,Item_ID,Qty,Current_Qty,Cost,CurrentCost";
string s = "";
for (int i = 0; i < BETable.Columns.Count; i++)
{
if (i == 0)
{
values += s + "'" + Convert.ToDateTime(BETable.Rows[k][i].ToString()).ToString(Classes.sysDateTimeFormat) + "'";
s = ",";
}
else
{
values += s + "'" + BETable.Rows[k][i].ToString() + "'";
s = ",";
}
}
Classes.InsertRow("TransActions", cols, values);
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveUsers") == -1 && Authenticated.IndexOf("CheckAllUsers") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (DoSomeChecks() == false)
{
return;
}
for (int i = 0; i < UsersDGV.Items.Count; i++)
{
if (UsersDGV.Items[i].ToString().Equals(userIDtxt.Text))
{
MessageBox.Show("This Code Is Not Avaliable"); return;
}
}
try
{
string FiledSelection = "ID,Name,UserName,Password,UserClass_ID,Adress,Mobile,Email,Active,CreateDate,User_ID,WS";
string Values = string.Format("'{0}',N'{1}','{2}','{3}',(select UserClass_ID FROM UserClass_tbl Where Name='{4}'),N'{5}','{6}','{7}','{8}',GETDATE(),'{9}','{10}'", userIDtxt.Text, Nametxt.Text, UserNametxt.Text, passwordtxt.Password, jobTitle.Text, Addresstxt.Text, phone.Text, Mailtxt.Text, Active_chbx.IsChecked.ToString(), MainWindow.UserID, Classes.WS);
Classes.InsertRow("Users", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{
MainUiFormat();
Classes.LogTable(Classes.MyComm.CommandText.ToString(), userIDtxt.Text, "Users", "New");
UsersDGV.DataContext = null;
FillDGV();
}
MessageBox.Show("Saved Successfully");
}
}
private void SaveThePhyscialAdjacment()
{
if (!DoSomeChecks())
{
return;
}
SqlConnection con = new SqlConnection(Classes.DataConnString);
con.Open();
if (Blind == false)
{
try
{
string FiledSelection = "Adjacment_ID,Adjacment_Num,Adjacment_Reason,Adjacment_Date,Comment,Resturant_ID,KitchenID,Create_Date,Post_Date,User_ID,WS,Total_Cost";
string Values = string.Format("'{0}',{1},(select Code From Setup_AdjacmentReasons_tbl where Name='{2}'),'{3}','{4}',{5},{6},GETDATE(),GETDATE(),'{7}','{8}','{9}'", Serial_Adjacment_NO.Text, Adjacment_NO.Text, Reasoncbx.Text, Convert.ToDateTime(Adjacment_Date.Text).ToString("MM-dd-yyyy"), commenttxt.Text, ValOfResturant, ValOfKitchen, MainWindow.UserID, Classes.WS, Total_Price.Text);
Classes.InsertRow("Adjacment_tbl", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string FiledSelection = "Adjacment_ID,Item_ID,Qty,Cost";
string Values = string.Format("'{0}','{1}','{2}','{3}'", Serial_Adjacment_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]));
Classes.InsertRow("Adjacment_Items", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string 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[3]), (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), ValOfResturant, ValOfKitchen, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]));
SqlCommand 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[3]), MainWindow.MonthCost, Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), ValOfResturant, ValOfKitchen, MainWindow.CurrentYear);
cmd = new SqlCommand(H, con);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{ MessageBox.Show("Edited Successfully"); }
}
else
{
try
{
string FiledSelection = "Adjacment_ID,Adjacment_Num,Adjacment_Reason,Adjacment_Date,Comment,Resturant_ID,KitchenID,Create_Date,Post_Date,User_ID,WS,Total_Cost";
string Values = string.Format("'{0}',{1},(select Code From Setup_AdjacmentReasons_tbl where Name='{2}'),'{3}','{4}',{5},{6},GETDATE(),GETDATE(),'{7}','{8}','{9}'", Serial_Adjacment_NO.Text, Adjacment_NO.Text, Reasoncbx.Text, Convert.ToDateTime(Adjacment_Date.Text).ToString("MM-dd-yyyy"), commenttxt.Text, ValOfResturant, ValOfKitchen, MainWindow.UserID, Classes.WS, Total_Price.Text);
Classes.InsertRow("Adjacment_tbl", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string FiledSelection = "Adjacment_ID,Item_ID,Qty,AdjacmentableQty,Variance,Cost";
string Values = string.Format("'{0}','{1}','{2}','{3}','{4}','{5}'", Serial_Adjacment_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4], ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[5], Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]));
Classes.InsertRow("Adjacment_Items", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
string 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]));
SqlCommand 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();
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
finally
{ MessageBox.Show("Edited Successfully"); }
}
try
{
string s = string.Format("update PhysicalInventory_tbl set Inventory_Type='Closed' where Inventory_ID={0}", physicalinventoryID);
SqlCommand cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
if (Authenticated.IndexOf("SaveKitchens") == -1 && Authenticated.IndexOf("CheckAllKitchens") == -1)
{
LogIn logIn = new LogIn();
logIn.ShowDialog();
}
else
{
SqlConnection con = new SqlConnection(Classes.DataConnString);
SqlConnection con2 = new SqlConnection(Classes.DataConnString);
DataTable DT = new DataTable();
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)
{
con.Open();
string s = string.Format("select IsMain from Setup_Kitchens where IsMain='True' and RestaurantID='{0}'", ResturantCode);
SqlCommand cmd = new SqlCommand(s, con);
if (cmd.ExecuteScalar() != null)
{
MessageBox.Show("Can't be more Than Main Kitchen !");
return;
}
}
try
{
string FiledSelection = "Code,Name,Name2,IsMain,IsOutlet,IsActive,RestaurantID,Create_Date,WS,UserID";
string values = string.Format("'{0}', N'{1}', N'{2}', '{3}','{4}','{5}','{6}',{7},'{8}','{9}'", Code_txt.Text, Name_txt.Text, Name2_txt.Text, IsMain.IsChecked, IsOutlet.IsChecked, Active_chbx.IsChecked, ResturantCode, "GETDATE()", Classes.WS, MainWindow.UserID);
Classes.InsertRow("Setup_Kitchens", FiledSelection, values);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
MainUiFormat();
Stores_DGV.DataContext = null;
FillDGV(ResturantCode);
}
if (IsMain.IsChecked == true || IsOutlet.IsChecked == true)
{
string FiledSelectionKitchenItems = "KitchenID,ItemID,RestaurantID,MinQty,MaxQty,shulfID";
string FiledSelectionItems = "KitchenID,ItemID,RestaurantID,Qty,Units,Last_Cost,Current_Cost,Net_Cost";
string FiledSelectionItemsYear = "ItemID,Restaurant_ID,Kitchen_ID,Year";
string valuesItems = ""; string ValuesKitchenItems = ""; string ValuesItemsYear = ""; string Comma = "";
try
{
DT = Classes.RetrieveData("Code", "Setup_Items");
int NumOfItemsPerRec = DT.Rows.Count % 1000;
int NumOfItems = 0;
if (DT.Rows.Count > 0)
{
if (DT.Rows.Count > 1000)
{
for (int i = 0; i <= NumOfItemsPerRec; i++)
{
for (int q = NumOfItems; q < (i + 1) * 1000; q++)
{
ValuesKitchenItems = Comma + string.Format("('{0}','{1}','{2}','0','0','0')", Code_txt.Text, DT.Rows[q].ItemArray[0], ResturantCode);
valuesItems = Comma + string.Format("('{0}','{1}','{2}','0','','','0','')", Code_txt.Text, DT.Rows[q].ItemArray[0], ResturantCode);
ValuesItemsYear = Comma + string.Format("('{0}','{1}','{2}','{3}')", DT.Rows[q].ItemArray[0], ResturantCode, Code_txt.Text, MainWindow.CurrentYear);
Comma = ",";
}
NumOfItems = (i + 1) * 1000;
}
Classes.InsertRows("Setup_KitchenItems", FiledSelectionKitchenItems, ValuesKitchenItems);
Classes.InsertRows("ItemsYear", FiledSelectionItemsYear, ValuesItemsYear);
Classes.InsertRows("Items", FiledSelectionItems, valuesItems);
}
else
{
for (int i = 0; i < DT.Rows.Count; i++)
{
ValuesKitchenItems += Comma + string.Format("('{0}','{1}','{2}','0','0','0')", Code_txt.Text, DT.Rows[i].ItemArray[0], ResturantCode);
valuesItems += Comma + string.Format("('{0}','{1}','{2}','0','','','','')", Code_txt.Text, DT.Rows[i].ItemArray[0], ResturantCode);
ValuesItemsYear += Comma + string.Format("('{0}','{1}','{2}','{3}')", DT.Rows[i].ItemArray[0], ResturantCode, Code_txt.Text, MainWindow.CurrentYear);
Comma = ",";
}
Classes.InsertRows("Setup_KitchenItems", FiledSelectionKitchenItems, ValuesKitchenItems);
Classes.InsertRows("ItemsYear", FiledSelectionItemsYear, ValuesItemsYear);
Classes.InsertRows("Items", FiledSelectionItems, valuesItems);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
con2.Close();
}
}
MessageBox.Show("Saved Successfully");
}
}
} //Done Finall Function
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
RecipeItems = RecipesDGV.DataContext as DataTable;
if (Authenticated.IndexOf("SaveRecipes") == -1 && Authenticated.IndexOf("CheckAllRecipes") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (codetxt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty"); return;
}
if (Nametxt.Text == "")
{
MessageBox.Show("Name Field Can't Be Empty"); return;
}
if (Categtxt.Text == "")
{
MessageBox.Show("Should Enter the Category First"); return;
}
if (SUBCategtxt.Text == "")
{
MessageBox.Show("Should Enter the Sub Category First"); return;
}
if (Unittxt.Text == "")
{
MessageBox.Show("Should Enter the Unites First"); return;
}
if (Unitstxt.Text == "")
{
MessageBox.Show("Should Select the Unites First"); return;
}
DataTable CheckCode = new DataTable();
string Where = string.Format("Code='{0}'", codetxt.Text);
CheckCode = Classes.RetrieveData("Code", Where, "Setup_Recipes");
if (CheckCode.Rows.Count != 0)
{
MessageBox.Show("This Code Is Not Avaliable"); return;
}
DataTable NameofRecipe = new DataTable();
Where = string.Format("Name=N'{0}'", Nametxt.Text);
NameofRecipe = Classes.RetrieveData("Name", Where, "Setup_Recipes");
if (NameofRecipe.Rows.Count != 0)
{
MessageBox.Show("You Entered This Recipe Name Before");
return;
}
try
{
string FiledSelection = "Code,CrossCode,Name,Name2,Category_ID,SubCategory_ID,IsActive,Unit,UnitQty,CreateDate,UserID,WS";
string Values = string.Format("'{0}','{1}',N'{2}',N'{3}','{4}','{5}','{6}',N'{7}','{8}',GETDATE(),'{9}','{10}'", codetxt.Text, CrossCodetxt.Text, Nametxt.Text, Name2txt.Text, Categtxt.Text, SUBCategtxt.Text, ActiveChbx.IsChecked, Unitstxt.Text, Unittxt.Text, MainWindow.UserID, Classes.WS);
Classes.InsertRow("Setup_Recipes", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < RecipesDGV.Items.Count; i++)
{
string FiledSelection = "Item_Code,Recipe_ID,Qty,Recipe_Unit,Recipe_Code";
string Values = string.Format("'{0}','{1}','{2}',N'{3}','{4}'", RecipeItems.Rows[i]["Item_Code"], RecipeItems.Rows[i]["Recipe_Code"], RecipeItems.Rows[i]["Qty"], RecipeItems.Rows[i]["Recipe_Unit"], codetxt.Text);
Classes.InsertRow("Setup_RecipeItems", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
MainUiFormat();
EmptyTexts();
SaveBtn.IsEnabled = false;
ActiveChbx.IsChecked = false;
loadAllRecipes();
MessageBox.Show("Saved Successfully");
}
} //Done Finall Function
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 SaveBtn_Click(object sender, RoutedEventArgs e)
{
RecipeItems = RecipesDGV.DataContext as DataTable;
if (Authenticated.IndexOf("SaveRecipes") == -1 && Authenticated.IndexOf("CheckAllRecipes") == -1)
{
LogIn logIn = new LogIn(); logIn.ShowDialog();
}
else
{
if (codetxt.Text == "")
{
MessageBox.Show("Code Field Can't Be Empty"); return;
}
if (Nametxt.Text == "")
{
MessageBox.Show("Name Field Can't Be Empty"); return;
}
if (Categtxt.Text == "")
{
MessageBox.Show("Should Enter the Category First"); return;
}
if (SUBCategtxt.Text == "")
{
MessageBox.Show("Should Enter the Sub Category First"); return;
}
if (Unittxt.Text == "")
{
MessageBox.Show("Should Enter the Unites First"); return;
}
if (Unitstxt.Text == "")
{
MessageBox.Show("Should Select the Unites First"); return;
}
for (int i = 0; i < AllRecipesDGV.Items.Count; i++)
{
if (((DataRowView)AllRecipesDGV.Items[i]).Row.ItemArray[0].ToString().Equals(codetxt.Text))
{
MessageBox.Show("This Code Is Not Avaliable"); return;
}
}
try
{
string FiledSelection = "Code,CrossCode,Name,Name2,Category_ID,SubCategory_ID,IsActive,Unit,UnitQty,CreateDate,UserID,WS";
string Values = string.Format("'{0}','{1}',N'{2}',N'{3}','{4}','{5}','{6}','{7}','{8}',GETDATE(),'{9}','{10}'", codetxt.Text, CrossCodetxt.Text, Nametxt.Text, Name2txt.Text, Categtxt.Text, SUBCategtxt.Text, ActiveChbx.IsChecked, Unitstxt.Text, Unittxt.Text, MainWindow.UserID, Classes.WS);
Classes.InsertRow("Setup_Recipes", FiledSelection, Values);
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
try
{
for (int i = 0; i < RecipesDGV.Items.Count; i++)
{
string FiledSelection = "Item_Code,Recipe_ID,Qty,Recipe_Unit,Cost,Total_Cost,Cost_Precentage,Recipe_Code";
string Values = string.Format("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'", RecipeItems.Rows[i]["Item_Code"], RecipeItems.Rows[i]["Recipe_ID"], RecipeItems.Rows[i]["Qty"], RecipeItems.Rows[i]["Recipe_Unit"], RecipeItems.Rows[i]["Cost"], RecipeItems.Rows[i]["Total_Cost"], RecipeItems.Rows[i]["Cost_Precentage"], RecipeItems.Rows[i]["Recipe_Code"]);
Classes.InsertRow("Setup_RecipeItems", FiledSelection, Values);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.ToString()); }
MainUiFormat();
EmptyTexts();
SaveBtn.IsEnabled = false;
ActiveChbx.IsChecked = false;
MessageBox.Show("Saved Successfully");
}
}
} //Done
private void SaveInfoANdData()
{
try
{
string FiledSelected = ""; string Value = "";
DataTable IfOpend = new DataTable();
string Where = string.Format("Inventory_Type='Open' and Resturant_ID={0} and KitchenID={1}", ValOfResturant, ValOfKitchen);
IfOpend = Classes.RetrieveData("Blind", Where, "PhysicalInventory_tbl");
if (IfOpend.Rows.Count > 0)
{
if (IfOpend.Rows[0][0].ToString() == "True")
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
FiledSelected = "Qty,InventoryQty,Variance";
Value = string.Format("{0},{1},{2}", Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[5]));
Where = string.Format("Inventory_ID='{0}' and Item_ID='{1}'", Serial_Inventory_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]));
Classes.UpdateRow(FiledSelected, Value, Where, "PhysicalInventory_Items");
}
}
else
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
FiledSelected = "Qty";
Value = string.Format("{0}", Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]));
Where = string.Format("Inventory_ID='{0}' and Item_ID='{1}'", Serial_Inventory_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]));
Classes.UpdateRow(FiledSelected, Value, Where, "PhysicalInventory_Items");
}
}
FiledSelected = "Inventory_Num,Inventory_Date,Comment";
Value = string.Format("'{0}','{1}','{2}'", Inventory_NO.Text, Convert.ToDateTime(InventoryDate.Text).ToString("MM-dd-yyyy"), commenttxt.Text);
Where = string.Format("Inventory_ID='{0}'", Serial_Inventory_NO.Text);
Classes.UpdateRow(FiledSelected, Value, Where, "PhysicalInventory_tbl");
}
else
{
if (NotBlindChx.IsChecked == true)
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
FiledSelected = "Inventory_ID,Item_ID,Qty,InventoryQty,Variance,Cost";
Value = string.Format("'{0}','{1}',{2},'{3}','{4}',{5}", Serial_Inventory_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4], ((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[5], Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[6]));
Classes.InsertRow("PhysicalInventory_Items", FiledSelected, Value);
}
}
else
{
for (int i = 0; i < ItemsDGV.Items.Count; i++)
{
FiledSelected = "Inventory_ID,Item_ID,Qty,Cost";
Value = string.Format("'{0}','{1}',{2},{3}", Serial_Inventory_NO.Text, (((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[0]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[3]), Convert.ToDouble(((DataRowView)ItemsDGV.Items[i]).Row.ItemArray[4]));
Classes.InsertRow("PhysicalInventory_Items", FiledSelected, Value);
}
}
FiledSelected = "Inventory_ID,Inventory_Num,Inventory_Type,Inventory_Date,Comment,Resturant_ID,KitchenID,Post_Date,UserID,Blind,WS,Create_Date";
Value = string.Format("'{0}',{1},'{2}','{3}','{4}',{5},{6},GETDATE(),'{7}','{8}','{9}',GETDATE()", Serial_Inventory_NO.Text, Inventory_NO.Text, Typecbx.Text, Convert.ToDateTime(InventoryDate.Text).ToString("MM-dd-yyyy"), commenttxt.Text, ValOfResturant, ValOfKitchen, MainWindow.UserID, NotBlindChx.IsChecked, Classes.WS);
Classes.InsertRow("PhysicalInventory_tbl", FiledSelected, Value);
}
MessageBox.Show("The inventory Saved Sucessfully !");
}
catch { }
}