protected void btnSubmit_Click(object sender, EventArgs e)
{
JuryList JuryLists = JuryList.GetJuryList("", "");
foreach (Jury jury in JuryLists)
{
List <CompanyHistory> companies = CompanyHistoryList.GetCompanyHistoryList(jury.Id).OrderByDescending(x => x.DateCreated).ToList();
if (companies.Count > 0)
{ //EDIT HERE
int count = 1;
CompanyHistory CurrCompanyHistory = null;
//EDIT DATE CREATED
foreach (CompanyHistory com in companies)
{
if (count == 1)
{
//NEW COMPANY HISTORY
CompanyHistory compnyHistroy = CompanyHistory.NewCompanyHistory();
SaveCompanyHistory(jury, compnyHistroy, com.DateCreatedString);
}
else
{
SaveCompanyHistory(jury, CurrCompanyHistory, com.DateCreatedString);
}
if (count != companies.Count || companies.Count == 1)
{
CurrCompanyHistory = com;
}
count++;
}
//FOR LATEST COMPANY HISTORY
SaveCompanyHistory(jury, CurrCompanyHistory, jury.DateCreatedString);
}
else
{ //NEW COMPANY HISTORY
CompanyHistory compnyHistroy = CompanyHistory.NewCompanyHistory();
SaveCompanyHistory(jury, compnyHistroy, "Empty");
}
}
}
public void SaveCompanyHistory(Jury jury, ClosedXML.Excel.IXLRangeRow CurrentRow)
{
CompanyHistory compnyHistroy = CompanyHistory.NewCompanyHistory();
compnyHistroy.JuryId = jury.Id;
compnyHistroy.Type = RemoveControlChars(CurrentRow.Cell(2).GetString());
compnyHistroy.Designation = RemoveControlChars(CurrentRow.Cell(7).GetString());
compnyHistroy.Company = RemoveControlChars(CurrentRow.Cell(8).GetString());
compnyHistroy.Country = RemoveControlChars(CurrentRow.Cell(17).GetString());
compnyHistroy.DateModifiedString = DateTime.Now.ToString();
compnyHistroy.Network = RemoveControlChars(CurrentRow.Cell(9).GetString());
compnyHistroy.HoldingCompany = RemoveControlChars(CurrentRow.Cell(10).GetString());
if (compnyHistroy.IsNew)
{
compnyHistroy.DateCreatedString = DateTime.Now.AddYears(-3).ToString();
}
if (compnyHistroy.IsValid)
{
compnyHistroy.Save();
}
}