private void AddSheetForProvinceData <T>(IReadOnlyDbContext db, ExcelPackage pkg, Dictionary <string, string> centerNames, params string[] excludes) where T : Equipment
{
var sheet = pkg.Workbook.Worksheets.Add(typeof(T).Name);
var table = CreateDataTable(db.Find <T>(t => t.Deleted != true).ToEnumerable(), centerNames, excludes);
sheet.Cells["A1"].LoadFromDataTable(table, true);
}
private static void AddBatterySheet(IReadOnlyDbContext db, ExcelPackage pkg, Dictionary <string, string> centerNames)
{
var sheet = pkg.Workbook.Worksheets.Add("Batteries");
var data = db.Find <RectifierAndBattery>(rb => rb.Deleted != true)
.Project(rb => new { rb.Center, rb.Batteries }).ToList();
sheet.SetValue(1, 1, "مرکز");
for (int i = 0; i < data.Max(d => d.Batteries.Count); i++)
{
sheet.SetValue(1, i * 6 + 2, (i + 1) + ". مدل");
sheet.SetValue(1, i * 6 + 3, (i + 1) + ". ظرفیت");
sheet.SetValue(1, i * 6 + 4, (i + 1) + ". نوع");
sheet.SetValue(1, i * 6 + 5, (i + 1) + ". تعداد سلول ها");
sheet.SetValue(1, i * 6 + 6, (i + 1) + ". تاریخ تولید");
sheet.SetValue(1, i * 6 + 7, (i + 1) + ". تاریخ نصب");
}
for (int row = 0; row < data.Count; row++)
{
if (centerNames.ContainsKey(data[row].Center))
{
sheet.SetValue(row + 2, 1, centerNames[data[row].Center]);
}
for (int i = 0; i < data[row].Batteries.Count; i++)
{
sheet.SetValue(row + 2, i * 6 + 2, data[row].Batteries[i].Model);
sheet.SetValue(row + 2, i * 6 + 3, data[row].Batteries[i].Capacity);
sheet.SetValue(row + 2, i * 6 + 4, data[row].Batteries[i].Type);
sheet.SetValue(row + 2, i * 6 + 5, (int)data[row].Batteries[i].CellsCount);
sheet.SetValue(row + 2, i * 6 + 6, PersianDateUtils.GetPersianDateString(data[row].Batteries[i].ProductionDate));
sheet.SetValue(row + 2, i * 6 + 7, PersianDateUtils.GetPersianDateString(data[row].Batteries[i].InstallationDate));
}
}
}
public string GetPlaceDisplayName(IReadOnlyDbContext db)
{
var passive = db.FindById <Passive>(PatchPanel);
var rack = db.FindById <Rack>(passive.Place);
var room = db.FindById <Room>(rack.Parent);
StringBuilder sb = new StringBuilder();
sb.Append("اتاق/سالن ").Append(room.Name).Append(" ⇐ ")
.Append("راک ").Append(rack.Name).Append(" ⇐ ");
if (passive.Type == Passive.PassiveTypeEnum.PatchPanel)
{
sb.Append("پچ پنل ");
}
else if (passive.Type == Passive.PassiveTypeEnum.Transmissional)
{
sb.Append("تجهیز انتقال ")
.Append(DisplayUtils.DisplayName(passive.TransmissionType))
.Append(" ");
}
else
{
throw new NotImplementedException();
}
sb.Append(passive.Name);
return(sb.ToString());
}
public static AuthUser GetCurrentUser(this IReadOnlyDbContext db)
{
if (HttpContext.Current == null || HttpContext.Current.User == null || HttpContext.Current.User.Identity == null || string.IsNullOrEmpty(HttpContext.Current.User.Identity.Name))
{
return(null);
}
return(AuthUserDBExtention.GetUserByUsername(db, HttpContext.Current.User.Identity.Name));
}
public string GetCenterId(IReadOnlyDbContext db)
{
if (PlaceType == DevicePlaceType.Rack)
{
var rack = db.FindById <Rack>(Place);
var room = db.FindById <Room>(rack.Parent);
var building = db.FindById <Building>(room.Parent);
return(building.Parent);
}
else if (PlaceType == DevicePlaceType.Kafu)
{
var kafu = db.FindById <Kafu>(Place);
return(kafu.CommCenter);
}
throw new NotImplementedException();
}
public string GetPlaceDisplay(IReadOnlyDbContext db)
{
StringBuilder sb = new StringBuilder();
if (PlaceType == DevicePlaceType.Rack)
{
var rack = db.FindById <Rack>(Place);
var room = db.FindById <Room>(rack.Parent);
var building = db.FindById <Building>(room.Parent);
var center = db.FindById <CommCenter>(building.Parent);
var city = db.FindById <City>(center.City);
sb.Append(city.Name).Append(" ⇐ ")
.Append("مرکز ").Append(center.Name).Append(" ⇐ ")
.Append("ساختمان ").Append(building.Name).Append(" ⇐ ")
.Append("اتاق/سالن ").Append(room.Name).Append(" ⇐ ")
.Append("راک ").Append(rack.Name).Append(" ⇐ ")
.Append("دستگاه ").Append(ToString());
}
else if (PlaceType == DevicePlaceType.Kafu)
{
var kafu = db.FindById <Kafu>(Place);
var center = db.FindById <CommCenter>(kafu.CommCenter);
var city = db.FindById <City>(center.City);
sb.Append(city.Name).Append(" ⇐ ")
.Append("مرکز ").Append(center.Name).Append(" ⇐ ")
.Append("کافو ").Append(DisplayUtils.DisplayName(kafu.Type))
.Append(" \"").Append(kafu.Name).Append("\"");
}
else
{
throw new NotImplementedException();
}
return(sb.ToString());
}
public ReadOnlyOrderService(IReadOnlyDbContext dbContext, IMapper mapper)
: base(dbContext, mapper)
{
}
protected ReadOnlyEntityService(IReadOnlyDbContext dbContext, IMapper mapper)
{
DbContext = dbContext;
_mapper = mapper;
}
protected GetEntityByIdQueryHandler(IReadOnlyDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public GetOrderResultByIdQueryHandler(IReadOnlyDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
public static AuthUserX GetByUsername(IReadOnlyDbContext db, string username)
{
return(db.Find <AuthUserX>(u => u.Username == username).FirstOrDefault());
}
public GetOrderByIdQueryHandler(IReadOnlyDbContext dbContext, IMapper mapper) : base(dbContext, mapper)
{
}
protected DataTableFactory(IReadOnlyDbContext db, Type thisType)
{
this.db = db;
this.thisType = thisType;
}
public DataTableFactory(IReadOnlyDbContext db)
{
this.db = db;
thisType = typeof(DataTableFactory);
}
public static City GetMainCity(IReadOnlyDbContext db)
{
var mainCitySettings = db.FindFirst <Settings>(s => s.Key == "MainCity");
return(db.FindById <City>(mainCitySettings.Value));
}
public Handler(IReadOnlyDbContext dbContext, IMapper mapper)
{
this.dbContext = dbContext;
this.mapper = mapper;
}
public DataTable Create <T>(IReadOnlyDbContext db, bool convertDateToPersian = true, bool includeTimeInDates = true, bool addIndexColumn = false,
string[] excludeColumns = null, Dictionary <string, Dictionary <ObjectId, string> > valuesReferenceReplacement = null) where T : MongoEntity
{
return(Create(db.All <T>(), convertDateToPersian, includeTimeInDates, addIndexColumn, excludeColumns, valuesReferenceReplacement));
}
public ReadOnlyProductService(IReadOnlyDbContext dbContext, IMapper mapper)
: base(dbContext, mapper)
{
}
public static AuthUserX FindByUsername(this IReadOnlyDbContext db, string username)
{
return(db.FindFirst <AuthUserX>(u => u.Username == username));
}
public string GetPlaceDisplay(IReadOnlyDbContext db)
{
var device = db.FindById <Device>(Device);
return(device.GetPlaceDisplay(db));
}
public string GetPlaceDisplay(IReadOnlyDbContext db)
{
return(Mapper.Map <Passive>(this).GetPlaceDisplay(db));
}
public ReadOnlyEntityService(IReadOnlyDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
