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 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)); }
/* * Function: GetRecord * * Get data for security modals. * * Returns: * * model - a SecurityModalModel model of the record with the primary key equal to the SecurityKey */ public static SecurityModalModel GetRecord(string SecurityKey) { SqlConnection dbconnection = new SqlConnection(); SqlCommand dbcommand = new SqlCommand(); SqlDataReader dbreader; string connectionstring = ConfigurationManager.ConnectionStrings["MugShareDB"].ToString(); string queryString = "SELECT * FROM Security WHERE pKey = " + SecurityKey; SecurityModalModel model = new SecurityModalModel(); try { if (dbconnection.State == ConnectionState.Closed) { dbconnection.ConnectionString = connectionstring; dbconnection.Open(); } dbcommand.Connection = dbconnection; dbcommand.CommandTimeout = 600; dbcommand.CommandText = queryString; dbcommand.CommandType = CommandType.Text; dbreader = dbcommand.ExecuteReader(); if (dbreader.HasRows) { dbreader.Read(); if (!string.IsNullOrEmpty(dbreader["pKey"].ToString())) { model.SecurityKey = dbreader["pKey"].ToString(); } if (!string.IsNullOrEmpty(dbreader["FirstName"].ToString())) { model.FirstName = dbreader["FirstName"].ToString(); } if (!string.IsNullOrEmpty(dbreader["LastName"].ToString())) { model.LastName = dbreader["LastName"].ToString(); } if (!string.IsNullOrEmpty(dbreader["StaffCardID"].ToString())) { model.StaffCardID = dbreader["StaffCardID"].ToString(); } if (!string.IsNullOrEmpty(dbreader["Username"].ToString())) { model.Username = StringCipher.Decrypt(dbreader["Username"].ToString()); } if (!string.IsNullOrEmpty(dbreader["Email"].ToString())) { model.Email = dbreader["Email"].ToString(); } if (dbreader["AdminPermission"].ToString() == "True") { model.AdminPermission = true; } else { model.AdminPermission = false; } } return(model); } catch (Exception e) { throw new Exception(@"Mug-Share Application GetRecord() failed : ", e); } finally { if (dbconnection.State == ConnectionState.Open) { dbconnection.Close(); } } }
public JsonResult S_GetRecord(string SecurityKey) { SecurityModalModel model = security.GetRecord(SecurityKey); return(ResultJson(model)); }