public JsonResult ProcessForgotPassword(string ForgotPassword_Email) { bool ForgotPasswordStatus = false; if (login.CheckEmailAddress(ForgotPassword_Email)) { string temp_password = null; using (RandomNumberGenerator rng = new RNGCryptoServiceProvider()) { Byte[] bytes = new Byte[8]; rng.GetBytes(bytes); temp_password = Convert.ToBase64String(bytes); changepassword.UpdatePasswordQuery(ForgotPassword_Email, StringCipher.Encrypt(temp_password)); } string email_body = "Hi user!\r\n\r\nYour temporary password is " + temp_password + ". Please remember to reset your password!"; string email_subject = "Mug Share Web App Reset Password Request"; string email_recipients = ForgotPassword_Email; ForgotPasswordStatus = emailservice.SendEmail(email_recipients, email_subject, email_body); } IsTrueOrFalse model = new IsTrueOrFalse(ForgotPasswordStatus); return(ResultJson(model)); }
public JsonResult LS_MachineIDValidator(string MachineID) { bool machineIDStatus = locationsupply.MachineIDValidator(MachineID); IsTrueOrFalse model = new IsTrueOrFalse(machineIDStatus); return(ResultJson(model)); }
public JsonResult S_EmailValidator(string Email) { bool emailStatus = security.EmailValidator(Email); IsTrueOrFalse model = new IsTrueOrFalse(emailStatus); return(ResultJson(model)); }
public JsonResult ProcessChangePassword(string CurrentPassword, string NewPassword, string RetypeNewPassword) { bool changePasswordStatus = true; string Username = SessionStorage.Username; string Email = SessionStorage.Email; // Check that username and current password matches //string AdminPermission = login.GetAdminPermission(Username, StringCipher.Encrypt(CurrentPassword)); //login.GetAdminPermission(Username, CurrentPassword); if (!(login.GetAdminPermission(Username, CurrentPassword))) { // Username and current password do not match changePasswordStatus = false; } else { // Check that new password and retyped new password matches if (!(string.Compare(NewPassword, RetypeNewPassword) == 0)) { // New password and retyped new password does not match changePasswordStatus = false; } else { // Change current password to the new password changepassword.UpdatePasswordQuery(Email, StringCipher.Encrypt(NewPassword)); } } IsTrueOrFalse model = new IsTrueOrFalse(changePasswordStatus); return(ResultJson(model)); }
public JsonResult MR_MugIDValidator(string MugID) { bool mugIDStatus = mugregistry.MugIDValidator(MugID); IsTrueOrFalse model = new IsTrueOrFalse(mugIDStatus); return(ResultJson(model)); }
public JsonResult S_Delete(string SecurityKey) { bool deleteStatus = security.DeleteQuery(SecurityKey); IsTrueOrFalse model = new IsTrueOrFalse(deleteStatus); return(ResultJson(model)); }
public JsonResult LS_Edit(LocationModalModel jsonString) { string MachineKey = jsonString.MachineKey; string MachineID = jsonString.MachineID; string MachineLocation = jsonString.MachineLocation; int OpeningHour = jsonString.OpeningHour; int ClosingHour = jsonString.ClosingHour; string TotalCapacity = jsonString.TotalCapacity; bool OutOfOrder = jsonString.OutOfOrder; string Notes = jsonString.Notes; //Notes field is allowed to be null, therfore account for string variation if (Notes != null) { Notes = "'" + Notes + "'"; } else { Notes = "NULL"; } bool editStatus = locationsupply.EditQuery(MachineKey, MachineID, MachineLocation, OpeningHour, ClosingHour, TotalCapacity, OutOfOrder, Notes); IsTrueOrFalse model = new IsTrueOrFalse(editStatus); return(ResultJson(model)); }
public JsonResult LS_Delete(string MachineID) { bool deleteStatus = locationsupply.DeleteQuery(MachineID); IsTrueOrFalse model = new IsTrueOrFalse(deleteStatus); return(ResultJson(model)); }
public JsonResult MSU_StudentNumberValidator(string StudentNumber) { bool studentNumberStatus = mugshareusers.StudentNumberValidator(StudentNumber); IsTrueOrFalse model = new IsTrueOrFalse(studentNumberStatus); return(ResultJson(model)); }
public JsonResult MSU_EmailValidator(string Email) { bool emailStatus = mugshareusers.EmailValidator(Email); IsTrueOrFalse model = new IsTrueOrFalse(emailStatus); return(ResultJson(model)); }
public JsonResult MSU_Delete(string UserKey) { bool deleteStatus = mugshareusers.DeleteQuery(UserKey); IsTrueOrFalse model = new IsTrueOrFalse(deleteStatus); return(ResultJson(model)); }
public JsonResult S_StaffCardIDValidator(string StaffCardID) { bool staffCardIDStatus = security.StaffCardIDValidator(StaffCardID); IsTrueOrFalse model = new IsTrueOrFalse(staffCardIDStatus); return(ResultJson(model)); }
public JsonResult S_UsernameValidator(string Username) { bool usernameStatus = security.UsernameValidator(Username); IsTrueOrFalse model = new IsTrueOrFalse(usernameStatus); return(ResultJson(model)); }
public JsonResult MR_Delete(string MugKey) { bool deleteStatus = mugregistry.DeleteQuery(MugKey); IsTrueOrFalse model = new IsTrueOrFalse(deleteStatus); return(ResultJson(model)); }
public JsonResult ProcessLogIn(string LogInUsername, string LogInPassword) { bool logInStatus = login.GetAdminPermission(LogInUsername, LogInPassword); IsTrueOrFalse model = new IsTrueOrFalse(logInStatus); return(ResultJson(model)); }
public JsonResult MR_Create(string MugID) { bool CurrentlyInUse = false; bool createStatus = mugregistry.CreateQuery(MugID, CurrentlyInUse); IsTrueOrFalse model = new IsTrueOrFalse(createStatus); return(ResultJson(model)); }
public JsonResult SendEmailService(string EmailSubject, string EmailBody, string EmailRecipients) { bool sendEmailStatus = true; // Send Email sendEmailStatus = emailservice.SendEmail(EmailRecipients, EmailSubject, EmailBody); IsTrueOrFalse model = new IsTrueOrFalse(sendEmailStatus); return(ResultJson(model)); }
public JsonResult ProcessReturn(string MugID) { bool returnStatus = mugreturn.UpdateMugStatusQuery(MugID); if (returnStatus == true) { string LastBorrowedBy = mugreturn.GetUBC_ID(MugID); returnStatus = mugreturn.UpdateUserStatusQuery(LastBorrowedBy); } IsTrueOrFalse model = new IsTrueOrFalse(returnStatus); return(ResultJson(model)); }
public JsonResult S_Edit(SecurityModalModel jsonString) { string SecurityKey = jsonString.SecurityKey; string FirstName = jsonString.FirstName; string LastName = jsonString.LastName; string StaffCardID = jsonString.StaffCardID; string UserName = StringCipher.Encrypt(jsonString.Username); string Email = jsonString.Email; bool AdminPermission = jsonString.AdminPermission; bool editStatus = security.EditQuery(SecurityKey, FirstName, LastName, StaffCardID, UserName, Email, AdminPermission); IsTrueOrFalse model = new IsTrueOrFalse(editStatus); return(ResultJson(model)); }
public JsonResult S_Create(SecurityModalModel jsonString) { string FirstName = jsonString.FirstName; string LastName = jsonString.LastName; string StaffCardID = jsonString.StaffCardID; string Username = StringCipher.Encrypt(jsonString.Username); string Password = StringCipher.Encrypt(jsonString.Password); string Email = jsonString.Email; bool AdminPermission = jsonString.AdminPermission; bool createStatus = security.CreateQuery(FirstName, LastName, StaffCardID, Username, Password, Email, AdminPermission); IsTrueOrFalse model = new IsTrueOrFalse(createStatus); return(ResultJson(model)); }
public JsonResult MR_Edit(MugsModalModel jsonString) { string MugKey = jsonString.MugKey; string MugID = jsonString.MugID; bool CurrentlyInUse = jsonString.CurrentlyInUse; string Notes = jsonString.Notes; //Notes field is allowed to be null, therfore account for string variation if (Notes != null) { Notes = "'" + Notes + "'"; } else { Notes = "NULL"; } bool editStatus = mugregistry.EditQuery(MugKey, MugID, CurrentlyInUse, Notes); IsTrueOrFalse model = new IsTrueOrFalse(editStatus); return(ResultJson(model)); }
public JsonResult MSU_Create(UsersModalModel jsonString) { string StudentNumber = jsonString.StudentNumber; string FirstName = jsonString.FirstName; string LastName = jsonString.LastName; string Email = jsonString.Email; string Notes = jsonString.Notes; //Notes field is allowed to be null, therfore account for string variation if (Notes != null) { Notes = "'" + Notes + "'"; } else { Notes = "NULL"; } bool createStatus = mugshareusers.CreateQuery(StudentNumber, FirstName, LastName, Email, Notes); IsTrueOrFalse model = new IsTrueOrFalse(createStatus); return(ResultJson(model)); }
public JsonResult MSU_Edit(UsersModalModel jsonString) { string UserKey = jsonString.UserKey; string StudentNumber = jsonString.StudentNumber; string FirstName = jsonString.FirstName; string LastName = jsonString.LastName; string Email = jsonString.Email; bool MugInUse = jsonString.MugInUse; string DateOfRental = jsonString.DateOfRental; string Notes = jsonString.Notes; //Date of rental field is allowed to be null, therfore account for string variation if (DateOfRental != null) { DateOfRental = "'" + DateOfRental + "'"; } else { DateOfRental = "NULL"; } //Notes field is allowed to be null, therfore account for string variation if (Notes != null) { Notes = "'" + Notes + "'"; } else { Notes = "NULL"; } bool editStatus = mugshareusers.EditQuery(UserKey, StudentNumber, FirstName, LastName, Email, MugInUse, DateOfRental, Notes); IsTrueOrFalse model = new IsTrueOrFalse(editStatus); return(ResultJson(model)); }
public JsonResult MSU_Excel(string ExcelPath) { //string connectionString = @"C:\Users\Logan\Downloads\StudentInfoExample.xlsx"; string connectionString = ExcelPath; string sheetName = "Sheet1"; bool createStatus = false; //tempString is the hardcoded working string, and connectionString is the same string passed through ajax //if(tempString != connectionString) //{ // IsTrueOrFalse temp = new IsTrueOrFalse(false); // return ResultJson(temp); //} List <UsersModalModel> list = new List <UsersModalModel>(); //connect to excel document and get row data var excelFile = new ExcelQueryFactory(connectionString); var studentRecords = from a in excelFile.Worksheet(sheetName) select a; //create UsersModalModel models containing the data from excel document foreach (var a in studentRecords) { UsersModalModel model = new UsersModalModel(); model.StudentNumber = a["STUD_NO"]; model.FirstName = a["GIVEN_NAME"]; model.LastName = a["SURNAME"]; model.Email = a["EMAIL_ADDRESS"]; model.TotalMugsBorrowed = "0"; list.Add(model); } //get ride of duplicates based on student numbers list = list.GroupBy(x => x.StudentNumber).Select(y => y.First()).ToList(); //delete all records from the MugShareUsers table in database if (list.Count > 0) { string clearMSUTable = "DELETE FROM MugShareUsers"; createStatus = mugshareusers.QueryProcessor(clearMSUTable); } //make query string to input excel data into database if (createStatus) { string dataEntryQuery = "INSERT INTO MugShareUsers (StudentNumber, FirstName, LastName, Email, MugInUse, TotalMugsBorrowed) VALUES "; foreach (UsersModalModel element in list) { string recordValues = "(" + element.StudentNumber + ", '" + element.FirstName + "', '" + element.LastName + "', '" + element.Email + "', 'false', 0), "; dataEntryQuery += recordValues; } dataEntryQuery = dataEntryQuery.Substring(0, dataEntryQuery.Length - 2); createStatus = mugshareusers.QueryProcessor(dataEntryQuery); } IsTrueOrFalse boolModel = new IsTrueOrFalse(createStatus); return(ResultJson(boolModel)); }