public bool UpdateClientGrounp(ClientGrounp cg)
{
int i = 0;
i = new SqlClientGrounpProvider().UpdateClientGrounp(cg);
if (i != 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool AddClientGrounp(ClientGrounp cg)
{
int i = 0;
i = new SqlClientGrounpProvider().AddClientGrounp(cg);
if (i != 0)
{
return(true);
}
else
{
return(false);
}
}
public List <ClientGrounp> GetClientGrounpByAccountId(string accountId)
{
string sql = string.Format("select * from LiveSupport_ClientGrounp where accountId='{0}' order by addDate", accountId);
List <ClientGrounp> list = new List <ClientGrounp>();
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
while (sdr.Read())
{
ClientGrounp cg = new ClientGrounp(sdr);
cg.Account = new SqlAccountProvider().GetAccountByAccountId(accountId);
list.Add(cg);
}
return(list);
}
}
public ClientGrounp GetClientGrounpById(string grounpId)
{
string sql = string.Format("select * from LiveSupport_ClientGrounp where Id='{0}' order by addDate", grounpId);
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
if (sdr.Read())
{
ClientGrounp cg = new ClientGrounp(sdr);
cg.Account = new SqlAccountProvider().GetAccountByAccountId(grounpId);
return(cg);
}
else
{
return(null);
}
}
}
public ClientGrounp CheckClientGrounpByAccountIdAndGrountpName(string accountId, string GrountpName)
{
string sql = string.Format("select * from LiveSupport_ClientGrounp where accountId='{0}' and [Name]='{1}' order by addDate", accountId, GrountpName);
using (SqlDataReader sdr = DBHelper.GetReader(sql))
{
if (sdr.Read())
{
ClientGrounp cg = new ClientGrounp(sdr);
cg.Account = new SqlAccountProvider().GetAccountByAccountId(accountId);
return(cg);
}
else
{
return(null);
}
}
}
public int UpdateClientGrounp(ClientGrounp cg)
{
string sql = string.Format("update from LiveSupport_ClientGrounp Name='{0}',accountId='{1}' where Id='{2}'", cg.Name, cg.Account.AccountId, cg.Id);
return(DBHelper.ExecuteSql(sql));
}
public int AddClientGrounp(ClientGrounp cg)
{
string sql = string.Format("insert into LiveSupport_ClientGrounp([Id],[Name],accountId,addDate) values('{0}','{1}','{2}','{3}',)", cg.Id, cg.Name, cg.Account.AccountId, cg.AddDate);
return(DBHelper.ExecuteSql(sql));
}
