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