/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
Proxy productService = new Proxy();
int productId = Convert.ToInt32(this.hfldProductId.Value);
string productName = this.txtProductName.Text.ToString().Trim();
decimal productPrice = Convert.ToDecimal(this.txtProductPrice.Text);
int categoryId = Convert.ToInt32(this.ddlCategorylist.SelectedValue);
ProductBE product = new ProductBE();
product.ProductId = productId;
product.ProductName = productName;
product.ProductPrice = productPrice;
product.CategoryId = categoryId;
CategoryBE category = new CategoryBE();
category.CategoryId = categoryId;
product.Category = category;
productService.UpdateProduct(product);
Response.Redirect("ProductList.aspx");
}
public IList <SongBE> GetCategorySongs(CategoryBE category, UserBE user)
{
try
{
var dbContext = new DBContext();
var dataSet = new DataSet();
List <SongBE> songs = new List <SongBE>();
var parameters = new SqlParameter[2];
parameters[0] = dbContext.CreateParameters("@categoryID", category.Id);
parameters[1] = dbContext.CreateParameters("@userID", user.Id);
dataSet = dbContext.Read("GetCategorySongs", parameters);
if (dataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
var song = new SongBE()
{
Id = Helper.GetGuidDB(dr["SongID"]),
Name = Helper.GetStringDB(dr["Name"]),
UploadDate = Helper.GetDateTimeDB(dr["UploadDate"]),
Playbacks = Helper.GetIntDB(dr["Playbacks"]),
SongKey = Helper.GetStringDB(dr["SongKey"])
};
if (Helper.GetGuidDB(dr["AlbumID"]) != Guid.Empty)
{
song.Album = new AlbumBE()
{
Id = Helper.GetGuidDB(dr["AlbumID"]),
Name = Helper.GetStringDB(dr["AlbumName"]),
ImgKey = Helper.GetStringDB(dr["ImgKey"])
};
}
;
song.User = new UserBE()
{
Id = Helper.GetGuidDB(dr["UserID"]),
UserName = Helper.GetStringDB(dr["ArtistName"])
};
songs.Add(song);
}
}
return(songs);
}
catch (Exception ex)
{
throw new Exception(Messages.Generic_Error);
}
}
/// <summary>
/// Inserts the product.
/// </summary>
/// <param name="productBE">The product BE.</param>
public void InsertProduct()
{
ProductBE productBE = new ProductBE();
productBE.ProductName = View.ProductName;
productBE.ProductPrice = View.ProductPrice;
productBE.CategoryId = View.CategoryId;
CategoryBE categoryBE = new CategoryBE();
categoryBE.CategoryId = View.CategoryId;
productBE.Category = categoryBE;
_controller.InsertProduct(productBE);
}
/// <summary>
/// Translate CategoryBE To Category
/// </summary>
/// <param name="categoryBE"></param>
/// <returns></returns>
public Category Translate(CategoryBE categoryBE)
{
if (categoryBE != null)
{
Category CategoryDE = new Category();
CategoryDE.CategoryId = categoryBE.CategoryId;
CategoryDE.CategoryName = categoryBE.CategoryName;
return(CategoryDE);
}
else
{
return(null);
}
}
/// <summary>
/// Gets all categories.
/// </summary>
/// <param name="dbEntity">The db entity.</param>
/// <returns></returns>
public List <CategoryBE> GetAllCategories(TTAEntityContainer dbEntity)
{
List <CategoryBE> listCategoryBE = new List <CategoryBE>();
CategoryTranslator categoryTranslator = new CategoryTranslator();
List <Category> categoryDEList = (from Category category in dbEntity.Categories
select category).ToList <Category>();
foreach (Category categoryDE in categoryDEList)
{
CategoryBE categoryBE = categoryTranslator.Translate(categoryDE);
listCategoryBE.Add(categoryBE);
}
return(listCategoryBE);
}
/// <summary>
/// Updates the product.
/// </summary>
/// <param name="productBE">The product BE.</param>
public void UpdateProduct()
{
ProductBE product = new ProductBE();
product.ProductId = View.ProductId;
product.ProductName = View.ProductName;
product.ProductPrice = View.ProductPrice;
product.CategoryId = View.CategoryId;
CategoryBE category = new CategoryBE();
category.CategoryId = View.CategoryId;
product.Category = category;
_controller.UpdateProduct(product);
}
internal static CategoryBE Get(DbDataRecord row)
{
var category = new CategoryBE();
category.CategoryID = DataUtilities.GetInt32(row["CategoryID"]).Value;
category.CategoryName = DataUtilities.GetString(row["CategoryName"]);
category.Description = DataUtilities.GetString(row["Description"]);
var dbCommand = Provider.GetDbCommand("SELECT Picture FROM Categories WHERE CategoryID = ?");
Data.DataUtilities.Utilities.SetValue(dbCommand, category.CategoryID);
category.Picture = DAC.EjecutarEscalar(dbCommand) as byte[];
return(category);
}
/// <summary>
/// Translate Category To CategoryBE
/// </summary>
/// <param name="categoryDE"></param>
/// <returns></returns>
public CategoryBE Translate(Category categoryDE)
{
if (categoryDE != null)
{
CategoryBE categoryBE = new CategoryBE()
{
CategoryId = categoryDE.CategoryId,
CategoryName = categoryDE.CategoryName
};
return(categoryBE);
}
else
{
return(null);
}
}
public IList <SongBE> GetSongsToCalculate(CategoryBE category)
{
try
{
var dbContext = new DBContext();
var dataSet = new DataSet();
List <SongBE> songs = new List <SongBE>();
var parameters = new SqlParameter[1];
parameters[0] = dbContext.CreateParameters("@categoryID", category.Id);
dataSet = dbContext.Read("GetSongsToCalculate", parameters);
if (dataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
var song = new SongBE()
{
Id = Helper.GetGuidDB(dr["SongID"]),
Name = Helper.GetStringDB(dr["Name"]),
UploadDate = Helper.GetDateTimeDB(dr["UploadDate"]),
Playbacks = Helper.GetIntDB(dr["Playbacks"]),
SongKey = Helper.GetStringDB(dr["SongKey"])
};
songs.Add(song);
}
}
return(songs);
}
catch (Exception ex)
{
throw new Exception(Messages.Generic_Error);
}
}
private IList <SongBE> GetCategorySongs(CategoryBE category, UserBE user)
{
SongDAL songDAL = new SongDAL();
return(songDAL.GetCategorySongs(category, user));
}
