public CabinetModel Put(CabinetModel model)
{
var cabinet = dbContext.Cabinets
.Include(c => c.Medications)
.FirstOrDefault(m => m.Id == model.Id);
if (cabinet == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
cabinet.Name = model.Name ?? cabinet.Name;
cabinet.LastUpdated = DateTime.Now;
if (model.Medications != null)
{
// Remove all medications from the cabinet
foreach (var dbMedication in cabinet.Medications)
{
dbContext.Remove(dbMedication);
}
// Re-populate the cabinet
cabinet.Medications = model.Medications.Select(m => m.ToDbMedication()).ToList();
}
dbContext.Commit();
return(Get(model.Id));
}
public HttpResponseMessage ScanVerification(CabinetModel model)
{
string Result = string.Empty;
try
{
//请求中包含的固定参数
model.SOURCE = ParametersFilter.FilterSqlHtml(model.SOURCE, 24);
model.CREDENTIALS = ParametersFilter.FilterSqlHtml(model.CREDENTIALS, 24);
model.ADDRESS = HttpHelper.IPAddress();
model.TERMINAL = ParametersFilter.FilterSqlHtml(model.TERMINAL, 1);
model.INDEX = ParametersFilter.FilterSqlHtml(model.INDEX, 24);
model.METHOD = ParametersFilter.FilterSqlHtml(model.METHOD, 24);
//去除用户参数中包含的特殊字符
model.QRCODE = ParametersFilter.StripSQLInjection(model.QRCODE);
//返回结果
Result = ApiHelper.HttpRequest(username, password, Url, model);
}
catch (Exception ex)
{
LogHelper.LogError(ex.ToString());
}
HttpResponseMessage Respend = new HttpResponseMessage {
Content = new StringContent(Result, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(Respend);
}
public void FirstRun()
{
string ApplicationDataDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), _appName);
string BaseConfigurationFilename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), _appName, "BaseConfig.json");
string CabinetConfigurationFilename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), _appName, "CabinetConfig.json");
string CabinetFilesDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), _appName);
string ExcelExportDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), _appName);
if (!Directory.Exists(ApplicationDataDirectory))
{
Directory.CreateDirectory(ApplicationDataDirectory);
}
if (!Directory.Exists(CabinetFilesDirectory))
{
Directory.CreateDirectory(CabinetFilesDirectory);
}
if (!Directory.Exists(ExcelExportDirectory))
{
Directory.CreateDirectory(ExcelExportDirectory);
}
if (!File.Exists(BaseConfigurationFilename))
{
var baseConf = new BaseConfiguration
{
cabinetFilesDirectory = CabinetFilesDirectory,
excelExportDirectory = ExcelExportDirectory
};
synchrontization.BaseSave(baseConf);
}
if (!File.Exists(CabinetConfigurationFilename))
{
var cabConf = new CabinetModel
{
name = "Default",
height = 720,
width = 600,
depth = 510,
sizeElement = 18,
back = 3,
enumFront = 9,
Slots = new Slots
{
Left = 3,
Right = 3,
Bottom = 3,
Top = 3,
BetweenCabinet = 2,
BetweenHorizontally = 3,
BetweenVertically = 3
}
};
synchrontization.CabSave(cabConf);
}
}
public void verifyStandardCabinet(CabinetModel cabinet, int id)
{
Assert.AreEqual(id, cabinet.Id);
Assert.AreEqual(3, cabinet.Medications.Count());
foreach (var medication in cabinet.Medications)
{
verifyStandardMedication(medication, medication.Id);
}
}
public static void materializeCabinet(CabinetModel cabinet)
{
// Underlying database will materialize result.Medications but our mock does not, so materialize it here
cabinet.Medications = cabinet.Medications.ToList();
// Underlying database will set IDs but our mock does not, so reset them prior to verifying cabinet
foreach (var medication in cabinet.Medications)
{
materializeMedication(medication);
}
}
public CabinetModel Post(CabinetModel model)
{
if (!dbContext.Users.Any(u => u.Id == model.UserId))
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
var cabinet = model.ToDbCabinet();
dbContext.Add(cabinet);
dbContext.Commit();
return(Get(cabinet.Id));
}
public ActionResult Cabinet()
{
CabinetModel cabinet = new CabinetModel();
using (var db = new QuestionContext())
{
cabinet.tests = db.Tests.ToList();
}
using (var db = new SaveContext())
{
cabinet.RSM = db.Save.Where(x => x.UserName == HttpContext.User.Identity.Name).ToList();
}
return(View(cabinet));
}
public HttpResponseMessage CounterLogin(CabinetModel model)
{
string Result = string.Empty;
try
{
//请求中包含的固定参数
model.SOURCE = ParametersFilter.FilterSqlHtml(model.SOURCE, 24);
model.CREDENTIALS = ParametersFilter.FilterSqlHtml(model.CREDENTIALS, 24);
model.ADDRESS = HttpHelper.IPAddress();
model.TERMINAL = ParametersFilter.FilterSqlHtml(model.TERMINAL, 1);
model.INDEX = ParametersFilter.FilterSqlHtml(model.INDEX, 24);
model.METHOD = ParametersFilter.FilterSqlHtml(model.METHOD, 24);
//去除用户参数中包含的特殊字符
model.DATA = ParametersFilter.StripSQLInjection(model.DATA);
if (model.TERMINAL == "2")
{
model.DATA = System.Web.HttpUtility.UrlEncode(model.DATA);
}
//返回结果
Result = ApiHelper.HttpRequest(username, password, Url, model);
///写日志
string RequestAction = "api/" + username + "/" + HttpContext.Current.Request.RequestContext.RouteData.Values["action"].ToString() + "：";
LogHelper.LogResopnse(RequestAction + Result);
}
catch (Exception ex)
{
LogHelper.LogError(ex.ToString());
}
HttpResponseMessage Respend = new HttpResponseMessage {
Content = new StringContent(Result, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(Respend);
}
public CabinetModel GetCabinet(string login)
{
CabinetModel cabinet = new CabinetModel();
using (SqlConnection conn = new SqlConnection(_connectionStringCabinet))
{
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.GetAgentByLogin", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@login", login);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
cabinet.AgentId = reader["Id"] != DBNull.Value ? Convert.ToInt32(reader["Id"]) : 0;
cabinet.AgentName = reader["Name"] != DBNull.Value ? Convert.ToString(reader["Name"]) : string.Empty;
cabinet.QueryCount = reader["QueryCount"] != DBNull.Value ? Convert.ToInt32(reader["QueryCount"]) : 0;
cabinet.Query = reader["Query"] != DBNull.Value ? Convert.ToInt32(reader["Query"]) : 0;
cabinet.IsTest = reader["IsTest"] != DBNull.Value ? Convert.ToBoolean(reader["IsTest"]) : false;
}
}
return(cabinet);
}
public void CabSave(CabinetModel cabConf)
{
File.WriteAllText(CabinetConfigurationFilename, JsonConvert.SerializeObject(cabConf, Formatting.Indented));
}
public Config()
{
FirstRun();
_baseConfiguration = synchrontization.BaseRead();
_cabinetModel = synchrontization.CabRead();
}
