public async Task <IActionResult> Save(SensorEditModel model)
{
if (!ModelState.IsValid)
{
return(View("Edit", model));
}
var entity = _mapper.Map <Sensor>(model);
if (model.IsEdit)
{
_context.Sensors.Update(entity);
}
else
{
_context.Sensors.Add(entity);
}
await _context.SaveChangesAsync();
TempData[ViewKeys.Message] = "Sensor saved successfully.";
TempData[ViewKeys.IsSuccess] = true;
return(RedirectToAction("Index"));
}
public static SelectResult <SensorEditModel> GetSensorTypeID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@id", SqlDbType.Int),
};
paras[0].Value = id;
string sql = @"SELECT * FROM dbo.SensorList WHERE TypeID=@id";
List <SensorEditModel> list = ConvertToList <SensorEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
SensorEditModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <SensorEditModel>()
{
DataResult = data,
Message = msg
});
}
public static OperationResult EditSensorType(SensorEditModel model, int EditUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@TypeID", SqlDbType.Int),
//new SqlParameter("@SensorName",SqlDbType.NVarChar,30),
new SqlParameter("@TValue", SqlDbType.Bit),
new SqlParameter("@FValue", SqlDbType.Bit),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@EditTime", SqlDbType.DateTime),
new SqlParameter("@EditUserID", SqlDbType.Int),
};
paras[0].Value = model.TypeID;
paras[1].Value = model.Value1;
paras[2].Value = model.Value2;
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[3].Value = DBNull.Value;
}
else
{
paras[3].Value = model.Remark;
}
paras[4].Value = DateTime.Now;
paras[5].Value = EditUserID;
#region SQL
string sql;
sql = @"UPDATE dbo.SensorList
SET Value1=@TValue,Value2 = @FValue,Remark=@Remark ,EditTime=@EditTime,EditUserID=@EditUserID
WHERE TypeID = @TypeID";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
public ActionResult EditSensorTypes(SensorEditModel model)
{
if (ModelState.IsValid)
{
var result = SensorBLL.EditSensorType(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Edit, result, "SensorName:" + model.SensorName);
return(Json(result));
}
else
{
return(PartialView("_EditSensorType", model));
}
}
public static MvcHtmlString AssetSensorCreatedStatusMsg(this HtmlHelper htmlHelper, ModelStateDictionary modelState, SensorEditModel model, string currCity, string assetIdStatus)
{
var sb = new StringBuilder();
if (model.Saved)
{
sb.Append("<span class=\"").Append("page-validation-error").Append("\">");
if (assetIdStatus == "New")
{
sb.Append("New Sensor " + model.AssetId + " for City " + currCity + " Successfully Created.");
}
else
{
sb.Append("Sensor " + model.AssetId + " for City " + currCity + " Successfully Updated.");
}
sb.Append("</span>");
}
else
{
sb.Append("<span class=\"").Append("page-validation-error").Append("\">");
sb.Append("");
sb.Append("</span>");
}
return(MvcHtmlString.Create(sb.ToString()));
}
