public LoginHistory GetOneLoginHistory(int loginHistoryId) { var loginHistory = (LoginHistory)null; List<Dictionary<string, string>> list = _database.Query("Select * from LoginHistory where Id = @id", new Dictionary<string, object>() { { "@id", loginHistoryId } }); if (list != null && list.Count == 1) { var dictionary = list[0]; loginHistory = new LoginHistory { Id = int.Parse(dictionary["Id"]), Type = int.Parse(dictionary["Type"]), UserName = dictionary["UserName"], LoginTime = DateTime.Parse(dictionary["LoginTime"]), LoginStatus = int.Parse(dictionary["LoginStatus"]), RefreshToken = dictionary["RefreshToken"], AppId = dictionary["AppId"], ClientUri = dictionary["ClientUri"], ClientIP = dictionary["ClientIP"], ClientUA = dictionary["ClientUA"], ClientDevice = dictionary["ClientDevice"], ClientApiKey = dictionary["ClientApiKey"], Created = DateTime.Parse(dictionary["Created"]) }; } return loginHistory; }
public static async Task< long> InsertHistory(LoginHistory input) { string commandText = @" INSERT INTO LoginHistory(Id, Type, UserName, LoginTime, LoginStatus, RefreshToken, AppId, ClientUri, ClientIP, ClientUA, ClientDevice, ClientApiKey, Created) VALUES( @Id, @Type, @UserName, @LoginTime, @LoginStatus, @RefreshToken, @AppId, @ClientUri, @ClientIP, @ClientUA, @ClientDevice, @ClientApiKey, @Created)"; var parameters = new DynamicParameters(); parameters.Add("@Id", (object)null); parameters.Add("@Type", (object)input.Type); parameters.Add("@UserName", (object)input.UserName); parameters.Add("@LoginTime", (object)input.LoginTime); parameters.Add("@LoginStatus", (object)input.LoginStatus); parameters.Add("@RefreshToken", (object)input.RefreshToken); parameters.Add("@AppId", (object)input.AppId); parameters.Add("@ClientUri", (object)input.ClientUri); parameters.Add("@ClientIP", (object)input.ClientIP); parameters.Add("@ClientUA", (object)input.ClientUA); parameters.Add("@ClientDevice", (object)input.ClientDevice); parameters.Add("@ClientApiKey", (object)input.ClientApiKey); parameters.Add("@Created", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn)) { var id = await conn.QueryAsync<long>(commandText, parameters); results = id.Single(); } return results; }
public int InsertHistory(LoginHistory input) { try { return this._database.Execute("INSERT INTO LoginHistory\n ( Id,\n Type,\n UserName,\n LoginTime,\n LoginStatus,\n RefreshToken,\n AppId,\n ClientUri,\n ClientIP,\n ClientUA,\n ClientDevice,\n ClientApiKey,\n Created)\n VALUES(\n @Id,\n @Type,\n @UserName,\n @LoginTime,\n @LoginStatus,\n @RefreshToken,\n @AppId,\n @ClientUri,\n @ClientIP,\n @ClientUA,\n @ClientDevice,\n @ClientApiKey,\n @Created)", new Dictionary<string, object>() { { "@Id", null }, { "@Type", input.Type }, { "@UserName", input.UserName }, { "@LoginTime", input.LoginTime }, { "@LoginStatus", input.LoginStatus }, { "@RefreshToken", input.RefreshToken }, { "@AppId", input.AppId }, { "@ClientUri", input.ClientUri }, { "@ClientIP", input.ClientIP }, { "@ClientUA", input.ClientUA }, { "@ClientDevice", input.ClientDevice }, { "@ClientApiKey", input.ClientApiKey }, { "@Created", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") } }); } catch (Exception ex) { } return -1; }
public static async Task<long> InsertLoginHistory(LoginHistory input) { return await (LoginHistoryDal.InsertHistory(input)); }