public async Task <bool> SendLogs(string LogsFilePath)
{
LogsModel logModel = new LogsModel();
logModel.fileName = Path.GetFileName(LogsFilePath);
logModel.fileContent = System.IO.File.ReadAllBytes(LogsFilePath);
string Uri = @"/Stream/GetLogFile";
var obj = JsonConvert.SerializeObject(logModel);
var content = new StringContent(obj, Encoding.UTF8, "application/json");
try
{
var response = await httpClient.PostAsync(Uribase + Uri, content);
var result = await response.Content.ReadAsStringAsync();
return(JsonConvert.DeserializeObject <bool>(result));
}
catch (Exception ex)
{
await DependencyService.Get <ILogger>().WriteLog(ex);
return(false);
}
}
public List <LogsModel> GetLogs(int requestId)
{
List <LogsModel> logs = new List <LogsModel>();
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.GetLogs", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@requestId", requestId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LogsModel log = new LogsModel();
log.Id = reader["Id"] != DBNull.Value ? Convert.ToInt32(reader["Id"]) : 0;
log.Command = reader["Command"] != DBNull.Value ? Convert.ToString(reader["Command"]) : string.Empty;
log.LogTime = reader["LogTime"] != DBNull.Value ? Convert.ToDateTime(reader["LogTime"]) : DateTime.MinValue;
log.ProfileId = reader["ProfileId"] != DBNull.Value ? Convert.ToInt32(reader["ProfileId"]) : 0;
log.Name = reader["Name"] != DBNull.Value ? Convert.ToString(reader["Name"]) : string.Empty;
log.Surname = reader["Surname"] != DBNull.Value ? Convert.ToString(reader["Surname"]) : string.Empty;
logs.Add(log);
}
}
return(logs);
}
public LogsModel GetLogsByDate(LogsModel logs)
{
string date = String.Concat(logs.Date.Substring(8), ".", logs.Date.Substring(5).Remove(2), ".", logs.Date.Remove(4));
string file = $"{Directory.GetCurrentDirectory()}\\logs\\log_{date}.txt";
return(ReturnLogsModel(date, file));
}
public ActionResult Logs(LogsModel LModel)
{
string type = LModel.TypeChose;
//check for entered type
if (string.IsNullOrEmpty(type) || (!type.Equals("INFO") && !type.Equals("FAIL") && !type.Equals("WARNING")))
{
//no enterd or not valid
foreach (Log log in model.Logs)
{
model.LogsFilter.Add(log);
}
}
else
{
//filter the logs by the given type
model.LogsFilter.Clear();
foreach (Log log in model.Logs)
{
if (log.Type.Equals(type))
{
model.LogsFilter.Add(log);
}
}
}
return(View(model));
}
public JsonResult GetLogFile(LogsModel logModel)
{
string filePath = Server.MapPath(@"~/Logs/MobileLogs" + logModel.fileName);
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
try
{
using (var fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))
fs.Write(logModel.fileContent, 0, logModel.fileContent.Length);
return(new JsonResult {
Data = true, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
return(new JsonResult {
Data = false, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
throw ex;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="LogsViewModel"/> class.
/// </summary>
public LogsViewModel()
{
logsModel = new LogsModel();
logsModel.ReceivedLog += OnLogReceived;
logs = new ObservableCollection <MessageRecievedEventArgs>();
//logs.Add(new MessageRecievedEventArgs("Liora", MessageTypeEnum.INFO));
}
private void UpdateModel(LogsModel model)
{
_subscription?.Dispose();
_subscription = model
.WhenAnyValue(x => x.SelectedItem)
.Subscribe(x => SelectedItem = x);
}
public IActionResult Logs()
{
LogsModel model = new LogsModel();
model.Logs = _appEntities.GetLogs().ToList();
model.ClearLogsDate = DateTime.Now;
return(View(model));
}
/// <summary>
/// 获取日志表单信息
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string FindForm(HttpContext context)
{
string fId = context.Request.Params["fId"];
LogsModel logModel = logsBll.FindForm(fId);
return(SuccessResult(logModel));
}
/// <summary>
/// Constructor
/// </summary>
public LogsViewModel()
{
LogsModel = new LogsModel();
// sign to the event of property changed
LogsModel.PropertyChanged +=
delegate(Object sender, PropertyChangedEventArgs e) {
NotifyPropertyChanged("VM_" + e.PropertyName);
};
}
public IActionResult Logs(LogsModel model)
{
if (model != null && ModelState.IsValid)
{
_appEntities.DeleteLogs(model.ClearLogsDate);
}
model.Logs = _appEntities.GetLogs().ToList();
return(View(model));
}
public async Task <ActionResult> Logs()
{
LogsModel model = new LogsModel();
using (DAL.ApiDataContext ctx = new DAL.ApiDataContext())
{
model.Logs = await ctx.Logs.OrderByDescending(x => x.LogDate).ToListAsync();
}
return(View(model));
}
public ActionResult Logs()
{
/*List<MessageRecievedEventArgs> logsList = new List<MessageRecievedEventArgs>()
* {
* new MessageRecievedEventArgs("Hello",MessageTypeEnum.INFO)
* };*/
//logsModel.Logs = logsList;
logsModel = new LogsModel(WebClient.GetInstance());
return(View(logsModel));
}
public LogsModule()
: base("/logs")
{
Get["/"] = (parameters) =>
{
var model = new LogsModel()
{
LogMessages = GetLatestLogs(500)
};
return(View["logs.html", model]);
};
}
/// <summary>
/// 获取表格所有信息
/// </summary>
/// <param name="queryParam">查询条件</param>
/// <param name="pagination">分页信息</param>
/// <returns></returns>
public List <LogsModel> FindPageList(Dictionary <string, string> queryParam, Pagination pagination)
{
string sql = @"select logs.* from Sys_Logs logs where 1=1 ";
List <DbParameter> paramters = new List <DbParameter>();
if (!string.IsNullOrEmpty(queryParam["system"]))
{
sql += " and F_System=@F_System";
paramters.Add(new SqlParameter("@F_System", SqlDbType.NVarChar)
{
Value = queryParam["system"]
});
}
if (!string.IsNullOrEmpty(queryParam["startTime"]))
{
sql += " and F_CreateTime > @startTime";
paramters.Add(new SqlParameter("@startTime", SqlDbType.NVarChar)
{
Value = queryParam["startTime"]
});
}
if (!string.IsNullOrEmpty(queryParam["endTime"]))
{
sql += " and F_CreateTime < @endTime";
paramters.Add(new SqlParameter("@endTime", SqlDbType.NVarChar)
{
Value = queryParam["endTime"]
});
}
if (!string.IsNullOrEmpty(queryParam["keyword"]))
{
sql += " and (F_OptContent like @keyword or F_Module like @keyword )";
paramters.Add(new SqlParameter("@keyword", SqlDbType.NVarChar)
{
Value = string.Format("%{0}%", queryParam["keyword"])
});
}
string pageSql = DbHelper.GetPageSql(sql, pagination, "F_CreateTime", paramters.ToArray());
List <LogsModel> logs = new List <LogsModel>();
using (DbDataReader dr = DbHelper.ExecuteReader(pageSql, paramters.ToArray()))
{
while (dr.Read())
{
LogsModel log = ReaderToModel <LogsModel>(dr);
logs.Add(log);
}
}
return(logs);
}
/// <summary>
/// 将日志写入到数据库的方法
/// </summary>
/// <param name="sysLogModel">系统传过来的日志信息</param>
/// <returns></returns>
public bool AddSysLog(BaseSysLogModel sysLogModel)
{
LogsModel model = sysLogModel.Copy<LogsModel>();
var loginInfo = OperatorProvider.Provider.GetCurrent();
if (loginInfo != null)
{
model.F_IPAddress = loginInfo.LoginIpAddress;
model.F_IPCity = loginInfo.LoginIpAddressName;
}
return logsDal.AddForm(model);
}
public LogsVM()
{
this.m_logsModel = new LogsModel();
m_logsModel.PropertyChanged +=
delegate(object sender, PropertyChangedEventArgs e)
{
NotifyPropertyChanged("VM_" + e.PropertyName);
};
//m_logsModel.PropertyChanged += delegate (object sender, PropertyChangedEventArgs e)
//{
// NotifyPropertyChanged(e.PropertyName);
//};
}
public ActionResult Logs(string type)
{
logsModel = new LogsModel(WebClient.GetInstance());
if (MessageTypeEnum.INFO.ToString() == type || MessageTypeEnum.WARNING.ToString() == type ||
MessageTypeEnum.FAIL.ToString() == type)
{
List <MessageRecievedEventArgs> tempLogs = new List <MessageRecievedEventArgs>();
foreach (MessageRecievedEventArgs log in logsModel.Logs)
{
if (log.Status.ToString() == type)
{
tempLogs.Add(log);
}
}
logsModel.Logs = tempLogs;
}
return(View(logsModel));
}
/// <summary>
/// 批量日志写入到数据库的方法
/// </summary>
/// <param name="sysLogList">系统传过来的日志列表</param>
/// <returns></returns>
public bool AddSysLog(List<BaseSysLogModel> sysLogList)
{
List<LogsModel> modelList = new List<LogsModel>();
var loginInfo = OperatorProvider.Provider.GetCurrent();
foreach (BaseSysLogModel sysLogModel in sysLogList)
{
LogsModel model = sysLogModel.Copy<LogsModel>();
if (loginInfo != null)
{
model.F_IPAddress = loginInfo.LoginIpAddress;
model.F_IPCity = loginInfo.LoginIpAddressName;
}
modelList.Add(model);
}
return logsDal.AddFormList(modelList);
}
private LogsModel ReturnLogsModel(string date, string file)
{
string text = "За указанную дату нет логов!";
try
{
using (StreamReader sr = new StreamReader(file))
{
text = sr.ReadToEnd();
}
}
catch { };
LogsModel model = new LogsModel
{
Date = date,
Text = text
};
return(model);
}
/// <summary>
/// 获取日志表单信息
/// </summary>
/// <param name="fId">日志Id</param>
/// <returns></returns>
public LogsModel FindForm(string fId)
{
string sql = "select * from sys_Logs where F_Id=@F_Id";
DbParameter[] parameters = new DbParameter[] {
new SqlParameter("@F_Id", SqlDbType.VarChar)
{
Value = fId
}
};
LogsModel log = null;
using (DbDataReader dr = DbHelper.ExecuteReader(sql, parameters))
{
if (dr.Read())
{
log = ReaderToModel <LogsModel>(dr);
}
}
return(log);
}
/*
* Camera noticed movement. Show alert
* */
private void CameraViewfinder_AlertEvent()
{
if (MainPageModel.NotificationEnabled)
{
if (_nextAlarmDelayTimer == null)
{
// Play alert
FrameworkDispatcher.Update();
_alarmSound.Play();
// Show alert user control
this.CameraViewfinder.ShowAlert();
// Send "Alert" notification into service
string message = "ALERT " + LogsModel.GetNow();
SendNotification(message);
// Count down to time for allowing next alarm sending
_nextAlarmDelayTicks = (int)this.ActivitySlider.Maximum;
_nextAlarmDelayTimer = new DispatcherTimer();
_nextAlarmDelayTimer.Interval = new TimeSpan(0, 0, 0, 0, 10 * 1000 / _nextAlarmDelayTicks);
_nextAlarmDelayTimer.Tick += new EventHandler(AlarmDelay_Tick);
// Update slider style to Orange
this.ActivitySlider.Style = Application.Current.Resources["CustomSliderStyle_Orange"] as Style;
// Remove DataContext from ActivitySlider
this.ActivitySlider.DataContext = null;
this.ActivitySlider.Value = this.ActivitySlider.Maximum;
// Store alarm to history log
LogsModel.AddAlarmToLog();
_nextAlarmDelayTimer.Start();
}
}
}
public static void GravarLogNobanco(string logar, string pEtapa = "")
{
LogsController logs = new LogsController();
LogsModel logsModel = new LogsModel();
logsModel.id_arquivo = 0;
logsModel.etapa = pEtapa;
if (logar.ToUpper().IndexOf("INSERT") >= 0 ||
logar.ToUpper().IndexOf("SELECT") >= 0 ||
logar.ToUpper().IndexOf("UPDATE") >= 0 ||
logar.ToUpper().IndexOf("DELETE") >= 0 ||
logar.ToUpper().IndexOf("CREATE TABLE") >= 0 ||
logar.ToUpper().IndexOf("DROP TABLE") >= 0)
{
logsModel.ComandoSql = logar;
logsModel.Mensagem = "Comando Sql executado no Banco de Dados.";
}
else
{
logsModel.ComandoSql = "";
logsModel.Mensagem = logar;
}
logs.GravaLog(logsModel.id_arquivo, logsModel.etapa, logsModel.Mensagem, logsModel.ComandoSql);
}
private static LogsModel LogEntriesToModel(IList <CloudLogEntry> entryList, int requestedCount)
{
if (entryList.Count == 0)
{
return(new LogsModel {
NewestToken = string.Empty, Groups = new LogGroup[0]
});
}
var logsModel = new LogsModel
{
NewestToken = EntryToToken(entryList[0]),
Groups = entryList.GroupBy(EntryToGroupKey).Select(group => new LogGroup
{
Key = group.Key,
Title = group.First().DateTimeUtc.ToLongDateString(),
NewestToken = EntryToToken(group.First()),
OldestToken = EntryToToken(group.Last()),
Entries = group.Select(entry => new LogItem
{
Token = EntryToToken(entry),
Time = entry.DateTimeUtc.ToString("HH:mm:ss"),
Level = entry.Level,
Message = HttpUtility.HtmlEncode(entry.Message),
Error = HttpUtility.HtmlEncode(entry.Error ?? string.Empty)
}).ToArray()
}).ToArray()
};
if (entryList.Count == requestedCount)
{
logsModel.Groups.Last().OlderAvailable = true;
}
return(logsModel);
}
public async Task <IActionResult> GetSortLogs()
{
var Dates = await _db.ItemLogs
.Select(x => x.LogDateTransfer.Date)
.Distinct()
.ToListAsync();
LogsOfLogsModel LogsList = new LogsOfLogsModel();
LogsModel LogsArr = new LogsModel();
foreach (var date in Dates)
{
var Data = await _db.ItemLogs
.Where(x => x.LogDateTransfer.Date == date)
.ToArrayAsync();
LogsList.Logs = LogsArr;
}
return(Json(new
{
data = LogsList
}));
}
public JsonResult loadLogItems()
{
LogsModel lms = new LogsModel();
List <v_Logs> vLogs = es.getLogs();
string empID = es.getUserId(User.Identity.Name);
lms.selectedLogs = es.getSelecedLogs(empID);
#region Activities of Daily Living
List <v_Logs> adLogs = vLogs.Where(x => x.logTypeName.Equals("Activities of Daily Living")).ToList <v_Logs>();
lms.DLActivities = createLogItem(adLogs);
#endregion
#region Food Prep
List <v_Logs> fpLogs = vLogs.Where(x => x.logTypeName.Equals("Food Prep")).ToList <v_Logs>();
lms.FPActivities = createLogItem(fpLogs);
#endregion
#region Activities
List <v_Logs> aLogs = vLogs.Where(x => x.logTypeName.Equals("Activities")).ToList <v_Logs>();
lms.Activities = createLogItem(aLogs);
#endregion
#region Light Chores/House Keeping
List <v_Logs> lchkLogs = vLogs.Where(x => x.logTypeName.Equals("Light Chores/House Keeping")).ToList <v_Logs>();
lms.LcHkActivities = createLogItem(lchkLogs);
#endregion
#region Toileting
List <Toileting> tList = es.getToileting(empID);
List <DaysOfWeek> dLst = es.getDaysOfWeek();
foreach (DaysOfWeek d in dLst)
{
ToiletingModel tm = new ToiletingModel();
tm.DayID = d.ID;
tm.Day = d.fullDayName;
List <Toileting> dtList = tList.Where(x => x.DayID == d.ID).ToList <Toileting>();
if (dtList.Capacity > 0)
{
foreach (Toileting t in dtList)
{
ToiletingItem tItm = new ToiletingItem();
tItm.isBm = t.Bm;
tItm.BmTime = t.BmTime;
tItm.isUrine = t.Urine;
tItm.UrineTime = t.UrineTime;
tm.ToiletingItemLst.Add(tItm);
}
}
else
{
ToiletingItem tItm = new ToiletingItem();
tItm.isBm = false;
tItm.BmTime = null;
tItm.isUrine = false;
tItm.UrineTime = null;
tm.ToiletingItemLst.Add(tItm);
}
lms.ToiletingLst.Add(tm);
}
#endregion
return(Json(lms));
}
public LogsViewModel()
{
model = new LogsModel();
}
/// <summary>
/// Функция для добавления логов
/// </summary>
public void AddLog(Data data, string description)
{
var log = new LogsModel()
{
Description = description,
Date = DateTime.Now.ToString()
};
switch (data)
{
case Data.OK:
{
log.Data = "M17,3A2,2 0 0,1 19,5V21L12,18L5,21V5C5,3.89 5.9,3 7,3H17M11,14L17.25,7.76L15.84,6.34L11,11.18L8.41,8.59L7,10L11,14Z";
break;
}
case Data.Error:
{
log.Data = "M13,13H11V7H13M13,17H11V15H13M12,2A10,10 0 0,0 2,12A10,10 0 0,0 12,22A10,10 0 0,0 22,12A10,10 0 0,0 12,2Z";
break;
}
case Data.Save_File:
{
log.Data = "M14,2H6A2,2 0 0,0 4,4V20A2,2 0 0,0 6,22H18A2,2 0 0,0 20,20V8L14,2M13.5,16V19H10.5V16H8L12,12L16,16H13.5M13,9V3.5L18.5,9H13Z";
break;
}
case Data.Load_File:
{
log.Data = "M14,2H6C4.89,2 4,2.89 4,4V20C4,21.11 4.89,22 6,22H18C19.11,22 20,21.11 20,20V8L14,2M12,19L8,15H10.5V12H13.5V15H16L12,19M13,9V3.5L18.5,9H13Z";
break;
}
case Data.Delete:
{
log.Data = "M19,4H15.5L14.5,3H9.5L8.5,4H5V6H19M6,19A2,2 0 0,0 8,21H16A2,2 0 0,0 18,19V7H6V19Z";
break;
}
case Data.Delete_Error:
{
log.Data = "";
break;
}
case Data.Account_Add:
{
log.Data = "M2,16H10V14H2M18,14V10H16V14H12V16H16V20H18V16H22V14M14,6H2V8H14M14,10H2V12H14V10Z";
break;
}
case Data.Account_Edit:
{
log.Data = "M2,6V8H14V6H2M2,10V12H14V10H2M20.04,10.13C19.9,10.13 19.76,10.19 19.65,10.3L18.65,11.3L20.7,13.35L21.7,12.35C21.92,12.14 21.92,11.79 21.7,11.58L20.42,10.3C20.31,10.19 20.18,10.13 20.04,10.13M18.07,11.88L12,17.94V20H14.06L20.12,13.93L18.07,11.88M2,14V16H10V14H2Z";
break;
}
}
Logs.Insert(0, log);
Files files = new Files();
files.Save(Properties.Settings.Default.PathFileLogs, Logs);
}
/// <summary>
/// 添加表单数据
/// </summary>
/// <param name="model">表单的对象信息</param>
/// <returns></returns>
public bool AddForm(LogsModel model)
{
string sql = @"INSERT INTO Sys_Logs
(F_Id,F_System,F_Module,F_OptType,F_OptContent,F_IPAddress,F_IPCity,F_CreateUserId,F_CreateTime)
VALUES(@F_Id,@F_System,@F_Module,@F_OptType,@F_OptContent,@F_IPAddress,@F_IPCity,@F_CreateUserId,@F_CreateTime)" ;
DbParameter[] parameters = new DbParameter[] {
new SqlParameter("@F_Id", SqlDbType.VarChar, 36)
{
Value = model.F_Id
},
model.F_System == null ? new SqlParameter("@F_System", SqlDbType.VarChar, 36)
{
Value = DBNull.Value
} : new SqlParameter("@F_System", SqlDbType.VarChar, 36)
{
Value = model.F_System
},
model.F_Module == null ? new SqlParameter("@F_Module", SqlDbType.VarChar, 36)
{
Value = DBNull.Value
} : new SqlParameter("@F_Module", SqlDbType.VarChar, 36)
{
Value = model.F_Module
},
model.F_OptType == null ? new SqlParameter("@F_OptType", SqlDbType.VarChar, 10)
{
Value = DBNull.Value
} : new SqlParameter("@F_OptType", SqlDbType.VarChar, 10)
{
Value = model.F_OptType
},
model.F_OptContent == null ? new SqlParameter("@F_OptContent", SqlDbType.VarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@F_OptContent", SqlDbType.VarChar, 1000)
{
Value = model.F_OptContent
},
model.F_IPAddress == null ? new SqlParameter("@F_IPAddress", SqlDbType.NVarChar, 36)
{
Value = DBNull.Value
} : new SqlParameter("@F_IPAddress", SqlDbType.NVarChar, 36)
{
Value = model.F_IPAddress
},
model.F_IPCity == null ? new SqlParameter("@F_IPCity", SqlDbType.NVarChar, 36)
{
Value = DBNull.Value
} : new SqlParameter("@F_IPCity", SqlDbType.NVarChar, 36)
{
Value = model.F_IPCity
},
model.F_CreateUserId == null ? new SqlParameter("@F_CreateUserId", SqlDbType.VarChar, 36)
{
Value = DBNull.Value
} : new SqlParameter("@F_CreateUserId", SqlDbType.VarChar, 36)
{
Value = model.F_CreateUserId
},
model.F_CreateTime == null ? new SqlParameter("@F_CreateTime", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@F_CreateTime", SqlDbType.DateTime, 8)
{
Value = model.F_CreateTime
},
};
int line = DbHelper.ExecuteNonQuery(sql, parameters);
return(line == 1);
}
/*
* Clear logs
* */
private void ApplicationBarMenuItem_Click_1(object sender, EventArgs e)
{
LogsModel.ClearLogs();
}
