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