public async Task <IActionResult> LanguageCreate(SuClassificationPageLanguageCreateGetWithListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ObjectLanguage.OId), new SqlParameter("@LanguageId", FromForm.ObjectLanguage.LanguageId), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ObjectLanguage.Name ?? ""), new SqlParameter("@Description", FromForm.ObjectLanguage.Description ?? ""), new SqlParameter("@MouseOver", FromForm.ObjectLanguage.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.ObjectLanguage.MenuName ?? ""), new SqlParameter("@TitleName", FromForm.ObjectLanguage.TitleName ?? ""), new SqlParameter("@TitleDescription", FromForm.ObjectLanguage.TitleDescription ?? "") }; _context.Database.ExecuteSqlCommand("ClassificationPageLanguageCreatePost " + "@OId" + ", @LanguageId" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @TitleName" + ", @TitleDescription", parameters); return(RedirectToAction("LanguageIndex", new { Id = FromForm.ObjectLanguage.OId.ToString() })); }
public async Task <IActionResult> Edit(SuOrganizationEditGetWithListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.Organization.OId), new SqlParameter("@StatusId", FromForm.Organization.OrganizationStatusId), new SqlParameter("@TypeId", FromForm.Organization.OrganizationTypeId), new SqlParameter("@LId", FromForm.Organization.LId), new SqlParameter("@LanguageId", FromForm.Organization.LanguageId), new SqlParameter("@Name", FromForm.Organization.Name ?? ""), new SqlParameter("@Description", FromForm.Organization.Description ?? ""), new SqlParameter("@MouseOver", FromForm.Organization.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.Organization.MenuName ?? ""), new SqlParameter("@ModifierId", CurrentUser.Id) }; _context.Database.ExecuteSqlCommand("OrganizationEditPost " + "@OId" + ", @StatusId" + ", @TypeId" + ", @LId" + ", @LanguageId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @ModifierId", parameters); return(RedirectToAction("Index")); }
public async Task <IActionResult> Edit(SuClassificationPageEditGetWithListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ClassificationPage.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@StatusId", FromForm.ClassificationPage.StatusId), new SqlParameter("@ShowTitleName", FromForm.ClassificationPage.ShowTitleName), new SqlParameter("@ShowTitleDescription", FromForm.ClassificationPage.ShowTitleDescription), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ClassificationPage.Name), new SqlParameter("@Description", FromForm.ClassificationPage.Description), new SqlParameter("@MouseOver", FromForm.ClassificationPage.MouseOver), new SqlParameter("@MenuName", FromForm.ClassificationPage.MenuName), new SqlParameter("@TitleName", FromForm.ClassificationPage.TitleName), new SqlParameter("@TitleDescription", FromForm.ClassificationPage.TitleDescription) }; _context.Database.ExecuteSqlCommand("ClassificationPageEditPost " + "@OId" + ", @LanguageId" + ", @StatusId" + ", @ShowTitleName" + ", @ShowTitleDescription" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @TitleName" + ", @TitleDescription", parameters); return(RedirectToAction("Index", new { Id = FromForm.ClassificationPage.PId })); }
public async Task <IActionResult> Edit(SuClassificationPageSectionEditGetWithListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ClassificationPageSection.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@Sequence", FromForm.ClassificationPageSection.Sequence), new SqlParameter("@SectionTypeId", FromForm.ClassificationPageSection.SectionTypeId), new SqlParameter("@ShowSectionTitleName", FromForm.ClassificationPageSection.ShowSectionTitleName), new SqlParameter("@ShowSectionTitleDescription", FromForm.ClassificationPageSection.ShowSectionTitleDescription), new SqlParameter("@ShowContentTypeTitleName", FromForm.ClassificationPageSection.ShowContentTypeTitleName), new SqlParameter("@ShowContentTypeTitleDescription", FromForm.ClassificationPageSection.ShowContentTypeTitleDescription), new SqlParameter("@OneTwoColumns", FromForm.ClassificationPageSection.OneTwoColumns), new SqlParameter("@ContentTypeId", FromForm.ClassificationPageSection.ContentTypeId), new SqlParameter("@SortById", FromForm.ClassificationPageSection.SortById), new SqlParameter("@MaxContent", FromForm.ClassificationPageSection.MaxContent), new SqlParameter("@HasPaging", FromForm.ClassificationPageSection.HasPaging), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ClassificationPageSection.Name), new SqlParameter("@Description", FromForm.ClassificationPageSection.Description), new SqlParameter("@MouseOver", FromForm.ClassificationPageSection.MouseOver), new SqlParameter("@MenuName", FromForm.ClassificationPageSection.MenuName), new SqlParameter("@TitleName", FromForm.ClassificationPageSection.TitleName), new SqlParameter("@TitleDescription", FromForm.ClassificationPageSection.TitleDescription) }; _context.Database.ExecuteSqlCommand("ClassificationPageSectionEditPost " + "@OId" + ", @LanguageId" + ", @Sequence" + ", @SectionTypeId" + ", @ShowSectionTitleName" + ", @ShowSectionTitleDescription" + ", @ShowContentTypeTitleName" + ", @ShowContentTypeTitleDescription" + ", @OneTwoColumns" + ", @ContentTypeId" + ", @SortById" + ", @MaxContent" + ", @HasPaging" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @TitleName" + ", @TitleDescription", parameters); return(RedirectToAction("Index", new { Id = FromForm.ClassificationPageSection.PId })); }
public async Task <IActionResult> LanguageCreate(SuContentTypeLanguageEditGetWitLanguageListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ContentType.OId), new SqlParameter("@LanguageId", FromForm.ContentType.LanguageId), new SqlParameter("@Name", FromForm.ContentType.Name ?? ""), new SqlParameter("@Description", FromForm.ContentType.Description ?? ""), new SqlParameter("@MouseOver", FromForm.ContentType.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.ContentType.MenuName ?? ""), new SqlParameter("@TitleName", FromForm.ContentType.TitleName ?? ""), new SqlParameter("@TitleDescription", FromForm.ContentType.TitleDesciption ?? ""), new SqlParameter("@ModifierId", CurrentUser.Id) }; _context.Database.ExecuteSqlCommand("ContentTypeLanguageCreatePost " + "@OId" + ", @LanguageId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @TitleName" + ", @TitleDescription" + ", @ModifierId", parameters); return(RedirectToAction("LanguageIndex", new { Id = FromForm.ContentType.OId.ToString() })); //if (ModelState.IsValid) //{ // var ContentTypeLanguage = new SuContentTypeLanguageModel // { // Name = test3.SuObject.Name, // Description = test3.SuObject.Description, // MouseOver = test3.SuObject.MouseOver, // ContentTypeId = test3.SuObject.ObjectId, // LanguageId = test3.SuObject.LanguageId // }; // _contentTypeLanguage.AddContentTypeLanguage(ContentTypeLanguage); //} //return RedirectToAction("LanguageIndex", new { Id = test3.SuObject.ObjectId.ToString() }); }
public async Task <IActionResult> Create(SuUserAndLists FromForm) { // SuUserModel UpdateUser = new SuUserModel(); SuUserModel NewUser = new SuUserModel { Email = FromForm.User.Email, UserName = FromForm.User.UserName, DefaultLanguageId = FromForm.User.DefaultLanguageId, CountryId = FromForm.User.CountryId }; NewUser.Email = FromForm.User.Email; NewUser.UserName = FromForm.User.UserName; NewUser.NormalizedEmail = FromForm.User.Email.ToUpper(); NewUser.NormalizedUserName = FromForm.User.UserName.ToUpper(); NewUser.DefaultLanguageId = FromForm.User.DefaultLanguageId; NewUser.CountryId = FromForm.User.CountryId; NewUser.SecurityLevel = 5; await _userManager.CreateAsync(NewUser, FromForm.User.Password); return(RedirectToAction("Index")); }
public async Task <IActionResult> Edit(SuClassificationValueEditGetModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@FromDate", FromForm.FromDate), new SqlParameter("@ToDate", FromForm.ToDate), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.Name ?? ""), new SqlParameter("@Description", FromForm.Description ?? ""), new SqlParameter("@MouseOver", FromForm.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.MenuName ?? ""), new SqlParameter("@DropDownName", FromForm.MenuName ?? ""), new SqlParameter("@PageName", FromForm.MenuName ?? ""), new SqlParameter("@PageDescription", FromForm.MenuName ?? ""), new SqlParameter("@HeaderName", FromForm.MenuName ?? ""), new SqlParameter("@HeaderDescription", FromForm.MenuName ?? ""), new SqlParameter("@TopicName", FromForm.MenuName ?? "") }; _context.Database.ExecuteSqlCommand("ClassificationValueEditPost " + "@OId" + ", @LanguageId" + ", @FromDate" + ", @ToDate" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @DropDownName" + ", @PageName" + ", @PageDescription" + ", @HeaderName" + ", @HeaderDescription" + ", @TopicName", parameters); return(RedirectToAction("Index", new { Id = FromForm.PId })); }
public async Task <IActionResult> Edit(SuClassificationLevelEditGetWithListModel FromForm) { if (ModelState.IsValid) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@Id", FromForm.ClassificationLevel.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@Alphabetically", FromForm.ClassificationLevel.Alphabetically), new SqlParameter("@CanLink", FromForm.ClassificationLevel.CanLink), new SqlParameter("@InDropDown", FromForm.ClassificationLevel.InDropDown), new SqlParameter("@InMenu", FromForm.ClassificationLevel.InMenu), new SqlParameter("@OnTheFly", FromForm.ClassificationLevel.OnTheFly), new SqlParameter("@Sequence", FromForm.ClassificationLevel.Sequence), new SqlParameter("@DateLevel", FromForm.ClassificationLevel.DateLevel), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ClassificationLevel.Name), new SqlParameter("@Description", FromForm.ClassificationLevel.Description), new SqlParameter("@MouseOver", FromForm.ClassificationLevel.MouseOver), new SqlParameter("@MenuName", FromForm.ClassificationLevel.MenuName) }; _context.Database.ExecuteSqlCommand("ClassificationLevelEditPost " + "@Id" + ", @LanguageId" + ", @Alphabetically" + ", @CanLink" + ", @InDropDown" + ", @InMenu" + ", @OnTheFly" + ", @Sequence" + ", @DateLevel" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName", parameters); } return(RedirectToAction("Index", new { Id = FromForm.ClassificationLevel.PId })); }
public async Task <IActionResult> Register(RegisterViewModel registerViewModel) { if (ModelState.IsValid) { var user = new SuUserModel { UserName = registerViewModel.Email, Email = registerViewModel.Email }; var result = await _userManager.CreateAsync(user, registerViewModel.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false); return(RedirectToAction("Index", "Home")); } foreach (var error in result.Errors) { ModelState.AddModelError("", error.Description); } } return(View(registerViewModel)); }
public async Task <IActionResult> Users(List <AddUsersToRoleViewModel> UserUpdates, string Id) { var role = await _roleManager.FindByIdAsync(Id); //Users currently assigned. var AssignedUsers = await _userManager.GetUsersInRoleAsync(role.Name); //New assigned foreach (var u in UserUpdates) { //New assigned or not bool CheckedUser = u.IsSelected; bool HaveUser = false; SuUserModel AssignedUser = new SuUserModel(); foreach (var x in AssignedUsers) { if (u.UserName == x.UserName) { HaveUser = true; AssignedUser = x; } } if (CheckedUser && !HaveUser) { var us = await _userManager.FindByEmailAsync(u.UserName); await _userManager.AddToRoleAsync(us, role.Name); } if (!CheckedUser && HaveUser) { await _userManager.RemoveFromRoleAsync(AssignedUser, role.Name); } } return(RedirectToAction("Edit", new { Id })); }
public async Task <IActionResult> LanguageCreate(SuClassificationValueLanguageEditGetWitLanguageListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ClassificationValue.OId), new SqlParameter("@LanguageId", FromForm.ClassificationValue.LanguageId), new SqlParameter("@Name", FromForm.ClassificationValue.Name ?? ""), new SqlParameter("@Description", FromForm.ClassificationValue.Description ?? ""), new SqlParameter("@MouseOver", FromForm.ClassificationValue.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.ClassificationValue.MenuName ?? ""), new SqlParameter("@DropDownName", FromForm.ClassificationValue.PageName ?? ""), new SqlParameter("@PageName", FromForm.ClassificationValue.PageDescription ?? ""), new SqlParameter("@PageDescription", FromForm.ClassificationValue.HeaderName ?? ""), new SqlParameter("@HeaderName", FromForm.ClassificationValue.HeaderDescription ?? ""), new SqlParameter("@HeaderDescription", FromForm.ClassificationValue.TopicName ?? ""), new SqlParameter("@ModifierId", CurrentUser.Id) }; _context.Database.ExecuteSqlCommand("ClassificationValueLanguageCreatePost " + "@OId" + ", @LanguageId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @DropDownName" + ", @PageName" + ", @PageDescription" + ", @HeaderName" + ", @HeaderDescription" + ", @TopicName" + ", @ModifierId", parameters); return(RedirectToAction("LanguageIndex", new { Id = FromForm.ClassificationValue.OId.ToString() })); //if (ModelState.IsValid) //{ // var ClassificationValueLanguage = new SuClassificationValueLanguageModel // { // Name = FromForm.SuObject.Name, // Description = FromForm.SuObject.Description, // DropDownName = FromForm.SuObject.DropDownName, // MenuName = FromForm.SuObject.MenuName, // MouseOver = FromForm.SuObject.MouseOver // }; // ClassificationValueLanguage.MouseOver = FromForm.SuObject.MouseOver; // ClassificationValueLanguage.PageDescription = FromForm.SuObject.PageDescription; // ClassificationValueLanguage.HeaderName = FromForm.SuObject.HeaderName; // ClassificationValueLanguage.HeaderDescription = FromForm.SuObject.HeaderDescription; // ClassificationValueLanguage.TopicName = FromForm.SuObject.TopicName; // ClassificationValueLanguage.ClassificationValueId = FromForm.SuObject.ObjectId; // ClassificationValueLanguage.LanguageId = FromForm.SuObject.LanguageId; // _classificationValueLanguage.AddClassificationValueLanguage(ClassificationValueLanguage); //} //return RedirectToAction("LanguageIndex", new { Id = FromForm.SuObject.ObjectId.ToString() }); }
public async Task <IActionResult> MasterData() { var x = await _userManager.FindByEmailAsync("*****@*****.**"); if (x == null) { SuUserModel user1 = new SuUserModel() { UserName = "******", Email = "*****@*****.**", DefaultLanguageId = 41 }; await _userManager.CreateAsync(user1, "Pipo!9165"); } if (_env.IsDevelopment()) { if (_userManager.FindByEmailAsync("*****@*****.**").Result == null) { SuUserModel user1 = new SuUserModel() { UserName = "******", Email = "*****@*****.**", DefaultLanguageId = 41 }; await _userManager.CreateAsync(user1, "Xipo!9165"); } } var user = await _userManager.FindByEmailAsync("*****@*****.**"); foreach (var a in await _userManager.GetRolesAsync(user)) { await _userManager.RemoveFromRoleAsync(user, a); } await _userManager.AddToRoleAsync(user, "Admin"); await _userManager.AddToRoleAsync(user, "Super admin"); var SuperAdmin = await _roleManager.FindByNameAsync("Super admin"); await _roleManager.GetClaimsAsync(SuperAdmin); foreach (var claim in await _roleManager.GetClaimsAsync(SuperAdmin)) { await _roleManager.RemoveClaimAsync(SuperAdmin, claim); } await _roleManager.AddClaimAsync(SuperAdmin, new System.Security.Claims.Claim("Menu", "Role")); await _roleManager.AddClaimAsync(SuperAdmin, new System.Security.Claims.Claim("Menu", "Classification")); await _roleManager.AddClaimAsync(SuperAdmin, new System.Security.Claims.Claim("Menu", "Page")); await _roleManager.AddClaimAsync(SuperAdmin, new System.Security.Claims.Claim("Menu", "Project")); await _roleManager.AddClaimAsync(SuperAdmin, new System.Security.Claims.Claim("Menu", "Type")); string[] StoredProcedures; StoredProcedures = new string[] { "ClassificationCreatePost.sql" , "ClassificationDeleteGet.sql" , "ClassificationDeletePost.sql" , "ClassificationEditGet.sql" , "ClassificationEditPost.sql" , "ClassificationIndexGet.sql" , "ClassificationLanguageCreateGetLanguages.sql" , "ClassificationLanguageCreatePost.sql" , "ClassificationLanguageDeletePost.sql" , "ClassificationLanguageEditGet.sql" , "ClassificationLanguageEditPost.sql" , "ClassificationLanguageIndexGet.sql" , "ClassificationLevelCreateGetExistingLevels.sql" , "ClassificationLevelCreatePost.sql" , "ClassificationLevelDeleteGet.sql" , "ClassificationLevelDeletePost.sql" , "ClassificationLevelEditGet.sql" , "ClassificationLevelEditGetExistingLevels.sql" , "ClassificationLevelEditPost.sql" , "ClassificationLevelIndexGet.sql" , "ClassificationLevelLanguageCreateGetLanguages.sql" , "ClassificationLevelLanguageCreatePost.sql" , "ClassificationLevelLanguageDeletePost.sql" , "ClassificationLevelLanguageEditGet.sql" , "ClassificationLevelLanguageEditPost.sql" , "ClassificationLevelLanguageIndexGet.sql" , "ClassificationPageCreatePost.sql" , "ClassificationPageDeleteGet.sql" , "ClassificationPageDeletePost.sql" , "ClassificationPageEditGet.sql" , "ClassificationPageEditPost.sql" , "ClassificationPageIndexGet.sql" , "ClassificationPageLanguageCreateGetLanguages.sql" , "ClassificationPageLanguageCreatePost.sql" , "ClassificationPageLanguageDeletePost.sql" , "ClassificationPageLanguageEditGet.sql" , "ClassificationPageLanguageEditPost.sql" , "ClassificationPageLanguageIndexGet.sql" , "ClassificationPageSectionCreatePost.sql" , "ClassificationPageSectionDeleteGet.sql" , "ClassificationPageSectionDeletePost.sql" , "ClassificationPageSectionEditGet.sql" , "ClassificationPageSectionEditPost.sql" , "ClassificationPageSectionIndexGet.sql" , "ClassificationPageSectionLanguageCreateGetLanguages.sql" , "ClassificationPageSectionLanguageCreatePost.sql" , "ClassificationPageSectionLanguageDeletePost.sql" , "ClassificationPageSectionLanguageEditGet.sql" , "ClassificationPageSectionLanguageEditPost.sql" , "ClassificationPageSectionLanguageIndexGet.sql" , "ClassificationValueCreateGetLevel.sql" , "ClassificationValueCreatePost.sql" , "ClassificationValueDeleteGet.sql" , "ClassificationValueDeletePost.sql" , "ClassificationValueEditGet.sql" , "ClassificationValueEditGetLevel.sql" , "ClassificationValueEditPost.sql" , "ClassificationValueIndexGet.sql" , "ClassificationValueIndexGetCurrentLevel.sql" , "ClassificationValueIndexGetMaxLevel.sql" , "ClassificationValueLanguageCreateGetLanguageList.sql" , "ClassificationValueLanguageCreatePost.sql" , "ClassificationValueLanguageDeletePost.sql" , "ClassificationValueLanguageEditGet.sql" , "ClassificationValueLanguageEditPost.sql" , "ClassificationValueLanguageIndexGet.sql" , "ClassificationValueStructureValues.sql" , "ContentCreate1GetContentType.sql" , "ContentCreate1GetContentTypeGroup.sql" , "ContentCreate2GetAllowed.sql" , "ContentCreate2GetClassifications.sql" , "ContentCreate2GetContentType.sql" , "ContentCreate2ProcessTemplateIdGet.sql" , "ContentCreate2Post.sql" , "ContentEditGetAllowed.sql" , "ContentEditGetClassifications.sql" , "ContentEditGetClassificationValues.sql" , "ContentEditGetContent.sql" , "ContentEditGetStatusList.sql" , "ContentEditPost.sql" , "ContentEditPostDeleteValue.sql" , "ContentEditPostInsertValue.sql" , "ContentEditPostUpdateValue.sql" , "ContentStatusList.sql" , "ContentTypeClassificationEditGet.sql" , "ContentTypeClassificationEditGetStatusList.sql" , "ContentTypeClassificationEditPost.sql" , "ContentTypeClassificationIndexGet.sql" , "ContentTypeCreatePost.sql" , "ContentTypeDeleteGet.sql" , "ContentTypeDeletePost.sql" , "ContentTypeEditGet.sql" , "ContentTypeEditPost.sql" , "ContentTypeGroupCreatePost.sql" , "ContentTypeGroupEditGet.sql" , "ContentTypeGroupEditPost.sql" , "ContentTypeGroupIndexGet.sql" , "ContentTypeGroupLanguageCreateGetLanguageList.sql" , "ContentTypeGroupLanguageCreatePost.sql" , "ContentTypeGroupLanguageDeletePost.sql" , "ContentTypeGroupLanguageEditGet.sql" , "ContentTypeGroupLanguageEditPost.sql" , "ContentTypeGroupLanguageIndexGet.sql" , "ContentTypeGroupList.sql" , "ContentTypeIndexGet.sql" , "ContentTypeLanguageCreateGetLanguageList.sql" , "ContentTypeLanguageCreatePost.sql" , "ContentTypeLanguageDeletePost.sql" , "ContentTypeLanguageEditGet.sql" , "ContentTypeLanguageEditPost.sql" , "ContentTypeLanguageIndexGet.sql" , "ContentTypeSelectAllForLanguage.sql" , "ContentUpdate.sql" , "ContentValueCreate.sql" , "CountryDD.sql" , "CountrySelectAll.sql" , "DataTypeSelectAll.sql" , "ExternalPageGetContent.sql" , "ExternalPageGetPage.sql" , "ExternalPageGetPageSection.sql" , "FrontCalendarEventCalendarGet.sql" , "FrontCalendarMyCalendarGet.sql" , "FrontOrganizationDashboardGetContent.sql" , "FrontOrganizationDashboardGetOrganization.sql" , "FrontOrganizationDashboardGetUsers.sql" , "FrontOrganizationMyOrganizationGet.sql" , "FrontPageGetContent.sql" , "FrontPageGetPage.sql" , "FrontPageGetPageSection.sql" , "FrontPageMyContentGet.sql" , "FrontPageViewGet.sql" , "FrontPageViewGetClassificationValues.sql" , "FrontProcessCreateGet.sql" , "FrontProcessCreateGetField.sql" , "FrontProcessIndexGetTemplate.sql" , "FrontProcessIndexGetTemplateFlowCondition.sql" , "FrontProcessIndexGetTemplateGroup.sql" , "FrontProcessToDoEditGet.sql" , "FrontProcessToDoIndex2GetFlowId.sql" , "FrontProcessToDoIndex2GetForAndOr.sql" , "FrontProcessToDoIndexGet.sql" , "FrontProjectMyProjectGet.sql" , "FrontRelationMyRelationGet.sql" , "FrontUserUserDashboardGet.sql" , "FrontUserIndexGet.sql" , "GetMasterList.sql" , "GetProcessTemplateFlowConditionCreateGetFields.sql" , "GetProcessTemplateGroup.sql" , "HomeIndexAdminGetLanguages.sql" , "HomeIndexAdminGetNoOfRecordsAndPerLanguage.sql" , "HomeIndexAdminGetTables.sql" , "LanguageIndexGet.sql" , "LanguageSelectActive.sql" , "LanguageSelectAll.sql" , "Menu1.sql" , "Menu123EditGetClassificationList.sql" , "Menu1CreatePost.sql" , "Menu1DeleteGet.sql" , "Menu1DeletePost.sql" , "Menu1EditGet.sql" , "Menu1EditPost.sql" , "Menu1IndexGet.sql" , "Menu1LanguageCreateGetLanguages.sql" , "Menu1LanguageCreatePost.sql" , "Menu1LanguageDeletePost.sql" , "Menu1LanguageEditGet.sql" , "Menu1LanguageEditPost.sql" , "Menu1LanguageIndexGet.sql" , "Menu2.sql" , "Menu2CreatePost.sql" , "Menu2DeleteGet.sql" , "Menu2DeletePost.sql" , "Menu2EditGet.sql" , "Menu2EditPost.sql" , "Menu2IndexGet.sql" , "Menu2LanguageCreateGetLanguages.sql" , "Menu2LanguageCreatePost.sql" , "Menu2LanguageDeletePost.sql" , "Menu2LanguageEditGet.sql" , "Menu2LanguageEditPost.sql" , "Menu2LanguageIndexGet.sql" , "Menu3.sql" , "Menu3CreatePost.sql" , "Menu3DeleteGet.sql" , "Menu3DeletePost.sql" , "Menu3EditGet.sql" , "Menu3EditPost.sql" , "Menu3IndexGet.sql" , "Menu3LanguageCreateGetLanguages.sql" , "Menu3LanguageCreatePost.sql" , "Menu3LanguageDeletePost.sql" , "Menu3LanguageEditGet.sql" , "Menu3LanguageEditPost.sql" , "Menu3LanguageIndexGet.sql" , "MenuTypeList.sql" , "OrganizationDeleteGet.sql" , "OrganizationDeletePost.sql" , "OrganizationEditGet.sql" , "OrganizationIndexGet.sql" , "OrganizationLanguageCreateGetLanguageList.sql" , "OrganizationLanguageCreatePost.sql" , "OrganizationLanguageDeletePost.sql" , "OrganizationLanguageEditGet.sql" , "OrganizationLanguageEditPost.sql" , "OrganizationLanguageIndexGet.sql" , "OrganizationTypeCreatePost.sql" , "OrganizationTypeDeleteGet.sql" , "OrganizationTypeDeletePost.sql" , "OrganizationTypeEditGet.sql" , "OrganizationTypeIndexGet.sql" , "OrganizationTypeLanguageCreateGetLanguageList.sql" , "OrganizationTypeLanguageCreatePost.sql" , "OrganizationTypeLanguageDeletePost.sql" , "OrganizationTypeLanguageEditGet.sql" , "OrganizationTypeLanguageEditPost.sql" , "OrganizationTypeLanguageIndexGet.sql" , "OrgStructure.sql" , "PageCreatePost.sql" , "PageDeleteGet.sql" , "PageDeletePost.sql" , "PageEditGet.sql" , "PageIndexGet.sql" , "PageLanguageCreateGetLanguageList.sql" , "PageLanguageCreatePost.sql" , "PageLanguageDeletePost.sql" , "PageLanguageEditGet.sql" , "PageLanguageEditPost.sql" , "PageLanguageIndexGet.sql" , "PageSectionDeleteGet.sql" , "PageSectionDeletePost.sql" , "PageSectionEditGet.sql" , "PageSectionIndexGet.sql" , "PageSectionLanguageCreateGetLanguageList.sql" , "PageSectionLanguageCreatePost.sql" , "PageSectionLanguageDeletePost.sql" , "PageSectionLanguageEditGet.sql" , "PageSectionLanguageEditPost.sql" , "PageSectionLanguageIndexGet.sql" , "PageSectionTypeCreatePost.sql" , "PageSectionTypeDeleteGet.sql" , "PageSectionTypeDeletePost.sql" , "PageSectionTypeEditGet.sql" , "PageSectionTypeEditPost.sql" , "PageSectionTypeIndexGet.sql" , "PageSectionTypeLanguageCreateGetLanguageList.sql" , "PageSectionTypeLanguageCreatePost.sql" , "PageSectionTypeLanguageDeletePost.sql" , "PageSectionTypeLanguageEditGet.sql" , "PageSectionTypeLanguageEditPost.sql" , "PageSectionTypeLanguageIndexGet.sql" , "PageSectionTypeSelectAllForLanguage.sql" , "PageSectionUpdate.sql" , "PageStatusSelectAll.sql" , "PageTypeCreatePost.sql" , "PageTypeDeleteGet.sql" , "PageTypeDeletePost.sql" , "PageTypeEditGet.sql" , "PageTypeIndexGet.sql" , "PageTypeLanguageCreateGetLanguageList.sql" , "PageTypeLanguageCreatePost.sql" , "PageTypeLanguageDeletePost.sql" , "PageTypeLanguageEditGet.sql" , "PageTypeLanguageEditPost.sql" , "PageTypeLanguageIndexGet.sql" , "PartialLeftMenu.sql" , "PartialTopMenu1.sql" , "PartialTopMenu2.sql" , "PreferenceIndexGet.sql" , "PreferenceIndexPost.sql" , "PreferenceLeftMenuCreateGetAvailableMenus.sql" , "PreferenceLeftMenuCreateGetExistingMenus.sql" , "PreferenceLeftMenuCreatePost.sql" , "PreferenceLeftMenuEditGet.sql" , "PreferenceLeftMenuEditGetOtherMenus.sql" , "PreferenceLeftMenuEditPost.sql" , "PreferenceLeftMenuGet.sql" , "PreferenceLeftMenuGetAvailableMenus.sql" , "ProcessTemplateCreatePost.sql" , "ProcessTemplateDeleteGet.sql" , "ProcessTemplateDeletePost.sql" , "ProcessTemplateEditGet.sql" , "ProcessTemplateFieldCreate.sql" , "ProcessTemplateFieldCreatePost.sql" , "ProcessTemplateFieldDeleteGet.sql" , "ProcessTemplateFieldDeletePost.sql" , "ProcessTemplateFieldEditGet.sql" , "ProcessTemplateFieldEditPost.sql" , "ProcessTemplateFieldIndexGet.sql" , "ProcessTemplateFieldLanguageCreateGetLanguageList.sql" , "ProcessTemplateFieldLanguageCreatePost.sql" , "ProcessTemplateFieldLanguageDeletePost.sql" , "ProcessTemplateFieldLanguageEditGet.sql" , "ProcessTemplateFieldLanguageEditPost.sql" , "ProcessTemplateFieldLanguageIndexGet.sql" , "ProcessTemplateFieldTypeIndexGet.sql" , "ProcessTemplateFieldTypeLanguageCreateGetLanguageList.sql" , "ProcessTemplateFieldTypeLanguageCreatePost.sql" , "ProcessTemplateFieldTypeLanguageDeletePost.sql" , "ProcessTemplateFieldTypeLanguageEditGet.sql" , "ProcessTemplateFieldTypeLanguageEditPost.sql" , "ProcessTemplateFieldTypeLanguageIndexGet.sql" , "ProcessTemplateFieldTypeSelectAllForLanguage.sql" , "ProcessTemplateFieldUpdate.sql" , "ProcessTemplateFlowConditionCreate.sql" , "ProcessTemplateFlowConditionCreateGetComparison.sql" , "ProcessTemplateFlowConditionCreateGetFields.sql" , "ProcessTemplateFlowConditionCreateGetType.sql" , "ProcessTemplateFlowConditionDeleteGet.sql" , "ProcessTemplateFlowConditionDeletePost.sql" , "ProcessTemplateFlowConditionEditGet.sql" , "ProcessTemplateFlowConditionEditGetTypes.sql" , "ProcessTemplateFlowConditionEditPost.sql" , "ProcessTemplateFlowConditionIndexGet.sql" , "ProcessTemplateFlowConditionLanguageCreatePost.sql" , "ProcessTemplateFlowConditionLanguageDeletePost.sql" , "ProcessTemplateFlowConditionLanguageEditGet.sql" , "ProcessTemplateFlowConditionLanguageEditPost.sql" , "ProcessTemplateFlowConditionLanguageIndexGet.sql" , "ProcessTemplateFlowConditionUpdate.sql" , "ProcessTemplateFlowCreate.sql" , "ProcessTemplateFlowDeleteGet.sql" , "ProcessTemplateFlowDeletePost.sql" , "ProcessTemplateFlowEditGet.sql" , "ProcessTemplateFlowIndexGet.sql" , "ProcessTemplateFlowLanguageCreateGetLanguageList.sql" , "ProcessTemplateFlowLanguageCreatePost.sql" , "ProcessTemplateFlowLanguageDeletePost.sql" , "ProcessTemplateFlowLanguageEditGet.sql" , "ProcessTemplateFlowLanguageEditPost.sql" , "ProcessTemplateFlowLanguageIndexGet.sql" , "ProcessTemplateFlowUpdate.sql" , "ProcessTemplateGroupCreatePost.sql" , "ProcessTemplateGroupDeleteGet.sql" , "ProcessTemplateGroupDeletePost.sql" , "ProcessTemplateGroupEditGet.sql" , "ProcessTemplateGroupEditPost.sql" , "ProcessTemplateGroupIndexGet.sql" , "ProcessTemplateGroupLanguageCreateGetLanguageList.sql" , "ProcessTemplateGroupLanguageCreatePost.sql" , "ProcessTemplateGroupLanguageDeletePost.sql" , "ProcessTemplateGroupLanguageEditGet.sql" , "ProcessTemplateGroupLanguageEditPost.sql" , "ProcessTemplateGroupLanguageIndexGet.sql" , "ProcessTemplateIndexGet.sql" , "ProcessTemplateLanguageCreateGetLanguageList.sql" , "ProcessTemplateLanguageCreatePost.sql" , "ProcessTemplateLanguageDeletePost.sql" , "ProcessTemplateLanguageEditGet.sql" , "ProcessTemplateLanguageIndexGet.sql" , "ProcessTemplateList.sql" , "ProcessTemplateStepCreate.sql" , "ProcessTemplateStepDeleteGet.sql" , "ProcessTemplateStepDeletePost.sql" , "ProcessTemplateStepEditGet.sql" , "ProcessTemplateStepFieldsIndexGet.sql" , "ProcessTemplateStepFieldUpdate.sql" , "ProcessTemplateStepIndexGet.sql" , "ProcessTemplateStepLanguageCreateGetLanguageList.sql" , "ProcessTemplateStepLanguageDeletePost.sql" , "ProcessTemplateStepLanguageEditGet.sql" , "ProcessTemplateStepLanguageIndexGet.sql" , "ProcessTemplateStepUpdate.sql" , "ProjectDeleteGet.sql" , "ProjectDeletePost.sql" , "ProjectEditGet.sql" , "ProjectIndexGet.sql" , "ProjectLanguageCreatePost.sql" , "ProjectLanguageDeletePost.sql" , "ProjectLanguageEditGet.sql" , "ProjectLanguageEditPost.sql" , "ProjectLanguageIndexGet.sql" , "ProjectTypeEditGet.sql" , "ProjStructure.sql" , "SecurityLevelSelectAll.sql" , "ShowContent.sql" , "ShowPage.sql" , "ShowPageSection.sql" , "UITermLanguageCreateGetLanguages.sql" , "UITermLanguageCreatePost.sql" , "UITermLanguageEditGet.sql" , "UITermLanguageEditPost.sql" , "UITermLanguageSelect.sql" , "UITermLanguageSelectForUpdate.sql" , "UITermLanguagesSelectForOneTerm.sql" , "UITermLanguageUpdate.sql" , "UITermSelectAll.sql" , "UserOrganizationCreate.sql" , "UserOrganizationSelectAll.sql" , "UserOrganizationSelectBasedOnUser.sql" , "UserOrganizationTypeIndexGet.sql" , "UserOrganizationTypeLanguageCreateGetLanguages.sql" , "UserOrganizationTypeLanguageCreatePost.sql" , "UserOrganizationTypeLanguageEditGet.sql" , "UserOrganizationTypeLanguageEditPost.sql" , "UserOrganizationTypeLanguageIndexGet.sql" , "UserOrganizationTypeSelectAll.sql" , "UserOrganizationTypeSelectAllLanguages.sql" , "UserProjectCreate.sql" , "UserProjectSelectAll.sql" , "UserProjectSelectBasedOnUser.sql" , "UserProjectTypeLanguageCreateGetLanguages.sql" , "UserProjectTypeLanguageCreatePost.sql" , "UserProjectTypeLanguageEditGet.sql" , "UserProjectTypeLanguageEditPost.sql" , "UserProjectTypeLanguageIndexGet.sql" , "UserProjectTypeSelectAll.sql" , "UserRelationSelectAll.sql" , "UserRelationTypeIndexGet.sql" , "UserRelationTypeLanguageCreateGetLanguages.sql" , "UserRelationTypeLanguageCreatePost.sql" , "UserRelationTypeLanguageDeleteGet.sql" , "UserRelationTypeLanguageDeletePost.sql" , "UserRelationTypeLanguageEditGet.sql" , "UserRelationTypeLanguageEditPost.sql" , "UserRelationTypeLanguageIndexGet.sql" }; foreach (string StoredProcedure in StoredProcedures) { using (StreamReader sr = new StreamReader("MasterDataScripts\\StoredProcedures\\" + StoredProcedure, System.Text.Encoding.UTF8)) { string line = sr.ReadToEnd(); _context.Database.ExecuteSqlCommand(line); } } string[] MasterDataScripts; MasterDataScripts = new string[] { "MasterData.sql", "UIScreens.sql", "UITerms.sql", "UITermScreen.sql" }; foreach (string MasterDataScript in MasterDataScripts) { using (StreamReader sr = new StreamReader("MasterDataScripts\\" + MasterDataScript, System.Text.Encoding.UTF8)) { string line = sr.ReadToEnd(); _context.Database.ExecuteSqlCommand(line); } } return(View()); }