public int AddDepartment(Department department)
{
try
{
bool b=CheckAccountByDepartment(department.Account.AccountId, department.DepartmentName);
if (b)
{
int isDefault = 0;
if (department.IsDefault == false)
isDefault = 0;
else
isDefault = 1;
string sql = string.Format("insert into LiveSupport_Department(DepartmentId,DepartmentName,AccountId,IsDefault,AddDate) values('{0}','{1}','{2}','{3}','{4}')", department.DepartmentId, department.DepartmentName, department.Account.AccountId, isDefault, department.AddDate);
return DBHelper.ExecuteCommand(sql);
}
else
{
return 0;
}
}
catch (Exception ex)
{
System.Console.Write(ex.ToString());
return 0;
}
}
public static bool AddDepartment(Department department)
{
int i = 0;
i = Provider.AddDepartment(department);
if (i != 0)
return true;
else
return false;
}
public static bool AddAccount(Account account,string NickName, string loginName, string loginPwd)
{
int i = 0;
int di = 0;
int oi = 0;
i = SqlAccountProvider.Default.AddAccount(account);
if (i != 0)
{
//添加默认部门
Department dt = new Department();
dt.Account = account;
dt.DepartmentId = Guid.NewGuid().ToString();
dt.DepartmentName = "默认部门";
dt.IsDefault = true;
dt.AddDate = DateTime.Now.ToString();
di=new SqlDepartmentProvider().AddDepartment(dt);
if (di!=0)
{
Operator op = new Operator();
op.Account = account;
op.LoginName = loginName;
op.Password = loginPwd;
op.IsAdmin = true;
op.NickName = NickName;
op.Department = dt;
op.Email = account.Email;
op.AVChatStatus = OperatorStatus.Offline.ToString();
op.Status = OperatorStatus.Offline;
oi=new SqlOperatorProvider().NewOperator(op);
}
WebSite wst = WebSiteManager.GetWebSiteByDomainName(Util.GetDomainName(account.Url));
if (wst == null)
{
wst = new WebSite();
wst.DomainName =Util.GetDomainName(account.Url);
wst.ChatStyle = "0";
wst.IcoLocation = "0";
wst.IconStyle = "0";
wst.InviteStyle = "0";
wst.RegisterId = account.AccountId;
LiveSupport.BLL.WebSiteManager.NewWebSite(wst);
}
if (i != 0 && di != 0 && oi != 0)
{
return true;
}
else
return false;
}
else
return false;
}
public List<Department> GetDepartmentByAccountId(string AccountId)
{
List<Department> list = new List<Department>();
string sql = "select * from LiveSupport_Department where AccountId='" + AccountId + "' order by AddDate";
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
while (sdr.Read())
{
Department department = new Department();
department.DepartmentId = sdr["DepartmentId"].ToString();
department.DepartmentName = sdr["DepartmentName"].ToString();
department.IsDefault = Convert.ToBoolean(sdr["IsDefault"]);
string aid = sdr["AccountId"].ToString();
department.Account = accountProvider.GetAccountByAccountId(aid);
list.Add(department);
}
return list;
}
}
public Department GetDepartmentById(string departmentId)
{
string sql = "select * from LiveSupport_Department where DepartmentId='" + departmentId + "'";
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
if (sdr.Read())
{
Department department = new Department();
department.DepartmentId = sdr["DepartmentId"].ToString();
department.DepartmentName = sdr["DepartmentName"].ToString();
department.IsDefault = Convert.ToBoolean(sdr["IsDefault"]);
string aid = sdr["AccountId"].ToString();
department.Account = accountProvider.GetAccountByAccountId(aid);
return department;
}
else
{
return null;
}
}
}