C# (CSharp) DSWebService.BLL.Data_Centre Link.ExecuteNonQuery Examples

Example #1

File: syntool.asmx.cs Project: Audery/Audery-Repository

 public bool DelCompleteLink(string t_id, int iden, string authKey)
 {
     if (islogin(authKey))
     {
         BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
         string sql = string.Format("DELETE dbo.Link WHERE t_id='{0}' AND iden={1}", t_id, iden);
         bll.ExecuteNonQuery(sql);
         return(true);
     }
     return(false);
 }

Example #2

File: syntool.asmx.cs Project: Audery/Audery-Repository

 public bool SetDefaultShop(int iden, string t_id, string is_default, string authKey)
 {
     if (islogin(authKey))
     {
         string sql = string.Format("UPDATE Link SET is_default={0} WHERE t_id='{1}' and iden={2}", is_default, t_id, iden);
         BLL.Data_Centre.Link bll = new BLL.Data_Centre.Link();
         bll.ExecuteNonQuery(sql);
         return(true);
     }
     else
     {
         return(false);
     }
 }