public void SaveSetting(IntegrationSetting setting)
{
using (var dc = new VendorDataContext(_connectionString))
{
var existingSettin =
dc.IntegrationSettings.FirstOrDefault(x => x.IntegrationSettingId == setting.IntegrationSettingId);
existingSettin.Value = setting.Value;
dc.SubmitChanges();
}
}
public int AddSetting(IntegrationSetting input)
{
using (var dc = new VendorDataContext(_connectionString))
{
var maxId = dc.IntegrationSettings.Max(x => x.IntegrationSettingId);
input.IntegrationSettingId = maxId + 1;
dc.IntegrationSettings.InsertOnSubmit(input);
dc.SubmitChanges();
}
return(input.IntegrationSettingId);
}
public async Task <IActionResult> OnPostAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
IntegrationSetting = await _wcaDbContext.IntegrationSettings.FindAsync(id);
if (IntegrationSetting != null)
{
_wcaDbContext.IntegrationSettings.Remove(IntegrationSetting);
await _wcaDbContext.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
IntegrationSetting = await _wcaDbContext.IntegrationSettings
.Include(i => i.ActionstepOrg)
.Include(i => i.Integration)
.Include(i => i.User).FirstOrDefaultAsync(m => m.Id == id);
if (IntegrationSetting == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
IntegrationSetting = await _wcaDbContext.IntegrationSettings
.Include(i => i.ActionstepOrg)
.Include(i => i.Integration)
.Include(i => i.User).FirstOrDefaultAsync(m => m.Id == id);
if (IntegrationSetting == null)
{
return(NotFound());
}
ViewData["ActionstepOrgKey"] = new SelectList(_wcaDbContext.ActionstepOrgs.OrderBy(u => u.Key), "Key", "Key");
ViewData["IntegrationId"] = new SelectList(_wcaDbContext.Integrations.OrderBy(u => u.Title), "Id", "Title");
ViewData["UserId"] = new SelectList(_wcaDbContext.Users.OrderBy(u => u.Email), "Id", "Email");
return(Page());
}
