public async void Load_data()//ladowanie nazw firm
{
List <Data_player_building> C_data = await SQL_Manager.Select <Data_player_building>("Player_building");
List <Data_building> B_data = await SQL_Manager.Select <Data_building>("Building");
D_Company_A.ClearOptions();
D_Company_B.ClearOptions();
List <TMP_Dropdown.OptionData> companys = new List <TMP_Dropdown.OptionData>();
foreach (var p in C_data)
{
foreach (var b in B_data)
{
if (p.Id_building == b.Id)
{
companys.Add(new TMP_Dropdown.OptionData(p.Id.ToString() + "# " + b.Name));
}
}
}
D_Company_A.AddOptions(companys);
D_Company_B.AddOptions(companys);
}
public void Awake()
{
if (instance == null)
{
instance = this;
}
}
public async void Game_reset()
{
await SQL_Manager.Delete("Reset");
GameObject building = GameObject.Find("budynki");
Destroy(building);
}
public async void Refresh(int itemId) //wczytuje item z podanego id
{
data_item = await SQL_Manager.Select <Data_item>("Item", itemId);
Name.text = data_item.Name;
Price.text = data_item.Cost.ToString() + "$";
amount.text = data_item_stack.Amount.ToString();
}
public async void Send_product()
{
Data_item_stack item_stac = new Data_item_stack()
{
Amount = 1, Id_item = itemId, Id_list = data_building.Id_list
};
await SQL_Manager.Insert <Data_item_stack>("Item_stack", item_stac);
done = true;
}
public async void Load(GameObject parent)
{
List <Data_player_building> buildings = await SQL_Manager.Select <Data_player_building>("Player_building");
foreach (var data_a in buildings)
{
Data_building data_b = await SQL_Manager.Select <Data_building>("Building", data_a.Id_building);
GameObject temp = Load_object_Sql(data_a, data_b);
temp.transform.parent = parent.transform;
}
}
async Task Load_List(E_Build_type type)
{
List <Data_building> temp = await SQL_Manager.Select <Data_building>("Building");
foreach (var d in temp)
{
if (d.Id_type == (int)type)
{
Data.Add(d);
}
}
}
public async void Load_new_data(Building building)
{
gameObject.SetActive(true);
this.building = building;
Data_player_building data_player_building = building.B_data_player_building;
Data_building data_building = await SQL_Manager.Select <Data_building>("Building", data_player_building.Id_building);
G_Name.text = data_building.Name;
G_time.text = "Time: " + building.time.ToString() + " Sec";
G_item1.Refresh(building.Id_i1);
}
public async void Load_Company_products(int List_Id)//pobiera produkty z magazynu i wyswietla je
{
gameObject.SetActive(true);
Clear_Items();
List <Data_item_stack> products = await SQL_Manager.Select <Data_item_stack>("Item_list", List_Id, true);
foreach (var p in products)
{
GameObject item = new Gui_item().Get_new_objectSQL(p, null);
item.transform.parent = Content.transform;
}
}
//Asks for the data from the SQL
public void SetData()
{
if (dataSetFlag)
{
return;
}
SetName();
SQL_Manager.GetInstance().GetDeviceDataShared(this, deviceName);
dataSetFlag = true;
}
async Task Refresh_Company_data()
{
//wczytywanie zawartosci wybranego budynku
string p1 = D_Company_A.options[D_Company_A.value].text;
string p2 = D_Company_B.options[D_Company_B.value].text;
p1 = p1.Substring(0, p1.LastIndexOf("#"));
p2 = p2.Substring(0, p2.LastIndexOf("#"));
building1 = await SQL_Manager.Select <Data_player_building>("Player_building", int.Parse(p1));
building2 = await SQL_Manager.Select <Data_player_building>("Player_building", int.Parse(p2));
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
if (SQL_Manager.connectToSQL())
{
Application.Run(new Login());
}
else
{
MessageBox.Show("Cannot access the Database, Please try again later");
}
}
public async void New_Select(Data_player_building d1, List <Data_item_stack> output)
{
Refresh_Lists();
this.Output = output;
List <Data_item_stack> Data = await SQL_Manager.Select <Data_item_stack>("Item_list", d1.Id_list, true);
foreach (var d in Data)
{
GameObject item = new Gui_item().Get_new_objectSQL(d, null);
item.transform.parent = content_A.transform;
item.GetComponent <Gui_item>().Button.onClick.AddListener(() => Select_Company(item));
List_from.Add(item);
}
}
private void loginBtn_Click(object sender, EventArgs e)
{
if (username != "" && password != "")
{
AuthObject[] auths = SQL_Manager.getAuthObjectByUsername(username);
if (auths.Length > 0)
{
// Check if this pair of username and password are correct
for (int i = 0; i < auths.Length; i++)
{
if (auths[i].username == username)
{
string encryptedPassword;
if (auths[i].isMD5)
{
encryptedPassword = EncryptionManger.MD5(password);
}
else
{
encryptedPassword = EncryptionManger.easyEncryption(password, encryptionKey);
}
if (encryptedPassword == auths[i].encryptedPass)
{
MessageBox.Show("Congragulations! you are connected to Demo_SQL");
}
else
{
MessageBox.Show("The username or the password are incorrect");
}
}
}
}
else
{
MessageBox.Show("The username or the password are incorrect");
}
}
else
{
MessageBox.Show("Please enter the required fields");
}
}
public async Task Send()
{
if (building1.Id == building2.Id)
{
return;
}
gameObject.SetActive(false); //wylacza interface z widoku
GameObject car = GameObject.Find("Car"); //wczytuje samochod
print(building1.Location + " " + building2.Location);
GameObject buildingA = Building.Find(building1.Id);
GameObject buildingB = Building.Find(building2.Id);
//tworze nowe zamowienie
Data_item_list new_list = new Data_item_list()
{
Name = "Order#" + UnityEngine.Random.Range(0, 100000)
};
string list_id = await SQL_Manager.Insert <Data_item_list>("Item_list", new_list);
Data_deliver order = new Data_deliver();
order.Id_b1 = building1.Id;
order.Id_b2 = building2.Id;
order.Date = DateTime.Now.ToString("MM/dd/yyyy H:mm");
order.Id_list = int.Parse(list_id);
await SQL_Manager.Insert <Data_deliver>("Deliver", order);
//przesylam produkty
foreach (var item in products)
{
item.Id_list = order.Id_list; //tworze historie zamowieniea
await SQL_Manager.Insert <Data_item_stack>("Item_stack", item);
item.Id_list = building2.Id_list; //zmiana na liste w drugim magazynie
await SQL_Manager.Update <Data_item_stack>("Item_stack", item.Id, item);
}
new A_Deliver(car, buildingA, buildingB, products.Count); //akcja
}
async void Send_data()
{
Data_item_list data_list = new Data_item_list()
{
Name = "List#" + Random.Range(1000, 10000)
};
string new_id = await SQL_Manager.Insert <Data_item_list>("Item_list", data_list);
Data_building b = (Data_building)B_obj;
Vector3 pos = A_obj.transform.position;
data_pb = new Data_player_building();
data_pb.Id_building = b.Id;
data_pb.Id_player = 1;
data_pb.Id_list = int.Parse(new_id);
data_pb.Location = Mathf.RoundToInt(pos.x).ToString() + ",0," + Mathf.RoundToInt(pos.z).ToString();
string building_id = await SQL_Manager.Insert <Data_player_building>("Player_building", data_pb);
A_obj.GetComponent <Building>().B_data_player_building = data_pb;
A_obj.GetComponent <Building>().B_data_building = b;
A_obj.GetComponent <Building>().B_data_player_building.Id = int.Parse(building_id);
}
private void button1_Click(object sender, EventArgs e)
{
if (
username != "" && name != "" && lastN != "" && password != "" && passAgain != "" && encrShift != "0" ||
username != "" && name != "" && lastN != "" && password != "" && passAgain != "" && useMD5
)
{
// Checking if the passwords equal
if (password == passAgain && encrShift.Length == passAgain.Length)
{
bool isInserted = SQL_Manager.insertNewUser(
new UserRecord(username, name, lastN, EncryptionManger.easyEncryption(password, encrShift))
);
if (isInserted)
{
MessageBox.Show("User Inserted successfuly");
}
else
{
MessageBox.Show("This username already exists please choose another");
}
}
else
{
if (password == passAgain && useMD5)
{
bool isInserted = SQL_Manager.insertNewUser(
new UserRecord(username, name, lastN, EncryptionManger.MD5(password), useMD5)
);
if (isInserted)
{
MessageBox.Show("User Inserted successfuly");
}
else
{
MessageBox.Show("This username already exists please choose another");
}
}
else
{
string text = "";
if (encrShift.Length != password.Length || !useMD5)
{
text = "Encryption not at the same length as password";
}
else
{
text = "The passwords not equal please type again.";
}
MessageBox.Show(text);
}
}
}
else
{
MessageBox.Show("Something missing... Please check");
}
}
public async void send()//
{
await SQL_Manager.Insert(JsonUtility.ToJson(B_obj), table);
}
