public override async void Execute(object parameter)
{
var album = parameter as AlbumItem;
if (album == null)
{
return;
}
// If the album is favorite, then now it is not
// if the album was not favorite, now it is
album.Favorite = !album.Favorite;
var albumDatabase = new AlbumDatabase();
// updating the FavoriteAlbums collection
if (album.Favorite)
{
Locator.MusicLibraryVM.FavoriteAlbums.Add(album);
// if the album is already in the list then don't add it, simply
if (Locator.MusicLibraryVM.RandomAlbums.FirstOrDefault(x => x.Id == album.Id) == null)
{
Locator.MusicLibraryVM.RandomAlbums.Add(album);
}
}
else if (Locator.MusicLibraryVM.FavoriteAlbums.Contains(album))
{
Locator.MusicLibraryVM.FavoriteAlbums.Remove(album);
Locator.MusicLibraryVM.RandomAlbums.Remove(album);
}
// Update database;
await albumDatabase.Update(album);
}
public JsonResult UpdatePrise(int photo_id, int cart_itemqua)
{
int i = 0;
AlbumDatabase mod = new AlbumDatabase();
mod = repoc.detail(photo_id, repou.GetUserId(User.Identity.Name));
if (mod.cart_itemqua > cart_itemqua)
{
i = repoc.DecreesCartItem(repou.GetUserId(User.Identity.Name), photo_id);
}
else
{
i = repoc.updateprise(photo_id, repou.GetUserId(User.Identity.Name));
}
if (i >= 0)
{
repo.UpdatesellQuantity(cart_itemqua, photo_id);
int total_prise = repoc.totalPrise(repou.GetUserId(User.Identity.Name), photo_id);
var jsonResult = Json(total_prise, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
else
{
var message = "failed";
var jsonResult = Json(message, JsonRequestBehavior.AllowGet);
return(jsonResult);
}
}
public AlbumViewModel()
{
albumDatabase = App.Container.Resolve <AlbumDatabase>();
albumApi = App.Container.Resolve <AlbumApi>();
photoApi = App.Container.Resolve <PhotoApi>();
userApi = App.Container.Resolve <UserApi>();
GetDatabase();
}
public AlbumDatabase detail(int photo_id, int u_id)
{
//Add Database connections string Data
String connections = ("Server=;Port=;Database=;User Id=;Password="******"select * from \"mg_cartData\" where a_id=@a_id and u_id=@u_id";
connection.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, connection);
cmd.Parameters.AddWithValue("@a_id", photo_id);
cmd.Parameters.AddWithValue("@u_id", u_id);
try
{
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
mod.cart_itemqua = Convert.ToInt32(dr["cart_itemqua"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
connection.Close();
}
return(mod);
}
public int totalPrise(int u_id, int photo_id)
{
//Add Database connections string Data
String connections = ("Server=;Port=;Database=;User Id=;Password="******"select sum(mg_albumstore.a_price*mg_cartData.cart_itemqua) as total_prise from mg_albumstore left outer join mg_cartData on mg_albumstore.a_id=mg_cartData.a_id where u_id=@u_id";
connection.Open();
NpgsqlCommand cmd = new NpgsqlCommand(query, connection);
cmd.Parameters.AddWithValue("@u_id", u_id);
cmd.Parameters.AddWithValue("@a_id", photo_id);
try
{
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
mod.a_price = Convert.ToInt32(dr["total_prise"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
connection.Close();
}
return(mod.a_price);
}
