public List <IProductDTO> ReadAllProducts()
{
List <IProductDTO> productList = new List <IProductDTO>();
try
{
if (1 > 0)
{
using (var tmcDBContext = new TMCContext())
{
var products = (from blog in tmcDBContext.Products
select blog).ToList();
foreach (var product in products)
{
var productDTO = (IProductDTO)DTOFactory.Instance.Create(DTOType.Product);
productDTO.ProductId = product.ProductId;
productDTO.Description = product.Description;
productDTO.Name = product.Name;
productDTO.SeoTitle = product.SeoTitle;
productDTO.ImageURL = product.ImageURL;
productList.Add(productDTO);
}
}
}
}
catch (Exception ex)
{
//ExceptionManager.HandleException(ex);
//throw new DACException("Error while fetching the organization locations.", ex);
}
return(productList);
}
public IProductDTO ReadProductBySeoTitle(string seoTitle)
{
var productDTO = (IProductDTO)DTOFactory.Instance.Create(DTOType.Product);
try
{
if (1 > 0)
{
using (var tmcDBContext = new TMCContext())
{
var product = (from blog in tmcDBContext.Products
where blog.SeoTitle == seoTitle && blog.IsActive == true
select blog).SingleOrDefault();
productDTO.ProductId = product.ProductId;
productDTO.Description = product.Description;
productDTO.Name = product.Name;
productDTO.Content = product.Content;
productDTO.SeoTitle = product.SeoTitle;
productDTO.ImageURL = product.ImageURL;
}
}
}
catch (Exception ex)
{
//ExceptionManager.HandleException(ex);
//throw new DACException("Error while fetching the organization locations.", ex);
}
return(productDTO);
}
public List <BlogDTO> ReadAllBlogs()
{
List <BlogDTO> blogList = new List <BlogDTO>();
try
{
if (1 > 0)
{
using (var tmcDBContext = new TMCContext())
{
var blogs = (from blog in tmcDBContext.Blogs
select blog).ToList();
foreach (var blog in blogs)
{
var blogDTO = new BlogDTO();
blogDTO.BlogId = blog.Id;
blogDTO.Description = blog.Description;
blogList.Add(blogDTO);
}
}
}
}
catch (Exception ex)
{
//ExceptionManager.HandleException(ex);
//throw new DACException("Error while fetching the organization locations.", ex);
}
return(blogList);
}
/// <summary>
/// Create Help
/// </summary>
/// <returns> long</returns>
public long CreateProduct(IProductDTO productDto)
{
long helpMasterID = int.MinValue;
using (var tmcDBContext = new TMCContext())
{
var productItem = (from product in tmcDBContext.Products
where product.ProductId == 1 && product.IsActive == true
select product).SingleOrDefault();
productItem.Content = productDto.Content;
productItem.ContentText = productDto.ContentText;
//productItem.IsActive = false;
tmcDBContext.Products.AddOrUpdate(productItem);
tmcDBContext.SaveChanges();
}
/* try
* {
* using (IDatabase db = DatabaseFactory.CreateDatabase())
* {
* db.Connect();
* db.BeginTransaction();
* db.CreateDBCommand(DatabaseConstants.Procedures.prc_ins_tbl_HelpMaster, System.Data.CommandType.StoredProcedure);
*
* db.AddParameter("HELPMASTERID", DbType.Int64, (object)help.HelpMasterID, ParameterDirection.InputOutput);
* db.AddParameter("PRODUCTID", DbType.Int32, HelpDAC.ValidateDataObject(help.ProductID));
* db.AddParameter("SITEID", DbType.Int32, HelpDAC.ValidateDataObject(help.SiteID));
* db.AddParameter("ISFOLDER", DbType.Boolean, HelpDAC.ValidateDataObject(help.IsFolder));
* db.AddParameter("PARENTCODE", DbType.String, HelpDAC.ValidateDataObject(help.ParentCode));
* db.AddParameter("TITLE", DbType.String, HelpDAC.ValidateDataObject(help.Title));
* db.AddParameter("CONTENT", DbType.String, HelpDAC.ValidateDataObject(help.Content));
* db.AddParameter("CONTENTTEXT", DbType.String, HelpDAC.ValidateDataObject(help.ContentText));
* db.AddParameter("HELPCODE", DbType.String, HelpDAC.ValidateDataObject(help.HelpCode));
* db.AddParameter("LANGUAGEID", DbType.Int32, HelpDAC.ValidateDataObject(help.LanguageID));
* db.AddParameter("CREATEDBY", DbType.Int64, HelpDAC.ValidateDataObject(help.CreatedBy));
*
* db.ExecuteNonQuery();
* helpMasterID = db.GetOutputParameterValue<long>("HELPMASTERID");
*
* if (helpMasterID > 0)
* {
* db.Commit();
* }
* else
* {
* db.Rollback();
* }
* }
* }
* catch (Exception ex)
* {
* ExceptionManager.HandleException(ex);
* throw new DACException("An exception Saving Help", ex);
* }*/
return(1);
}
