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