public override List<Operator> FindOperatorsByAccountId(int accountId) { List<Operator> list = new List<Operator>(); using (SqlConnection con = new SqlConnection(connectionString())) { con.Open(); SqlCommand cmd = new SqlCommand(SqlDataAccessConstant.SP_LiveSupport_Operators_FindOperatorsByAccountId, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AccountId", SqlDbType.Int).Value = accountId; SqlDataReader r = cmd.ExecuteReader(); Operator curr; while (r.Read()) { curr = new Operator(r.GetInt32(0), r.GetInt32(1)); curr.Name = r.GetString(2); curr.Password = r.GetString(3); curr.Email = r.GetString(4); curr.IsOnline = r.GetBoolean(5); list.Add(curr); } return list; } }
public override List <ChatRequestInfo> GetChatRequests(LiveSupport.DAL.Entity.Operator op) { bool cacheExists; List <ChatRequestInfo> results = new List <ChatRequestInfo>(); foreach (ChatRequestInfo req in GetCurrentRequest(out cacheExists)) { if (req.AcceptByOpereratorId == op.Id) { results.Add(req); } } return(results); }
public abstract void UpdateOperator(Operator op);
public abstract void InsertOperator(Operator op);
public override List<Operator> GetOnlineOperator() { SqlConnection sqlC = new SqlConnection(connectionString()); SqlCommand cmd = new SqlCommand("LiveChat_OperatorsGetAllOnline", sqlC); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader data = null; List<Operator> retList = new List<Operator>(); try { sqlC.Open(); data = cmd.ExecuteReader(); while (data.Read()) { Operator curr = new Operator(data.GetInt32(0), data.GetInt32(1)); curr.Name = data.GetString(2); curr.Password = data.GetString(3); curr.Email = data.GetString(4); curr.IsOnline = data.GetBoolean(5); retList.Add(curr); } data.Close(); data.Dispose(); data = null; cmd.Dispose(); sqlC.Close(); } catch { throw; } finally { if (sqlC != null) { if (sqlC.State == ConnectionState.Open) sqlC.Close(); sqlC.Dispose(); sqlC = null; } } return retList; }
public override void UpdateOperator(Operator op) { using (SqlConnection con = new SqlConnection(connectionString())) { string sqlCmdString = string.Format("update LiveChat_Operators set [Name] = '{0}',[Password] = '{1}', [Email] = '{2}' where Id={3}", op.Name, op.Password, op.Email, op.Id.ToString()); SqlCommand cmd = new SqlCommand(sqlCmdString, con); cmd.CommandType = CommandType.Text; con.Open(); cmd.ExecuteNonQuery(); } }
private List<Operator> getOperators(string sqlcmd) { List<Operator> list = new List<Operator>(); // connect to the database using (SqlConnection con = new SqlConnection(connectionString())) { con.Open(); SqlCommand cmd = new SqlCommand(sqlcmd, con); cmd.CommandType = CommandType.Text; SqlDataReader r = cmd.ExecuteReader(); Operator curr; while (r.Read()) { //if (r["id"] is DBNull || r["visible"] is DBNull || r["title"] is DBNull) // throw new InvalidOperationException(Messages.ItemRequiredAttributesMissing); curr = new Operator(r.GetInt32(0), r.GetInt32(1)); curr.Email = r["Email"] as string; curr.IsOnline = (Boolean)r["IsOnline"]; curr.Name = r["Name"] as string; curr.Password = r["Password"] as string; list.Add(curr); } } return list; }
public override Operator LoginOperator(string name, string password, int accountId) { using (SqlConnection con = new SqlConnection(connectionString())) { SqlCommand cmd = new SqlCommand(SqlDataAccessConstant.SP_LiveSupport_LiveSupport_Operators_LoginOperator, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = name; cmd.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = password; cmd.Parameters.Add("@AccountId", SqlDbType.Int).Value = accountId; con.Open(); SqlDataReader r = cmd.ExecuteReader(); if (r.Read()) { Operator op = new Operator(r.GetInt32(0), r.GetInt32(1)); op.Name = r.GetString(2); op.Password = r.GetString(3); op.Email = r.GetString(4); op.IsOnline = r.GetBoolean(5); return op; } else return null; } }
public override void InsertOperator(Operator op) { using (SqlConnection con = new SqlConnection(connectionString())) { SqlCommand cmd = new SqlCommand(SqlDataAccessConstant.SP_LiveSupport_Operators_CreateOperator, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AccountId", SqlDbType.Int).Value = op.AccountId; cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = op.Name; cmd.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = op.Password; cmd.Parameters.Add("@Email", SqlDbType.VarChar, 250).Value = op.Email; con.Open(); cmd.ExecuteNonQuery(); } }
public override Operator GetOperatorById(int operatorId) { using (SqlConnection con = new SqlConnection(connectionString())) { SqlCommand cmd = new SqlCommand(SqlDataAccessConstant.SP_LiveSupport_Operators_GetOperatorById, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OperatorId", SqlDbType.Int).Value = operatorId; ; con.Open(); SqlDataReader r = cmd.ExecuteReader(); if (r.Read()) { Operator op = new Operator(r.GetInt32(0), r.GetInt32(1)); op.Name = r.GetString(2); op.Password = r.GetString(3); op.Email = r.GetString(4); op.IsOnline = r.GetBoolean(5); return op; } else return null; } }
public void RemoveOperator(Operator op) { operators.Remove(op); }
public void AddOperator(Operator op) { operators.Add(op); }