private void BindData()
{
PersonBiz pBiz = new PersonBiz();
lwg_Person person = pBiz.GetByID(this.ComposerId);
if (person != null)
{
txtDOB.Text = person.DOB;
txtDOD.Text = person.DOD;
txtFirstName.Text = (String)person.FirstName;
txtLastName.Text = (String)person.LastName;
txtNameDisplay.Text = (String)person.NameDisplay;
txtNameList.Text = (String)person.NameList;
txtNameSort.Text = (String)person.NameSort;
txtBiography.Content = Server.HtmlDecode(person.Biography);
if (person.PictureID.HasValue)
{
if (person.PictureID.Value > 0)
{
Picture Picture = PictureManager.GetPictureById(person.PictureID.Value);
this.btnRemoveImage.Visible = Picture != null;
string pictureUrl = PictureManager.GetPictureUrl(Picture, 100);
this.iPicture.Visible = true;
this.iPicture.ImageUrl = pictureUrl;
}
}
}
}
public List <lwg_Person> GetTopComposer(int number)
{
if (number > 0)
{
List <lwg_Person> lstResult = new List <lwg_Person>();
var query = from temp in dbContext.lwg_PersonInRole
where temp.RoleId == LWGUtils.COMPOSER_ROLE_ID
group temp by temp.PersonId into g
orderby g.Count() descending
select g.Key;
int j = 0;
var lwg_PersonTmp = dbContext.lwg_Person.ToList();
foreach (int i in query)
{
if (j < number)
{
lwg_Person lwg = lwg_PersonTmp.SingleOrDefault(lg => lg.PersonId == i);
if (lwg != null)
{
lstResult.Insert(lstResult.Count, lwg);
}
j++;
}
else
{
break;
}
}
return(lstResult);
}
return(null);
}
public bool DeletePerson(long PersonId)
{
lwg_Person person = GetByID(PersonId);
if (person != null)
{
dbContext.lwg_Person.Remove(person);
dbContext.SaveChanges();
return(true);
}
return(false);
}
public lwg_Person SaveImport(lwg_Person p)
{
if (dbContext.lwg_Person.Count() > 0)
{
p.PersonId = dbContext.lwg_Person.Max(ct => ct.PersonId) + 1;
}
else
{
p.PersonId = 1;
}
dbContext.lwg_Person.Add(p);
dbContext.SaveChanges();
return(p);
}
protected void btnRemoveImage_Click(object sender, EventArgs e)
{
lwg_Person person = null;
PersonBiz pbiz = new PersonBiz();
person = pbiz.GetByID(this.ComposerId);
if (person != null)
{
PictureManager.DeletePicture(person.PictureID.Value);
person.PictureID = 0;
pbiz.SavePerson(person);
btnRemoveImage.Visible = false;
BindData();
}
}
public bool SavePerson(lwg_Person h)
{
if (h != null)
{
if (h.PersonId > 0)
{
lwg_Person c = dbContext.lwg_Person.SingleOrDefault(ht => ht.PersonId == h.PersonId);
if (c != null)
{
c.Biography = h.Biography;
c.DOB = h.DOB;
c.DOD = h.DOD;
c.FirstLetter = h.FirstLetter;
c.FirstName = h.FirstName;
c.LastName = h.LastName;
c.NameDisplay = h.NameDisplay;
c.NameList = h.NameList;
c.NameSort = h.NameSort;
c.PictureID = h.PictureID;
}
else
{
return(false);
}
}
else
{
if (dbContext.lwg_Person.Count() > 0)
{
h.PersonId = dbContext.lwg_Person.Max(ct => ct.PersonId) + 1;
}
else
{
h.PersonId = 1;
}
dbContext.lwg_Person.Add(h);
}
dbContext.SaveChanges();
return(true);
}
return(false);
}
protected void dtlTopComposer_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
lwg_Person obj = (lwg_Person)e.Item.DataItem;
if (obj != null)
{
Label lblNumber = (Label)e.Item.FindControl("lblNumber");
lblNumber.Text = (e.Item.ItemIndex + 1).ToString();
HyperLink lblName = (HyperLink)e.Item.FindControl("lblName");
lblName.Text = obj.NameDisplay;
lblName.NavigateUrl = string.Format("~/ComposerDetails.aspx?ComposerID={0}", obj.PersonId);
PersonBiz pBiz = new PersonBiz();
Label lblProductNumber = (Label)e.Item.FindControl("lblProductNumber");
lblProductNumber.Text = pBiz.CountTotalProductWithComposerRole(obj.PersonId).ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string title = GetLocaleResourceString("PageTitle.ComposerDetailsPage");
SEOHelper.RenderTitle(this, title, true);
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ComposerID"]))
{
string PId = Request.QueryString["ComposerID"].ToString();
long PersonId = 0;
if (long.TryParse(PId, out PersonId))
{
try
{
PersonBiz pb = new PersonBiz();
lwg_Person person = pb.GetByID(PersonId);
if (person != null)
{
this.litName.Text = person.NameDisplay;
this.lblName.Text = person.NameDisplay;
this.Literal1.Text = "About " + person.NameDisplay;
if (!String.IsNullOrEmpty(person.Biography))
{
this.Literal2.Text = Custring(person.Biography);
}
if (person.PictureID.HasValue)
{
if (person.PictureID.Value > 0)
{
Picture Picture = PictureManager.GetPictureById(person.PictureID.Value);
string pictureUrl = PictureManager.GetPictureUrl(Picture, 150);
this.iPicture.Visible = true;
this.iPicture.ImageUrl = pictureUrl;
}
}
else
{
iPicture.ImageUrl = PictureManager.GetDefaultPictureUrl(SettingManager.GetSettingValueInteger("Media.Product.DetailImageSize", 150));
}
}
else
{
Response.Write("This composer doesn't exist.");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return;
}
}
// Invalid Person ID. Go to Composers page or 404 page.
Response.Redirect("~/MeetComposers.aspx");
}
}
public string SaveInfo()
{
PersonBiz pBiz = new PersonBiz();
lwg_Person person = pBiz.GetByID(this.ComposerId);
Picture pic = null;
if (person == null)
{
person = new lwg_Person();
}
else
{
if (person.PictureID.HasValue)
{
if (person.PictureID.Value > 0)
{
pic = PictureManager.GetPictureById(person.PictureID.Value);
}
}
}
HttpPostedFile PictureFile = fuPicture.PostedFile;
if ((PictureFile != null) && (!String.IsNullOrEmpty(PictureFile.FileName)))
{
byte[] pictureBinary = PictureManager.GetPictureBits(PictureFile.InputStream, PictureFile.ContentLength);
if (pic != null)
{
pic = PictureManager.UpdatePicture(pic.PictureId, pictureBinary, PictureFile.ContentType, true);
}
else
{
pic = PictureManager.InsertPicture(pictureBinary, PictureFile.ContentType, true);
}
}
int PictureId = 0;
if (pic != null)
{
PictureId = pic.PictureId;
}
person.Biography = Server.HtmlEncode(txtBiography.Content);
if (txtDOB.Text.Trim() != person.DOB)
{
person.DOB = txtDOB.Text.Trim();
}
if (txtDOD.Text.Trim() != person.DOD)
{
person.DOD = txtDOD.Text.Trim();
}
string lastName = txtLastName.Text.Trim();
person.FirstLetter = lastName.Length > 0 ? lastName.Substring(0, 1).ToUpper() : string.Empty;
person.FirstName = txtFirstName.Text.Trim();
person.LastName = lastName;
person.NameDisplay = txtNameDisplay.Text.Trim();
person.NameList = txtNameList.Text.Trim();
person.NameSort = txtNameSort.Text.Trim();
person.PictureID = PictureId;
pBiz.SavePerson(person);
return(person.PersonId.ToString());
}
