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