protected void Page_Load(object sender, EventArgs e)
{
MembershipUser u;
u = Membership.GetUser(User.Identity.Name);
Guid key = (Guid)u.ProviderUserKey;
String keyString = key.ToString();
TextBox address = (TextBox)FormViewPayment.FindControl("txtboxAddress");
GalleryEntities1 _db = new GalleryEntities1();
if (Roles.IsUserInRole("Artists"))
{
artist = _db.ARTISTs.Find(key);
address.Text = artist.Address;
}
else
{
customer = _db.CUSTOMERs.Find(key);
address.Text = customer.Address;
}
//address.Text = u.a
TextBox email = (TextBox)FormViewPayment.FindControl("txtboxEmail");
email.Text = u.Email;
email.Enabled = false;
Session["email"] = email.Text;
double total1 = Convert.ToDouble(Session["total"]);
TextBox txtboxTotal = (TextBox)FormViewPayment.FindControl("txtboxTotal");
txtboxTotal.Text = String.Format("{0:0.00}", total1);
}
// Artists ----------------------------------------
private List <ARTIST> AllArtistList()
{
var list = new List <ARTIST>();
try
{
var rows = DbHelper.Query("SELECT * FROM ARTISTS");
foreach (DataRow row in rows)
{
var artist = new ARTIST();
artist.ARTIST_NAME = (string)row["ARTIST_NAME"];
artist.ARTIST_ID = (int)row["ARTIST_ID"];
artist.ARTIST_IMG = (string)row["ARTIST_IMG"];
list.Add(artist);
}
return(list);
}
catch (Exception e)
{
return(list);
}
}
public ActionResult DeleteConfirmed(decimal id)
{
ARTIST artist = db.ARTISTs.Find(id);
db.ARTISTs.Remove(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Artist/Delete/5
public ActionResult Delete(decimal id = 0)
{
ARTIST artist = db.ARTISTs.Find(id);
if (artist == null)
{
return(HttpNotFound());
}
return(View(artist));
}
public ActionResult Edit(ARTIST artist)
{
if (ModelState.IsValid)
{
db.Entry(artist).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}
public ActionResult Create(ARTIST artist)
{
if (ModelState.IsValid)
{
db.ARTISTs.Add(artist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(artist));
}
// private List<ALBUM> GetTopAlbums2()
// {
// List<ALBUM> organize = new List<ALBUM>();
// try
// {
// var rows = DbHelper.Query("SELECT TOP 2 RELEASE_YEAR, ALBUM_NAME, ALBUM_ART, BAND_NAME FROM ALBUMS ORDER BY RELEASE_YEAR DESC; ");
// foreach (DataRow row in rows)
// {
// var album = new ALBUM
// {
// RELEASE_YEAR = (int)row["RELEASE_YEAR"],
// ALBUM_NAME = (string)row["ALBUM_NAME"],
// ALBUM_ART = (string)row["ALBUM_ART"],
// BAND_NAME = (string)row["BAND_NAME"]
// };
// organize.Add(album);
// }
// return organize;
// }
// catch (Exception)
// {
// return organize;
// }
// }
private ARTIST GetRandomArtist()
{
var artist = new ARTIST();
var allArtists = AllArtistList();
int r = rnd.Next(allArtists.Count);
artist = allArtists[r];
return(artist);
}
protected void Page_Load(object sender, EventArgs e)
{
u = Membership.GetUser(User.Identity.Name);
_db = new Models.GalleryEntities1();
Guid key = (Guid)u.ProviderUserKey;
String keyString = key.ToString();
if (Roles.IsUserInRole("Artists"))
{
artist = _db.ARTISTs.Find(key);
}
else
{
customer = _db.CUSTOMERs.Find(key);
}
for (int i = 2003; i >= 1950; i--)
{
ListItem item = new ListItem(i + "", i + "");
ddlYear.Items.Add(item);
}
if (!IsPostBack)
{
tbEmail.Text = u.Email;
if (artist != null)
{
tbName.Text = artist.Name;
tbAddress.Text = artist.Address;
tbContact.Text = artist.ContactNo;
date = (DateTime)artist.DateOfBirth;
}
else
{
tbName.Text = customer.Name;
tbAddress.Text = customer.Address;
tbContact.Text = customer.ContactNo;
date = (DateTime)customer.DateOfBirth;
}
ddlYear.SelectedValue = date.Year.ToString();
ddlMonth.SelectedValue = date.Month.ToString();
updateDay();
}
}
public ActionResult Create(FormCollection collection)
{
try
{
ARTIST artist = db.ARTISTS.Create();
artist.ArtistName = collection["artistName"];
artist.BirthCity = collection["birthCity"];
artist.BirthDate = collection["birthDate"];
db.ARTISTS.Add(artist);
db.SaveChanges();
return(RedirectToAction("Artists"));
}
catch
{
return(View());
}
}
