public ActionResult EditFromID(int pageID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBPageModel page = db.SelectPage(pageID);
return(RedirectToAction("Edit", page));
}
public void Execute()
{
IDBConnector db = null;
try
{
db = DBConnector.Initialize();
db.Open();
_actionDB(db);
}
catch (Exception ex)
{
if (OnError != null)
{
OnError(ex);
}
}
finally
{
if (db != null)
{
db.Disconnect();
}
};
}
private static void sendEmailWithExcelFile(string salesOrg, List <MissingCMIRProperty> missingCMIRList, IMailUtil mu, string email)
{
IDBConnector dbxl = Create.dbXl();
Workbook wb;
string path = $"{Environment.GetFolderPath(Environment.SpecialFolder.Desktop)}\\{salesOrg} {DateTime.Now.Day}.{DateTime.Now.Month}.{DateTime.Now.Year} {DateTime.Now.Hour}hour {DateTime.Now.Minute}minute Missing CMIR Report.xlsx";
dbxl.listToExcel(list: missingCMIRList, path: path);
using (IExcelUtil xl = Create.xlUtil()) {
try {
wb = xl.getWorkbook(path: path);
} catch (Exception) {
System.Threading.Thread.Sleep(5000);
wb = xl.getWorkbook(path: path);
}
Worksheet ws = wb.Worksheets[1] as Worksheet;
try {
IdaExcelService.prettifyExcel(worksheet: ws, excelUtilObj: xl);
} catch (Exception) {
System.Threading.Thread.Sleep(2000);
IdaExcelService.prettifyExcel(worksheet: ws, excelUtilObj: xl);
}
wb.Save();
mu.mailOneAttachment(emailTo: email, cc: "", subject: $"{salesOrg} Missing CMIR Report", body: $"{mu.listToHTMLtable(missingCMIRList)}", path: path);
dbxl.closeConnection();
xl.closeWBAndAllInstances(wbName: wb.Name);
}
}
private static bool CheckDuplication(IDBConnector dbConnector, Contest contest)
{
int sportTypeDuplicationRange = SportTypeTimeRangeDuplication.GetTimeRangeBySportType(contest.SportType);
ISearchService searchService = new AzureSearchService();
SearchIndexParameters parameters = new SearchIndexParameters()
{
Filter = $"SportType eq '{contest.SportType}' and League eq '{contest.League}' " +
$"and HomeTeam eq '{contest.HomeTeam}' and AwayTeam eq '{contest.AwayTeam}' " +
$"and GameStartDate gt {contest.GameStartDate.AddHours(-sportTypeDuplicationRange).ToString("yyyy-MM-ddTHH:mm:ssZ")} " +
$"and GameStartDate lt {contest.GameStartDate.AddHours(sportTypeDuplicationRange).ToString("yyyy-MM-ddTHH:mm:ssZ")}",
Select = new[] { "id" }
};
var results = searchService.RunQuery(parameters);
if (results == null || (results != null && results.Results.Count == 0))
{
return(false);
}
else
{
return(true);
}
}
public ActionResult EditFromID(int websiteID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
UserWebsiteModel website = db.SelectWebsite(websiteID);
return(RedirectToAction("Edit", website));
}
public ParticipantContext(
ILogger <ParticipantContext> logger,
IDBConnector dbConnector)
{
_logger = logger;
_dbConnector = dbConnector;
}
public ActionResult SelectSections(List <SectionModel> sections)
{
if (ModelState.IsValid)
{
List <DBSectionModel> removePositions = new List <DBSectionModel>();
List <DBSectionModel> addPositions = new List <DBSectionModel>();
foreach (SectionModel section in sections)
{
if (section.IsSelected)
{
addPositions.Add(ConvertSectionModel(section));
}
else
{
removePositions.Add(ConvertSectionModel(section));
}
}
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.InsertPositions(addPositions);
db.DeletePositions(removePositions);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID = sections[0].PageID }));
}
return(View(sections));
}
public ActionResult Delete(int UserSocialMediaID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeleteSocialMedia(UserSocialMediaID);
return(RedirectToAction("Edit", "Profile"));
}
public Manager()
{
bool str;
dbConnector = new DapperConnector();
dbConnector.SQLConnect("./WorkWithDB/DB.db", out str);
dbConnector.CreateTableOperation(out str);
}
public ActionResult Delete(int websiteID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeleteWebsite(websiteID);
return(RedirectToAction("MyWebsites"));
}
public TestContext(
ILogger <TestContext> logger,
IDBConnector dbConnector,
IVariantPicker variantPicker)
{
_logger = logger;
_dbConnector = dbConnector;
}
public ActionResult Delete(int PageID, int WebsiteID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeletePage(PageID);
return(RedirectToAction("EditFromID", "Website", new { websiteID = WebsiteID }));
}
public ActionResult Remove(int sectionID, int pageID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeleteSectionFromPage(sectionID, pageID);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID }));
}
public ActionResult Delete(PermissionModel permission)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeletePermission(permission.PermissionID);
return(RedirectToAction("EditFromID", "Website", new { websiteID = permission.WebsiteID }));
}
public ActionResult Create(DBPageModel page)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.InsertPage(page);
return(RedirectToAction("EditFromID", "Website", new { websiteID = page.WebsiteID }));
}
public ActionResult Delete(SectionModel section)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.DeleteSection(section.SectionID);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID = section.PageID }));
}
public ActionResult Create(NewWebsiteModel website)
{
website.LoginID = User.Identity.GetUserId();
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.InsertWebsite(website);
return(RedirectToAction("MyWebsites"));
}
public ActionResult Edit(int id)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
SocialMediaModel model = db.SelectSocialMedia(id);
ViewBag.SocialMediaOptions = DropDownGenerator.GetSocialMediaDropDown(model.SocialMediaID);
return(View(model));
}
public ActionResult Edit(SocialMediaModel model)
{
model.LoginID = User.Identity.GetUserId();
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.UpdateSocialMedia(model);
return(RedirectToAction("Edit", "Profile"));
}
public TestRepository(
ILogger <TestRepository> logger,
IDBConnector dbConnector,
ITestContext testContext)
{
_logger = logger;
_dbConnector = dbConnector;
_testContext = testContext;
}
public ActionResult MyWebsites()
{
string userID = User.Identity.GetUserId();
List <UserWebsiteModel> websites = new List <UserWebsiteModel>();
if (userID != null)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
websites = db.SelectUserWebsites(userID);
}
return(View(websites));
}
public ParticipantRepository(
ILogger <ParticipantRepository> logger,
IDBConnector dbConnector,
IVariantPicker variantPicker,
ITestContext testContext,
IParticipantContext participantContext)
{
_logger = logger;
_variantPicker = variantPicker;
_dbConnector = dbConnector;
_testContext = testContext;
_participantContext = participantContext;
}
public ActionResult Delete(int pageID, int sectionID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel section = db.SelectSection(sectionID);
if (section != null)
{
section.PageID = pageID;
return(View(ConvertSectionModel(section)));
}
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID }));
}
public ActionResult Edit(PageModel page)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
db.UpdatePage(new DBPageModel()
{
PageID = page.PageID, Title = page.Title, DisplayTitle = page.DisplayTitle
});
db.UpdateWebsiteHomePage(page.WebsiteID, page.PageID, page.HomePage);
page.Sections = db.SelectEditPageSections(page.PageID);
return(View(page));
}
public ActionResult Create(SectionModel section)
{
if (GetValid(section))
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
int index = db.InsertSection(ConvertSectionModel(section));
List <SectionLinkModel> links = MarkdownConverter.FindInternalLinks(section.Text, index);
db.InsertSectionLinks(links);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID = section.PageID }));
}
return(View(section));
}
public ActionResult Display(int websiteID, int pageID, int sectionID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel section = db.SelectSection(sectionID);
if (section != null)
{
section.PageID = pageID;
section.Text = MarkdownConverter.MarkdownToHTML(section.Text, websiteID);
return(View(ConvertSectionModel(section)));
}
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID }));
}
public ActionResult SelectSections(int pageID)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
List <DBSectionModel> dbSections = db.SelectPagePositions(pageID);
List <SectionModel> sections = new List <SectionModel>();
foreach (DBSectionModel section in dbSections)
{
section.PageID = pageID;
sections.Add(ConvertSectionModel(section));
}
return(View(dbSections));
}
public ActionResult Delete(TagModel tag)
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
if (tag.WebsiteID == -1)
{
tag.LoginID = User.Identity.GetUserId();
db.DeleteUserTag(tag);
}
else
{
db.DeleteWebsiteTag(tag);
}
return(Return(tag));
}
private PageModel PopulatePageModel(DBPageModel webpage)
{
PageModel page = new PageModel()
{
PageID = webpage.PageID,
WebsiteID = webpage.WebsiteID,
Title = webpage.Title,
HomePage = webpage.HomePage,
DisplayTitle = webpage.DisplayTitle
};
IDBConnector db = DBConnectorFactory.GetDBConnector();
page.Sections = db.SelectEditPageSections(webpage.PageID);
return(page);
}
public ActionResult Edit(SectionModel section)
{
if (GetValid(section))
{
IDBConnector db = DBConnectorFactory.GetDBConnector();
DBSectionModel dbSection = ConvertSectionModel(section);
db.UpdateSection(dbSection);
db.UpdatePosition(dbSection);
List <SectionLinkModel> links = MarkdownConverter.FindInternalLinks(section.Text, section.SectionID);
db.MergeSectionLinks(links, section.SectionID);
return(RedirectToAction(StringKeys.EDIT_FROM_ID, StringKeys.PAGE_CONTROLLER, new { pageID = section.PageID }));
}
return(View(section));
}
public void SetDBProvider(IDBConnector Connector)
{
this.dbConnector = Connector;
}
