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);
}
