private static void EnableBroker(DatabaseHolder p_dbh) { if (p_dbh.DB is SqlDatabase && p_dbh.Options.EnableBroker && !p_dbh.Options.IsDependencyEnabled) p_dbh.Options.IsDependencyEnabled = SqlDependency.Start(p_dbh.Options.ConnectionString); }
private List <string> GetAllNames() { List <string> list = new List <string>(); for (int i = 0; i < DatabaseHolder.HowManyUsers(); i++) { list.Add(users[i].NameToString()); } return(list); }
private void CreatingUser(int i) { int offset = 2; User user = new User { Id = DatabaseHolder.ParsingId(offset + (43 * i), offset + (43 * i) + 1), Name = DatabaseHolder.ParsingChars(offset + (43 * i) + 2), Creation_date = DatabaseHolder.ParsingChars(offset + (43 * i) + 22), }; user.Secret_code[0] = DatabaseHolder.receiver[offset + (43 * i) + 42]; users.Add(user); }
private void OKBtn_Click(object sender, EventArgs e) { BluetoothHolder.bluetoothManage.Read(); if (DatabaseHolder.CODE() == "OK") { Toast.MakeText(this.Activity, "Received: " + DatabaseHolder.receiver, ToastLength.Long).Show(); UploadingDatabase(); UsersViewAdapter adapter = new UsersViewAdapter(this.Activity, users); usersList.Adapter = adapter; } alertDialogAndroid.Dismiss(); }
private bool UploadingDatabase() { users.Clear(); if (DatabaseHolder.HowManyUsers() == 0) { return(false); } for (int i = 0; i < DatabaseHolder.HowManyUsers(); i++) { CreatingUser(i); } return(true); }
private void DeleteBtn_Click(object sender, EventArgs p, AdapterView.ItemClickEventArgs e) { alertDialogAndroid.Dismiss(); LayoutInflater layoutInflater = LayoutInflater.From(this.Activity); var view = layoutInflater.Inflate(Resource.Layout.OKDialog, null); Delete_ClickConfig(view, "User has been deleted!"); char[] ar = new char[2]; ar = DatabaseHolder.IntToCharArr(users[e.Position].Id); OKBtn.Enabled = false; BluetoothHolder.bluetoothManage.Write(DatabaseHolder.DELUS + ar[0] + ar[1] + '\a'); DatabaseHolder.receiver = ""; AccBtn.Click += AccBtn_Click1; }
private void DoorClosedBtnOK_Click(object sender, EventArgs e) { BluetoothHolder.bluetoothManage.Read(); if (DatabaseHolder.CODE() == "OK") { } else if (DatabaseHolder.CODE() == "ER") { Toast.MakeText(this.Activity, "Error while closing door!", ToastLength.Long).Show(); } else { Toast.MakeText(this.Activity, "Unknown error!", ToastLength.Long).Show(); } alertDialogAndroid.Dismiss(); }
private void AccBtn_Click1(object sender, EventArgs e) { BluetoothHolder.bluetoothManage.Read(); OKBtn.Enabled = true; AccBtn.Enabled = false; if (DatabaseHolder.CODE() == "OK") { } else if (DatabaseHolder.CODE() == "ER") { Toast.MakeText(this.Activity, "There was an error while uploading a database!", ToastLength.Long).Show(); } else { Toast.MakeText(this.Activity, "UNKNOWN ERROR - RECEIVED MSG:'" + DatabaseHolder.receiver + "'", ToastLength.Long).Show(); } alertDialogAndroid.Dismiss(); }
private void UploadingUsersList() { BluetoothHolder.bluetoothManage.Read(); if (DatabaseHolder.CODE() == null) { Toast.MakeText(this.Activity, "Error, received message has wrong format!", ToastLength.Long).Show(); } else if (DatabaseHolder.CODE() == "OK") { if (UploadingDatabase()) { UsersViewAdapter adapter = new UsersViewAdapter(this.Activity, users); usersList.Adapter = adapter; } } else if (DatabaseHolder.CODE() == "ER") { Toast.MakeText(this.Activity, "Error while uploading a database!", ToastLength.Long).Show(); } }
private void AccBtn_Click2(object sender, EventArgs e, AdapterView.ItemClickEventArgs p) { BluetoothHolder.bluetoothManage.Read(); OKBtn.Enabled = true; AccBtn.Enabled = false; if (DatabaseHolder.CODE() == "OK") { Toast.MakeText(this.Activity, "Received: " + DatabaseHolder.receiver, ToastLength.Long).Show(); char[] ar = new char[2]; ar = DatabaseHolder.IntToCharArr(users[p.Position].Id); DatabaseHolder.receiver = ""; BluetoothHolder.bluetoothManage.Write(DatabaseHolder.CHNCD + ar[0] + ar[1] + '\a'); } else if (DatabaseHolder.CODE() == "ER") { Toast.MakeText(this.Activity, "There was an error while uploading a database!", ToastLength.Long).Show(); } else { Toast.MakeText(this.Activity, "UNKNOWN ERROR - RECEIVED MSG:'" + DatabaseHolder.receiver + "'", ToastLength.Long).Show(); } }
private DatabaseHolder DataBaseHandle(object model, MethodType type, string search = null, string[] updateValues = null) { var properties = ""; var propertiesName = ""; var values = ""; var modelId = ""; var counter = model.GetType().GetProperties().Length; var loopcounter = 0; var databaseHolder = new DatabaseHolder { ExecuteCodes = ExecuteCodes.SuccessToExecute }; var con = CreateConnection(); con.Open(); var command = CreateCommand(); command.Connection = con; command.CommandType = CommandType.Text; foreach (var prop in model.GetType().GetProperties()) { if (loopcounter < counter - 1 && !prop.Name.ToLower().Contains($"{model.GetType().Name.ToLower()}id")) { propertiesName += $"@{prop.Name},"; properties += $"{prop.Name},"; if (type != MethodType.GetOne && type != MethodType.GetAll) { object p = prop.GetValue(model).ToString(); if ((string)p == "") { p = "0"; } values += p.ToString() + ","; } } if (loopcounter == counter - 1 && !prop.Name.ToLower().Contains($"{model.GetType().Name.ToLower()}id")) { propertiesName += $"@{prop.Name}"; properties += $"{prop.Name}"; if (type != MethodType.GetOne && type != MethodType.GetAll) { object p = prop.GetValue(model).ToString(); if ((string)p == "") { p = "0"; } values += p.ToString(); } } else { if (type != MethodType.GetOne && type != MethodType.GetAll && prop.Name.ToLower().Contains($"{model.GetType().Name.ToLower()}id")) { modelId = prop.GetValue(model).ToString(); } if (loopcounter == 0 && (type == MethodType.GetAll || type == MethodType.GetOne)) { properties += $"{prop.Name},"; } } ++loopcounter; } var result = CreateSqlSyntax(type, model.GetType().Name, properties, propertiesName, search, values, modelId, command); command = result.Command; command.CommandText = result.Result; if (type == MethodType.Save || type == MethodType.Update) { try { var command2 = CreateCommand(); command2.Connection = con; command2.CommandType = CommandType.Text; command2.CommandText = "select @@Identity"; command.ExecuteNonQuery(); if (type != MethodType.Update) { databaseHolder.PrimaryKey = Convert.ToInt32(command2.ExecuteScalar()); } } catch (Exception e) { var a = e; databaseHolder.ExecuteCodes = ExecuteCodes.FailedToExecute; } finally { con.Close(); } } else if (type == MethodType.GetOne) { try { command.ExecuteNonQuery(); var reader = command.ExecuteReader(); var list = model.GetType().GetProperties(); while (reader.Read()) { for (int i = 0; i < list.Length; i++) { list[i].SetValue(model, reader[reader.GetName(i)]); } } databaseHolder.Model = model; reader.Close(); } catch (Exception e) { var a = e; databaseHolder.ExecuteCodes = ExecuteCodes.FailedToExecute; } finally { con.Close(); } } else if (type == MethodType.GetAll) { try { //TODO Bygg upp en lista av object och retunera. command.ExecuteNonQuery(); var reader = command.ExecuteReader(); var list = model.GetType().GetProperties(); while (reader.Read()) { var newModel = Activator.CreateInstance(model.GetType()); for (int i = 0; i < list.Length; i++) { object value = reader[reader.GetName(i)]; list[i].SetValue(newModel, value); } databaseHolder.List.Add(newModel); } reader.Close(); } catch (Exception e) { var a = e; databaseHolder.ExecuteCodes = ExecuteCodes.FailedToExecute; } finally { con.Close(); } } return(databaseHolder); }