public virtual List<TranslatableText> GetAll()
{
List<TranslatableText> all = new List<TranslatableText>();
using (StoredProcedure sp = new StoredProcedure("TranslatableTexts_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
TranslatableText item = new TranslatableText();
item.ID = Convert.ToString(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Text = Convert.ToString(r["Value"]);
all.Add(item);
}
}
}
}
return all;
}
public Service GetByLangGroup(string language, int groupId)
{
Service item = null;
using (StoredProcedure sp = new StoredProcedure("Services_GetByLangGroup"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupId;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new Service();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.Telephone = Convert.ToString(r["Telephone"]);
item.ServiceStatusID = Convert.ToInt32(r["ServiceStatusID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.CityID = Convert.ToInt32(r["CityID"]);
item.RegionID = Convert.ToInt32(r["RegionID"]);
item.Address = Convert.ToString(r["Address"]);
item.Url = Convert.ToString(r["Url"]);
item.Publish = Convert.ToBoolean(r["Publish"]);
}
}
}
return item;
}
public List<iPadActionSerial> GetAll()
{
List<iPadActionSerial> items = new List<iPadActionSerial>();
using (StoredProcedure sp = new StoredProcedure("iPadActionSerial_GetAll"))
{
var r = sp.ExecuteReader();
if (r != null)
{
while (r.Read())
{
iPadActionSerial item = new iPadActionSerial {
BuyDate = Convert.ToDateTime(r["BuyDate"]),
Email = Convert.ToString(r["Email"]),
Seller = Convert.ToInt32(r["Seller"]),
ID = Convert.ToInt32(r["ID"]),
Serial = Convert.ToString(r["Serial"]),
SellerName = Convert.ToString(r["SellerName"]),
Status = Convert.ToInt32(r["Status"])
};
items.Add(item);
}
}
}
return items;
}
public List<SerialNumber> GetAll()
{
List<SerialNumber> all = new List<SerialNumber>();
using (StoredProcedure sp = new StoredProcedure("SerialNumbers_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SerialNumber item = new SerialNumber();
item.ID = Convert.ToInt32(r["ID"]);
item.Number = Convert.ToString(r["SerialNumber"]);
item.ServiceID = NullableConverter.ToInt32(r["ServiceID"]);
item.AdminID = Convert.ToInt32(r["AdminID"]);
item.CreatedDate = Convert.ToDateTime(r["CreatedDate"]);
item.ModifiedDate = NullableConverter.ToDateTime(r["ModifiedDate"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual List<HomePageBlock> GetAll(string langCode)
{
List<HomePageBlock> all = new List<HomePageBlock>();
using (StoredProcedure sp = new StoredProcedure("HomePageBlocks_GetAll"))
{
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = langCode;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
HomePageBlock item = new HomePageBlock();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.LinkUrl = Convert.ToString(r["LinkUrl"]);
item.LinkText = Convert.ToString(r["LinkText"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.IsActive = Convert.ToBoolean(r["IsActive"]);
item.DateCreated = Convert.ToDateTime(r["DateCreated"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual List<SuccessStory> GetAll(string language)
{
List<SuccessStory> all = new List<SuccessStory>();
using (StoredProcedure sp = new StoredProcedure("SuccessStories_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SuccessStory item = new SuccessStory();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Title = Convert.ToString(r["Title"]);
item.Text = Convert.ToString(r["Text"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.PdfFileName = Convert.ToString(r["PdfFileName"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual List<SuccessStory> GetByLang(string langCode)
{
List<SuccessStory> all = new List<SuccessStory>();
using (StoredProcedure sp = new StoredProcedure("SuccessStory_GetByLang"))
{
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = langCode;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SuccessStory item = new SuccessStory();
item.ID = Convert.ToInt32(r["ID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Title = Convert.ToString(r["Title"]);
item.Text = Convert.ToString(r["Text"]);
item.Date = NullableConverter.ToDateTime(r["Date"]);
item.HasImage = Convert.ToBoolean(r["HasImage"]);
item.HasPdfFile = Convert.ToBoolean(r["HasPdfFile"]);
item.PdfFileName = Convert.ToString(r["PdfFileName"]);
all.Add(item);
}
}
}
}
return all;
}
//
public List<City> GetAllByLanguage(string language)
{
List<City> all = new List<City>();
using (StoredProcedure sp = new StoredProcedure("Cities_GetAllByLanguage"))
{
sp.Params.Add("@LangCode", SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
City item = new City();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.RegionID = Convert.ToInt32(r["RegionID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
all.Add(item);
}
}
}
}
return all;
}
public List<Service> GetAllByLanguage(string language)
{
List<Service> all = new List<Service>();
using (StoredProcedure sp = new StoredProcedure("Services_GetAllByLanguage"))
{
sp.Params.Add("@LangCode", SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
Service item = new Service();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.Telephone = Convert.ToString(r["Telephone"]);
item.ServiceStatusID = Convert.ToInt32(r["ServiceStatusID"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.CityID = Convert.ToInt32(r["CityID"]);
item.Url = Convert.ToString(r["Url"]);
item.Publish = Convert.ToBoolean(r["Publish"]);
all.Add(item);
}
}
}
}
return all;
}
public List<Product> GetAllByLanguage(string language)
{
List<Product> all = new List<Product>();
using (StoredProcedure sp = new StoredProcedure("Products_GetAllByLanguage"))
{
sp.Params.Add("@LangCode", SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
Product item = new Product();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.CategoryID = Convert.ToInt32(r["CategoryID"]);
item.Url = Convert.ToString(r["Url"]);
item.ImageLenght = Convert.ToInt32(r["ImageLenght"]);
all.Add(item);
}
}
}
}
return all;
}
public List<DownloadUserForm> GetByFileID(int id)
{
List<DownloadUserForm> res = new List<DownloadUserForm>();
using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM DownloadUserForms WHERE FileID = @FileID")))
{
sp.command.CommandType = CommandType.Text;
sp.Params.Add("FileID", SqlDbType.NVarChar).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
DownloadUserForm d = new DownloadUserForm();
d.Url = r.GetString(r.GetOrdinal("Url"));
d.FileID = r.GetInt32(r.GetOrdinal("FileID"));
d.ID = r.GetInt32(r.GetOrdinal("ID"));
d.Email = r.GetString(r.GetOrdinal("Email"));
d.FirstName = r.GetString(r.GetOrdinal("FirstName"));
d.LastName = r.GetString(r.GetOrdinal("LastName"));
res.Add(d);
}
}
}
}
return res;
}
public List<Specialization> GetAllByLanguage(string language)
{
List<Specialization> all = new List<Specialization>();
using (StoredProcedure sp = new StoredProcedure("Specializations_GetAllByLanguage"))
{
sp.Params.Add("@LangCode", SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
Specialization item = new Specialization();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.Description = Convert.ToString(r["Description"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
all.Add(item);
}
}
}
}
return all;
}
public virtual ContactForm GetByID(int id)
{
ContactForm item = null;
using (StoredProcedure sp = new StoredProcedure("ContactForms_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new ContactForm(r);
}
}
}
return item;
}
public LogMessage GetByID(int id)
{
LogMessage item = null;
using (StoredProcedure sp = new StoredProcedure("Log_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new LogMessage(r);
}
}
}
return item;
}
public StatusRequest GetByID(int id)
{
StatusRequest item = null;
using (StoredProcedure sp = new StoredProcedure("StatusRequests_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new StatusRequest(r);
}
}
}
return item;
}
public PageHtml GetByName(string name)
{
PageHtml item = null;
using (StoredProcedure sp = new StoredProcedure("PagesHtml_GetByID"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 100).Value = name;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new PageHtml(r);
}
}
}
return item;
}
public NewsSubscriber GetByID(int id)
{
NewsSubscriber item = null;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new NewsSubscriber(r);
}
}
}
return item;
}
public virtual ContactForm GetByName(string name)
{
ContactForm item = null;
using (StoredProcedure sp = new StoredProcedure("ContactForms_GetByName"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = name;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new ContactForm(r);
}
}
}
return item;
}
public virtual List<ContactForm> GetAll()
{
List<ContactForm> all = new List<ContactForm>();
using (StoredProcedure sp = new StoredProcedure("ContactForms_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
ContactForm item = new ContactForm(r);
all.Add(item);
}
}
}
}
return all;
}
public List<LogMessage> GetAll()
{
List<LogMessage> all = new List<LogMessage>();
using (StoredProcedure sp = new StoredProcedure("Log_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
LogMessage item = new LogMessage(r);
all.Add(item);
}
}
}
}
return all;
}
public List<NewsSubscriber> GetAll()
{
List<NewsSubscriber> all = new List<NewsSubscriber>();
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
NewsSubscriber item = new NewsSubscriber(r);
all.Add(item);
}
}
}
}
return all;
}
public List<SeminarRegistration> GetAll()
{
List<SeminarRegistration> all = new List<SeminarRegistration>();
using (StoredProcedure sp = new StoredProcedure("SeminarsRegistration_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
SeminarRegistration item = new SeminarRegistration(r);
all.Add(item);
}
}
}
}
return all;
}
public List<PageHtml> GetAll()
{
List<PageHtml> all = new List<PageHtml>();
using (StoredProcedure sp = new StoredProcedure("PagesHtml_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
PageHtml item = new PageHtml(r);
all.Add(item);
}
}
}
}
return all;
}
public ServiceStatus GetByID(int id)
{
ServiceStatus item = null;
using (StoredProcedure sp = new StoredProcedure("ServiceStatuses_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new ServiceStatus();
item.ID = Convert.ToInt32(r["ID"]);
item.Name = Convert.ToString(r["Name"]);
item.Description = Convert.ToString(r["Description"]);
}
}
}
return item;
}
public virtual Language GetByCode(string code)
{
Language item = null;
using (StoredProcedure sp = new StoredProcedure("Languages_GetByID"))
{
sp.Params.Add("@Code", System.Data.SqlDbType.NChar, 2).Value = code;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new Language();
item.Code = Convert.ToString(r["Code"]);
item.Locale = Convert.ToString(r["Locale"]);
item.Description = Convert.ToString(r["Description"]);
}
}
}
return item;
}
public List<StatusRequest> GetAll()
{
List<StatusRequest> all = new List<StatusRequest>();
using (StoredProcedure sp = new StoredProcedure("StatusRequests_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
StatusRequest item = new StatusRequest(r);
all.Add(item);
}
}
}
}
return all;
}
public virtual List<AdminPage> GetAll()
{
List<AdminPage> all = new List<AdminPage>();
using (StoredProcedure sp = new StoredProcedure("AdminPages_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
AdminPage item = new AdminPage(r);
all.Add(item);
}
}
}
}
return all;
}
public DownloadUserForm GetByIds(int id)
{
DownloadUserForm res = new DownloadUserForm();
using (StoredProcedure sp = new StoredProcedure(string.Format("SELECT * FROM DownloadUserForms WHERE ID = ", id)))
{
sp.command.CommandType = CommandType.Text;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
}
}
}
}
return res;
}
public List<ContentSection> GetAll()
{
List<ContentSection> all = new List<ContentSection>();
using (StoredProcedure sp = new StoredProcedure("ContentSections_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
ContentSection item = new ContentSection(r);
all.Add(item);
}
}
}
}
return all;
}
public static DbConfigItem GetByID(string id)
{
DbConfigItem item = null;
using (StoredProcedure sp = new StoredProcedure("DbConfig_GetByID"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar,255).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new DbConfigItem();
item.Name = Convert.ToString(r["Name"]);
item.Value = Convert.ToString(r["Value"]);
item.DateCreated = Convert.ToDateTime(r["DateCreated"]);
}
}
}
return item;
}
