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