protected void btnExport_Click(object sender, EventArgs e)
{
object data = GeneralFunction.GetReportDataCache();
if (data != null)
{
List <Entry> flist = (List <Entry>)data;
XLWorkbook workbook = new XLWorkbook();
MemoryStream memoryStream = new MemoryStream();
int x = 1;
int y = 1;
string sheetName = "Jury View Scores";
workbook.Worksheets.Add(sheetName);
x = 1;
// Jury information
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(jury.SerialNo); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(jury.FirstName + " " + jury.LastName); x++;
y++;
#region Basic Entry Headers
x = 1;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("No."); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 3; x++;
// basic details
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entry Id"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 7.71; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Category"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 13.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entry Title"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 13.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entrant"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 13.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Client"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 13.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Brand"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 13.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Country"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 8.14; x++;
#endregion
#region Score Headers
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("SC"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("ID"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("IL"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("RE"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("SC(C)"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("ID(C)"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("IL(C)"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("RE(C)"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Total Composite Score"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Scoring Status"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 8.14; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Advancement"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 10; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Jury Flag"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 5.43; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Flag remarks"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 50; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Reason remarks - Strongest element"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 50; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Reason remarks - Weakest element"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 50; x++;
//workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Recuse"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Additional remarks"); workbook.Worksheets.Worksheet(sheetName).Column(x).Width = 50; x++;
#endregion
y++;
foreach (Entry entry in flist)
{
x = 1;
#region Basic Entry DataRows
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue((y - 2).ToString()); x++;
// Basic Details
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(entry.Serial); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(GeneralFunction.GetEntryMarket(entry.CategoryMarketFromRound(round)) + " - " + entry.CategoryPSDetailFromRound(round)); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(entry.Campaign); x++;
// client and agency
CompanyCreditList cclist = CompanyCreditList.GetCompanyCreditList(entry.Id);
string client = "";
try
{
client = cclist[0].Company;
}
catch { }
Registration reg = GeneralFunction.GetRegistrationFromEntry(entry);
if (reg != null)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(reg.Company); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(reg.Country); x++;
}
else
{
x = x + 2;
}
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(client); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(entry.Brand); x++;
// scoring
Score score = GeneralFunction.GetScoreFromMatchingEntryCache(entry, jury.Id, round);
if (score != null)
{
bool isRecuse = false;
if (score.IsAdminRecuse || score.IsRecuse)
{
isRecuse = true;
}
if (!isRecuse)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.ScoreSC); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.ScoreID); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.ScoreIL); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.ScoreRE); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(GeneralFunction.CalculateSC(score.ScoreSC)); workbook.Worksheets.Worksheet(sheetName).Cell(y, x).Style.NumberFormat.Format = "#,##0.00"; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(GeneralFunction.CalculateID(score.ScoreID)); workbook.Worksheets.Worksheet(sheetName).Cell(y, x).Style.NumberFormat.Format = "#,##0.00"; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(GeneralFunction.CalculateIL(score.ScoreIL)); workbook.Worksheets.Worksheet(sheetName).Cell(y, x).Style.NumberFormat.Format = "#,##0.00"; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(GeneralFunction.CalculateRE(score.ScoreRE)); workbook.Worksheets.Worksheet(sheetName).Cell(y, x).Style.NumberFormat.Format = "#,##0.00"; x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.ScoreComposite); workbook.Worksheets.Worksheet(sheetName).Cell(y, x).Style.NumberFormat.Format = "#,##0.00"; x++;
}
else
{
// pop with X
for (int i = 0; i < 9; i++)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("X"); x++;
}
}
// status
if (score.IsSubmitted)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Completed");
}
else
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Pending");
}
if (isRecuse)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Recused");
}
x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue((score.IsAdvancement) ? "Y" : "N"); x++;
// flag and remarks
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.Flag); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.FlagOthers); x++;
// comments
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.FeedbackStrong); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.FeedbackWeak); x++;
//workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(recuse); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(score.AdditionalComments); x++;
}
else
{
x = x + 9;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Pending");
}
#endregion
y++;
}
workbook.SaveAs(memoryStream);
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=Effie_Jury_View_Scores_" + jury.SerialNo + ".xlsx");
memoryStream.WriteTo(Response.OutputStream);
Response.End();
}
}
protected void radGridEntry_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
Effie2017.App.Entry entry = (Effie2017.App.Entry)e.Item.DataItem;
ScoreList slist = GeneralFunction.GetAllScoreCache(false);
Score score = GeneralFunction.GetScoreFromMatchingEntryCache(entry, jury.Id, round);
if (entry == null)
{
return;
}
LinkButton lnkBtn = null;
Label lbl = null;
HyperLink lnk = null;
//// Edit button
//lnkBtn = (LinkButton)e.Item.FindControl("lnkBtnEdit");
//Security.SecureControlByHiding(lnkBtn);
// Entry Id
lbl = (Label)e.Item.FindControl("lbSerial");
lbl.Text = entry.Serial;
// Campaign title
lbl = (Label)e.Item.FindControl("lbCampaign");
lbl.Text = entry.Campaign;
// Category
lbl = (Label)e.Item.FindControl("lbCategory");
//lbl.Text = GeneralFunction.GetEntryMarket(entry.CategoryMarketFromRound(round)) + "<br/>" + entry.CategoryPSDetailFromRound(round);
lbl.Text = entry.CategoryPSDetailFromRound(round);
// submitted by
lbl = (Label)e.Item.FindControl("lnkBtnBuSubmittedBy");
Registration reg = GeneralFunction.GetRegistrationFromEntry(entry);
lbl.Text = "-";
if (reg != null)
{
lbl.Text = reg.Company;
//lnkBtn.CommandArgument = reg.Id.ToString();
}
// client and agency
CompanyCreditList cclist = CompanyCreditList.GetCompanyCreditList(entry.Id);
try
{
lbl = (Label)e.Item.FindControl("lbClient");
lbl.Text = cclist[0].Company;
//lbl = (Label)e.Item.FindControl("lbAgency1");
//lbl.Text = cclist[1].Company;
//lbl = (Label)e.Item.FindControl("lbAgency2");
//lbl.Text = cclist[2].Company;
//lbl = (Label)e.Item.FindControl("lbAgency3");
//lbl.Text = cclist[3].Company;
//lbl = (Label)e.Item.FindControl("lbAgency4");
//lbl.Text = cclist[4].Company;
//lbl = (Label)e.Item.FindControl("lbAgency5");
//lbl.Text = cclist[5].Company;
}
catch { }
// Brand
lbl = (Label)e.Item.FindControl("lbBrand");
lbl.Text = entry.Brand;
// Country
lbl = (Label)e.Item.FindControl("lbCountry");
lbl.Text = "-";
if (reg != null)
{
lbl.Text = reg.Country;
}
if (score != null)
{
// Raw score
lbl = (Label)e.Item.FindControl("lbScoreSCRaw");
lbl.Text = score.ScoreSC.ToString();
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// ID
lbl = (Label)e.Item.FindControl("lbScoreIDRaw");
lbl.Text = score.ScoreID.ToString();
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// IL
lbl = (Label)e.Item.FindControl("lbScoreILRaw");
lbl.Text = score.ScoreIL.ToString();
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// RE
lbl = (Label)e.Item.FindControl("lbScoreRERaw");
lbl.Text = score.ScoreRE.ToString();
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// Weighted scores
// SC
lbl = (Label)e.Item.FindControl("lbScoreSC");
lbl.Text = GeneralFunction.CalculateSC(score.ScoreSC).ToString("N");
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// ID
lbl = (Label)e.Item.FindControl("lbScoreID");
lbl.Text = GeneralFunction.CalculateID(score.ScoreID).ToString("N");
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// IL
lbl = (Label)e.Item.FindControl("lbScoreIL");
lbl.Text = GeneralFunction.CalculateIL(score.ScoreIL).ToString("N");
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// RE
lbl = (Label)e.Item.FindControl("lbScoreRE");
lbl.Text = GeneralFunction.CalculateRE(score.ScoreRE).ToString("N");
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// composite score
lbl = (Label)e.Item.FindControl("lbScoreComposite");
lbl.Text = score.ScoreComposite.ToString("N");
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "X";
}
// Status
lbl = (Label)e.Item.FindControl("lbScoreStatus");
lbl.Text = "Pending";
lbl.ForeColor = System.Drawing.Color.Gray;
if (score.IsSubmitted)
{
lbl.Text = "Completed";
lbl.ForeColor = System.Drawing.Color.Green;
}
if (score.IsAdminRecuse || score.IsRecuse)
{
lbl.Text = "Recused";
lbl.ForeColor = System.Drawing.Color.Gray;
}
// Flag
lbl = (Label)e.Item.FindControl("lbJuryFlag");
lbl.Text = "-";
if (score.Flag != "")
{
lbl.Text = score.Flag;
}
// Jury Recuse Flag
lbl = (Label)e.Item.FindControl("lbJuryRecuse");
lbl.Text = "";
if (score.IsRecuse)
{
lbl.Text = "Y";
}
// Recuse
lbl = (Label)e.Item.FindControl("lbRecuse");
lbl.Text = "";
if (score.IsAdminRecuse)
{
lbl.Text = "Y";
}
// Advancement
lbl = (Label)e.Item.FindControl("lbAdvancement");
lbl.Text = "-";
lbl.Text = ((score.IsRecuse || score.IsAdminRecuse) ? "-" : ((score.IsAdvancement) ? "Y" : "N"));
}
//Action
lnkBtn = (LinkButton)e.Item.FindControl("lnkScore");
if (score != null)
{
lnkBtn.CommandArgument = score.EntryId.ToString();
lnkBtn.Visible = true;
}
// Reset
lnkBtn = (LinkButton)e.Item.FindControl("lnkReset");
if (score != null && score.IsSubmitted)
{
lnkBtn.CommandArgument = score.Id.ToString();
lnkBtn.Visible = true;
}
if (Security.IsReadOnlyAdmin())
{
lnkBtn.Visible = false;
}
// chkboxes
//CheckBox chkbox = (CheckBox)e.Item.FindControl("chkbox");
//Security.SecureControlByHiding(chkbox);
}
}
protected void radGridEntry_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
Effie2017.App.Entry entry = (Effie2017.App.Entry)e.Item.DataItem;
LinkButton lnkBtn, lnkBtn2 = null;
Label lbl = null;
HyperLink lnk = null;
// Categories
lbl = (Label)e.Item.FindControl("lbCategory");//GeneralFunction.GetEntryMarket(entry.CategoryMarketFromRound(round)) + "<br/>" +
lbl.Text = entry.CategoryPSDetailFromRound(round);
// submitted by
lbl = (Label)e.Item.FindControl("lnkBtnBuSubmittedBy");
Registration reg = GeneralFunction.GetRegistrationFromEntry(entry);
lbl.Text = "-";
if (reg != null)
{
lbl.Text = reg.Company;
//lnkBtn.CommandArgument = reg.Id.ToString();
}
// Country
lbl = (Label)e.Item.FindControl("lbCountry");
lbl.Text = "-";
if (reg != null)
{
lbl.Text = reg.Country;
}
// client and agency
CompanyCreditList cclist = CompanyCreditList.GetCompanyCreditList(entry.Id);
try
{
lbl = (Label)e.Item.FindControl("lbClient");
lbl.Text = cclist[0].Company;
lbl = (Label)e.Item.FindControl("lbAgency1");
lbl.Text = cclist[1].Company;
lbl = (Label)e.Item.FindControl("lbAgency2");
lbl.Text = cclist[2].Company;
lbl = (Label)e.Item.FindControl("lbAgency3");
lbl.Text = cclist[3].Company;
lbl = (Label)e.Item.FindControl("lbAgency4");
lbl.Text = cclist[4].Company;
lbl = (Label)e.Item.FindControl("lbAgency5");
lbl.Text = cclist[5].Company;
}
catch { }
//// submitted details
//lbl = (Label)e.Item.FindControl("lblSubmittedDetails");
//lbl.Text = reg.Firstname + " " + reg.Lastname + "<br/>" + reg.Job + "<br/>" + GeneralFunction.ShowFriendlyContact(reg.Contact) + "<br/>" + reg.Email;
// Jury panel 1
List <JuryPanelCategory> jcpList = GeneralFunction.GetJuryPanelCategoryFromCategoryPS(entry.CategoryMarketFromRound(round), entry.CategoryPSFromRound(round), entry.CategoryPSDetailFromRound(round), round);
if (jcpList != null && jcpList.Count > 0)
{
lbl = (Label)e.Item.FindControl("lbJuryPanel");
lbl.Text = jcpList[0].PanelId;
}
// Jury panel round2
// Jury
List <EffieJuryManagementApp.Jury> jlist = GeneralFunction.GetJuryListFromEntryCategory(entry.CategoryMarketFromRound(round), entry.CategoryPSFromRound(round), entry.CategoryPSDetailFromRound(round), round);
DisplayJury(e, "lbJury1", jlist, 0);
DisplayJury(e, "lbJury2", jlist, 1);
DisplayJury(e, "lbJury3", jlist, 2);
DisplayJury(e, "lbJury4", jlist, 3);
DisplayJury(e, "lbJury5", jlist, 4);
DisplayJury(e, "lbJury6", jlist, 5);
DisplayJury(e, "lbJury7", jlist, 6);
DisplayJury(e, "lbJury8", jlist, 7);
DisplayJury(e, "lbJury9", jlist, 8);
DisplayJury(e, "lbJury10", jlist, 9);
DisplayJury(e, "lbJury11", jlist, 10);
DisplayJury(e, "lbJury12", jlist, 11);
DisplayJury(e, "lbJury13", jlist, 12);
DisplayJury(e, "lbJury14", jlist, 13);
DisplayJury(e, "lbJury15", jlist, 14);
DisplayJury(e, "lbJury16", jlist, 15);
DisplayJury(e, "lbJury17", jlist, 16);
DisplayJury(e, "lbJury18", jlist, 17);
DisplayJury(e, "lbJury19", jlist, 18);
DisplayJury(e, "lbJury20", jlist, 19);
//// chkboxes
//CheckBox chkbox = (CheckBox)e.Item.FindControl("chkbox");
//Security.SecureControlByHiding(chkbox);
}
else if (e.Item.ItemType == GridItemType.Pager)
{
RadComboBox PageSizeCombo = (RadComboBox)e.Item.FindControl("PageSizeComboBox");
PageSizeCombo.Items.Clear();
//PageSizeCombo.Items.Add(new RadComboBoxItem("20", "20"));
//PageSizeCombo.FindItemByText("20").Attributes.Add("ownerTableViewId", radGridEntry.MasterTableView.ClientID);
PageSizeCombo.Items.Add(new RadComboBoxItem("50", "50"));
PageSizeCombo.FindItemByText("50").Attributes.Add("ownerTableViewId", radGridEntry.MasterTableView.ClientID);
PageSizeCombo.Items.Add(new RadComboBoxItem("100", "100"));
PageSizeCombo.FindItemByText("100").Attributes.Add("ownerTableViewId", radGridEntry.MasterTableView.ClientID);
PageSizeCombo.Items.Add(new RadComboBoxItem("200", "200"));
PageSizeCombo.FindItemByText("200").Attributes.Add("ownerTableViewId", radGridEntry.MasterTableView.ClientID);
PageSizeCombo.Items.Add(new RadComboBoxItem("All", "99999"));
PageSizeCombo.FindItemByText("All").Attributes.Add("ownerTableViewId", radGridEntry.MasterTableView.ClientID);
string PageSize = e.Item.OwnerTableView.PageSize.ToString();
PageSizeCombo.FindItemByValue(PageSizeDefault.ToString()).Selected = true;
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
object data = GeneralFunction.GetReportDataCache();
if (data != null)
{
List <Entry> flist = (List <Entry>)data;
XLWorkbook workbook = new XLWorkbook();
MemoryStream memoryStream = new MemoryStream();
int x = 1;
int y = 1;
string sheetName = "Jury Assignment";
workbook.Worksheets.Add(sheetName);
x = 1;
#region Basic Entry Headers
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("No."); x++;
// Entry headers
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entry Id"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("CategoryPS"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entry Title"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Entrant"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Client"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Brand"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Country"); x++;
// agency headers
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency1"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency2"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency3"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency4"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency5"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency6"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency7"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Agency8"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Round 1 Jury Panel"); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Round 2 Jury Panel"); x++;
// jude headers
for (int i = 1; i <= 20; i++)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue("Judge" + i.ToString()); x++;
}
#endregion
y++;
foreach (Entry ent in flist)
{
x = 1;
Registration reg = GeneralFunction.GetRegistrationFromEntry(ent);
CompanyCreditList cclist = CompanyCreditList.GetCompanyCreditList(ent.Id);
List <JuryPanelCategory> jcpList = GeneralFunction.GetJuryPanelCategoryFromCategoryPS(ent.CategoryMarketFromRound(round), ent.CategoryPSFromRound(round), ent.CategoryPSDetailFromRound(round), round);
List <EffieJuryManagementApp.Jury> jlist = GeneralFunction.GetJuryListFromEntryCategory(ent.CategoryMarketFromRound(round), ent.CategoryPSFromRound(round), ent.CategoryPSDetailFromRound(round), round);
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue((y - 1).ToString()); x++;
// Entry Details
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(ent.Serial); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(ent.CategoryPSDetailFromRound(round)); x++; //GeneralFunction.GetEntryMarket(ent.CategoryMarketFromRound(round)) + " - " +
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(ent.Campaign); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(reg.Company); x++;
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[0].Company); x++; } catch { x++; }
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(ent.Brand); x++;
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(reg.Country); x++;
// Agency Details
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[1].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[2].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[3].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[4].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[5].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[6].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[7].Company); x++; } catch { x++; }
try { workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(cclist[8].Company); x++; } catch { x++; }
// Jury Panel 1
if (jcpList != null && jcpList.Count > 0)
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(jcpList[0].PanelId); x++;
}
// Jury Panel 2
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(""); x++;
// Jury 1 to 20
for (int i = 0; i < 20; i++)
{
try
{
if (!GeneralFunction.IsRecuse(ent, jlist[i].Id, round))
{
workbook.Worksheets.Worksheet(sheetName).Cell(y, x).SetValue(jlist[i].FirstName + " " + jlist[i].LastName + " / " + jlist[i].Company);
}
x++;
}
catch { x++; }
}
y++;
}
workbook.SaveAs(memoryStream);
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=Effie_Jury_Assignment.xlsx");
memoryStream.WriteTo(Response.OutputStream);
Response.End();
}
}
protected bool OnCloningData(string Id)
{
Entry entry_Old = Entry.GetEntry(new Guid(Id));
Entry entry_New = Entry.NewEntry();
if (entry_Old != null)
{
entry_New.Id = Guid.NewGuid();
entry_New.Campaign = entry_Old.Campaign;
entry_New.Client = entry_Old.Client;
entry_New.Brand = entry_Old.Brand;
entry_New.CategoryMarket = ""; //entry_Old.CategoryMarket;
entry_New.CategoryPS = ""; //entry_Old.CategoryPS;
entry_New.CategoryPSDetail = ""; //entry_Old.CategoryPSDetail;
//entry_New.CategoryMarket = entry_Old.CategoryMarket;
//entry_New.CategoryPS = entry_Old.CategoryPS;
//entry_New.CategoryPSDetail = entry_Old.CategoryPSDetail;
entry_New.DateCampaignStartString = entry_Old.DateCampaignStartString;
entry_New.DateCampaignEndString = entry_Old.DateCampaignEndString;
entry_New.IsCampaignOngoing = entry_Old.IsCampaignOngoing;
entry_New.RepSalutation = entry_Old.RepSalutation;
entry_New.RepFirstname = entry_Old.RepFirstname;
entry_New.RepLastname = entry_Old.RepLastname;
entry_New.RepJob = entry_Old.RepJob;
entry_New.RepCompany = entry_Old.RepCompany;
entry_New.RepContact = entry_Old.RepContact;
entry_New.RepMobile = entry_Old.RepMobile;
entry_New.RepEmail = entry_Old.RepEmail;
entry_New.Effectiveness = entry_Old.Effectiveness;
entry_New.Summary = entry_Old.Summary;
entry_New.ProductClassification = entry_Old.ProductClassification;
entry_New.EntryObjective = entry_Old.EntryObjective;
entry_New.EntryObjective2 = entry_Old.EntryObjective2;
entry_New.TargetAudience = entry_Old.TargetAudience;
entry_New.TargetAudiencePri = entry_Old.TargetAudiencePri;
entry_New.TargetAudienceOthers = entry_Old.TargetAudienceOthers;
entry_New.TargetAudiencePriOthers = entry_Old.TargetAudiencePriOthers;
entry_New.HeroTouchPoint = entry_Old.HeroTouchPoint;
entry_New.HeroTouchPointOthers = entry_Old.HeroTouchPointOthers;
entry_New.HeroTouchPoint2 = entry_Old.HeroTouchPoint2;
entry_New.HeroTouchPointOthers2 = entry_Old.HeroTouchPointOthers2;
entry_New.HeroTouchPoint3 = entry_Old.HeroTouchPoint3;
entry_New.HeroTouchPointOthers3 = entry_Old.HeroTouchPointOthers3;
entry_New.SocialPlatforms = entry_Old.SocialPlatforms;
entry_New.SocialPlatformsOthers = entry_Old.SocialPlatformsOthers;
entry_New.Research = entry_Old.Research;
entry_New.ResearchImp = entry_Old.ResearchImp;
entry_New.CaseData = entry_Old.CaseData;
entry_New.SDGData1 = entry_Old.SDGData1;
entry_New.SDGData2 = entry_Old.SDGData2;
entry_New.Permission = entry_Old.Permission;
entry_New.Name = entry_Old.Name;
entry_New.Title = entry_Old.Title;
entry_New.Company = entry_Old.Company;
entry_New.DateModifiedString = DateTime.Now.ToString();
entry_New.DateCreatedString = DateTime.Now.ToString();
entry_New.Status = StatusEntry.Draft;//entry_Old.Status;
//entry_New.WithdrawnStatus = entry_Old.WithdrawnStatus;
entry_New.WithdrawnStatus = "";
//entry_New.DateSubmittedString = entry_Old.DateSubmittedString;
entry_New.RegistrationId = entry_Old.RegistrationId;
entry_New.PayGroupId = Guid.Empty;
//entry_New.ProcessingStatus = entry_Old.ProcessingStatus;
//entry_New.AdminidAssignedto = entry_Old.AdminidAssignedto;
//entry_New.MaterialsSubmitted = entry_Old.MaterialsSubmitted;
//entry_New.DQFlag = entry_Old.DQFlag;
//entry_New.NotificationSentDate = entry_Old.NotificationSentDate;
//entry_New.ReopeningDate = entry_Old.ReopeningDate;
//entry_New.ReopeningDeadline = entry_Old.ReopeningDeadline;
//entry_New.FlagReason = entry_Old.FlagReason;
//entry_New.FlagDQDescription = entry_Old.FlagDQDescription;
//entry_New.ReopenedBy = entry_Old.ReopenedBy;
//entry_New.OtherRemarks = entry_Old.OtherRemarks;
//entry_New.DateVerified = entry_Old.DateVerified;
//entry_New.ReasonFeeWaiver = entry_Old.ReasonFeeWaiver;
entry_New.Save();
CompanyCreditList CompanyCreditOld = CompanyCreditList.GetCompanyCreditList(entry_Old.Id);
foreach (CompanyCredit item in CompanyCreditOld)
{
CompanyCredit CompanyCreditNew = CompanyCredit.NewCompanyCredit();
CompanyCreditNew.ContactType = item.ContactType;
CompanyCreditNew.Company = item.Company;
CompanyCreditNew.Address1 = item.Address1;
CompanyCreditNew.Address2 = item.Address2;
CompanyCreditNew.City = item.City;
CompanyCreditNew.Postal = item.Postal;
CompanyCreditNew.Country = item.Country;
CompanyCreditNew.Salutation = item.Salutation;
CompanyCreditNew.Fullname = item.Fullname;
CompanyCreditNew.Job = item.Job;
CompanyCreditNew.Contact = item.Contact;
CompanyCreditNew.Email = item.Email;
CompanyCreditNew.ClientCompanyNetwork = item.ClientCompanyNetwork;
CompanyCreditNew.ClientCompanyNetworkOthers = item.ClientCompanyNetworkOthers;
CompanyCreditNew.Network = item.Network;
CompanyCreditNew.NetworkOthers = item.NetworkOthers;
CompanyCreditNew.HoldingCompany = item.HoldingCompany;
CompanyCreditNew.HoldingCompanyOthers = item.HoldingCompanyOthers;
CompanyCreditNew.CompanyType = item.CompanyType;
CompanyCreditNew.CompanyTypeOther = item.CompanyTypeOther;
CompanyCreditNew.Status = item.Status;
CompanyCreditNew.EntryId = entry_New.Id;
CompanyCreditNew.Save();
}
return(true);
}
return(false);
}
