public IEnumerable <LogModel> GetAll(int pageIndex = 0, int pageSize = 10)
{
var logModels = new List <LogModel>();
using (var db = new LogDb())
{
var entities = db.LogInfos.AsNoTracking().OrderByDescending(q => q.Id).Skip(pageIndex * pageSize).Take(pageSize);
foreach (var entity in entities)
{
var model = new LogModel()
{
Id = entity.Id,
UserCode = entity.UserCode,
UserName = entity.UserName,
LoginIP = entity.LoginIP,
Type = (int)entity.LogType,
Operation = entity.Operation,
Remark = entity.Remark,
CreateDate = entity.CreateDate
};
logModels.Add(model);
}
}
return(logModels);
}
public RequestCharactersMessageHandler(
IOutgoingMessageService <ZoneServerNetPeer> outgoingMessageService,
LogDb logDb)
{
this.outgoingMessageService = outgoingMessageService;
this.logDb = logDb;
}
public IEnumerable <LogModel> GetAll(string op, int pageIndex = 0, int pageSize = 10)
{
var logModels = new List <LogModel>();
using (var db = new LogDb())
{
var query = db.LogInfos.Where(q => q.Id > 0);
if (!string.IsNullOrEmpty(op))
{
query = query.Where(q => q.Operation.Contains(op));
}
var entities = query.OrderByDescending(q => q.Id).Skip(pageIndex * pageSize).Take(pageSize);
foreach (var entity in entities)
{
var model = new LogModel()
{
Id = entity.Id,
UserCode = entity.UserCode,
UserName = entity.UserName,
LoginIP = entity.LoginIP,
Type = (int)entity.LogType,
Operation = entity.Operation,
Remark = entity.Remark,
CreateDate = entity.CreateDate
};
logModels.Add(model);
}
}
return(logModels);
}
public LogModel Add(LogModel item)
{
LogModel logModel;
using (var db = new LogDb())
{
var entity = new LogInfo()
{
UserCode = item.UserCode,
UserName = item.UserName,
LoginIP = item.LoginIP,
LogType = (LogType)item.Type,
Operation = item.Operation,
Remark = item.Remark,
CreateDate = item.CreateDate
};
db.LogInfos.Add(entity);
var result = db.SaveChanges();
if (result > 0)
{
logModel = item;
logModel.Id = entity.Id;
}
else
{
logModel = null;
}
}
return(logModel);
}
public async static void AddNew(WeaponLog item)
{
using (var db = new LogDb())
{
db.Weapons.Add(item);
await db.SaveChangesAsync();
}
}
public async static void AddNew(CommandLog item)
{
using (var db = new LogDb())
{
db.Commands.Add(item);
await db.SaveChangesAsync();
}
}
public async static Task AddNewAsync(AttackLog item)
{
using (var db = new LogDb())
{
db.Deaths.Add(item);
await db.SaveChangesAsync();
}
}
public async static void UpdateAsync(CommandLog item)
{
using (var db = new LogDb())
{
db.Commands.Attach(item);
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
}
}
public int RemoveAll()
{
var result = 0;
using (var db = new LogDb())
{
result = db.LogInfos.Where(q => q.Id > 0).Delete();
}
return(result);
}
public void RefreshSystemLog()
{
SystemLogs.Clear();
foreach (LogModel.SystemLog log in LogDb.Table <LogModel.SystemLog>())
{
log.Time = log.Time.ToLocalTime();
SystemLogs.Add(log);
}
SystemLogsSelectedIndex = SystemLogs.Count - 1;
}
public SelectCharacterMessageHandler(
EntitiesProcessor entitiesProcessor,
PlayerRepository playerRepository,
IOutgoingMessageService <ZoneServerNetPeer> outgoingMessageService,
LogDb logDb)
{
this.entitiesProcessor = entitiesProcessor;
this.playerRepository = playerRepository;
this.outgoingMessageService = outgoingMessageService;
this.logDb = logDb;
}
public PlayerLoginMessageHandler(
TokenRepository tokenRepository,
ZoneServerNetPeer zoneServerNetPeer,
LogDb logDb,
TokenManager tokenManager)
{
this.tokenRepository = tokenRepository;
this.zoneServerNetPeer = zoneServerNetPeer;
this.logDb = logDb;
this.tokenManager = tokenManager;
}
bool kiemtra = false;//bien kiem tra xem phuong an co gia tri hay khong.
public DataTable MySheet(string name)
{
DataTable dt = new DataTable();
OleDbConnection myConnection = new OleDbConnection();
try
{
var path = Path.Combine(Directory.GetCurrentDirectory(), name);
// name="~/Files/somefiles/MauNhapLieu_20160808_081958.xlsx";
if (name[name.Length - 1] == 'x')
{
//myConnection = new OleDbConnection(
// "Provider=Microsoft.ACE.OLEDB.12.0; " +
// "data source='" + path + "';" +
// "Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\" ");
myConnection = new OleDbConnection(string.Format("Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0}; Extended Properties=Excel 8.0;", name));
}
else if (name[name.Length - 1] == 's')
{
// chuỗi connection mở file
myConnection = new OleDbConnection(string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", name)); //"provider=Microsoft.Jet.OLEDB.4.0; data source={0};HDR=Yes;IMEX=1;ReadOnly:=false;UpdateLinks:=0\" "
}
else
{
return(dt);
}
myConnection.Open();
DataTable mySheets = myConnection.GetOleDbSchemaTable(
OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }
);
//mySheets.Columns.Remove()
//dt = mySheets.Columns["TABLE_NAME"].Table;
dt.Columns.Add("Sheet", typeof(string)); //đọc trong file có bao nhiêu sheet cho vào datatable
foreach (DataRow cot in mySheets.Rows)
{
DataRow dr = dt.NewRow();
dr["Sheet"] = cot["TABLE_NAME"];
dt.Rows.Add(dr);
}
}
catch (Exception ex)
{
LogDb.WriteLogError("HieuTM", "MySheet", "TuVanController", ex);
}
return(dt);
}
/// <summary>
/// HieuTM: Upload file, phân tích trả về mẫu dữ liệu.
/// </summary>
/// <returns></returns>
public PartialViewResult UploadExcel()
{
LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "Vao Upload");
BanTinTuVan bttv = null;
try
{
LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "file count: " + Request.Files.Count.ToString());
string linkSaveServer = "";
for (int i = 0; i < Request.Files.Count; i++)
{
string directoryPath = Path.Combine((Server.MapPath("~/Files/tuvan/")));
var file = Request.Files[i];
string filename = file.FileName;
if (!System.IO.Directory.Exists(directoryPath))
{
System.IO.Directory.CreateDirectory(directoryPath);
}
string newname = Lib.Security.CurrentUserName + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + Path.GetFileName(file.FileName);
linkSaveServer = Path.Combine(Server.MapPath("~/Files/tuvan/"), newname);
ViewBag.LinkFile = linkSaveServer;
file.SaveAs(linkSaveServer);
ReadExcel excel = new ReadExcel();
List <DataTable> table = excel.makeDataTableFromSheetName(linkSaveServer, excel.MySheet(linkSaveServer));
bttv = table.Count == 0 ? null : excel.BanTinTuVanExcel(table);
if (bttv != null)
{
bttv.Link = @"Files/tuvan/" + newname;
}
}
}
catch (Exception ex)
{
bttv = null;
LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "Error: " + ex.Message);
LogDb.WriteLogError("HieuTM", "UploadExcel", "TuVanController", ex);
}
return(PartialView("TuVan_All_Par", bttv));
}
public List <DataTable> makeDataTableFromSheetName(string filename, DataTable mysheet)
{
DataTable dtImport;
List <DataTable> dsImport = new List <DataTable>();
string connectionString;
string sheetName;
if (filename[filename.Length - 1] == 's')
{
connectionString = string.Format("provider=Microsoft.Jet.OLEDB.4.0; data source={0};Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1;ReadOnly:=false;UpdateLinks:=0\"", filename);
}
else if (filename[filename.Length - 1] == 'x')
{
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filename + ";" + "Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\" ";
}
else
{
return(dsImport);
}
try
{
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);
DataSet ds;
foreach (DataRow sheetName1 in mysheet.Rows)
{
sheetName = sheetName1[0].ToString();
OleDbDataAdapter myImportCommand = new OleDbDataAdapter("select * from [" + sheetName + "]", myConnection);
ds = new DataSet();
myImportCommand.Fill(ds);
dtImport = new DataTable();
dtImport = ds.Tables[0];
dtImport.TableName = sheetName;
dsImport.Add(dtImport);
}
}
catch (Exception ex)
{
LogDb.WriteLogError("HieuTM", "makeDataTableFromSheetName", "TuVanController", ex);
}
return(dsImport);
}
public void RefreshBuildLog()
{
// I don't know why, but LogStats.Clear throws thread exception even though EnableCollectionSynchronization is used.
// Reproduce: Remove Dispatcher.Invoke, and run CodeBox three times in a row (without closing LogWindow).
// TODO: This is a quick dirty fix. Apply better patch later.
Application.Current?.Dispatcher.Invoke(() =>
{
LogStats.Clear();
VariableLogs.Clear();
// Populate SelectBuildEntries
LogModel.BuildInfo[] buildEntries = LogDb.Table <LogModel.BuildInfo>()
.OrderByDescending(x => x.StartTime)
.ToArray();
BuildEntries = new ObservableCollection <LogModel.BuildInfo>(buildEntries);
});
SelectedBuildIndex = 0;
// Print summary
SelectedScriptIndex = 0;
}
public void RefreshScripts(int?buildId, bool showLastScript)
{
// Without dispatcher, ScriptEntries.Clear sets SelectedScriptIndex to -1 too late.
Application.Current?.Dispatcher.Invoke(() =>
{
ScriptEntries.Clear();
if (buildId == null)
{
// Clear
SelectedScriptIndex = -1;
}
else
{
// Populate SelectScriptEntries
ScriptEntries.Add(new Tuple <string, int, int>("Total Summary", -1, (int)buildId));
LogModel.Script[] scripts = LogDb.Table <LogModel.Script>()
.Where(x => x.BuildId == buildId && 0 < x.Order)
.OrderBy(x => x.Order)
.ToArray();
foreach (LogModel.Script sc in scripts)
{
ScriptEntries.Add(new Tuple <string, int, int>($"[{sc.Order}/{scripts.Length}] {sc.Name} ({sc.TreePath})", sc.Id, (int)buildId));
}
if (showLastScript)
{
SelectedScriptIndex = ScriptEntries.Count - 1; // Display Last Script
}
else
{
SelectedScriptIndex = 0; // Summary is always index 0
}
}
});
}
/// <summary>
/// 添加日志信息
/// </summary>
/// <param name="Log"></param>
/// <returns></returns>
public bool Add(Entity.T_Log Log)
{
return(LogDb.Insert(Log));
}
/// <summary>
/// 更新日志信息
/// </summary>
/// <param name="Log"></param>
/// <returns></returns>
public bool Update(Entity.T_Log Log)
{
return(LogDb.Update(Log));
}
/// <summary>
/// 通过ID删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Delete(int id)
{
return(LogDb.DeleteById(id));
}
/// <summary>
/// 通过ID查询
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Entity.T_Log FindById(int id)
{
return(LogDb.GetById(id));
}
public DeviceController(ILogger <DataController> logger, LogDbContext context)
{
_logger = logger;
_logDb = new LogDb(context);
}
public HomeController(ILogger <HomeController> logger, LogDbContext context)
{
_logger = logger;
_logDb = new LogDb(context);
}
//-------------------------------------------------------------------------------------------------------------------------------------------
public ActivityBase(UInt64 companyrecordid)
{
companyRecordId = companyrecordid;
log = new LogDb(DataAccessHelper.GetCompanyId(companyRecordId));
tableCompanyRecordId = DataAccessHelper.GetTableReferenceId(companyRecordId, GetType().BaseType.Name);
}
public Log(LogDb logDb)
{
Data = licensingLogDb.OldDataJson.Deserialize <T>();
Id = licensingLogDb.Id;
}
public DataController(ILogger <DataController> logger, LogDbContext context)
{
_logger = logger;
_logDb = new LogDb(context);
//_context = context;
}
private void SetupDatabases()
{
_documentDb = new DocumentDb(_config, "Grouper Service");
_logDb = new LogDb(_config);
}
public BanTinTuVan BanTinTuVanExcel(List <DataTable> dsImport)
{
BanTinTuVan bantintuvan = new BanTinTuVan();
List <PhuongAnExcel> lstphuonganexcel = new List <PhuongAnExcel>();
PhuongAnExcel phuonganexcel = new PhuongAnExcel();;
List <DienBien_Models> dienbienexcel = new List <DienBien_Models>();
LogDb.WriteLogInfo("HieuTM", "BanTinTuVanExcel", "ReadExcel", "Vao ban tin tu van");
try
{
foreach (DataTable table in dsImport)
{
if (table.TableName == "Chung$")
{
table.Columns[0].ColumnName = "F1";
table.Columns[4].ColumnName = "F5";
string thoigian = "";
thoigian = table.Rows[3]["F5"].ToString();
string[] ngay = { "ngày", "tháng", "năm", ",", " ", "/" };
int b = -1;
string date = "";
foreach (string a in thoigian.Split(ngay, StringSplitOptions.RemoveEmptyEntries))
{
try
{
b = int.Parse(a);
date = date + a + "/";
}
catch { }
}
b = date.LastIndexOf("/");
date = date.Substring(0, b);
bantintuvan.ThoiGian = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//bantintuvan.NhanXetTinhHinh = table.Rows[11]["F1"].ToString();
//bantintuvan.DuKien = table.Rows[14]["F1"].ToString();
List <string> lstDuKien = DuKienDienBien(table, 1, 11);
bantintuvan.NhanXetTinhHinh = lstDuKien[0];
bantintuvan.DuKien = lstDuKien[1];
dienbienexcel = DienBien_Excel(table, 1, 21);
if (kiemtra == true)
{
bantintuvan.DienBienExcel = dienbienexcel;
bantintuvan.HienTrangExcel = HienTrangExcel(table, 1, 30);
}
}
else
{
table.Columns[0].ColumnName = "F1";
phuonganexcel = Phuongan_Dettail_excel(table, 1, 3);
//kiem tra neu kiemtra = true bang phuong an co gia tri them vao lst phuong an excel
if (kiemtra == true)
{
lstphuonganexcel.Add(phuonganexcel);
}
}
}
bantintuvan.PhuongAnExcel = lstphuonganexcel;
LogDb.WriteLogInfo("HieuTM", "BanTinTuVanExcel", "ReadExcel", "Doc xong file excel");
}
catch (Exception ex)
{
bantintuvan = null;
LogDb.WriteLogInfo("HieuTM", "BanTinTuVanExcel", "ReadExcel", "Error: " + ex.Message);
LogDb.WriteLogError("HieuTM", "BanTinTuVanExcel", "ReadExcel", ex);
}
return(bantintuvan);
}
/// <summary>
/// Update build logs
/// </summary>
public void RefreshBuildLog(int scriptIdx)
{
if (scriptIdx != -1 && 0 < _scriptEntries.Count)
{
int scriptId = _scriptEntries[scriptIdx].Item2;
int buildId = _scriptEntries[scriptIdx].Item3;
if (scriptId == -1)
{ // Total Summary
// BuildLog
_allBuildLogs = new List <LogModel.BuildLog>();
foreach (LogState state in new LogState[] { LogState.Error, LogState.Warning })
{
var bLogs = LogDb.Table <LogModel.BuildLog>().Where(x => x.BuildId == buildId && x.State == state);
_allBuildLogs.AddRange(bLogs);
}
if (_allBuildLogs.Count == 0)
{
_allBuildLogs.Add(new LogModel.BuildLog
{
BuildId = buildId,
State = LogState.Info,
Message = "No Error or Warning",
Time = DateTime.MinValue,
});
}
BuildLogs = new ObservableCollection <LogModel.BuildLog>(_allBuildLogs);
// Variables
var varLogs = LogDb.Table <LogModel.Variable>()
.Where(x => x.BuildId == buildId && x.Type != VarsType.Local)
.OrderBy(x => x.Type)
.ThenBy(x => x.Key);
VariableLogs = new ObservableCollection <LogModel.Variable>(varLogs);
// Statistics
List <Tuple <LogState, int> > fullStat = new List <Tuple <LogState, int> >();
var existStates = ((LogState[])Enum.GetValues(typeof(LogState))).Where(x => x != LogState.None && x != LogState.CriticalError);
foreach (LogState state in existStates)
{
int count = LogDb
.Table <LogModel.BuildLog>()
.Count(x => x.BuildId == buildId && x.State == state);
fullStat.Add(new Tuple <LogState, int>(state, count));
}
LogStats = new ObservableCollection <Tuple <LogState, int> >(fullStat);
}
else
{ // Per Script
// BuildLog
var builds = LogDb.Table <LogModel.BuildLog>()
.Where(x => x.BuildId == buildId && x.ScriptId == scriptId);
if (!BuildLogShowComments)
{
builds = builds.Where(x => (x.Flags & LogModel.BuildLogFlag.Comment) != LogModel.BuildLogFlag.Comment);
}
if (!BuildLogShowMacros)
{
builds = builds.Where(x => (x.Flags & LogModel.BuildLogFlag.Macro) != LogModel.BuildLogFlag.Macro);
}
_allBuildLogs = new List <LogModel.BuildLog>(builds);
BuildLogs = new ObservableCollection <LogModel.BuildLog>(_allBuildLogs);
// Variables
List <LogModel.Variable> varLogs = new List <LogModel.Variable>();
varLogs.AddRange(LogDb.Table <LogModel.Variable>()
.Where(x => x.BuildId == buildId && x.Type != VarsType.Local)
.OrderBy(x => x.Type)
.ThenBy(x => x.Key));
varLogs.AddRange(LogDb.Table <LogModel.Variable>()
.Where(x => x.BuildId == buildId && x.ScriptId == scriptId && x.Type == VarsType.Local)
.OrderBy(x => x.Key));
VariableLogs = new ObservableCollection <LogModel.Variable>(varLogs);
// Statistics
List <Tuple <LogState, int> > fullStat = new List <Tuple <LogState, int> >();
var existStates = ((LogState[])Enum.GetValues(typeof(LogState))).Where(x => x != LogState.None && x != LogState.CriticalError);
foreach (LogState state in existStates)
{
int count = LogDb
.Table <LogModel.BuildLog>()
.Count(x => x.BuildId == buildId && x.ScriptId == scriptId && x.State == state);
fullStat.Add(new Tuple <LogState, int>(state, count));
}
LogStats = new ObservableCollection <Tuple <LogState, int> >(fullStat);
}
}
else
{
BuildLogs = new ObservableCollection <LogModel.BuildLog>();
}
}
/// <summary>
/// HieuTM: Kiểm tra tài khoản bên TLVN
/// </summary>
/// <param name="user"></param>
/// <param name="pass"></param>
/// <returns></returns>
public UserTLVN CheckLogin(string user, string pass)
{
UserTLVN result = null;
try
{
#region Gọi service check đăng nhập bên TLVN
string url = linkServer + "Home/AcountLoginVHLH";
var request = (HttpWebRequest)WebRequest.Create(url);
string postData = String.Format("userName={0}&passWord={1}", user, pass);
var data = Encoding.ASCII.GetBytes(postData);
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = data.Length;
using (var stream = request.GetRequestStream())
{
stream.Write(data, 0, data.Length);
}
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
#endregion
#region Code cũ
//// Truyền tham số cho reqest.
//// Khởi tạo request goi API
//WebRequest req = WebRequest.Create(url);
//// req.Credentials = CredentialCache.DefaultCredentials;
//req.ContentType = "application/x-www-form-urlencoded";
//// Thiết lập phương thức cho request.
//req.Method = "Post";
////byte[] byteArray = Encoding.UTF8.GetBytes(postData);
////req.ContentLength = byteArray.Length;
////Stream dataStream = req.GetRequestStream();
////dataStream.Write(byteArray, 0, byteArray.Length);
////dataStream.Close();
//// Nhận response.
//WebResponse response = req.GetResponse();
//Stream dataStream = response.GetResponseStream();
//StreamReader reader = new StreamReader(dataStream);
//string responseFromServer = reader.ReadToEnd();
//string str = responseFromServer;
#endregion
if (responseString == "-1")
{
result = new UserTLVN();
result.UserId = -1;
result.GroupRef = "b9bacf66-2439-454d-868c-23d3b04c420e";
result.UserName = "******";
result.FullName = "Chua Xac Dinh";
result.RoleRef = "asd";
result.IsAdminBitType = true;
}
else
{
UserTLVN myDeserializedObjList = (UserTLVN)Newtonsoft.Json.JsonConvert.DeserializeObject(responseString, typeof(UserTLVN));
result = myDeserializedObjList;
}
LogDb.WriteLogInfo("hieutm", "CheckLogin", "commonDataBase", "Đăng nhập thành công");
}
catch (Exception ex)
{
LogDb.WriteLogError("hieutm", "CheckLogin", "commonDataBase", ex);
Log.WriteErrorLocation(ex.Message);
}
return(result);
}
