public void EditSession(SC_LoginHistory sessionobj)
{
string query = "Update SC_LoginHistory set LogOutDate = @LogOutDate,OrganizationId=@OrganizationId where LoginId = @LoginId";
using (var db = DbHelper.GetDBConnection())
{
db.Execute(query, sessionobj);
}
}
public void AddSession(SC_LoginHistory mS_Country)
{
string query = "Insert into SC_LoginHistory (LoginId, UserId, LoginDate, RoleId,OrganizationId,ActualOrganizationId,LogOutDate)" +
" values (NEWID(), @UserId, @LoginDate, @RoleId, @OrganizationId,@ActualOrganizationId,@LogOutDate)";
using (var db = DbHelper.GetDBConnection())
{
db.Execute(query, mS_Country);
}
}
