public bool InsertAdmin(AdminModel theAdmin)
{
if (!File.Exists(SqliteBaseRepository.DbLocation))
{
SqliteBaseRepository.CreateDatabase();
}
string sql = "INSERT INTO admin(username, password) VALUES(@username, @password)";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@username", theAdmin.username },
{ "@password", theAdmin.password }
};
bool output = true;
try
{
SqliteDataAccess.SaveData(sql, parameters);
}
catch
{
output = false;
}
return(output);
}
public void Configuration(IAppBuilder app)
{
// For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=316888
if (!File.Exists(SqliteBaseRepository.DbLocation))
{
SqliteBaseRepository.CreateDatabase();
}
app.UseCors(Microsoft.Owin.Cors.CorsOptions.AllowAll);
var myProvider = new AuthorizationServerProvider();
OAuthAuthorizationServerOptions options = new OAuthAuthorizationServerOptions
{
AllowInsecureHttp = true,
TokenEndpointPath = new PathString("/token"),
AccessTokenExpireTimeSpan = TimeSpan.FromDays(7),
Provider = myProvider
};
app.UseOAuthAuthorizationServer(options);
app.UseOAuthBearerAuthentication(new OAuthBearerAuthenticationOptions());
HttpConfiguration config = new HttpConfiguration();
WebApiConfig.Register(config);
}
public bool InsertStaff(StaffModel newStaff)
{
if (!File.Exists(SqliteBaseRepository.DbLocation))
{
SqliteBaseRepository.CreateDatabase();
}
string sql = "insert into staff(branch_id, firstname, lastname, fingerPrint) values(@branch_id, @firstname, @lastname, @fingerPrint)";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@branch_id", newStaff.branch_id },
{ "@firstname", newStaff.firstName },
{ "@lastname", newStaff.lastName },
{ "@fingerPrint", newStaff.fingerPrint }
};
bool output = true;
try
{
SqliteDataAccess.SaveData(sql, parameters);
}
catch
{
output = false;
}
return(output);
}
public static void SaveData(string sqlStatement, Dictionary <string, object> parameters, string connectionName = "Default")
{
DynamicParameters p = parameters.ToDynamicParameters();
using (IDbConnection cnn = SqliteBaseRepository.SimpleDbConnection())
{
cnn.Execute(sqlStatement, p);
}
}
public static List <T> LoadData <T>(string sqlStatement, Dictionary <string, object> parameters, string connectionName = "Default")
{
DynamicParameters p = parameters.ToDynamicParameters();
using (IDbConnection cnn = SqliteBaseRepository.SimpleDbConnection())
{
var rows = cnn.Query <T>(sqlStatement, p);
return(rows.ToList());
}
}
private void InitDataBase()
{
if (mappingDic == null)
{
mappingDic = ResourceAction.GetTableNameDictionary();
}
if (!mappingDic.Any())
{
SqliteBaseRepository baseRepository = new SqliteBaseRepository();
baseRepository.CreateNewDatabase();
baseRepository.ConnectToDatabase();
baseRepository.CreateTable();
ResourceAction.AddMapping();
mappingDic = ResourceAction.GetTableNameDictionary();
}
}
public bool InsertBranch(BranchModel theBranch)
{
if (!File.Exists(SqliteBaseRepository.DbLocation))
{
SqliteBaseRepository.CreateDatabase();
}
string sql = "INSERT INTO branch(name) VALUES(@name)";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@name", theBranch.name }
};
bool output = true;
try
{
SqliteDataAccess.SaveData(sql, parameters);
}
catch
{
output = false;
}
return(output);
}
