public override Account FindAccountByAdminUserName(string name)
{
Account account = null;
MembershipUser user = Membership.GetUser(name);
if (user == null)
{
return null;
}
using (SqlConnection con = new SqlConnection(connectionString()))
{
con.Open();
SqlCommand cmd = new SqlCommand(SqlDataAccessConstant.SP_LiveSupport_Accounts_FindAccountByAdminUserId, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AdminUserId", SqlDbType.UniqueIdentifier).Value = user.ProviderUserKey;
SqlDataReader r = cmd.ExecuteReader();
if (r.Read())
{
account = new Account(r.GetInt32(0), r.GetGuid(1));
}
return account;
}
}
public override List<Account> GetAllAccounts()
{
List<Account> list = new List<Account>();
// connect to the database
using (SqlConnection con = new SqlConnection(connectionString()))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from LiveSupport_Accounts" , con);
cmd.CommandType = CommandType.Text;
SqlDataReader r = cmd.ExecuteReader();
Account curr;
while (r.Read())
{
//if (r["id"] is DBNull || r["visible"] is DBNull || r["title"] is DBNull)
// throw new InvalidOperationException(Messages.ItemRequiredAttributesMissing);
curr = new Account(r.GetInt32(0), r.GetGuid(1));
curr.Name = r["Name"].ToString();
curr.Email = r["Email"].ToString();
curr.UserId = (Guid) r["AdminUserId"];
list.Add(curr);
}
}
return list;
}