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; }