public ActionResult Create(SchoolAccount model)
{
try
{
// TODO: Add insert logic here
// model.Amount = theFeetoBeApproved.Paid;
model.ApprovedBy = User.Identity.Name;
model.BankDraftNumber = "";
model.ChequeNumber = "";
model.DateApproved = DateTime.Now;
model.EnteredBy = User.Identity.Name;
model.PaidDate = DateTime.Now;
model.POSTransactionNumber = "";
model.StudentID = 0;
model.TellerNumber = "";
model.TransactionMethod = "";
model.TransactionType = "Credit";
model.Session = "";
model.Balance = new SchoolAccountBalanceHelper().getSchoolAccountBalance(model.Amount);
work.SchoolAccountRepository.Insert(model);
work.Save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//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 ActionResult Edit2(int id)
{
try
{
SchoolFeePayment theFeetoBeApproved = work.SchoolFeePaymentRepository.GetByID(id);
theFeetoBeApproved.Approved = true;
work.SchoolFeePaymentRepository.Update(theFeetoBeApproved);
SchoolFeesAccount thePayment = new SchoolFeesAccount();
thePayment.Amount = theFeetoBeApproved.Paid;
thePayment.ApprovedBy = User.Identity.Name;
thePayment.BankDraftNumber = theFeetoBeApproved.BankDraftNumber;
thePayment.ChequeNumber = theFeetoBeApproved.ChequeNumber;
thePayment.DateApproved = DateTime.Now;
thePayment.EnteredBy = theFeetoBeApproved.EnteredBy;
thePayment.PaidDate = theFeetoBeApproved.DatePaid;
thePayment.POSTransactionNumber = theFeetoBeApproved.POSTransactionNumber;
thePayment.StudentID = theFeetoBeApproved.StudentID;
thePayment.TellerNumber = theFeetoBeApproved.TellerNumber;
thePayment.TransactionMethod = theFeetoBeApproved.PaymentMethod;
thePayment.TransactionType = "Credit";
thePayment.Session = theFeetoBeApproved.Session;
thePayment.Level = theFeetoBeApproved.Level;
work.SchoolFeesAccountRepository.Insert(thePayment);
SchoolAccount thePayment1 = new SchoolAccount();
thePayment1.Amount = theFeetoBeApproved.Paid;
thePayment1.ApprovedBy = User.Identity.Name;
thePayment1.BankDraftNumber = theFeetoBeApproved.BankDraftNumber;
thePayment1.ChequeNumber = theFeetoBeApproved.ChequeNumber;
thePayment1.DateApproved = DateTime.Now;
thePayment1.EnteredBy = theFeetoBeApproved.EnteredBy;
thePayment1.PaidDate = theFeetoBeApproved.DatePaid;
thePayment1.POSTransactionNumber = theFeetoBeApproved.POSTransactionNumber;
thePayment1.StudentID = theFeetoBeApproved.StudentID;
thePayment1.TellerNumber = theFeetoBeApproved.TellerNumber;
thePayment1.TransactionMethod = theFeetoBeApproved.PaymentMethod;
thePayment1.TransactionType = "Credit";
thePayment1.Session = theFeetoBeApproved.Session;
thePayment1.Level = theFeetoBeApproved.Level;
thePayment1.Balance = new SchoolAccountBalanceHelper().getSchoolAccountBalance(thePayment1.Amount);
work.SchoolAccountRepository.Insert(thePayment1);
work.Save();
// TODO: Add update logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(string id)
{
try
{
Int32 theId = Convert.ToInt32(Models.Encript.DecryptString(id, true));
Order theOrder = work.OrderRepository.GetByID(theId);
theOrder.Approved = true;
SchoolAccount thePayment1 = new SchoolAccount();
thePayment1.Amount = theOrder.TotalAmount;
thePayment1.ApprovedBy = User.Identity.Name;
//thePayment1.BankDraftNumber = ;
// thePayment1.ChequeNumber = theFeetoBeApproved.ChequeNumber;
thePayment1.DateApproved = DateTime.Now;
// thePayment1.EnteredBy = theFeetoBeApproved.EnteredBy;
thePayment1.PaidDate = Convert.ToDateTime(theOrder.OrderDate);
// thePayment1.POSTransactionNumber = theFeetoBeApproved.POSTransactionNumber;
thePayment1.StudentID = theOrder.studentID;
// thePayment1.TellerNumber = theFeetoBeApproved.TellerNumber;
thePayment1.TransactionMethod = Convert.ToString(theOrder.OrderNumber);
thePayment1.TransactionType = "Credit, Stored Item Sold";
thePayment1.Balance = new SchoolAccountBalanceHelper().getSchoolAccountBalance(thePayment1.Amount);
List <TermRegistration> theTermReg = new List <TermRegistration>();
theTermReg = work.TermRegistrationRepository.Get(a => a.StudentID == theOrder.studentID).OrderByDescending(a => a.DateRegistered).ToList();
if (theTermReg.Count() > 0)
{
thePayment1.Session = theTermReg[0].Session;
}
thePayment1.Level = theOrder.Level;// theFeetoBeApproved.Level;
work.SchoolAccountRepository.Insert(thePayment1);
work.Save();
// TODO: Add update logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
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);
}
//
// GET: /SchoolAccount/Edit/5
public ActionResult Edit()
{
SchoolAccount theAccount = new SchoolAccount();
return(View(theAccount));
}
public ActionResult Edit(string id)
{
Int32 theId = Convert.ToInt32(Models.Encript.DecryptString(id, true));
OrderItem theOrderItem = work.OrderItemRepository.GetByID(theId);
string theItemName = theOrderItem.ItemName;
int theItemQuantity = theOrderItem.Quantity;
List <Store> theStore = work.StoreRepository.Get(a => a.ItemName.Equals(theItemName)).ToList();
if (theStore.Count > 0)
{
Store theStoreItem = theStore[0];
theStoreItem.Quanity = theItemQuantity + theStoreItem.Quanity;
work.StoreRepository.Update(theStoreItem);
work.Save();
Order theOrder = work.OrderRepository.GetByID(theOrderItem.OrderID);
theOrder.ItemQuantity = theOrder.ItemQuantity - theItemQuantity;
theOrder.TotalAmount = theOrder.TotalAmount - theOrderItem.SubTotal;
// theOrder.OrderDate = theOrder.OrderDate;
if (theOrder.ItemQuantity == 0)
{
work.OrderRepository.Delete(theOrder);
}
else
{
work.OrderRepository.Update(theOrder);
}
work.OrderItemRepository.Delete(theOrderItem);
string orderNumberString = theOrderItem.OrderNumber.ToString();
List <SchoolAccount> theAccount = new List <SchoolAccount>();
theAccount = work.SchoolAccountRepository.Get(a => a.TransactionMethod == orderNumberString).ToList();
if (theAccount.Count() > 0)
{
decimal theAmount = theOrderItem.SubTotal;
SchoolAccount thePaymenttoBeDeleted = new SchoolAccount();
thePaymenttoBeDeleted = theAccount[0];
thePaymenttoBeDeleted.Amount = thePaymenttoBeDeleted.Amount - theAmount;
if (thePaymenttoBeDeleted.Amount == 0)
{
work.SchoolAccountRepository.Delete(thePaymenttoBeDeleted);
}
else
{
work.SchoolAccountRepository.Update(thePaymenttoBeDeleted);
}
}
work.Save();
if (User.Identity.Name != "5000001")
{
AuditTrail audit = new AuditTrail {
Date = DateTime.Now, Action = "An Order was reversed, item name:-" + " " + theItemName + " " + "Quntities :- " + theItemQuantity, UserID = User.Identity.Name
};
work.AuditTrailRepository.Insert(audit);
work.Save();
}
}
return(RedirectToAction("Index", "Order"));
// return View("Order");
}