/// <summary>
/// Create Help
/// </summary>
/// <returns> long</returns>
public long CreateProduct(ProductDTO 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;
}
public List<ProductDTO> ReadAllProducts()
{
List<ProductDTO> productList = new List<ProductDTO>();
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 = new ProductDTO();
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 ProductDTO ReadProductBySeoTitle(string seoTitle)
{
var productDTO = new ProductDTO();
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;
}
private ProductDTO getProductDTO(ProductItemViewModel productMaster, bool creatingProduct)
{
ProductDTO product = new ProductDTO();
try
{
product.ProductId = 1;
product.Name = "Pay TTm";// productMaster.Title.Trim();
product.Content = productMaster.Content.Trim();
product.ContentText = productMaster.ContentText;
if (creatingProduct)
{
//product.CreatedBy = this.LoggedInUserID;
}
/* else
{
help.ModifiedBy = this.LoggedInUserID;
if (!string.IsNullOrEmpty(helpMaster.HelpCode))
help.HelpCode = helpMaster.HelpCode.Trim();
} */
}
catch (Exception ex)
{
//ExceptionManager.HandleException(ex);
}
return product;//
}