// Insertar elementos en la base de datos
public RolePage Insert(RolePage rolePage)
{
// Guardar elemento
_context.RolePage.Add(rolePage);
_context.SaveChanges();
return(rolePage);
}
public IActionResult Put([FromODataUri] Guid key, RolePage rolepage)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var trans = context.Database.BeginTransaction())
{
try
{
if (context.RolePages.Find(key) == null)
{
return(NotFound());
}
//context = new ApplicationDbContext(context.Options);
var local = context.RolePages.Local.FirstOrDefault(it => it.RolePageID.Equals(key));
if (local != null)
{
context.Entry(local).State = EntityState.Detached;
}
context.Entry(rolepage).State = EntityState.Modified;
context.SaveChanges();
trans.Commit();
return(Ok(rolepage));
}
catch (Exception ex)
{
trans.Rollback();
return(BadRequest(ex));
}
}
}
public void AddRole()
{
var login = new AuthPage(driver);
var role = new RolePage(driver);
driver.Url = string.Concat(Url.Deautos.Views.Backoffice.Main, "roleAssociation");
login.BackOfficeLogin();
IsTrue(role.AddRole());
}
public void TestIniti()
{
this.TestInitialize();
this.loginPage = new LoginPage(this.Driver);
this.loginPage.CurrentUserLogin(BaseConstants.TestAdminPanelUrl);
this.settings = new APSettingsGlobalOptionsPage(this.Driver);
this.role = new RolePage(this.Driver);
Thread.Sleep(1500);
this.settings.NavigateToSettings();
this.settings.NavigateToRoles();
}
public async Task <ActionResultResponse> Insert(RolePage rolePage)
{
var isExists = await CheckExists(rolePage.PageId, rolePage.RoleId);
if (isExists)
{
return(new ActionResultResponse(-1, _resourceService.GetString("Role page already assigned.")));
}
_rolePageRepository.Create(rolePage);
var result = await Context.SaveChangesAsync();
return(new ActionResultResponse(result, result > 0 ? _resourceService.GetString("Role page assign successful.")
: _sharedResourceService.GetString("Something went wrong. Please contact with administrator.")));
}
public IHttpActionResult Create(RolePage model)
{
var db = new VidlyDbFirstEntities1();
//the linq below would translate to //select * from productstable where Id in(value1, value2, value3)
var pages = db.Pages.Where(m => model.pageIds.Contains(m.Id));
foreach (var page in pages)
{
var vm = new PageRole
{
RoleId = model.roleId,
PageID = page.Id
};
db.PageRoles.Add(vm);
}
db.SaveChanges();
return(Ok());
}
public RolePage GetRoleInfo(string RoleName, int States, int PageSize = 5, int CurrentPage = 1)
{
var list = db.RoleInfo.ToList();
if (!string.IsNullOrEmpty(RoleName))
{
list = list.Where(s => s.RoleName.Contains(RoleName)).ToList();
}
if (States != -1)
{
list = list.Where(s => s.States.Equals(States)).ToList();
}
if (CurrentPage < 1)
{
CurrentPage = 1;
}
var count = list.Count();
var index = 0;
if (count % PageSize == 0)
{
index = count / PageSize;
}
else
{
index = count / PageSize + 1;
}
if (CurrentPage > index)
{
CurrentPage = index;
}
RolePage p = new RolePage();
p.PageIndex = index;
p.CurrentPage = CurrentPage;
p.TotalCount = count;
p.RoleInfos = list.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList();
return(p);
}
public IActionResult Post(RolePage rolepage)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var trans = context.Database.BeginTransaction())
{
try
{
context.RolePages.Add(rolepage);
context.SaveChanges();
trans.Commit();
return(Ok(rolepage));
}
catch (Exception ex)
{
trans.Rollback();
return(BadRequest(ex));
}
}
}
public RolePage Insert(RolePage body, string id)
{
throw new NotImplementedException();
}
void Rock(RolePage role, UIRocker.Direction direction)
{
role.Rocking(direction);
}
