public static string AddUserSession(UsersSessions usses, int num_table) { string msg = string.Empty, query = $"insert into UserSessions_{num_table}(CurLogin, CurPassword, RememberMe, IsActive, AccessToken, DateEnter, DateLeave)" + $"values(@CurLogin, @CurPassword, @RememberMe, @IsActive, @AccessToken, @DateEnter, @DateLeave)"; using (var c = Connection.conn = new System.Data.SqlClient.SqlConnection(Connection.connectstr)) { c.Open(); using (var cmd = Connection.cmd = new System.Data.SqlClient.SqlCommand(query, c)) { cmd.Parameters.AddWithValue("@CurLogin", usses.CurLogin); cmd.Parameters.AddWithValue("@CurPassword", usses.CurPassword); cmd.Parameters.AddWithValue("@RememberMe", usses.RememberMe); cmd.Parameters.AddWithValue("@IsActive", usses.IsActive); cmd.Parameters.AddWithValue("@AccessToken", usses.AccessToken); cmd.Parameters.AddWithValue("@DateEnter", usses.DateEnter); cmd.Parameters.AddWithValue("@DateLeave", usses.DateLeave); int res = cmd.ExecuteNonQuery(); if (res == 1) { msg = "Info about Website has inserted Successfuly!!!"; } else { msg = "Something went wrong..."; } } } return(msg); }
public static IEnumerable <UsersSessions> AllUsersSessions(int num) { List <UsersSessions> list = new List <UsersSessions>(); using (var conn = Connection.conn = new SqlConnection(Connection.connectstr)) { conn.Open(); using (var cmd = Connection.cmd = new SqlCommand($"select * from UserSessions_{num}", conn)) { SqlDataReader dreder = null; try { dreder = Connection.dreder = cmd.ExecuteReader(); } catch { } if (dreder == null) { list = null; } else { while (dreder.Read()) { UsersSessions area = new UsersSessions(); area.Id = Convert.ToInt32(dreder["Id"].ToString()); area.CurLogin = dreder["CurLogin"].ToString(); area.CurPassword = dreder["CurPassword"].ToString(); area.RememberMe = Convert.ToBoolean(dreder["RememberMe"]); area.IsActive = Convert.ToBoolean(dreder["IsActive"]); area.DateEnter = Convert.ToDateTime(dreder["DateEnter"].ToString()); area.DateLeave = Convert.ToDateTime(dreder["DateLeave"].ToString()); list.Add(area); } } } return(list); } }