public static Entity.PlanRegulation GetById(int idPlanRegulation)
{
using (var context = new Entity.OiWeb())
{
return(context.PlanRegulations.Find(idPlanRegulation));
}
}
public static void Delete(int idPlan, int idPriceGroup)
{
using (var context = new Entity.OiWeb())
{
var deletePrices =
from prices in context.Prices
where prices.idPlan == idPlan &&
prices.idPriceGroup == idPriceGroup
select prices;
foreach (var price in deletePrices)
{
context.Prices.Remove(price);
}
context.SaveChanges();
var deletePlanGroup =
from planGroup in context.PlanGroups
where planGroup.idPlan == idPlan &&
planGroup.idPriceGroup == idPriceGroup
select planGroup;
foreach (var planGroups in deletePlanGroup)
{
context.PlanGroups.Remove(planGroups);
}
context.SaveChanges();
}
}
public static List <Entity.City> GetCititesByDdd(int ddd)
{
using (var context = new Entity.OiWeb())
{
return(context.Cities.Where(w => w.DDD == ddd).ToList());
}
}
public static Entity.City GetCityById(int idCity)
{
using (var context = new Entity.OiWeb())
{
return(context.Cities.Find(idCity));
}
}
public static List <Entity.GroupModal> GetAllGroupModal()
{
using (var context = new Entity.OiWeb())
{
return(context.GroupModals.ToList());
}
}
public static void Delete(int idPage)
{
using (var context = new Entity.OiWeb())
{
var dataGroupCustomDataPages = context.GroupCustomDataPages.Where(p => p.idPage == idPage).ToList();
if (dataGroupCustomDataPages != null)
{
context.GroupCustomDataPages.RemoveRange(dataGroupCustomDataPages);
context.SaveChanges();
}
var dataGroupModalPages = context.GroupModalPages.Where(p => p.idPage == idPage).ToList();
if (dataGroupModalPages != null)
{
context.GroupModalPages.RemoveRange(dataGroupModalPages);
context.SaveChanges();
}
var dataPage = context.Pages.Find(idPage);
if (dataPage != null)
{
context.Pages.Remove(dataPage);
context.SaveChanges();
}
}
}
public static void ExcludeGroupModal(int idGroupModal)
{
using (var context = new Entity.OiWeb())
{
var dataGroupModalPages = context.GroupModalPages.Where(p => p.idGroupModal == idGroupModal).ToList();
if (dataGroupModalPages != null)
{
context.GroupModalPages.RemoveRange(dataGroupModalPages);
context.SaveChanges();
}
var dataGroupModalCities = context.GroupModalCities.Where(p => p.idGroupModal == idGroupModal).ToList();
if (dataGroupModalCities != null)
{
context.GroupModalCities.RemoveRange(dataGroupModalCities);
context.SaveChanges();
}
var data = context.GroupModals.Find(idGroupModal);
if (data != null)
{
context.GroupModals.Remove(data);
context.SaveChanges();
}
}
}
public static void UpdateUser(Entity.CMS_Account account)
{
if (account.password != null)
{
var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(account.password);
account.password = System.Convert.ToBase64String(plainTextBytes);
}
using (var context = new Entity.OiWeb())
{
var query = (from c in context.CMS_Account
where c.idAccount == account.idAccount
select c).First();
query.name = account.name;
if (account.password == "" || account.password == null)
{
account.password = query.password;
}
query.password = account.password;
query.email = account.email;
query.isActive = account.isActive;
context.SaveChanges();
}
}
public static Entity.CustomData GetCustomData(int id_Data)
{
using (var context = new Entity.OiWeb())
{
return(context.CustomDatas.Where(cw => cw.idData == id_Data).FirstOrDefault());
}
}
public static void Insert(Entity.PlanRegulation data)
{
using (var context = new Entity.OiWeb())
{
context.PlanRegulations.Add(data);
context.SaveChanges();
}
}
public static void Insert(PriceGroupCity data)
{
using (var context = new Entity.OiWeb())
{
context.PriceGroupCities.Add(data);
context.SaveChanges();
}
}
public static void Insert(List <PriceGroupCity> datas)
{
using (var context = new Entity.OiWeb())
{
context.PriceGroupCities.AddRange(datas);
context.SaveChanges();
}
}
public static void Create(Entity.CMS_AccountLoginLog accountLoginLog)
{
using (var context = new Entity.OiWeb())
{
context.CMS_AccountLoginLog.Add(accountLoginLog);
context.SaveChanges();
}
}
public static void Save(Entity.PriceGroup group)
{
using (var context = new Entity.OiWeb())
{
context.PriceGroups.Add(group);
context.SaveChanges();
}
}
public static void Insert(List <Entity.GroupCustomDataPage> datas)
{
using (var context = new Entity.OiWeb())
{
context.GroupCustomDataPages.AddRange(datas);
context.SaveChanges();
}
}
public static Entity.Page GetPage(int idPage)
{
using (var context = new Entity.OiWeb())
{
var query = context.Pages.Find(idPage);
return(query);
}
}
public static void Create(Entity.Page page)
{
using (var context = new Entity.OiWeb())
{
context.Pages.Add(page);
context.SaveChanges();
}
}
public static void CreatePlanGroup(Entity.PlanGroup planGroup)
{
using (var context = new Entity.OiWeb())
{
context.PlanGroups.Add(planGroup);
context.SaveChanges();
}
}
public static Entity.ComponentType GetIdentifierParent(string nameComponent, int idGroup, int idVersion)
{
using (var context = new Entity.OiWeb())
{
return(context.ComponentTypes
.Where(cw => cw.identifier == nameComponent).FirstOrDefault());
}
}
public static void Insert(Entity.GroupCustomDataPage data)
{
using (var context = new Entity.OiWeb())
{
context.GroupCustomDataPages.Add(data);
context.SaveChanges();
}
}
public static void Create(Entity.PlanProduct planProduct)
{
using (var context = new Entity.OiWeb())
{
context.PlanProducts.Add(planProduct);
context.SaveChanges();
}
}
public static IEnumerable <Entity.CMS_Account> GetUsers()
{
using (var context = new Entity.OiWeb())
{
var query = from o in context.CMS_Account
select o;
return(query.ToList());
}
}
public static IEnumerable <Entity.Page> GetPages()
{
using (var context = new Entity.OiWeb())
{
var query = from c in context.Pages
select c;
return(query.ToList());
}
}
public static IEnumerable <Entity.ComponentType> GetAllComponentTypes()
{
using (var context = new Entity.OiWeb())
{
var query = from o in context.ComponentTypes
select o;
return(query.ToList());
}
}
public static IEnumerable <Entity.GroupCustomData> GetGroupCustomDatas()
{
using (var context = new Entity.OiWeb())
{
var query = from _G in context.GroupCustomDatas
select _G;
return(query.ToList());
}
}
public static void InsertGroupModal(Entity.GroupModal entity)
{
entity.dtCreate = DateTime.Now;
using (var context = new Entity.OiWeb())
{
context.GroupModals.Add(entity);
context.SaveChanges();
}
}
public static Entity.PlanProduct GetPlan(int idPlan)
{
using (var context = new Entity.OiWeb())
{
var query = from c in context.PlanProducts
where c.idPlan == idPlan
select c;
return(query.FirstOrDefault());
}
}
public static void Create(Entity.GroupCustomData groupCustomData)
{
using (var context = new Entity.OiWeb())
{
groupCustomData.isActive = true;
groupCustomData.dtCreate = DateTime.Now;
context.GroupCustomDatas.Add(groupCustomData);
context.SaveChanges();
}
}
public static void RemoveByIdPriceGroup(int id)
{
using (var context = new Entity.OiWeb())
{
var datas = context.PriceGroupCities.Where(w => w.idPriceGroup == id).ToList();
context.PriceGroupCities.RemoveRange(datas);
context.SaveChanges();
}
}
public static void RemoveByIdGroupAndPage(int idGroup, int idPage)
{
using (var context = new Entity.OiWeb())
{
var datas = context.GroupCustomDataPages.Where(w => w.idGroup == idGroup && w.idPage == idPage).ToList();
context.GroupCustomDataPages.RemoveRange(datas);
context.SaveChanges();
}
}