public FormMain(BEUser loggedUser)
{
InitializeComponent();
_bllScanner = new BLLScanner();
_loggedUser = loggedUser;
PopulateTreeView();
InitSettings();
}
public void InsertUserIfNotExist(BEUser user)
{
bool userExist = false;
using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;"))
{
using (var com = new SQLiteCommand(con))
{
con.Open();
string stm = "SELECT * FROM Users WHERE Username = '******'";
com.CommandText = stm;
using (SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
userExist = true;
// Console.WriteLine(reader["Key"] + " : " + reader["Value"]); // Display the value of the key and value column for every row
}
}
}
}
if (!userExist)
{
using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;"))
{
using (var com = new SQLiteCommand(con))
{
con.Open();
string insert = "INSERT INTO Users (FullName, Username, Company) Values ('" + user.FullName + "', '" + user.Username + "', '" + user.Company + "')";
com.CommandText = insert;
com.ExecuteNonQuery();
}
}
}
}
public BEUser GetUserByUsername(string username)
{
using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;"))
{
using (var com = new SQLiteCommand(con))
{
con.Open();
string stm = "SELECT * FROM Users WHERE Username = '******'";
com.CommandText = stm;
using (SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
BEUser loggingUser = new BEUser()
{
Id = reader.GetInt32(0),
FullName = reader.GetString(1),
Username = reader.GetString(2),
Company = reader.GetString(3)
};
return loggingUser;
// Console.WriteLine(reader["Key"] + " : " + reader["Value"]); // Display the value of the key and value column for every row
}
}
}
}
return null;
}
public List<BEUser> GetAllUsers()
{
List<BEUser> users = new List<BEUser>();
using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;"))
{
using (var com = new SQLiteCommand(con))
{
con.Open();
string stm = "SELECT * FROM Users";
com.CommandText = stm;
using (SQLiteDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
var user = new BEUser()
{
Id = reader.GetInt32(0),
FullName = reader.GetString(1),
Username = reader.GetString(2),
Company = reader.GetString(3)
};
users.Add(user);
}
}
}
}
return users;
}
// Database section
public void InsertUser(BEUser loggedUser)
{
_sql.InsertUserIfNotExist(loggedUser);
}
public BEBusinessCard GetScannedCard(BEUser loggedUser)
{
var card = new BEBusinessCard
{
Firstname = Sdk.GetText(SDKWrapper.Fields.FirstName) + " " + Sdk.GetText(SDKWrapper.Fields.MiddleName),
Lastname = Sdk.GetText(SDKWrapper.Fields.LastName),
Address = Sdk.GetText(SDKWrapper.Fields.Address1_Line1),
City = Sdk.GetText(SDKWrapper.Fields.Address1_City),
Postal = Sdk.GetText(SDKWrapper.Fields.Address1_PostalCode),
Country = Sdk.GetText(SDKWrapper.Fields.Address1_Country),
Title = Sdk.GetText(SDKWrapper.Fields.Title),
Company = Sdk.GetText(SDKWrapper.Fields.Company),
PhoneNumber = Sdk.GetText(SDKWrapper.Fields.Phone),
Fax = Sdk.GetText(SDKWrapper.Fields.Fax),
Email = Sdk.GetText(SDKWrapper.Fields.Email),
Homepage = Sdk.GetText(SDKWrapper.Fields.WebSite),
Other = Sdk.GetText(SDKWrapper.Fields.Other),
EncodedImage = "d",
CreatedDate = DateTime.Now.ToString(),
CreatedUserId = loggedUser.Id
};
return card;
}
public FormLoadingDevice(BEUser loggedUser)
{
_loggedUser = loggedUser;
InitializeComponent();
detectDevice();
}
