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));
}
