/// <summary>
/// Checks for null entries and puts
/// </summary>
public void getDonorNames()
{
// populates donor names
ConvictsContext db = new ConvictsContext();
List <PaymentRecord> found = (from payments in db.Payments
where payments.DonorName == null
select payments).ToList();
foreach (var payment in found)
{
try
{
convictsforacauseWS.CatalystCRMWebservice CFACWS = new convictsforacauseWS.CatalystCRMWebservice();
convictsforacauseWS.ContactRecord CR = CFACWS.Contact_RetrieveByEmailAddress("*****@*****.**", "convicts2011", 223280, payment.PayerEmail);
payment.DonorName = CR.fullName;
db.Entry(payment).CurrentValues.SetValues(payment);
}
catch (Exception)
{
}
}
try
{
db.SaveChanges();
}
catch (Exception)
{
}
}
/// <summary>
/// Parses the convict page to get the convict's URL
/// </summary>
public void getConvictURLS()
{
HtmlWeb webLoad = new HtmlWeb();
HtmlDocument doc = webLoad.Load("http://www.convictsforacause.org.au/support/convict.html");
var meh = from link in doc.DocumentNode.DescendantNodes()
where link.Name == "a" &&
link.Attributes["email"] != null
select new
{
URL = link.Attributes["href"].Value,
email = link.Attributes["email"].Value
};
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List <Convict> found = (from convicts in db.Convicts
where convicts.ProfileURL == null
select convicts).ToList();
foreach (var convict in found)
{
foreach (var link in meh)
{
if (convict.Email == link.email)
{
convict.ProfileURL = link.URL;
}
}
db.Entry(convict).CurrentValues.SetValues(convict);
}
db.SaveChanges();
}
public void getTeamURLs()
{
HtmlWeb webLoad = new HtmlWeb();
HtmlDocument doc = webLoad.Load("http://www.convictsforacause.org.au/support/team.html");
var meh = from link in doc.DocumentNode.DescendantNodes()
where link.Name == "a" &&
link.Attributes["teamcode"] != null
select new
{
URL = link.Attributes["href"].Value,
teamcode = link.Attributes["teamcode"].Value
};
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List <Team> found = (from teams in db.Teams
where teams.TeamURL == null
select teams).ToList();
foreach (var team in found)
{
foreach (var link in meh)
{
if (team.TeamCode == link.teamcode)
{
team.TeamURL = link.URL;
}
}
db.Entry(team).CurrentValues.SetValues(team);
}
db.SaveChanges();
}
public void CalculateTeamTotals()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List <Team> found = (from teams in db.Teams
select teams).ToList();
foreach (var team in found)
{
try
{
ConvictsContext db1 = new ConvictsContext();
var total = (from payments in db1.Payments
where payments.TeamCode == team.TeamCode
select payments.amount).Sum();
team.Total = total.ToString();
db.Entry(team).CurrentValues.SetValues(team);
}
catch (Exception ex)
{
}
}
db.SaveChanges();
}
public void CalculateConvictTotals()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List <Convict> found = (from convicts in db.Convicts
select convicts).ToList();
foreach (var convict in found)
{
try
{
ConvictsContext db1 = new ConvictsContext();
var total = (from payments in db1.Payments
where payments.ConvictEmail == convict.Email
select payments.amount).Sum();
convict.Total = total.ToString();
db.Entry(convict).CurrentValues.SetValues(convict);
}
catch (Exception ex)
{
Console.Write(ex.Message.ToString());
}
}
db.SaveChanges();
}
public ConvictReturnObject registerTeamConvict(string email, string name, string registrationType)
{
ConvictsContext db = new ConvictsContext();
Convict convict = new Convict();
string returnStatus = "false";
string errorMessage = "";
try
{
Convict found = db.Convicts.Find(email);
if (found == null)
{
convict.Email = email;
convict.Name = name;
convict.ModifiedDate = DateTime.Now;
convict.Total = "0";
convict.CreateDate = DateTime.Now;
convict.TeamType = registrationType;
convict.Total = "0";
convict.TeamCode = Helper.GenerateTeamCode();
convict.ConvictCode = Helper.GenerateConvictCode();
db.Convicts.Add(convict);
db.SaveChanges();
}
else
{
convict = found;
convict.ModifiedDate = DateTime.Now;
db.Entry(found).CurrentValues.SetValues(convict);
db.SaveChanges();
}
returnStatus = "true";
}
catch (Exception ex)
{
returnStatus = "false";
errorMessage = ex.Message;
}
ConvictReturnObject returnobj = new ConvictReturnObject();
returnobj.status = returnStatus;
returnobj.errorMessage = errorMessage;
returnobj.convict = convict;
return(returnobj);
}
public static TeamDTO registerTeam(string teamCode, string name, string registrationType)
{
ConvictsContext db = new ConvictsContext();
Team team = new Team();
string returnStatus = "false";
string errorMessage = "";
try
{
Team found = db.Teams.Find(teamCode);
if (found == null)
{
team.TeamCode = teamCode;
team.TeamName = name;
team.TeamType = registrationType;
team.ModifiedDate = DateTime.Now;
team.Total = "0";
team.CreateDate = DateTime.Now;
db.Teams.Add(team);
db.SaveChanges();
}
else
{
team = found;
team.ModifiedDate = DateTime.Now;
db.Entry(found).CurrentValues.SetValues(team);
db.SaveChanges();
}
returnStatus = "true";
}
catch (Exception ex)
{
returnStatus = "false";
errorMessage = ex.Message;
}
TeamDTO returnobj = new TeamDTO();
returnobj.status = returnStatus;
returnobj.errorMessage = errorMessage;
returnobj.team = team;
return(returnobj);
}
public static ConvictReturnObject registerConvict(string email, string name)
{
ConvictsContext db = new ConvictsContext();
string returnStatus = "false";
string errorMessage = "";
Convict convict = new Convict();
try
{
Convict found = db.Convicts.Find(email);
if (found == null)
{
convict = new Convict();
convict.Email = email;
convict.Name = name;
convict.ModifiedDate = DateTime.Now;
convict.Total = "0";
convict.CreateDate = DateTime.Now;
convict.ConvictCode = Helper.GenerateConvictCode();
db.Convicts.Add(convict);
db.SaveChanges();
}
else
{
convict = found;
convict.ModifiedDate = DateTime.Now;
db.Entry(found).CurrentValues.SetValues(convict);
db.SaveChanges();
}
returnStatus = "true";
}
catch (Exception ex)
{
returnStatus = "false";
errorMessage = ex.Message;
}
ConvictReturnObject returnobj = new ConvictReturnObject();
returnobj.status = returnStatus;
returnobj.errorMessage = errorMessage;
returnobj.convict = convict;
return returnobj;
}
public void addTeamCodeToPaymentRecords()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List <Convict> found = (from convicts in db.Convicts
where convicts.TeamCode != null
select convicts).ToList();
foreach (var convict in found)
{
ConvictsContext db1 = new ConvictsContext();
var payment = (from payments in db1.Payments
where payments.ConvictEmail == convict.Email
select payments).ToList();
foreach (var p in payment)
{
p.TeamCode = convict.TeamCode;
db1.Entry(p).CurrentValues.SetValues(p);
}
db1.SaveChanges();
}
}
public static TeamDTO registerTeam(string teamCode, string name, string registrationType)
{
ConvictsContext db = new ConvictsContext();
Team team = new Team();
string returnStatus = "false";
string errorMessage = "";
try
{
Team found = db.Teams.Find(teamCode);
if (found == null)
{
team.TeamCode = teamCode;
team.TeamName = name;
team.TeamType = registrationType;
team.ModifiedDate = DateTime.Now;
team.Total = "0";
team.CreateDate = DateTime.Now;
db.Teams.Add(team);
db.SaveChanges();
}
else
{
team = found;
team.ModifiedDate = DateTime.Now;
db.Entry(found).CurrentValues.SetValues(team);
db.SaveChanges();
}
returnStatus = "true";
}
catch (Exception ex)
{
returnStatus = "false";
errorMessage = ex.Message;
}
TeamDTO returnobj = new TeamDTO();
returnobj.status = returnStatus;
returnobj.errorMessage = errorMessage;
returnobj.team = team ;
return returnobj;
}
public void getTeamURLs()
{
HtmlWeb webLoad = new HtmlWeb();
HtmlDocument doc = webLoad.Load("http://www.convictsforacause.org.au/support/team.html");
var meh = from link in doc.DocumentNode.DescendantNodes()
where link.Name == "a" &&
link.Attributes["teamcode"] != null
select new
{
URL = link.Attributes["href"].Value,
teamcode = link.Attributes["teamcode"].Value
};
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List<Team> found = (from teams in db.Teams
where teams.TeamURL == null
select teams).ToList();
foreach (var team in found)
{
foreach (var link in meh)
{
if (team.TeamCode == link.teamcode)
{
team.TeamURL = link.URL;
}
}
db.Entry(team).CurrentValues.SetValues(team);
}
db.SaveChanges();
}
/// <summary>
/// Checks for null entries and puts
/// </summary>
public void getDonorNames()
{
// populates donor names
ConvictsContext db = new ConvictsContext();
List<PaymentRecord> found = (from payments in db.Payments
where payments.DonorName == null
select payments).ToList();
foreach (var payment in found)
{
try
{
convictsforacauseWS.CatalystCRMWebservice CFACWS = new convictsforacauseWS.CatalystCRMWebservice();
convictsforacauseWS.ContactRecord CR = CFACWS.Contact_RetrieveByEmailAddress("*****@*****.**", "convicts2011", 223280, payment.PayerEmail);
payment.DonorName = CR.fullName;
db.Entry(payment).CurrentValues.SetValues(payment);
}
catch (Exception)
{
}
}
try
{
db.SaveChanges();
}
catch (Exception)
{
}
}
/// <summary>
/// Parses the convict page to get the convict's URL
/// </summary>
public void getConvictURLS()
{
HtmlWeb webLoad = new HtmlWeb();
HtmlDocument doc = webLoad.Load("http://www.convictsforacause.org.au/support/convict.html");
var meh = from link in doc.DocumentNode.DescendantNodes()
where link.Name == "a" &&
link.Attributes["email"] != null
select new
{
URL = link.Attributes["href"].Value,
email = link.Attributes["email"].Value
};
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List<Convict> found = (from convicts in db.Convicts
where convicts.ProfileURL == null
select convicts).ToList();
foreach (var convict in found)
{
foreach(var link in meh )
{
if (convict.Email == link.email)
{
convict.ProfileURL = link.URL;
}
}
db.Entry(convict).CurrentValues.SetValues(convict);
}
db.SaveChanges();
}
public void CalculateTeamTotals()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List<Team> found = (from teams in db.Teams
select teams).ToList();
foreach (var team in found)
{
try
{
ConvictsContext db1 = new ConvictsContext();
var total = (from payments in db1.Payments
where payments.TeamCode == team.TeamCode
select payments.amount).Sum();
team.Total = total.ToString();
db.Entry(team).CurrentValues.SetValues(team);
}
catch (Exception ex)
{
}
}
db.SaveChanges();
}
public void CalculateConvictTotals()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List<Convict> found = (from convicts in db.Convicts
select convicts).ToList();
foreach (var convict in found)
{
try
{
ConvictsContext db1 = new ConvictsContext();
var total = (from payments in db1.Payments
where payments.ConvictEmail == convict.Email
select payments.amount).Sum();
convict.Total = total.ToString();
db.Entry(convict).CurrentValues.SetValues(convict);
}
catch (Exception ex)
{
Console.Write(ex.Message.ToString());
}
}
db.SaveChanges();
}
public void addTeamCodeToPaymentRecords()
{
// check if team code already exists
ConvictsContext db = new ConvictsContext();
List<Convict> found = (from convicts in db.Convicts
where convicts.TeamCode != null
select convicts).ToList();
foreach (var convict in found)
{
ConvictsContext db1 = new ConvictsContext();
var payment = (from payments in db1.Payments
where payments.ConvictEmail == convict.Email
select payments).ToList();
foreach (var p in payment)
{
p.TeamCode = convict.TeamCode;
db1.Entry(p).CurrentValues.SetValues(p);
}
db1.SaveChanges();
}
}