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