//public ActionResult Student(string school, string code)
public ActionResult Student(string id)
{
if (id != null)
{
AccessCodeClient acc = new AccessCodeClient();
AccessCode code = acc.GetByPartitionAndRowKey("accesscode", id);
//AssessmentGroupPinCodeClient agpcc = new AssessmentGroupPinCodeClient();
//AssessmentGroupPinCode groupInfo = agpcc.GetByPartitionAndRowKey("pincodes", id);
if (code != null && code.School != "CareerThesaurus Demo School")
{
SchoolAccountClient sac = new SchoolAccountClient();
SchoolAccount schoolAccount = sac.GetByPartitionAndRowKey("school", code.School);
ViewBag.SignUpSchoolZip = schoolAccount.ZipCode;
ViewBag.SignUpSchool = code.School;
ViewBag.SignUpSchoolName = schoolAccount.SchoolName;
ViewBag.SignUpCode = code.Code;
ViewBag.SignUpGrade = code.Grade;
ViewBag.SignUpCounselor = code.Counselor;
ViewBag.SignUpGroupName = code.GroupName;
}
else
{
ViewBag.InvalidLink = true;
}
}
return(View());
}
public HttpResponse GetSchoolsByZip(string zipcode)
{
SchoolAccountClient sac = new SchoolAccountClient();
List <SchoolAccount> schoolList = new List <SchoolAccount>(sac.GetByZipCode(zipcode));
JavaScriptSerializer jss = new JavaScriptSerializer();
string response = schoolList.Count != 0 ? "{\"result\": \"ok\", \"results\":" + jss.Serialize(schoolList) + "}" : "{\"result\": \"ok\", \"results\":[]}";
Response.ContentType = "application/json";
Response.Write(response);
Response.End();
return(null);
}
public ActionResult Student(FormCollection collection)
{
UserAccountClient uac = new UserAccountClient();
UserAccount account = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(collection["email"].ToLower()), collection["email"]);
if (account == null)
{
AccessCodeClient aac = new AccessCodeClient();
AccessCode code = aac.GetBySchoolPinCodeCounselorGrade(collection["school"], collection["accesscode"], collection["counselor"], collection["grade"]);
if (code == null || code.School == "7181234567")
{
ViewBag.ErrorMessage = "Invalid fields";
return(RedirectToAction("Index"));
}
uac.AddNewItem(new UserAccount {
PartitionKey = UserAccountClient.GetPartitionKeyForEmail(collection["email"].ToLower()), RowKey = collection["email"].ToLower(), FirstName = collection["firstname"], LastName = collection["lastname"], Email = collection["email"], Password = collection["password"], ProfileType = "student"
});
StudentAccountClient sac = new StudentAccountClient();
sac.AddNewItem(new StudentAccount {
PartitionKey = StudentAccountClient.GetPartitionKeyForEmail(collection["email"].ToLower()), RowKey = collection["email"].ToLower(), Gender = collection["gender"], StudentID = collection["studentid"], School = collection["school"], Counselor = collection["counselor"], Year = code.Year, Grade = collection["grade"], GroupName = code.GroupName
});
//StudentProfileClient spc = new StudentProfileClient();
//spc.AddNewItem(new StudentProfile { PartitionKey = StudentProfileClient.GetPartitionKeyForEmail(collection["email"]), RowKey = collection["email"].ToLower(), Gender = collection["gender"], GradYear = collection["gradyear"], School = school, SchoolZip = collection["zipcode"], Teacher = teacher, Group = group });
}
else
{
ViewBag.ErrorMessage = "There is an account already associated with this email. Please log in instead.";
return(View());
}
SendVerificationEmail(collection["email"].ToLower(), collection["firstname"]);
SchoolAccountClient saclient = new SchoolAccountClient();
SchoolAccount schoolAccount = saclient.GetByPartitionAndRowKey("school", collection["school"]);
UserAccount adminAccount = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(collection["counselor"]), collection["counselor"]);
EmailManager emailManager = new EmailManager();
string str = "<p>Full name: " + collection["firstname"] + " " + collection["lastname"] + "</p><p>Email: " + collection["email"].ToLower() + "</p><p>School: " + (schoolAccount != null ? schoolAccount.SchoolName : "") + "</p><p>Counselor: " + (adminAccount != null ? adminAccount.FirstName + " " + adminAccount.LastName : "") + "</p><p>Grade: " + collection["grade"] + "</p><p>Year: " + collection["year"] + "</p>";
emailManager.SendMail("*****@*****.**", "Admin", "*****@*****.**", "HS Student", str);
return(RedirectToAction("Complete"));
}
public ActionResult ChangeRole(string counselor)
{
if (AuthTokens[0] == "demo")
{
return(RedirectToAction("Index", "AdminPortal"));;
}
string currentAdminEmail = AuthTokens[1];
AdminAccountClient aac = new AdminAccountClient();
CounselorAccountClient cac = new CounselorAccountClient();
UserAccountClient uac = new UserAccountClient();
SchoolAccountClient sac = new SchoolAccountClient();
AdminAccount admin = aac.GetByPartitionAndRowKey("admin", currentAdminEmail);
CounselorAccount counselorAccount = cac.GetByPartitionAndRowKey("counselor", counselor);
UserAccount currentAdmin = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(currentAdminEmail), currentAdminEmail);
UserAccount newAdmin = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(counselor), counselor);
SchoolAccount school = sac.GetByPartitionAndRowKey("school", admin.School);
if (admin != null && counselorAccount != null && currentAdmin != null && newAdmin != null && school != null)
{
aac.AddNewItem(new AdminAccount {
RowKey = counselor, PhoneNumber = counselorAccount.PhoneNumber, PhoneExtension = counselorAccount.PhoneExtension, School = school.RowKey, SchoolSelected = true, ConnectionToSchoolConfirmed = true
});
cac.AddNewItem(new CounselorAccount {
RowKey = currentAdminEmail, PhoneNumber = admin.PhoneNumber, PhoneExtension = admin.PhoneExtension, School = school.RowKey
});
currentAdmin.ProfileType = "counselor";
uac.Update(currentAdmin);
newAdmin.ProfileType = "administrator";
uac.Update(newAdmin);
school.Admin = counselor;
sac.Update(school);
aac.Delete(admin);
cac.Delete(counselorAccount);
}
return(RedirectToAction("LogOut", "Account"));
}
public ActionResult Counselor(FormCollection collection)
{
string adminEmail = "";
UserAccountClient uac = new UserAccountClient();
CounselorInviteClient cic = new CounselorInviteClient();
SchoolAccountClient sac = new SchoolAccountClient();
UserAccount account = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(collection["email"].ToLower()), collection["email"].ToLower());
CounselorInvite invite = cic.GetByPartitionAndRowKey("invite", collection["invite"]);
SchoolAccount school = sac.GetByPartitionAndRowKey("school", collection["school"]);
if (invite != null)
{
if (invite.Email == collection["email"].ToLower())
{
if (account == null)
{
uac.AddNewItem(new UserAccount {
PartitionKey = UserAccountClient.GetPartitionKeyForEmail(collection["email"].ToLower()), RowKey = collection["email"].ToLower(), FirstName = collection["firstname"], LastName = collection["lastname"], Email = collection["email"], Password = collection["password"], ProfileType = "counselor", EmailConfirmed = true
});
CounselorAccountClient сac = new CounselorAccountClient();
AdminAccountClient aac = new AdminAccountClient();
AdminAccount admin = aac.GetBySchool(collection["school"]);
if (admin != null)
{
adminEmail = admin.RowKey;
}
сac.AddNewItem(new CounselorAccount {
RowKey = collection["email"].ToLower(), PhoneNumber = collection["phonenumber"], PhoneExtension = collection["extension"], School = collection["school"]
});
cic.Delete(invite);
}
else
{
ViewBag.Invite = invite;
ViewBag.ErrorMessage = "There is an account already associated with this email. Please log in instead.";
return(View());
}
}
else
{
ViewBag.Invite = invite;
ViewBag.EmailMatch = "Email has to match";
return(View());
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
string sessionkey = ClientSession.GetClientSessionKey("user", collection["email"].ToLower(), collection["firstname"] + " " + collection["lastname"], "counselor");
Response.Cookies["sessionkey"].Value = sessionkey;
Response.Cookies["sessionkey"].Expires = DateTime.UtcNow.AddDays(7);
Response.Cookies["sessionusername"].Value = collection["email"].ToLower();
Response.Cookies["sessionusername"].Expires = DateTime.UtcNow.AddDays(7);
Response.Cookies["cbnvm"].Value = "1";
Response.Cookies["cbnvm"].Expires = DateTime.UtcNow.AddDays(7);
SendCongratulationsEmailToCounselor(collection["email"], collection["firstname"] + " " + collection["lastname"]);
SendUpdateEmailToAdmin(adminEmail, collection["firstname"] + " " + collection["lastname"]);
EmailManager emailManager = new EmailManager();
string schooStr = "";
if (school != null)
{
schooStr = "<p>School name: " + school.SchoolName + "</p>";
}
string str = "<p>Full name: " + collection["firstname"] + " " + collection["lastname"] + "</p><p>Email: " + collection["email"] + "</p><p>Phone Number: " + collection["phonenumber"] + "</p><p>" + collection["extension"] + "</p>" + schooStr;
emailManager.SendMail("*****@*****.**", "Admin", "*****@*****.**", "HS Counselor", str);
TempData["counselor"] = true;
return(RedirectToAction("Index", "CounselorPortal"));
}
public HttpResponse AddSchoolPost(string rowkey)
{
if (AuthTokens[0] == "demo")
{
Response.ContentType = "application/json";
Response.Write("{\"result\": \"done\"}");
Response.End();
return(null);
}
string response = "";
SchoolAccountClient sac = new SchoolAccountClient();
SchoolAccount school = sac.GetByPartitionAndRowKey("school", rowkey);
if (school != null)
{
AdminAccountClient aac = new AdminAccountClient();
AdminAccount admin = aac.GetByPartitionAndRowKey("admin", AuthTokens[1].ToLower());
if (school.Admin != null && school.Admin != "")
{
response = "{\"result\": \"exist\"}";
}
else
{
if (admin.SchoolSelected && !admin.ConnectionToSchoolConfirmed)
{
response = "{\"result\": \"not confirm\"}";
}
else if (admin.ConnectionToSchoolConfirmed)
{
response = "{\"result\": \"dup\"}";
}
else
{
admin.School = school.RowKey;
admin.SchoolSelected = true;
aac.Update(admin);
UserAccountClient uac = new UserAccountClient();
UserAccount user = uac.GetByPartitionAndRowKey(UserAccountClient.GetPartitionKeyForEmail(admin.RowKey), admin.RowKey);
EmailManager emailManager = new EmailManager();
string body = "<div>Admin name: " + user.FirstName + " " + user.LastName + "</div><div>Admin phone number and extension:" + admin.PhoneNumber + " x " + admin.PhoneExtension + "</div><div>Admin Email: " + admin.RowKey + "</div>" +
"<div>School name: " + school.SchoolName + "</div><div>School address" + school.Address + " " + school.City + " " + school.State + " " + school.ZipCode + "</div>" +
"<div>School phone number: " + school.PhoneNumber + "</div>";
emailManager.SendMail("*****@*****.**", "Admin", "*****@*****.**", "Admin request", body);
response = "{\"result\": \"done\"}";
}
}
}
else
{
response = "{\"result\": \"error\"}";
}
//if (school != null)
//{
// //AdminProfileClient apc = new AdminProfileClient();
// //AdminProfile admin = apc.GetByPartitionAndRowKey("adminProfile", AuthTokens[1].ToLower());
// if (admin != null)
// {
// TeacherToSchoolConnectionClient ttscc = new TeacherToSchoolConnectionClient();
// TeacherToSchoolConnection connection = ttscc.GetByPartitionAndRowKey(rowkey, admin.RowKey);
// SchoolToTeacherConnectionClient sttcc = new SchoolToTeacherConnectionClient();
// SchoolToTeacherConnection s2tconnection = sttcc.GetByPartitionAndRowKey(admin.RowKey, rowkey);
// if (connection == null)
// {
// ttscc.AddNewItem(new TeacherToSchoolConnection { PartitionKey = rowkey, RowKey = admin.RowKey });
// sttcc.AddNewItem(new SchoolToTeacherConnection { PartitionKey = admin.RowKey, RowKey = rowkey });
// response = "{\"result\": \"done\"}";
// }
// else
// {
// response = "{\"result\": \"already exist\"}";
// }
// }
// else
// {
// response = "{\"result\": \"fail\"}";
// }
//}
//else
//{
// response = "{\"result\": \"fail\"}";
//}
Response.ContentType = "application/json";
Response.Write(response);
Response.End();
return(null);
}
