protected void radGridTemplateHistory_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
EmailSent emailsent = (EmailSent)e.Item.DataItem;
if (emailsent != null)
{
Jury jury = Jury.GetJury(emailsent.JuryId);
if (jury != null)
{
Label lblType = (Label)e.Item.FindControl("lblType");
lblType.Text = jury.Type;
LinkButton lnkBtnJuryId = (LinkButton)e.Item.FindControl("lnkBtnJuryId");
lnkBtnJuryId.Text = jury.SerialNo;
lnkBtnJuryId.CommandArgument = jury.Id.ToString();
HyperLink lnk = (HyperLink)e.Item.FindControl("lnkJuryName");
lnk.Text = jury.FirstName + " " + jury.LastName;
lnk.NavigateUrl = "mailto:" + jury.Email;
}
Label lblEmailTemplate = (Label)e.Item.FindControl("lblEmailTemplate");
lblEmailTemplate.Text = emailsent.TemplateName;
}
}
}
public void PopulateForm()
{
if (inv != null)
{
lblEventYear.Text = inv.EventCode;
Jury jury = Jury.GetJury(inv.JuryId);
lblJuryId.Text = jury.SerialNo;
lblName.Text = jury.FirstName + " " + jury.LastName;
lblCompany.Text = jury.Company;
lblEmail.Text = jury.Email;
lblCountry.Text = jury.Country;
chkInvRound1.Checked = inv.IsRound1Invited;
chkInvRound2.Checked = inv.IsRound2Invited;
//if (inv.IsLocked)
{
chkAccptRound1.Checked = inv.IsRound1Accepted;
chkAccptRound2.Checked = inv.IsRound2Accepted;
chkDecline.Checked = inv.IsDeclined;
}
chkShortListedRound1.Checked = inv.IsRound1Shortlisted;
chkShortListedRound2.Checked = inv.IsRound2Shortlisted;
chkAssignRound1.Checked = inv.IsRound1Assigned;
chkAssignRound2.Checked = inv.IsRound2Assigned;
}
}
public decimal?CalculateMark(Article a)
{
var all = Jury.Select(j => a.Marks.Where(m => m.User == j).SingleOrDefault())
.Where(m => m != null)
.Select(m => m.Marks)
.ToArray();
if (all.Length == 0)
{
return(null);
}
var config = ReadMarksConfig();
decimal result;
var parts = all.Select(m => config.GetValues(m)).ToArray();
if (Flags.HasFlag(EditathonFlags.ConsensualVote))
{
var p = parts.Aggregate((p1, p2) => p1 != null && p1.SequenceEqual(p2) ? p1 : null);
if (p == null)
{
return(null);
}
result = p.Values.Sum(v => v.Value);
}
else
{
result = parts.Average(p => p.Values.Sum(v => v.Value));
}
return(Math.Round(result, 2));
}
public async Task <IActionResult> Post([FromBody] Jury jury)
{
_context.Jurys.Add(jury);
await _context.SaveChangesAsync();
return(Ok());
}
public Jury GetJuryById(Guid juryId)
{
string sqlJury = String.Format("SELECT * FROM Juries WHERE Id='{0}'", juryId);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlJury, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Jury jury = new Jury();
jury.ID = Guid.Parse((string)reader["id"]);
jury.Name = (string)reader["name"];
jury.Info = (string)reader["info"];
jury.Logo = (string)reader["logo"];
reader.Close();
return(jury);
}
}
reader.Close();
return(null);
}
}
public IEnumerable <Jury> GetAllJury()
{
string sqlExpression = "SELECT * FROM Juries";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Jury jury = new Jury();
jury.ID = Guid.Parse((string)reader["id"]);
jury.Name = (string)reader["name"];
jury.Info = (string)reader["info"];
jury.Logo = (string)reader["logo"];
yield return(jury);
}
}
reader.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//jury = Jury.GetJury(new Guid(Request.QueryString["juryId"]));
if (Request.QueryString["juryId"] != null && Request.QueryString["juryId"] != "")
{
jury = Jury.GetJury(IptechLib.Validation.GetValueGuid(Request.QueryString["juryId"], true));
}
}
catch { }
if (jury == null)
{
Security.RedirectToAccessDeniedPage();
}
itemsToShow = Convert.ToInt32(Gen_GeneralUseValueList.GetGen_GeneralUseValueList("DefaultListToShow")[0].Value);
if (!IsPostBack)
{
LoadForm();
PopulateForm();
}
if (GeneralFunction.IsProfileUpdateDateCutOff())
{
Response.Redirect("../Jury/Thankyou.aspx");
}
}
private void dismissJury(Player curPlayer)
{
Jury jury = chooseJuryChoice(game.Board.Juries, curPlayer, "Select Jury to Dismiss");
FileLogger.Instance.Log(curPlayer + " dismissed " + jury);
game.Board.RemoveJury(jury);
}
public JuryVM() : base()
{
TheJury = new Jury();
TheItem = TheJury;
lstRecoursVM = new ObservableCollection <RecoursVM>();
IsNew = true;
create1erRecours();
}
public static int SendTemplateEmail(Jury jury, Guid tempalteId)
{
int rtnValue = 0;
//string emailformat = ReadEmailTemplate(System.Configuration.ConfigurationSettings.AppSettings["storagePhysicalPath"] + "EmailTemplate\\InvitationEmailRound1.htm");
EmailTemplate emailtempalte = EmailTemplate.GetEmailTemplate(tempalteId);
if (emailtempalte != null)
{
string emailformat = emailtempalte.Body;
string emailCC = string.Empty;
if (jury != null)
{
emailformat = emailformat.Replace("#NAME#", jury.FirstName);
emailformat = emailformat.Replace("#LINKAPPROVE#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|2") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKAPPROVER1#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKAPPROVER2#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("2|") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKREJECT#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|2") + "&request=" + GeneralFunction.StringEncryption("no") + "");
emailformat = emailformat.Replace("#JURYLOGINURL#", System.Configuration.ConfigurationSettings.AppSettings["WebURLEffie"] + "Jury/Login.aspx");
emailformat = emailformat.Replace("#LOGINID#", jury.SerialNo);
emailformat = emailformat.Replace("#PASSWORD#", jury.Password);
if (emailformat.IndexOf("#PROFILELINK#") != -1)
{
jury.IsProfileUpdated = false;
}
jury.Save();
string updateProfileLink = ConfigurationSettings.AppSettings["WebURL"] + "Jury/Profile.aspx?juryId=" + IptechLib.Crypto.StringEncryption(jury.Id.ToString());
emailformat = emailformat.Replace("#PROFILELINK#", "<a href='" + updateProfileLink + "'>this link</a>");
if (!String.IsNullOrEmpty(jury.PAEmail.Trim()))
{
string pattern = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
Match match = Regex.Match(jury.PAEmail.Trim(), pattern, RegexOptions.IgnoreCase);
if (match.Success && tempalteId != new Guid("714b1944-3fab-41c7-b353-cedeec28924f") && tempalteId != new Guid("e0cc09ee-30e1-44b7-83b1-48834a6fbbb9"))
{
emailCC = jury.PAEmail;
}
}
//Disable PAEmail
emailCC = "";
rtnValue = SendMail(jury.Email, System.Configuration.ConfigurationSettings.AppSettings["AdminEmail"], emailCC, "", emailtempalte.Subject, emailformat, true, null, null);
}
}
return(rtnValue);
}
protected override void init()
{
jury = (Jury)GameManager.Instance.Game.Board.Juries[Idx];
SelectKey = jury;
ownedJuryAspectElements.ForEach(e => e.InitJuryAspect(jury));
swayTrackElement.InitSwayTrack(jury);
updateUI();
}
public JuryVM(GestVAEcls.Jury pJury) : base(pJury)
{
TheJury = pJury;
lstRecoursVM = new ObservableCollection <RecoursVM>();
foreach (var item in TheJury.lstRecours)
{
RecoursVM oRecours = new RecoursVM(item);
lstRecoursVM.Add(oRecours);
}
IsNew = false;
}
public bool IsSameCompanyDetails(Jury jury, ClosedXML.Excel.IXLRangeRow CurrentRow)
{
if ((jury.Type != RemoveControlChars(CurrentRow.Cell(2).GetString())) || (!jury.Designation.Trim().ToUpper().Equals(RemoveControlChars(CurrentRow.Cell(7).GetString()).ToUpper())) || (!jury.Company.Trim().ToUpper().Equals(RemoveControlChars(CurrentRow.Cell(8).GetString()).ToUpper())) ||
(!jury.Country.Trim().ToUpper().Equals(RemoveControlChars(CurrentRow.Cell(17).GetString()).Trim().ToUpper())) || (!jury.Network.Trim().ToUpper().Equals(RemoveControlChars(CurrentRow.Cell(9).GetString()).Trim().ToUpper())) ||
(!jury.HoldingCompany.Trim().ToUpper().Equals(RemoveControlChars(CurrentRow.Cell(10).GetString()).Trim().ToUpper())))
{
return(false);
}
return(true);
}
public void AddJury(Jury jury)
{
string sqlAddJury = String.Format("INSERT INTO Juries (Id, UserId, Name, UserPic, Info) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
jury.ID, jury.UserID, jury.Name, jury.Logo, jury.Info);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlAddJury, connection);
command.ExecuteNonQuery();
}
}
public async Task <IActionResult> Put(int id, [FromBody] Jury jury)
{
var dbJury = _context.Jurys.FirstOrDefault(x => x.ID == id);
dbJury.Teacher1 = jury.Teacher1;
dbJury.Teacher2 = jury.Teacher2;
dbJury.Teacher3 = jury.Teacher3;
_context.Jurys.Update(dbJury);
await _context.SaveChangesAsync();
return(Ok());
}
public virtual void Commit()
{
foreach (JuryVM item in lstJuryVM)
{
Jury obj = (Jury)item.TheItem;
if (item.IsNew)
{
TheLivret.lstJurys.Add(obj);
item.IsNew = false;
}
item.Commit();
}
}
public static int SendInvitationTemplateEmail(Invitation inv, Guid tempalteId)
{
int rtnValue = 0;
//string emailformat = ReadEmailTemplate(System.Configuration.ConfigurationSettings.AppSettings["storagePhysicalPath"] + "EmailTemplate\\InvitationEmailRound1.htm");
EmailTemplate emailtempalte = EmailTemplate.GetEmailTemplate(tempalteId);
if (emailtempalte != null)
{
string emailformat = emailtempalte.Body;
string emailCC = string.Empty;
Jury jury = Jury.GetJury(inv.JuryId);
if (jury != null)
{
emailformat = emailformat.Replace("#NAME#", jury.FirstName);
emailformat = emailformat.Replace("#LINKAPPROVE#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|2") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKAPPROVER1#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKAPPROVER2#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("2|") + "&request=" + GeneralFunction.StringEncryption("yes") + "");
emailformat = emailformat.Replace("#LINKREJECT#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Thankyou.aspx?jId=" + GeneralFunction.StringEncryption(jury.Id.ToString()) + "&rounds=" + GeneralFunction.StringEncryption("1|2") + "&request=" + GeneralFunction.StringEncryption("no") + "");
if (emailformat.IndexOf("#PROFILELINK#") != -1)
{
jury.IsProfileUpdated = false;
}
jury.Save();
emailformat = emailformat.Replace("#PROFILELINK#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "Jury/Profile.aspx?juryId=" + IptechLib.Crypto.StringEncryption(jury.Id.ToString()));
emailformat = emailformat.Replace("#EMAILTRACKER#", System.Configuration.ConfigurationSettings.AppSettings["WebURL"] + "EmailTracking.aspx?invId=" + IptechLib.Crypto.StringEncryption(inv.Id.ToString()));
if (!String.IsNullOrEmpty(jury.PAEmail.Trim()))
{
string pattern = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
Match match = Regex.Match(jury.PAEmail.Trim(), pattern, RegexOptions.IgnoreCase);
if (match.Success)
{
emailCC = jury.PAEmail;
}
}
rtnValue = SendMail(jury.Email, System.Configuration.ConfigurationSettings.AppSettings["AdminEmail"], emailCC, "", emailtempalte.Subject, emailformat, true, null, null);
}
}
return(rtnValue);
}
public void SaveCompanyHistory(Jury jury, CompanyHistory compnyHistroy, string DateCreated = "")
{
if (!string.IsNullOrEmpty(DateCreated) && !compnyHistroy.IsNew)
{
compnyHistroy.DateCreatedString = DateCreated;
}
else
{
compnyHistroy.JuryId = jury.Id;
compnyHistroy.Type = jury.Type;
compnyHistroy.Designation = jury.Designation;
compnyHistroy.Company = jury.Company;
compnyHistroy.Address1 = jury.Address1;
compnyHistroy.Address2 = jury.Address2;
compnyHistroy.City = jury.City;
compnyHistroy.Postal = jury.Postal;
compnyHistroy.Country = jury.Country;
if (DateCreated == "Empty")
{
compnyHistroy.DateCreatedString = jury.DateCreatedString;
}
else if (!string.IsNullOrEmpty(DateCreated))
{
compnyHistroy.DateCreatedString = DateCreated;
}
compnyHistroy.CompanyType = jury.CompanyType;
compnyHistroy.CompanyTypeOther = jury.CompanyTypeOther;
compnyHistroy.Network = jury.Network;
if (compnyHistroy.Network == "Others")
{
compnyHistroy.NetworkOthers = jury.NetworkOthers.Trim();
}
compnyHistroy.HoldingCompany = jury.HoldingCompany;
if (compnyHistroy.HoldingCompany == "Others")
{
compnyHistroy.HoldingCompanyOthers = jury.HoldingCompanyOthers.Trim();
}
}
compnyHistroy.Save();
string msg = "JURY ID : " + jury.Id + " || CompnyHistroy ID : " + compnyHistroy.Id + " || IsNew : " + compnyHistroy.IsNew + " || DateCreated : " + DateCreated + "<br>";
Response.Write(msg);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["juryId"] != null && Request.QueryString["juryId"] != "")
{
jury = Jury.GetJury(new Guid(Request.QueryString["juryId"]));
}
else
{
jury = Jury.NewJury();
}
itemsToShow = Convert.ToInt32(Gen_GeneralUseValueList.GetGen_GeneralUseValueList("DefaultListToShow")[0].Value);
if (!IsPostBack)
{
LoadForm();
PopulateForm();
}
// view mode
if (Request.QueryString["v"] != null && Request.QueryString["v"] == "1")
{
IptechLib.Forms.ChangeStateControls(this, false);
filePhoto.Enabled = false;
btnSubmit.Visible = false;
btnEdit.Visible = true;
btnEdit.Enabled = true;
btnBack.Enabled = true;
}
else
{
btnEdit.Enabled = true;
lnkChangePassword.Visible = Security.IsRoleSuperAdmin() && !jury.IsNew;
}
if (Security.IsRoleReadOnlyAdmin())
{
GeneralFunction.DisableAllAction(this, false);
btnSubmit.Visible = false;
btnJurySubmitRemarks.Visible = false;
filePhoto.Enabled = false;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Invitation inv = SaveForm();
if (inv != null)
{
Jury jury = Jury.GetJury(inv.JuryId);
if (jury != null)
{
jury.EffieExpYear = Jury.GetEffieExperienceYears(jury, inv);
jury.DateModifiedString = DateTime.Now.ToString();
jury.Save();
}
Response.Redirect(GeneralFunction.GetRedirect("../Main/InvitationList.aspx"));
}
}
public static bool isAttendedEvent(Jury jury, string eventCode)
{
bool isAttended = false;
Invitation inv = null;
try
{
inv = InvitationList.GetInvitationList(jury.Id, eventCode).Single();
}
catch { }
if (inv != null)
{
isAttended = inv.IsRound1Assigned || inv.IsRound2Assigned;
}
return(isAttended);
}
public Guid AddJury(string email, string pass, string juryName)
{
User user = new User();
user.EMail = email;
user.Pass = pass;
user.Role = UserRoles.Jury;
user.ID = Guid.NewGuid();
_usersDal.AddUser(user);
Jury jury = new Jury();
jury.ID = Guid.NewGuid();
jury.UserID = user.ID;
jury.Name = juryName;
jury.Info = "";
_juryDal.AddJury(jury);
return(jury.ID);
}
public void GenerateEmails(Guid templateId)
{
string evetnYear = string.Empty;
try
{
evetnYear = Gen_GeneralUseValueList.GetGen_GeneralUseValueList("EventCode")[0].Value;
}
catch { }
lblError.Text = string.Empty;
int counter = 0;
foreach (GridDataItem item in radGridJury.Items)
{
CheckBox chkbox = (CheckBox)item.FindControl("chkbox");
HiddenField hdfId = (HiddenField)item.FindControl("hdfId");
if (chkbox.Checked)
{
Jury jury = Jury.GetJury(new Guid(hdfId.Value.ToString()));
Email.SendTemplateEmail(jury, templateId);
GeneralFunction.SaveEmailSentLog(jury, templateId, evetnYear);
chkbox.Checked = false;
counter++;
}
}
if (counter == 0)
{
lblError.Text = "Please select atleat one jury to send email.<br/>";
}
else
{
lblError.Text = "Email sent to " + (counter).ToString() + " Jury(s).<br/>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
juryIdString = Request.QueryString["jId"];
rounds = Request.QueryString["rounds"];
requestString = Request.QueryString["request"];
if (GeneralFunction.IsInvitationDateCutOff())
{
pnlDeadline.Visible = true;
}
else
{
if (juryIdString != null && rounds != null && requestString != null)
{
if (GeneralFunction.ValidateGuid(GeneralFunction.GetValueGuid(juryIdString, true).ToString()))
{
juryId = GeneralFunction.GetValueGuid(juryIdString, true);
jury = Jury.GetJury(juryId);
if (!IsPostBack)
{
LoadForm();
PopulateForm(jury);
}
}
else
{
return;
}
}
else
{
return;
}
}
}
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();
}
}
public string ValidateExcelData(XLWorkbook workBook)
{
string error = string.Empty;
bool isErrorOccured = false;
if (workBook.Worksheets.Count > 0)
{
int sheetNo = 1;
foreach (IXLWorksheet sh in workBook.Worksheets)
{
var dataRange = sh.RangeUsed();
int skiprows = 1;
if (dataRange != null)
{
foreach (var row in dataRange.Rows())
{
if (skiprows >= 2 && sheetNo == 1)
{
if (ValidateRow(row))
{
Jury jury = Jury.NewJury();
jury.Type = RemoveControlChars(row.Cell(3).GetString());
jury.Salutation = RemoveControlChars(row.Cell(4).GetString());
jury.FirstName = RemoveControlChars(row.Cell(5).GetString());
jury.LastName = RemoveControlChars(row.Cell(6).GetString());
jury.Designation = RemoveControlChars(row.Cell(8).GetString());
jury.Company = RemoveControlChars(row.Cell(9).GetString());
//jury.CompanyType = RemoveControlChars(row.Cell(9).GetString());
jury.Network = RemoveControlChars(row.Cell(10).GetString());
jury.HoldingCompany = RemoveControlChars(row.Cell(11).GetString());
jury.Email = RemoveControlChars(row.Cell(12).GetString());
jury.Contact = RemoveControlChars(row.Cell(13).GetString());
jury.Mobile = RemoveControlChars(row.Cell(14).GetString());
jury.PAName = RemoveControlChars(row.Cell(15).GetString());
jury.PAEmail = RemoveControlChars(row.Cell(16).GetString());
jury.PATel = RemoveControlChars(row.Cell(17).GetString());
jury.Address1 = RemoveControlChars(row.Cell(18).GetString());
jury.Address2 = RemoveControlChars(row.Cell(19).GetString());
jury.City = RemoveControlChars(row.Cell(20).GetString());
jury.Postal = RemoveControlChars(row.Cell(21).GetString());
jury.Country = RemoveControlChars(row.Cell(22).GetString());
//jury.MarketExp = RemoveControlChars(row.Cell(23).GetString());
//jury.IndustryExp = RemoveControlChars(row.Cell(24).GetString());
jury.EffieExp = RemoveControlChars(row.Cell(25).GetString());
//jury.OtherJudgingExp = RemoveControlChars(row.Cell(28).GetString());
jury.Remarks = RemoveControlChars(row.Cell(26).GetString());
jury.Reference = RemoveControlChars(row.Cell(27).GetString());
jury.Source = RemoveControlChars(row.Cell(28).GetString());
jury.LastUpdate = RemoveControlChars(row.Cell(29).GetString());
jury.DateModifiedString = DateTime.Now.ToString();
if (!jury.IsValid)
{
error += "Data is not valid in row: " + (row.RowNumber() - 1).ToString() + "[" + jury.BrokenRulesCollection.ToString() + "]";
isErrorOccured = true;
break;
}
}
else
{
error += "Data is not valid in row: " + (row.RowNumber() - 1).ToString();
isErrorOccured = true;
break;
}
}
skiprows++;
}
}
sheetNo++;
if (isErrorOccured)
{
break;
}
}
}
else
{
error += "Sheet contains no data.<br/>";
}
return(error);
}
public void ReadExcelData(XLWorkbook workBook)
{
if (workBook.Worksheets.Count > 0)
{
int sheetNo = 1;
foreach (IXLWorksheet sh in workBook.Worksheets)
{
var dataRange = sh.RangeUsed();
int skiprows = 1;
if (dataRange != null)
{
foreach (var row in dataRange.Rows())
{
if (skiprows >= 2 && sheetNo == 1)
{
if (ValidateRow(row))
{
Jury jury = Jury.NewJury();
jury.Type = RemoveControlChars(row.Cell(3).GetString());
jury.Salutation = RemoveControlChars(row.Cell(4).GetString());
jury.FirstName = RemoveControlChars(row.Cell(5).GetString());
jury.LastName = RemoveControlChars(row.Cell(6).GetString());
jury.Designation = RemoveControlChars(row.Cell(8).GetString());
jury.Company = RemoveControlChars(row.Cell(9).GetString());
//jury.CompanyType = RemoveControlChars(row.Cell(9).GetString());
jury.Network = RemoveControlChars(row.Cell(10).GetString());
jury.HoldingCompany = RemoveControlChars(row.Cell(11).GetString());
jury.Email = RemoveControlChars(row.Cell(12).GetString());
jury.Contact = RemoveControlChars(row.Cell(13).GetString());
jury.Mobile = RemoveControlChars(row.Cell(14).GetString());
jury.PAName = RemoveControlChars(row.Cell(15).GetString());
jury.PAEmail = RemoveControlChars(row.Cell(16).GetString());
jury.PATel = RemoveControlChars(row.Cell(17).GetString());
jury.Address1 = RemoveControlChars(row.Cell(18).GetString());
jury.Address2 = RemoveControlChars(row.Cell(19).GetString());
jury.City = RemoveControlChars(row.Cell(20).GetString());
jury.Postal = RemoveControlChars(row.Cell(21).GetString());
jury.Country = RemoveControlChars(row.Cell(22).GetString());
string effieExpereinceYears = string.Empty;
effieExpereinceYears += "#" + RemoveControlChars(row.Cell(25).GetString()) + "|";
effieExpereinceYears += "#" + RemoveControlChars(row.Cell(24).GetString()) + "|";
effieExpereinceYears += "#" + RemoveControlChars(row.Cell(23).GetString()) + "|";
jury.EffieExpYear = effieExpereinceYears;
jury.EffieExp = RemoveControlChars(row.Cell(26).GetString());
jury.Remarks = RemoveControlChars(row.Cell(27).GetString());
jury.Reference = RemoveControlChars(row.Cell(28).GetString());
jury.Source = RemoveControlChars(row.Cell(29).GetString());
jury.LastUpdate = RemoveControlChars(row.Cell(30).GetString());
if (jury.IsNew)
{
jury.SerialNo = GeneralFunction.GetNewJuryId();
jury.DateCreatedString = DateTime.Now.ToString();
jury.Password = Guid.NewGuid().ToString().Substring(0, 6);
}
if (jury.IsValid)
{
jury = jury.Save();
}
}
//else
// return;
}
skiprows++;
}
}
sheetNo++;
}
}
else
{
lbError.Text += "The Sheet has invalid/not enough data.<br/>Please check your file";
}
}
public void Commit()
{
foreach (DiplomeCandVM item in lstDiplomesCandVMs)
{
if (item.IsDeleted)
{
if (!item.IsNew)
{
_ctx.DiplomeCands.Remove(item.TheDiplomeCand);
}
}
}
if (_ctx.Entry <Candidat>(TheCandidat).State == System.Data.Entity.EntityState.Detached)
{
_ctx.Candidats.Add(TheCandidat);
}
if (_ctx.Entry <Candidat>(TheCandidat).State == System.Data.Entity.EntityState.Deleted)
{
_ctx.Candidats.Remove(TheCandidat);
}
foreach (LivretVMBase item in lstLivrets)
{
if (item.IsDeleted)
{
if (!item.IsNew)
{
//Suppression Manuelle des Jurys
while (item.TheLivret.lstJurys.Count > 0)
{
Jury oJ = item.TheLivret.lstJurys[0];
_ctx.Juries.Remove(oJ);
}
// Suppression des enregistrements de Livrets
if (item.Typestr == Livret1.TYPELIVRET)
{
_ctx.Livret1.Remove((Livret1)item.TheLivret);
}
if (item.Typestr == Livret2.TYPELIVRET)
{
_ctx.Livret2.Remove((Livret2)item.TheLivret);
}
}
item.IsDeleted = false;
item.IsNew = false;
}
else
{
if (item is Livret1VM)
{
if (item.IsNew)
{
TheCandidat.lstLivrets1.Add((Livret1)item.TheLivret);
item.IsNew = false;
}
}
if (item is Livret2VM)
{
if (item.IsNew)
{
TheCandidat.lstLivrets2.Add((Livret2)item.TheLivret);
item.IsNew = false;
}
}
item.Commit();
}
}
}
public void InitSwayTrack(Jury jury)
{
swayTrack = jury.SwayTrack;
SelectKey = swayTrack;
updateUI();
}
private void PopulateForm(Jury jury)
{
if (jury != null)
{
InvitationList inv = InvitationList.GetInvitationList(jury.Id, Gen_GeneralUseValueList.GetGen_GeneralUseValueList("EventCode")[0].Value);
if (inv.Count > 0)
{
if (!inv[0].IsLocked)
{
string[] roundsArray = null;
try
{
roundsArray = GeneralFunction.StringDecryption(rounds).ToString().Trim().Split('|').ToArray();
}
catch
{
}
string evetnYear = string.Empty;
try
{
evetnYear = Gen_GeneralUseValueList.GetGen_GeneralUseValueList("EventCode")[0].Value;
}
catch { }
if (roundsArray != null)
{
if (GeneralFunction.StringDecryption(requestString).Trim().ToLower().Equals("yes"))
{
foreach (string round in roundsArray)
{
if (!String.IsNullOrEmpty(round))
{
if (Convert.ToInt32(round) == 1)
{
inv[0].IsRound1Accepted = true;
}
if (Convert.ToInt32(round) == 2)
{
inv[0].IsRound2Accepted = true;
}
}
}
EmailTemplate updateProfileTemplate = EmailTemplate.GetEmailTemplate(new Guid(Gen_GeneralUseValueList.GetGen_GeneralUseValueList("DefaultUpdateProfileTemplateId")[0].Value));
if (updateProfileTemplate != null)
{
Email.SendTemplateEmail(jury, updateProfileTemplate.Id);
GeneralFunction.SaveEmailSentLog(jury, updateProfileTemplate.Id, evetnYear);
}
pnlSuccess.Visible = true;
}
else
{
foreach (string round in roundsArray)
{
if (!String.IsNullOrEmpty(round))
{
if (Convert.ToInt32(round) == 1)
{
inv[0].IsRound1Accepted = false;
}
if (Convert.ToInt32(round) == 2)
{
inv[0].IsRound2Accepted = false;
}
}
}
pnlReject.Visible = true;
}
inv[0].IsLocked = true; //Only one time Jury can give his response
inv[0].IsDeclined = GeneralFunction.StringDecryption(requestString).Trim().ToLower().Equals("no");
inv[0].Save();
}
}
else
{
pnlLock.Visible = true;
}
}
}
}
