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