public bool Insert_Pin(DataLoad data)
{
bool result = false;
try
{
MoneyDataContext db = new MoneyDataContext();
Pinterest pin = new Pinterest
{
Old_Id = data.OldId,
Board = data.Board,
Backlink = data.Backlink,
Note = data.Note,
Image_Url = data.Image_Url,
Type = data.Type,
Is_Pin = 0,
Created_Date = DateTime.Now
};
db.Pinterests.InsertOnSubmit(pin);
db.SubmitChanges();
result = true;
}
catch (Exception ex) { }
return(result);
}
public Product Insert_Product(DataLoad data)
{
MoneyDataContext db = new MoneyDataContext();
Product prod = new Product
{
Sku = data.Sku,
Group_Id = data.GroupId,
Name = data.Title,
Description = data.Description,
Url_Source = data.Url,
Url_Name = data.UrlName,
ProductTypeId = data.Type,
Image = data.Image,
Price = data.Price,
Keywords = data.Keywords,
CreatedDate = DateTime.Now,
Source_Id = 1
};
try
{
db.Products.InsertOnSubmit(prod);
db.SubmitChanges();
}
catch (Exception ex) { }
return(prod);
}
public ProductType Get_Product_Type_By_Id(int id)
{
MoneyDataContext context = new MoneyDataContext();
var query = from product in context.ProductTypes
where product.Id == id
select product;
return(query.FirstOrDefault());
}
public Category Get_Category_By_Name(string name)
{
MoneyDataContext context = new MoneyDataContext();
var query = from category in context.Categories
where category.Name == name
select category;
return(query.FirstOrDefault());
}
public IEnumerable <ProductType> Get_Product_Type_To_Search()
{
MoneyDataContext context = new MoneyDataContext();
var query = from search in context.ProductTypes
where search.Is_Active == 1
select search;
return(query);
}
public IEnumerable <Category> Get_Parent_Category_To_Search(int id)
{
MoneyDataContext context = new MoneyDataContext();
var query = from search in context.Categories
where search.IsActive == 1 && search.Id == id
select search;
return(query);
}
public IEnumerable <ReachBoardPinterest> Get_Reach_Board()
{
MoneyDataContext context = new MoneyDataContext();
var query = from pin in context.ReachBoardPinterests
where pin.IsLoad == 0
select pin;
return(query);
}
public Pinterest Find_Pin_By_Id(string id)
{
MoneyDataContext context = new MoneyDataContext();
var query = (from pin in context.Pinterests
where pin.Old_Id == id
select pin).FirstOrDefault();
return(query);
}
public IEnumerable <Pinterest> Get_Type_Image_Is_Not_Pin()
{
MoneyDataContext context = new MoneyDataContext();
var query = (from pin in context.Pinterests
where pin.Is_Pin == 0 && pin.Type == 2
select pin)
.Take(1000)
.OrderBy(c => c.Id);
return(query);
}
public void Update_Board(int id)
{
try
{
MoneyDataContext db = new MoneyDataContext();
ReachBoardPinterest prod = (from p in db.ReachBoardPinterests
where p.Id == id
select p).SingleOrDefault();
prod.IsLoad = 1;
db.SubmitChanges();
}
catch (Exception ex) { }
}
public void Update_Pin(int id, string pin_id)
{
try
{
MoneyDataContext db = new MoneyDataContext();
Pinterest prod = (from p in db.Pinterests
where p.Id == id
select p).SingleOrDefault();
prod.PinId = pin_id;
prod.Is_Pin = 1;
prod.Update_Date = DateTime.Now;
db.SubmitChanges();
}
catch (Exception ex) { }
}
public bool Check_Exits_Product(string product_id, int category_id)
{
bool result = false;
try
{
MoneyDataContext db = new MoneyDataContext();
var query = from product in db.Products
join category in db.ProductCategoryDetails on product.Id equals category.Product_Id
where product.Sku == product_id && category.Category.Id == category_id
select product;
if (query.Count() > 0)
{
result = true;
}
}
catch (Exception ex) { }
return(result);
}
public bool Insert_Product_Link_Pinterest(long product_id, int pinterest_id)
{
bool result = false;
try
{
MoneyDataContext db = new MoneyDataContext();
ProductPinterest prod = new ProductPinterest
{
ProductId = product_id,
PinId = pinterest_id
};
db.ProductPinterests.InsertOnSubmit(prod);
db.SubmitChanges();
result = true;
}
catch (Exception ex) { }
return(result);
}
public bool Insert_Product_Category(long product_id, int category_id)
{
bool result = false;
try
{
MoneyDataContext db = new MoneyDataContext();
ProductCategoryDetail prod = new ProductCategoryDetail
{
Product_Id = product_id,
Category_Id = category_id
};
db.ProductCategoryDetails.InsertOnSubmit(prod);
db.SubmitChanges();
result = true;
}
catch (Exception ex) { }
return(result);
}
// Insert Pinterest
public Pinterest Insert_Pinterest(long product_id, DataLoad data)
{
MoneyDataContext db = new MoneyDataContext();
Pinterest prod = new Pinterest
{
Board = data.Tag,
Backlink = data.UrlName,
Note = data.Description,
Image_Url = data.Image,
Type = 1,
Is_Pin = 0,
Created_Date = DateTime.Now
};
try
{
db.Pinterests.InsertOnSubmit(prod);
db.SubmitChanges();
}
catch (Exception ex) { }
return(prod);
}
