public static bool Clear() { bool result = false; using (StoredProcedure sp = new StoredProcedure("Log_Clear")) { result = sp.ExecuteNonQuery() > 0; } return result; }
public bool DeleteImageByGroupID(int groupID) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Products_DeleteImage")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupID; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Delete(Service item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("ServiceSpecialization_DeleteByService")) { sp.Params.Add("@ServiceID", System.Data.SqlDbType.Int).Value = item.GroupID; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool Delete(ContactForm item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("ContactForms_DeleteItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool DeleteGroup(City item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Cities_DeleteGroup")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Delete(PageHtml item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("PagesHtml_DeleteItem")) { sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 100).Value = item.Name; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Delete(NewsSubscriber item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_DeleteItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; result = sp.ExecuteNonQuery() > 0; } return result; }
public static bool Delete(DbConfigItem item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("DbConfig_DeleteItem")) { sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Delete(int partnerID) { bool result = false; using (StoredProcedure sp = new StoredProcedure("PartnerSpecialization_DeleteByPartner")) { sp.Params.Add("@PartnerID", System.Data.SqlDbType.Int).Value = partnerID; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Update(ContentPage item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("ContentPages_UpdateItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name; result = sp.ExecuteNonQuery() > 0; } return result; }
public void DeleteById(SeminarRegistration s) { if (s != null) { using ( StoredProcedure sp = new StoredProcedure("DELETE FROM SeminarsRegistration WHERE ID=" + s.ID.ToString())) { sp.command.CommandType = CommandType.Text; sp.ExecuteNonQuery(); } } }
public virtual void Delete(iPadActionSerial item) { int newID = 0; using (StoredProcedure sp = new StoredProcedure("iPadActionSerial_DeleteItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; try { sp.ExecuteNonQuery(); } catch (Exception ex) { Debug.WriteLine("iPadActionSerial_DeleteItem:" + ex.ToString()); } } }
public virtual bool Update(ContactForm item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("ContactForms_UpdateItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; sp.Params.Add("@Subject", System.Data.SqlDbType.NVarChar, 255).Value = item.Subject; sp.Params.Add("@To", System.Data.SqlDbType.NVarChar).Value = item.To; sp.Params.Add("@CC", System.Data.SqlDbType.NVarChar).Value = item.CC; sp.Params.Add("@SetForAll", System.Data.SqlDbType.Bit).Value = item.SetForAllForms; result = sp.ExecuteNonQuery() > 0; } return result; }
public static bool Save(string name,string value) { bool result = false; using (StoredProcedure sp = new StoredProcedure("DbConfig_AddUpdateItem")) { sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = name; sp.Params.Add("@Value", System.Data.SqlDbType.NVarChar).Value = value; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Update(SerialNumber item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("SerialNumbers_UpdateItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; sp.Params.Add("@SerialNumber", System.Data.SqlDbType.NVarChar, 20).Value = item.Number; sp.Params.Add("@ServiceID", System.Data.SqlDbType.Int).Value = item.ServiceID; sp.Params.Add("@AdminID", System.Data.SqlDbType.Int).Value = item.AdminID; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool SetOrderNumber(int categoryID,int orderNumber) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Categories_SetOrderNumber")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = categoryID; sp.Params.Add("@OrderNumber", System.Data.SqlDbType.Int).Value = orderNumber; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual int Update(iPadActionSerial item) { int newID = 0; using (StoredProcedure sp = new StoredProcedure("iPadActionSerial_UpdateItem")) { Debug.WriteLine(string.Format("id={0}, status={1}", item.ID, item.Status)); sp.Params.Add("@Status", System.Data.SqlDbType.Int).Value = item.Status; sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; try { sp.ExecuteNonQuery(); } catch (Exception ex) { Debug.WriteLine("iPadActionSerial_UpdateItem:" + ex.ToString()); } } return newID; }
public void ShowInSections(int newID, List<int> sectionsIDs) { RemoveFromAllSections(newID); using (StoredProcedure sp = new StoredProcedure("Stories_AddToSection")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = newID; SqlParameter pid = sp.Params.Add("@SectionID", System.Data.SqlDbType.Int); foreach (int id in sectionsIDs) { pid.Value = id; sp.ExecuteNonQuery(); } } }
public void UpdateEmailStatus(string[] IDs, int type) { string s = string.Join(", ", IDs); string sql = string.Format(@"UPDATE SeminarsRegistration SET SentEmailType=@SentEmailType, EmailSent=@EmailSent WHERE ID in ({0})", s); using (StoredProcedure sp = new StoredProcedure(sql)) { sp.command.CommandType = CommandType.Text; sp.Params.Add("SentEmailType",SqlDbType.Int).Value = type; sp.Params.Add("EmailSent", SqlDbType.DateTime).Value = DateTime.Now; sp.ExecuteNonQuery(); } }
public bool UpdatePdfFile(int groupID, string langCode, byte[] pdffile, string PdfFileName) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Stories_UpdatePdfFile")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NVarChar).Value = langCode; sp.Params.Add("@PdfFile", System.Data.SqlDbType.VarBinary).Value = pdffile; sp.Params.Add("@PdfFileName", System.Data.SqlDbType.NVarChar).Value = PdfFileName; result = sp.ExecuteNonQuery() > 0; } return result; }
public void ShowOnPages(int newID, List<int> pagesIDs) { RemoveFromAllPages(newID); using (StoredProcedure sp = new StoredProcedure("News_AddToPage")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = newID; SqlParameter pid = sp.Params.Add("@PageID", System.Data.SqlDbType.Int); foreach (int id in pagesIDs) { pid.Value = id; sp.ExecuteNonQuery(); } } }
public bool RemoveFromAllSections(int newID) { bool result = false; using (StoredProcedure sp = new StoredProcedure("News_RemoveFromAllSections")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = newID; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool Update(TranslatableText item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("TranslatableTexts_UpdateItem")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode; sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool DeletePdfFile(string LangCode, int GroupID) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Stories_DeletePdfFile")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = GroupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NVarChar).Value = LangCode; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool Update(NewsSubscriber item) { if (!Tools.CheckEmail(item.Email)) throw new InvalidOperationException("Invalid e-mail address"); bool result = false; using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_UpdateItem")) { sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID; sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name; sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool Update(DevelopersLink item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("DevelopersLinks_UpdateItem")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode; sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text; sp.Params.Add("@LinkUrl", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.LinkUrl); sp.Params.Add("@LinkText", System.Data.SqlDbType.NVarChar, 255).Value = item.LinkText; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool Update(NewsItem item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("News_UpdateItem")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode; sp.Params.Add("@Title", System.Data.SqlDbType.NVarChar, 255).Value = item.Title; sp.Params.Add("@Notice", System.Data.SqlDbType.NVarChar, 1024).Value = item.Notice; sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text; sp.Params.Add("@LinkUrl", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.LinkUrl); sp.Params.Add("@LinkText", System.Data.SqlDbType.NVarChar, 255).Value = item.LinkText; sp.Params.Add("@Link2Url", System.Data.SqlDbType.NVarChar, 255).Value = Tools.FixUrl(item.Link2Url); sp.Params.Add("@Link2Text", System.Data.SqlDbType.NVarChar, 255).Value = item.Link2Text; sp.Params.Add("@ImagePosition", System.Data.SqlDbType.Int).Value = item.ImagePosition; sp.Params.Add("@IsActive", System.Data.SqlDbType.Bit).Value = item.IsActive; sp.Params.Add("@IsMain", System.Data.SqlDbType.Bit).Value = item.IsMain; sp.Params.Add("@Date", System.Data.SqlDbType.DateTime).Value = item.Date; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool Update(SuccessStory item) { bool result = false; using (StoredProcedure sp = new StoredProcedure("SuccessStories_UpdateItem")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID; sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode; sp.Params.Add("@Title", System.Data.SqlDbType.NVarChar, 255).Value = item.Title; sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text; sp.Params.Add("@Date", System.Data.SqlDbType.DateTime).Value = item.Date; result = sp.ExecuteNonQuery() > 0; } return result; }
public bool ChangePublishStatus(int groupID) { bool result = false; using (StoredProcedure sp = new StoredProcedure("Services_ChangePublishStatus")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupID; result = sp.ExecuteNonQuery() > 0; } return result; }
public virtual bool UpdateImage(int groupID, byte[] image) { bool result = false; using (StoredProcedure sp = new StoredProcedure("News_UpdateImage")) { sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupID; sp.Params.Add("@ImageFile", System.Data.SqlDbType.VarBinary).Value = image; result = sp.ExecuteNonQuery() > 0; } return result; }