public void DrawPolSourceSitesPoints_test()
{
csspWebToolsTaskRunner = new CSSPWebToolsTaskRunner();
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
TVItemService tvItemService = new TVItemService(LanguageEnum.en, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
Bitmap bitmap = new Bitmap(1280, 1200);
Graphics g = Graphics.FromImage(bitmap);
int GraphicWidth = bitmap.Width;
int GraphicHeight = bitmap.Height;
CoordMap coordMap = new CoordMap()
{
NorthEast = new Coord()
{
Lat = 46.5364151f, Lng = -64.55215f, Ordinal = 0
},
SouthWest = new Coord()
{
Lat = 46.23907f, Lng = -64.99161f, Ordinal = 0
},
};
int SubsectorTVItemID = 635;
List <MapInfoPointModel> mapInfoPointModelPolSourceSiteList = new List <MapInfoPointModel>();
List <TVItemModel> tvItemModelPolSourceSiteList = new List <TVItemModel>();
mapInfoPointModelPolSourceSiteList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithParentIDAndTVTypeAndMapInfoDrawTypeDB(SubsectorTVItemID, TVTypeEnum.PolSourceSite, MapInfoDrawTypeEnum.Point);
tvItemModelPolSourceSiteList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(SubsectorTVItemID, TVTypeEnum.PolSourceSite).Where(c => c.IsActive == true).ToList();
GoogleMapToPNG googleMapToPNG = new GoogleMapToPNG(); // (new TaskRunnerBaseService(new List<BWObj>()), "", "", "", "");
googleMapToPNG.DrawPolSourceSitesPoints(g, GraphicWidth, GraphicHeight, coordMap, mapInfoPointModelPolSourceSiteList, tvItemModelPolSourceSiteList);
}
public ClassificationService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public DocTemplateService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
}
private void SetupTest(ContactModel contactModelToDo, CultureInfo culture, string actionStr)
{
LanguageEnum languageEnum = (culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en);
if (contactModelToDo == null)
{
user = null;
}
else
{
user = new GenericPrincipal(new GenericIdentity(contactModelToDo.LoginEmail, "Forms"), null);
}
routeData = new RouteData();
routeData.Values.Add("culture", culture);
routeData.Values.Add("controller", "MikeScenario");
routeData.Values.Add("action", actionStr);
stubHttpContext = new StubHttpContextBase();
stubHttpRequestBase = new StubHttpRequestBase();
stubHttpContext.RequestGet = () => stubHttpRequestBase;
requestContext = new RequestContext(stubHttpContext, routeData);
controller = new MikeScenarioController();
controller.Url = new UrlHelper(requestContext);
controller.ControllerContext = new ControllerContext(stubHttpContext, routeData, controller);
stubHttpContext.UserGet = () => user;
randomService = new RandomService(languageEnum, user);
mapInfoService = new MapInfoService(languageEnum, user);
tvItemService = new TVItemService(languageEnum, user);
mikeBoundaryConditionService = new MikeBoundaryConditionService(languageEnum, user);
appTaskService = new AppTaskService(languageEnum, user);
mikeScenarioService = new MikeScenarioService(languageEnum, user);
tvFileService = new TVFileService(languageEnum, user);
mikeSourceService = new MikeSourceService(languageEnum, user);
mikeSourceStartEndService = new MikeSourceStartEndService(languageEnum, user);
controller.SetRequestContext(requestContext);
// Assert
Assert.IsNotNull(controller);
Assert.AreEqual(2, controller.CultureListAllowable.Count);
Assert.AreEqual("en-CA", controller.CultureListAllowable[0]);
Assert.AreEqual("fr-CA", controller.CultureListAllowable[1]);
Assert.IsNotNull(controller._ContactService);
Assert.IsNotNull(controller._RequestContext);
Assert.IsNotNull(controller._MikeScenarioService);
Assert.IsNotNull(culture.Name, controller._RequestContext.RouteData.Values["culture"].ToString());
Assert.IsNotNull("MikeScenario", controller._RequestContext.RouteData.Values["controller"].ToString());
Assert.IsNotNull(actionStr, controller._RequestContext.RouteData.Values["action"].ToString());
Assert.AreEqual((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), controller.LanguageRequest);
Assert.AreEqual((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), controller.ViewBag.Language);
Assert.AreEqual(culture.Name, controller.CultureRequest);
Assert.AreEqual(culture.Name, controller.ViewBag.Culture);
if (contactModelToDo != null)
{
Assert.AreEqual(contactModelToDo.IsAdmin, controller.IsAdmin);
Assert.AreEqual(contactModelToDo.IsAdmin, controller.ViewBag.IsAdmin);
}
Assert.AreEqual(true, controller.Debug);
Assert.AreEqual(true, controller.ViewBag.Debug);
}
public RatingCurveService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
_HydrometricSiteService = new HydrometricSiteService(LanguageRequest, User);
}
public ContactShortcutService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_ContactService = new ContactService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public PolSourceObservationService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_PolSourceObservationIssueService = new PolSourceObservationIssueService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public MWQMSiteStartEndDateService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public MikeBoundaryConditionService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_MapInfoService = new MapInfoService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public TVTypeUserAuthorizationModel GetTVTypeUserAuthorizationModelWithTVTypeUserAuthorizationIDDB(int TVTypeUserAuthorizationID)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
TVTypeUserAuthorizationModel tvTypeUserAuthorizationModel = (from c in db.TVTypeUserAuthorizations
where c.TVTypeUserAuthorizationID == TVTypeUserAuthorizationID
select new TVTypeUserAuthorizationModel
{
Error = "",
TVTypeUserAuthorizationID = c.TVTypeUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVType = (TVTypeEnum)c.TVType,
TVPath = "",
TVLevel = -1,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <TVTypeUserAuthorizationModel>();
if (tvTypeUserAuthorizationModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, BaseEnumServiceRes.TVTypeUserAuthorization, BaseEnumServiceRes.TVTypeUserAuthorizationID, TVTypeUserAuthorizationID)));
}
tvTypeUserAuthorizationModel.TVPath = tvTypeNamesAndPathList.Where(c => c.Index == (int)tvTypeUserAuthorizationModel.TVType).FirstOrDefault().TVPath;
tvTypeUserAuthorizationModel.TVLevel = tvItemService.GetTVLevel(tvTypeUserAuthorizationModel.TVPath);
return(tvTypeUserAuthorizationModel);
}
public List <TVTypeUserAuthorizationModel> GetTVTypeUserAuthorizationModelListWithContactTVItemIDDB(int ContactTVItemID)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
List <TVTypeUserAuthorizationModel> tvTypeUserAuthorizationModelList = (from c in db.TVTypeUserAuthorizations
where c.ContactTVItemID == ContactTVItemID
select new TVTypeUserAuthorizationModel
{
Error = "",
TVTypeUserAuthorizationID = c.TVTypeUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVType = (TVTypeEnum)c.TVType,
TVPath = "",
TVLevel = -1,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).ToList <TVTypeUserAuthorizationModel>();
foreach (TVTypeUserAuthorizationModel tvTypeUserAuthorizationModel in tvTypeUserAuthorizationModelList)
{
tvTypeUserAuthorizationModel.TVPath = tvTypeNamesAndPathList.Where(c => c.Index == (int)tvTypeUserAuthorizationModel.TVType).FirstOrDefault().TVPath;
tvTypeUserAuthorizationModel.TVLevel = tvItemService.GetTVLevel(tvTypeUserAuthorizationModel.TVPath);
}
return(tvTypeUserAuthorizationModelList.OrderBy(c => c.TVLevel).ToList <TVTypeUserAuthorizationModel>());
}
public SpillService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_SpillLanguageService = new SpillLanguageService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public PolSourceSiteEffectService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_PolSourceSiteEffectTermService = new PolSourceSiteEffectTermService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public EmailService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public MWQMSampleService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_MWQMSampleLanguageService = new MWQMSampleLanguageService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public ContactPreferenceService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_ContactService = new ContactService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public DrogueRunPositionService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public EmailDistributionListContactService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
_EmailDistributionListContactLanguageService = new EmailDistributionListContactLanguageService(LanguageRequest, User);
}
public ClimateSiteService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public void SetupTest(LanguageEnum LanguageRequest)
{
csspWebToolsTaskRunner = new CSSPWebToolsTaskRunner();
_TVItemService = new TVItemService(LanguageRequest, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
_AppTaskService = new AppTaskService(LanguageRequest, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
_TVFileService = new TVFileService(LanguageRequest, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
_MapInfoService = new MapInfoService(LanguageRequest, csspWebToolsTaskRunner._TaskRunnerBaseService._User);
}
public TideSiteService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_AppTaskService = new AppTaskService(LanguageRequest, User);
_MikeBoundaryConditionService = new MikeBoundaryConditionService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public List <TVItemUserAuthorizationModel> GetTVItemUserAuthorizationModelListWithTVItemID1DB(int TVItemID1)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
List <TVItemUserAuthorizationModel> tvItemUserAuthorizationModelList = (from c in db.TVItemUserAuthorizations
let tvItemID1TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID1 select cl.TVText).FirstOrDefault <string>()
let tvItemID2TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID2 select cl.TVText).FirstOrDefault <string>()
let tvItemID3TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID3 select cl.TVText).FirstOrDefault <string>()
let tvItemID4TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID4 select cl.TVText).FirstOrDefault <string>()
let tvPath1 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID1 select ct.TVPath).FirstOrDefault <string>()
let tvPath2 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID2 select ct.TVPath).FirstOrDefault <string>()
let tvPath3 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID3 select ct.TVPath).FirstOrDefault <string>()
let tvPath4 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID4 select ct.TVPath).FirstOrDefault <string>()
where c.TVItemID1 == TVItemID1
select new TVItemUserAuthorizationModel
{
Error = "",
TVItemUserAuthorizationID = c.TVItemUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVItemID1 = c.TVItemID1,
TVText1 = tvItemID1TVText,
TVPath1 = tvPath1,
TVItemID2 = c.TVItemID2,
TVText2 = tvItemID2TVText,
TVPath2 = tvPath2,
TVItemID3 = c.TVItemID3,
TVText3 = tvItemID3TVText,
TVPath3 = tvPath3,
TVItemID4 = c.TVItemID4,
TVText4 = tvItemID4TVText,
TVPath4 = tvPath4,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).ToList <TVItemUserAuthorizationModel>();
foreach (TVItemUserAuthorizationModel tvItemUserAuthorizationModel in tvItemUserAuthorizationModelList)
{
tvItemUserAuthorizationModel.TVLevel1 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath1);
if (tvItemUserAuthorizationModel.TVPath2 != null)
{
tvItemUserAuthorizationModel.TVLevel2 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath2);
}
if (tvItemUserAuthorizationModel.TVPath3 != null)
{
tvItemUserAuthorizationModel.TVLevel3 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath3);
}
if (tvItemUserAuthorizationModel.TVPath4 != null)
{
tvItemUserAuthorizationModel.TVLevel4 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath4);
}
}
return(tvItemUserAuthorizationModelList.OrderBy(c => c.TVLevel1).ThenBy(c => c.TVLevel2).ToList <TVItemUserAuthorizationModel>());
}
public void TVItem_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemController tvItemController = new TVItemController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemController.DatabaseType);
TVItem tvItemLast = new TVItem();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
TVItemService tvItemService = new TVItemService(query, db, ContactID);
tvItemLast = (from c in db.TVItems select c).LastOrDefault();
}
// ok with TVItem info
IHttpActionResult jsonRet = tvItemController.GetTVItemWithID(tvItemLast.TVItemID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItem> Ret = jsonRet as OkNegotiatedContentResult <TVItem>;
TVItem tvItemRet = Ret.Content;
Assert.AreEqual(tvItemLast.TVItemID, tvItemRet.TVItemID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = tvItemController.Put(tvItemRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItem> tvItemRet2 = jsonRet2 as OkNegotiatedContentResult <TVItem>;
Assert.IsNotNull(tvItemRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because TVItemID of 0 does not exist
tvItemRet.TVItemID = 0;
IHttpActionResult jsonRet3 = tvItemController.Put(tvItemRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <TVItem> tvItemRet3 = jsonRet3 as OkNegotiatedContentResult <TVItem>;
Assert.IsNull(tvItemRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetTVItemList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemService tvItemService = new TVItemService(new Query()
{
Lang = lang
}, db, ContactID);
public MikeSourceService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_MapInfoService = new MapInfoService(LanguageRequest, User);
_MikeSourceStartEndService = new MikeSourceStartEndService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
private void CreatePartsSubsectorPollutionSourceFieldSheet(SpreadsheetDocument document)
{
int SheetOrdinal = 0;
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
List <string> SheetNameList = new List <string>();
SheetNameList.Add("Active - " + baseEnumService.GetEnumText_TVTypeEnum(TVTypeEnum.Subsector));
SheetNameList.Add("Inactive - " + baseEnumService.GetEnumText_TVTypeEnum(TVTypeEnum.Subsector));
XlsxBase.AddSheetNameAndID(SheetNameList[0]);
XlsxBase.AddSheetNameAndID(SheetNameList[1]);
ExtendedFilePropertiesPart extendedFilePropertiesPart = document.AddNewPart <ExtendedFilePropertiesPart>("rId1000");
XlsxBase.GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart);
WorkbookPart workbookPart = document.AddWorkbookPart();
XlsxBase.GenerateWorkbookPart1Content(workbookPart);
SheetOrdinal = 0;
WorksheetPart worksheetA = workbookPart.AddNewPart <WorksheetPart>(XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID);
GenerateWorksheetAContentSubsectorPollutionSourceFieldSheet(worksheetA, workbookPart.Workbook, SheetNameList[0], SheetOrdinal, true);
foreach (UsedHyperlink usedHyperlink in XlsxBase.UsedHyperlinkList)
{
worksheetA.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id);
}
SheetOrdinal = 1;
WorksheetPart worksheetB = workbookPart.AddNewPart <WorksheetPart>(XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID);
GenerateWorksheetAContentSubsectorPollutionSourceFieldSheet(worksheetB, workbookPart.Workbook, SheetNameList[1], SheetOrdinal, false);
foreach (UsedHyperlink usedHyperlink in XlsxBase.UsedHyperlinkList)
{
worksheetB.AddHyperlinkRelationship(new System.Uri(usedHyperlink.URL, System.UriKind.Absolute), true, usedHyperlink.Id);
}
SharedStringTablePart sharedStringTablePart = workbookPart.AddNewPart <SharedStringTablePart>("rId2000");
XlsxBase.GenerateSharedStringTablePart1Content(sharedStringTablePart);
WorkbookStylesPart workbookStylesPart = workbookPart.AddNewPart <WorkbookStylesPart>("rId3000");
XlsxBase.GenerateWorkbookStylesPart1Content(workbookStylesPart);
ThemePart themePart = workbookPart.AddNewPart <ThemePart>("rId4000");
XlsxBase.GenerateThemePart1Content(themePart);
XlsxBase.SetPackageProperties(document);
}
public KMZService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
_PolSourceSiteService = new PolSourceSiteService(LanguageRequest, User);
_InfrastructureService = new InfrastructureService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public SamplingPlanEmailService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_AppTaskService = new AppTaskService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_MWQMSubsectorService = new MWQMSubsectorService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public ProvinceToolsService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_PolSourceSiteService = new PolSourceSiteService(LanguageRequest, User);
_PolSourceObservationService = new PolSourceObservationService(LanguageRequest, User);
_PolSourceObservationIssueService = new PolSourceObservationIssueService(LanguageRequest, User);
}
private void GenerateMunicipalityDocument(Document document)
{
Body body = new Body();
Paragraph paragraph = new Paragraph();
Run run = new Run();
Table table = new Table();
TableRow tableRow = new TableRow();
TableCell tableCell = new TableCell();
string URL = "";
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemStatService tvItemStatService = new TVItemStatService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemModel tvItemModelMunicipality = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelMunicipality.Error))
{
paragraph = DocxBase.AddParagraph(body);
DocxBase.AddRunWithCurrentParagraphStyle(paragraph, tvItemModelMunicipality.Error);
}
//tvItemStatService.SetTVItemStatForTVItemIDAndParentsTVItemID(tvItemModelMunicipality.TVItemID);
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Heading1;
DocxBase.CurrentJustificationValue = JustificationValues.Center;
paragraph = DocxBase.AddParagraph(body);
URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelMunicipality);
run = DocxBase.AddRunHyperlink(paragraph, URL, tvItemModelMunicipality.TVText);
List <TVItemModel> tvItemModelInfrastructureList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelMunicipality.TVItemID, TVTypeEnum.Infrastructure);
foreach (TVItemModel tvItemModelInfrastructure in tvItemModelInfrastructureList)
{
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Heading2;
paragraph = DocxBase.AddParagraph(body);
URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelInfrastructure);
run = DocxBase.AddRunHyperlink(paragraph, URL, tvItemModelInfrastructure.TVText);
}
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Normal;
DocxBase.CurrentJustificationValue = JustificationValues.Left;
paragraph = DocxBase.AddParagraph(body);
paragraph = DocxBase.AddParagraph(body);
DocxBase.AddRunWithCurrentParagraphStyle(paragraph, "Etc ... ");
DocxBase.AddSectionProp(body);
document.Append(body);
}
