public void LastVersionUpdate()
{
user.Logs.AFTime = DateTime.Now.AddDays(-2);
session.Save(user);
Flush();
var filter = new WhoWasNotUpdatedFilter {
Session = session, BeginDate = DateTime.Now.AddDays(-1)
};
var data = filter.Find().Where(d => d.UserName == "user").ToList();
Assert.AreEqual(data.First().LastUpdateDate, user.Logs.AFTime.Value.ToString("dd.MM.yyyy HH:mm"));
user.Logs.AFTime = null;
user.Logs.AFNetTime = DateTime.Now.AddDays(-2).AddMinutes(10);
session.Save(user);
Flush();
data = filter.Find().Where(d => d.UserName == "user").ToList();
Assert.AreEqual(data.First().LastUpdateDate, user.Logs.AFNetTime.Value.ToString("dd.MM.yyyy HH:mm"));
user.Logs.AFTime = DateTime.Now.AddDays(-2);
session.Save(user);
Flush();
data = filter.Find().Where(d => d.UserName == "user").ToList();
Assert.AreEqual(data.First().LastUpdateDate, user.Logs.AFNetTime.Value.ToString("dd.MM.yyyy HH:mm"));
}
public void ExcelWhoWasNotUpdated()
{
var filter = new WhoWasNotUpdatedFilter();
filter.Session = DbSession;
BindObjectInstance(filter, IsPost ? ParamStore.Form : ParamStore.QueryString, "filter", AutoLoadBehavior.NullIfInvalidKey);
this.RenderFile("Кто_не_обновлялся_с_опред._даты.xls", ExportModel.ExcelWhoWasNotUpdated(filter));
}
public void Only_ones_users_in_result()
{
user.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user1.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user2.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user3.UserUpdateInfo.UpdateDate = DateTime.Now;
session.Save(user);
session.Save(user1);
session.Save(user2);
session.Save(user3);
Flush();
var filter = new WhoWasNotUpdatedFilter {
Session = session, BeginDate = DateTime.Now.AddDays(-1)
};
var data = filter.Find().Select(d => d.UserName).ToList();
Assert.AreEqual(data.Count, 3);
Assert.IsTrue(data.Contains("user"));
Assert.IsTrue(data.Contains("user1"));
Assert.IsTrue(data.Contains("user2"));
}
public void ExportWhoWasNotUpdatedFilterTest()
{
var filter = new WhoWasNotUpdatedFilter();
filter.Session = session;
var buf = ExportModel.ExcelWhoWasNotUpdated(filter);
var stream = new MemoryStream(buf);
var wb = Workbook.Load(stream);
var ws = wb.Worksheets.First();
Assert.That(ws.Name, Is.StringContaining("Кто не обновлялся с опред. даты"));
}
public static byte[] ExcelWhoWasNotUpdated(WhoWasNotUpdatedFilter filter)
{
var wb = new Workbook();
var ws = new Worksheet("Кто не обновлялся с опред. даты");
int row = 4;
int colShift = 0;
ws.Merge(0, 0, 0, 6);
ExcelHelper.WriteHeader1(ws, 0, 0, "Кто не обновлялся с опред. даты", false, true);
ws.Merge(1, 1, 1, 2);
ExcelHelper.Write(ws, 1, 0, "Регион:", false);
string regionName;
if (filter.Regions != null && filter.Regions.Any())
{
regionName = filter.GetRegionNames();
}
else
{
regionName = "Все";
}
ExcelHelper.Write(ws, 1, 1, regionName, false);
ws.Merge(2, 1, 2, 2);
ExcelHelper.Write(ws, 2, 0, "Нет обновлений с:", false);
ExcelHelper.Write(ws, 2, 1, filter.BeginDate.ToString("dd.MM.yyyy"), false);
var reportData = filter.Find(true);
foreach (var item in reportData)
{
ExcelHelper.Write(ws, row, colShift + 0, item.ClientId, true);
ExcelHelper.Write(ws, row, colShift + 1, item.ClientName, true);
ExcelHelper.Write(ws, row, colShift + 2, item.UserId, true);
ExcelHelper.Write(ws, row, colShift + 3, item.UserName, true);
ExcelHelper.Write(ws, row, colShift + 4, item.RegionName, true);
ExcelHelper.Write(ws, row, colShift + 5, item.Registrant, true);
ExcelHelper.Write(ws, row, colShift + 6, item.UpdateDate, true);
row++;
}
FormatWhoWasNotUpdated(ws);
wb.Worksheets.Add(ws);
var ms = new MemoryStream();
wb.Save(ms);
return(ms.ToArray());
}
public void Exclude_users()
{
//исключаем из отчета пользователя
user1.ExcludeFromManagerReports = true;
session.Save(user1);
Flush();
var filter = new WhoWasNotUpdatedFilter {
Session = session, BeginDate = DateTime.Now.AddDays(-3)
};
var data = filter.Find();
Assert.AreEqual(data.Count, 3);
}
public void All_in_result()
{
user.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user1.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user2.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user3.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
session.Save(user);
session.Save(user1);
session.Save(user2);
session.Save(user3);
Flush();
var filter = new WhoWasNotUpdatedFilter {
Session = session, BeginDate = DateTime.Now.AddDays(-1), Regions = new ulong[] { client.HomeRegion.Id }
};
var data = filter.Find();
Assert.AreEqual(data.Count, 4);
}
public void Only_multi_user_in_result()
{
user.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user1.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
user2.UserUpdateInfo.UpdateDate = DateTime.Now;
user3.UserUpdateInfo.UpdateDate = DateTime.Now.AddDays(-2);
session.Save(user);
session.Save(user1);
session.Save(user2);
session.Save(user3);
Flush();
var filter = new WhoWasNotUpdatedFilter {
Session = session, BeginDate = DateTime.Now.AddDays(-1)
};
var data = filter.Find();
Assert.AreEqual(data.Count, 1);
Assert.That(data[0].UserName, Is.EqualTo("user3"));
}
