public string GetActivationCode(NewClientApp x) { try { if (string.IsNullOrEmpty(x.code)) { string path = Server.MapPath(string.Format("~/App_Data/{0}", dataBase)); db.CreateGlobalDataBase(path, db.clientapp); x.code = CreateActivationCode(); if (x.code == null) { return(null); } if (string.IsNullOrEmpty(x.id)) { x.id = Guid.NewGuid().ToString(); } SQLiteConnection connection = new SQLiteConnection(string.Format("Data Source={0}", path)); connection.Open(); string sql = string.Format(@"BEGIN; INSERT OR REPLACE INTO clientapp (id, clientId, userId, code, lang) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}'); COMMIT;", x.id, x.clientId, x.userId, x.code, x.lang); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); } return(JsonConvert.SerializeObject(x, Formatting.None)); } catch (Exception e) { return(null); } }
public string Activate(string code) { NewClientApp x = new NewClientApp(); try { string path = Server.MapPath(string.Format("~/App_Data/{0}", dataBase)); //db.CreateGlobalDataBase(path, db.clientapp); using (SQLiteConnection connection = new SQLiteConnection(string.Format("Data Source={0}", path))) { connection.Open(); string sql = string.Format(@"SELECT id, clientId, userId, code, lang FROM clientapp WHERE code = '{0}'", code); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { x.id = reader.GetValue(0) == DBNull.Value ? "" : reader.GetString(0); x.clientId = reader.GetValue(1) == DBNull.Value ? "" : reader.GetString(1); x.userId = reader.GetValue(2) == DBNull.Value ? "" : reader.GetString(2); x.code = reader.GetValue(3) == DBNull.Value ? "" : reader.GetString(3); x.lang = reader.GetValue(4) == DBNull.Value ? "" : reader.GetString(4); } } } } return(JsonConvert.SerializeObject(x, Formatting.None)); } catch (Exception e) { L.SendErrorLog(e, code, null, "ClientApp", "Activate"); return(JsonConvert.SerializeObject(x, Formatting.None)); } }
private NewClientApp GetCode(string clientId) { try { string path = Server.MapPath(string.Format("~/App_Data/{0}", dataBase)); db.CreateGlobalDataBase(path, db.clientapp); NewClientApp x = new NewClientApp(); using (SQLiteConnection connection = new SQLiteConnection(string.Format("Data Source={0}", path))) { connection.Open(); string sql = string.Format(@"SELECT id, clientId, userId, code, lang FROM clientapp WHERE clientId = '{0}'", clientId); using (SQLiteCommand command = new SQLiteCommand(sql, connection)) { using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { x.id = reader.GetValue(0) == DBNull.Value ? "" : reader.GetString(0); x.clientId = reader.GetValue(1) == DBNull.Value ? "" : reader.GetString(1); x.userId = reader.GetValue(2) == DBNull.Value ? "" : reader.GetString(2); x.code = reader.GetValue(3) == DBNull.Value ? "" : reader.GetString(3); x.lang = reader.GetValue(4) == DBNull.Value ? "" : reader.GetString(4); } } } connection.Close(); } return(x); } catch (Exception e) { return(new NewClientApp()); } }
public string Get(string clientId) { NewClientApp x = new NewClientApp(); try { if (string.IsNullOrWhiteSpace(clientId)) { return(JsonConvert.SerializeObject(x, Formatting.None)); } x = GetCode(clientId); return(JsonConvert.SerializeObject(x, Formatting.None)); } catch (Exception e) { L.SendErrorLog(e, null, clientId, "ClientApp", "Get"); return(JsonConvert.SerializeObject(x, Formatting.None)); } }