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 string getConvictDetails(string convictCode)
{
JavaScriptSerializer js = new JavaScriptSerializer();
string strJSON = "";
Convict foundConvict = Helper.getConvictDetails(convictCode);
if (foundConvict == null)
{
strJSON = js.Serialize("{'name':''}");
}
else
{
strJSON = js.Serialize("{'name':'" + foundConvict.Name + "', 'emailaddress': '" + foundConvict.Email + "'}");
}
return(strJSON);
}
public string getConvictCode(string email)
{
JavaScriptSerializer js = new JavaScriptSerializer();
string strJSON = "";
Convict found = db.Convicts.Find(email);
if (found == null)
{
strJSON = js.Serialize("{'convictcode':'0', 'emailaddress': '" + email + "'}");
}
else
{
strJSON = js.Serialize("{'convictcode':'" + found.ConvictCode + "', 'emailaddress': '" + found.Email + "'}");
}
return(strJSON);
}
public string getTeamDetails(string teamCode)
{
JavaScriptSerializer js = new JavaScriptSerializer();
string strJSON = "";
Team foundTeam = Helper.getTeamDetails(teamCode);
Convict foundConvict = Helper.getConvictsInTeam(teamCode);
if (foundTeam == null)
{
strJSON = js.Serialize("{'teamcode':'0', 'teamCode': '" + teamCode + "'}");
}
else
{
strJSON = js.Serialize("{'teamcode':'" + foundTeam.TeamCode + "', 'teamName': '" + foundTeam.TeamName + "', 'emailaddress': '" + foundConvict.Email + "'}");
}
return(strJSON);
}
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 static bool doesAccountExist(string email)
{
ConvictsContext db = new ConvictsContext();
bool doesAccountExist = false;
string errorMessage = "";
Convict convict = new Convict();
try
{
Convict found = db.Convicts.Find(email);
if (found != null)
{
doesAccountExist = true;
}
}
catch (Exception ex)
{
doesAccountExist = false;
errorMessage = ex.Message;
}
return doesAccountExist;
}
public static bool doesAccountExist(string email)
{
ConvictsContext db = new ConvictsContext();
bool doesAccountExist = false;
string errorMessage = "";
Convict convict = new Convict();
try
{
Convict found = db.Convicts.Find(email);
if (found != null)
{
doesAccountExist = true;
}
}
catch (Exception ex)
{
doesAccountExist = false;
errorMessage = ex.Message;
}
return(doesAccountExist);
}
public static string getTeamDonations(string teamCode)
{
string returnStr = "{'status':'true'";
returnStr += ", 'messages': [ ";
ConvictsContext db = new ConvictsContext();
var found = from payments in db.Payments
where teamCode.Contains(payments.TeamCode)
orderby payments.CreateDate descending
select payments;
if (found.Count() == 0)
{
returnStr = "{'status':'false'}";
return(returnStr);
}
else
{
foreach (var p in found)
{
if (string.IsNullOrEmpty(p.DonorName))
{
continue;
}
if (p.Anonymous)
{
p.DonorName = "Anonymous";
}
DonationMessage d = new DonationMessage();
d.date = "" + p.CreateDate.ToShortDateString() + " " + p.CreateDate.ToShortTimeString();
if (p.PaymentType == "convict donation" || p.PaymentType == "cash donation")
{
Convict foundConvict = Helper.getConvictDetailsByEmail(p.ConvictEmail);
d.message = p.DonorName + " posted a $" + p.amount + " bail: " + p.Message;
returnStr += "{'date': '" + d.date + "','message': '" + d.message + "'},";
}
else if (p.PaymentType == "team donation")
{
Convict foundConvict = Helper.getConvictDetailsByEmail(p.ConvictEmail);
d.message = p.DonorName + " posted a $" + p.amount + " bail: " + p.Message;
returnStr += "{'date': '" + d.date + "','message': '" + d.message + "'},";
}
else if (p.PaymentType == "team registration" || p.PaymentType == "convict registration" || p.PaymentType == "team member registration")
{
Convict foundConvict = Helper.getConvictDetailsByEmail(p.ConvictEmail);
d.message = foundConvict.Name + " has been jailed and fined $" + p.amount;
returnStr += "{'date': '" + d.date + "','message': '" + d.message + "'},";
}
else if (p.PaymentType == "general donation")
{
d.message = p.DonorName + " posted a $" + p.amount + " bail.";
returnStr += "{'date': '" + d.date + "','message': '" + d.message + "'},";
}
}
returnStr += "]";
returnStr += "}";
return(returnStr);
}
//return "{'status':'false'}";
}
