public virtual int Add(NewsItem item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("News_AddItem"))
{
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("@ImageFile", System.Data.SqlDbType.VarBinary).Value = item.ImageFile;
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;
sp.Params.Add("@OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(ServiceSpecialization item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("ServiceSpecialization_AddSpecialization"))
{
sp.Params.Add("@ServiceID", System.Data.SqlDbType.NChar).Value = item.ServiceID;
sp.Params.Add("@SpecializationID", System.Data.SqlDbType.NVarChar).Value = item.SpecializationID;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(ContentPage item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("ContentPages_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(SerialNumber item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("SerialNumbers_AddItem"))
{
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;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(LogMessage item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Log_AddItem"))
{
sp.Params.Add("@MessageType", System.Data.SqlDbType.Int).Value = item.MessageType;
sp.Params.Add("@Source", System.Data.SqlDbType.NVarChar, 255).Value = item.Source;
sp.Params.Add("@Message", System.Data.SqlDbType.NVarChar).Value = item.Message;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(Admin item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Admins_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 100).Value = item.Name;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 100).Value = item.Email;
sp.Params.Add("@Password", System.Data.SqlDbType.NVarChar, 50).Value = item.Password;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public virtual int Add(iPadActionSerial item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("iPadActionSerial_AddItem"))
{
sp.Params.Add("@BuyDate", System.Data.SqlDbType.DateTime).Value = item.BuyDate;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar).Value = item.Email;
sp.Params.Add("@Serial", System.Data.SqlDbType.NVarChar).Value = item.Serial;
sp.Params.Add("@Seller", System.Data.SqlDbType.Int).Value = item.Seller;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(NewsSubscriber item)
{
if (!Tools.CheckEmail(item.Email))
throw new InvalidOperationException("Invalid e-mail address");
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public virtual int Add(TranslatableText item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("TranslatableTexts_AddItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.NVarChar,50).Value = item.ID;
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;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int AddUpdate(City item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Cities_AddUpdateItem"))
{
sp.Params.Add("LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("RegionID", System.Data.SqlDbType.Int).Value = item.RegionID;
sp.Params.Add("Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
sp.Params.Add("GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
public virtual int Add(ContactForm item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("ContactForms_AddItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
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;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int Add(SeminarRegistration item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("SeminarsRegistration_AddItem"))
{
sp.Params.Add("@CompanyName", System.Data.SqlDbType.NVarChar, 255).Value = item.CompanyName;
sp.Params.Add("@FIO", System.Data.SqlDbType.NVarChar, 255).Value = item.FIO;
sp.Params.Add("@JobTitle", System.Data.SqlDbType.NVarChar, 255).Value = item.JobTitle;
sp.Params.Add("@JobAction", System.Data.SqlDbType.VarChar, 20).Value = item.JobAction;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
sp.Params.Add("@Site", System.Data.SqlDbType.NVarChar, 255).Value = item.Site;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int AddUpdate(Product item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Products_AddUpdateItem"))
{
sp.Params.Add("LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
sp.Params.Add("GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
sp.Params.Add("CategoryID", System.Data.SqlDbType.Int).Value = item.CategoryID;
sp.Params.Add("Url", System.Data.SqlDbType.NVarChar).Value = Tools.FixUrl(item.Url);
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
public int Add(AdminPage item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("AdminPages_AddItem"))
{
sp.Params.Add("@ParentID", System.Data.SqlDbType.Int).Value = item.ParentID;
sp.Params.Add("@Title", System.Data.SqlDbType.NVarChar, 50).Value = item.Title;
sp.Params.Add("@Url", System.Data.SqlDbType.NVarChar, 250).Value = item.Url;
sp.Params.Add("@Control", System.Data.SqlDbType.NVarChar, 250).Value = item.Control;
sp.Params.Add("@OrderID", System.Data.SqlDbType.Int).Value = item.OrderID;
sp.Params.Add("@Active", System.Data.SqlDbType.Bit).Value = item.Active;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public virtual int Add(DevelopersLink item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("DevelopersLinks_AddItem"))
{
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;
sp.Params.Add("@OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public virtual int Add(HomePageBlock item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("HomePageBlocks_AddItem"))
{
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("@ImageFile", System.Data.SqlDbType.VarBinary).Value = item.ImageFile;
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("@IsActive", System.Data.SqlDbType.Bit).Value = item.IsActive;
sp.Params.Add("@OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int AddUpdate(Specialization item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Specializations_AddUpdateItem"))
{
sp.Params.Add("LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
if (!string.IsNullOrEmpty(item.Description))
{
sp.Params.Add("Description", System.Data.SqlDbType.NVarChar).Value = item.Description;
}
sp.Params.Add("Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
sp.Params.Add("GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
public static int GetNextGroupID()
{
int result = -1;
try
{
using (StoredProcedure sp = new StoredProcedure("GetNextSeqeuenceValue"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = SequenceID;
result = Convert.ToInt32(sp.ExecuteScalar());
}
return result;
}
catch (Exception)
{
return result;
}
}
public int Add(StatusRequest item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_AddItem"))
{
sp.Params.Add("@Status", System.Data.SqlDbType.NVarChar, 5).Value = item.Status;
sp.Params.Add("@CompanyName", System.Data.SqlDbType.NVarChar, 255).Value = item.CompanyName;
sp.Params.Add("@ContactName", System.Data.SqlDbType.NVarChar, 255).Value = item.ContactName;
sp.Params.Add("@Address", System.Data.SqlDbType.NVarChar, 255).Value = item.Address;
sp.Params.Add("@Phone", System.Data.SqlDbType.VarChar, 20).Value = item.Phone;
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 255).Value = item.Email;
sp.Params.Add("@IsPartner", System.Data.SqlDbType.Bit).Value = item.IsPartner;
sp.Params.Add("@IsServicePartner", System.Data.SqlDbType.Bit).Value = item.IsServicePartner;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public int AddUpdate(Feedback item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Feedback_Add"))
{
sp.Params.Add("FirstName", System.Data.SqlDbType.NVarChar).Value = item.FirstName;
sp.Params.Add("LastName", System.Data.SqlDbType.NVarChar).Value = item.LastName;
sp.Params.Add("Telephone", System.Data.SqlDbType.NVarChar).Value = item.Telephone;
sp.Params.Add("EMail", System.Data.SqlDbType.NVarChar).Value = item.EMail;
sp.Params.Add("Company", System.Data.SqlDbType.NVarChar).Value = item.Company;
sp.Params.Add("Position", System.Data.SqlDbType.NVarChar).Value = item.Position;
sp.Params.Add("Comment", System.Data.SqlDbType.NVarChar).Value = item.Comment;
sp.Params.Add("UserInfo", System.Data.SqlDbType.NVarChar).Value = item.UserInfo;
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
public bool Check2yearWarranty(string number)
{
List<string> list = new List<string>();
//
using (StoredProcedure sp = new StoredProcedure("SELECT count(Serial) FROM iPadActionSerial WHERE Status = 1"))
{
sp.command.CommandType = System.Data.CommandType.Text;
int cnt = (int)sp.ExecuteScalar();
if (cnt > 0) return true;
}
//using (StoredProcedure sp = new StoredProcedure("SELECT count(Serial) FROM MacActionSerial WHERE Status = 1"))
//{
// sp.command.CommandType = System.Data.CommandType.Text;
// int cnt = (int)sp.ExecuteScalar();
// if (cnt > 0) return true;
//}
return false;
}
public int AddUpdate(Service item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Services_AddUpdateItem"))
{
sp.Params.Add("LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("ServiceStatusID", System.Data.SqlDbType.Int).Value = item.ServiceStatusID;
sp.Params.Add("Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
sp.Params.Add("Address", System.Data.SqlDbType.NVarChar).Value = item.Address;
sp.Params.Add("Telephone", System.Data.SqlDbType.NVarChar).Value = item.Telephone;
sp.Params.Add("GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("CityID", System.Data.SqlDbType.Int).Value = item.CityID;
sp.Params.Add("RegionID", System.Data.SqlDbType.Int).Value = item.RegionID;
sp.Params.Add("Url", System.Data.SqlDbType.NVarChar).Value = Tools.FixUrl(item.Url);
//sp.Params.Add("Publish", System.Data.SqlDbType.Bit).Value = item.Publish;
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
public virtual int Add(SuccessStory item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("SuccessStories_AddItem"))
{
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("@ImageFile", System.Data.SqlDbType.VarBinary).Value = item.ImageFile;
sp.Params.Add("@PdfFile", System.Data.SqlDbType.VarBinary).Value = item.PdfFile;
sp.Params.Add("@Text", System.Data.SqlDbType.NVarChar).Value = item.Text;
sp.Params.Add("@Date", System.Data.SqlDbType.DateTime).Value = item.Date;
sp.Params.Add("@PdfFileName", System.Data.SqlDbType.DateTime).Value = item.PdfFileName;
newID = Convert.ToInt32(sp.ExecuteScalar());
}
return newID;
}
public bool Login(string email, string password)
{
bool result = false;
try
{
if (!String.IsNullOrEmpty(email) && !String.IsNullOrEmpty(password))
{
using (StoredProcedure sp = new StoredProcedure("Admins_FindItem"))
{
sp.Params.Add("@Email", System.Data.SqlDbType.NVarChar, 100).Value = email;
sp.Params.Add("@Password", System.Data.SqlDbType.NVarChar, 50).Value = password;
result = Convert.ToInt32(sp.ExecuteScalar()) > 0;
}
}
}
catch { }
return result;
}
