void DeleteItem(string AdminName, string tableName, string connectionString, Itemz isDeleteitem)
{
if (ListItem.Count != 0)
{
using (var command = new MySqlCommand())
{
command.Connection = new MySqlConnection(connectionString);
command.Connection.Open();
command.CommandText = $"delete from {tableName} where id=@id and userAdmin=@userAdmin";
command.Parameters.AddWithValue("@id", isDeleteitem.id);
command.Parameters.AddWithValue("@userAdmin", AdminName);
command.ExecuteNonQuery();
command.Connection.Close();
ListItem.Clear();
}
UpdateListItem(AdminName, tableName, connectionString);
if (ListItem.Count != 0)
{
HistoryData(AdminName, tableName, TypeDIU.Delete, connectionString, isDeleteitem);
DefaultDisplayItems();
}
else
{
HistoryData(AdminName, tableName, TypeDIU.Delete, connectionString, isDeleteitem);
DefaultDisplayItems();
}
}
else
{
MessageBox.Show("Không có dữ liệu để xóa");
}
}
void FreeDataItem(Itemz iz)
{
iz.id = iz.namez = iz.price = iz.sale
= iz.information = iz.timeLine = iz.repaiTime = "unknow";
iz.pathImage = null;
// OnPropertyChanged("itemDisplay");
}
public void UseItem(Items.ItemList ItemChoosen)
{
foreach (Items Itemz in ItemList)
{
if (ItemChoosen.ToString() == Itemz.Name)
{
Itemz.UseItem();
}
}
}
public void UseItem(Items ItemChoosen, GameObject Target)
{
foreach (Items Itemz in ItemList)
{
if (ItemChoosen.Name == Itemz.Name)
{
Itemz.UseItem(Target);
}
}
}
void DisplayItems(Itemz item)
{
try
{
itemDisplay = item;
itemDisplay.pathImage = System.IO.Path.GetFullPath(itemDisplay.pathImage);
OnPropertyChanged("itemDisplay");
}
catch
{
}
}
private static void Process_JSON_File(JObject o1, List <Character> _characters, List <Itemz> _items, List <Location> _locations, List <Player> _players, List <Ship> _ships, List <Skill> _skills, List <Storm> _storms)
{
foreach (JToken child in o1.Children())
{
String var1 = child.First.SelectToken("firstline").ToString();
if (var1.Trim() != "")
{
if (var1.ToString().ToLower().Trim().Contains("player") == true)
{
String var2 = child.First.ToString();
Player.Add(child.Path, var2, _players);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("loc") == true)
{
//Console.WriteLine("loc" + " " + child1.Value);
String var2 = child.First.ToString();
Location.Add(child.Path, var2, _locations);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("char") == true)
{
//Console.WriteLine("char" + " " + child1.Value);
String var2 = child.First.ToString();
Character.Add(child.Path, var2, _characters);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("item") == true)
{
String var2 = child.First.ToString();
Itemz.Add(child.Path, var2, _items);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("ship") == true)
{
String var2 = child.First.ToString();
Ship.Add(child.Path, var2, _ships);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("unform") == true)
{
//String var2 = child.First.ToString();
//Console.WriteLine(child.Path + "|" + var2);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("storm") == true)
{
String var2 = child.First.ToString();
Storm.Add(child.Path, var2, _storms);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("skill") == true)
{
String var2 = child.First.ToString();
Skill.Add(child.Path, var2, _skills);
}
else
{
if (var1.ToString().ToLower().Trim().Contains("lore") == true)
{
//String var2 = child.First.ToString();
//Console.WriteLine(child.Path + "|" + var2);
}
else
{
String var2 = child.First.ToString();
Console.WriteLine("Unknown: " + child.Path + "|" + var2);
}
}
}
}
}
}
}
}
}
//Console.WriteLine(child1.Name + " " + child1.Value);
}
}
}
void InitializeComponent()
{
// str = VMmain.connectionString;
AdminName = "gamoet1";
btn = new btn();
newItemz = new Itemz();// khởi tạo đầu tiên
itemDisplay = new Itemz();
{
ListItem = new ObservableCollection <Itemz>();
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(ListItem);
view.Filter = UserFilter;
}
DeletePathImageItem = new RelayCommand <object>(p => { return(true); }, p => { DeleteFilePathImage(AdminName, TableName.historyOfData, TypeDIU.Delete, str); });
OpenCreateItem = new RelayCommand <object>(p => { return(true); }, p => { warning = ""; OnPropertyChanged("warning"); });
LoadDefaultListItem = new RelayCommand <object>(p => { return(true); }, p => { UpdateListItem(AdminName, TableName.Saltyfood, str); DefaultDisplayItems(); });
GetComboBox = new RelayCommand <object>(p => { return(true); }, p =>
{
TypeOfItem = p as ComboBox;
//UpdateDataListItem("saltyfood", str); // mặc đinh load đồ ăn mặn
});
SearchOfNameItem = new RelayCommand <object>(p => { return(true); }, p => { CollectionViewSource.GetDefaultView(ListItem).Refresh(); });
SelectItem = new RelayCommand <ListView>(p => { return(true); }, p =>
{
if (p.SelectedItem != null)
{
DisplayItems(p.SelectedItem as Itemz);
}
});
OpenDialogImageCreateItem = new RelayCommand <object>(p => { return(true); }, p =>
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
newItemz.pathImage = openFileDialog.FileName;
OnPropertyChanged("newItemz");
}
});
OpenDialogImageEditItem = new RelayCommand <object>(p => { return(true); }, p =>
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
itemDisplay.pathImage = openFileDialog.FileName;
OnPropertyChanged("itemDisplay");
}
});
CommandCreateItem = new RelayCommand <object>(p => { return(true); }, p =>
{
if (TypeOfItem.SelectedIndex == 0)
{
CreateItem(AdminName, TableName.Saltyfood, str);
// DefaultDisplayItems();
}
else if (TypeOfItem.SelectedIndex == 1)
{
CreateItem(AdminName, TableName.Desserts, str);
//DefaultDisplayItems();
}
else if (TypeOfItem.SelectedIndex == 2)
{
CreateItem(AdminName, TableName.Drink, str);
//DefaultDisplayItems();
}
});
//OpenCreateItem = new RelayCommand<object>(p => { return true; }, p => { });
CloseViewCreateItem = new RelayCommand <object>(p => { return(true); }, p =>
{
newItemz.id = newItemz.namez = newItemz.price = newItemz.sale
= newItemz.information = newItemz.timeLine = newItemz.repaiTime = newItemz.pathImage = null;
OnPropertyChanged("newItemz");
});
UpdateDataOfEditItem = new RelayCommand <object>(p => { return(true); }, p =>
{
var a = p as ListView;
if (itemDisplay.id == "unknow")
{
MessageBox.Show("không có dữ liệu để cập nhập"); DefaultDisplayItems();
}
else if (TypeOfItem.SelectedIndex == 0)
{
EditItem(AdminName, TableName.Saltyfood, str);
}
else if (TypeOfItem.SelectedIndex == 1)
{
EditItem(AdminName, TableName.Desserts, str);
}
else if (TypeOfItem.SelectedIndex == 2)
{
EditItem(AdminName, TableName.Drink, str);
}
});
SelectDispalayListItem = new RelayCommand <object>(p => { return(true); }, p =>
{
if (TypeOfItem.SelectedIndex == 0)
{
UpdateListItem(AdminName, TableName.Saltyfood, str);
DefaultDisplayItems();
}
else if (TypeOfItem.SelectedIndex == 1)
{
UpdateListItem(AdminName, TableName.Desserts, str);
DefaultDisplayItems();
}
else if (TypeOfItem.SelectedIndex == 2)
{
UpdateListItem(AdminName, TableName.Drink, str);
DefaultDisplayItems();
}
});
DeleteOneItem = new RelayCommand <object>(p => { return(true); }, p =>
{
if (TypeOfItem.SelectedIndex == 0)
{
DeleteItem(AdminName, TableName.Saltyfood, str, itemDisplay);
}
else if (TypeOfItem.SelectedIndex == 1)
{
DeleteItem(AdminName, TableName.Desserts, str, itemDisplay);
}
else if (TypeOfItem.SelectedIndex == 2)
{
DeleteItem(AdminName, TableName.Drink, str, itemDisplay);
}
});
}
void HistoryData(string userAdmin, string tableName, TypeDIU typeDIU, string connectionString, Itemz itemDelete)
{
if (typeDIU == TypeDIU.Delete)
{
diuz = "Delete";
}
else if (typeDIU == TypeDIU.Insert)
{
diuz = "Insert";
}
else if (typeDIU == TypeDIU.Update)
{
diuz = "Update";
}
using (var command = new MySqlCommand())
{
command.Connection = new MySqlConnection(connectionString);
command.Connection.Open();
command.CommandText = $"insert into historyOfData(userAdmin,diu,tableName,id,namez,timeLine,pathImage) " +
$"values(@userAdmin,@diu,@tableName,@id,@namez,@timeLine,@pathImage)";
command.Parameters.AddWithValue("@pathImage", itemDelete.pathImage);
command.Parameters.AddWithValue("@userAdmin", AdminName);
command.Parameters.AddWithValue("@diu", $"{diuz}");
command.Parameters.AddWithValue("@tableName", tableName);
command.Parameters.AddWithValue("@id", itemDelete.id);
command.Parameters.AddWithValue("@namez", itemDelete.namez);
command.Parameters.AddWithValue("@timeLine", DateTime.Now.ToString());
command.ExecuteNonQuery();
command.Connection.Close();
}
}
