public ActionResult Index(RoleOptionView objRoleOptionView)
{
try
{
if (DataUtil.Validation())
{
RoleOptionView objRoleOptionView2 = new RoleOptionView();
try
{
if (Request.Form["ActionForm"] == "Registrar")
{
var RemoveAll = db.RoleOption.Where(x => x.roleID == objRoleOptionView.role.roleID);
db.RoleOption.RemoveRange(RemoveAll);
db.SaveChanges();
RoleOption objRoleOption = new RoleOption();
foreach (var item in objRoleOptionView.options)
{
if (item.selected)
{
objRoleOption.roleID = objRoleOptionView.role.roleID;
objRoleOption.optionID = item.optionID;
db.RoleOption.Add(objRoleOption);
db.SaveChanges();
}
}
objRoleOptionView2.roleOptionList = db.RoleOption.Include(u => u.option).Include(u => u.role).Where(u => u.role.roleID == objRoleOptionView.role.roleID).ToList();
objRoleOptionView2.options = db.Database.SqlQuery <Option>("select o.optionid, o.name, CAST(ISNULL((select 1 from roleOptions ro where ro.roleID = @roleID and ro.optionID = o.optionID),0) AS BIT) selected, o.active, o.createdate, o.createuser, o.updatedate, o.updateuser from options o where o.active = 1", new SqlParameter("@roleID", objRoleOptionView.role.roleID)).ToList();
objRoleOptionView2.role = db.Role.Find(objRoleOptionView.role.roleID);
ModelState.Clear();
}
}
catch (Exception ex)
{
}
return(View(objRoleOptionView2));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (Exception ex)
{
Error objError = new Error();
objError.page = "RoleOptions";
objError.option = "Index-2";
objError.date = DateTime.Now;
objError.description = ex.Message;
BaseDataAccess <Error> baseDataAccess = new BaseDataAccess <Error>();
baseDataAccess.Insert(objError);
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Edit(RoleViewModel Omodelo)
{
var OMensaje = new Mensaje();
try
{
using (RELOJBIOEntities wdb = new RELOJBIOEntities())
{
var ORole = wdb.Role.Where(a => a.RoleID == Omodelo.RoleID).FirstOrDefault();
ORole.Description = Omodelo.Description;
ORole.IsActive = Omodelo.IsActive;
wdb.Entry(ORole).State = EntityState.Modified;
wdb.SaveChanges();
foreach (var item in Omodelo.LisCodigoOpcionesSeleccionados)
{
var OExiste = wdb.RoleOption.Where(a => a.RoleID == ORole.RoleID && a.OptionID == item).FirstOrDefault();
if (OExiste == null)
{
var OUltimoRoleOption = wdb.RoleOption.OrderByDescending(a => a.RoleOptionID).FirstOrDefault();
int wID = OUltimoRoleOption.RoleOptionID + 1;
var ORoleOption = new RoleOption
{
RoleOptionID = wID,
RoleID = Omodelo.RoleID,
OptionID = item
};
wdb.RoleOption.Add(ORoleOption);
wdb.SaveChanges();
}
}
OMensaje.Tipo = "Exito";
OMensaje.Msg = "El Rol Fue Modificado con exito";
Session["Mensaje"] = OMensaje;
return(RedirectToAction("Index", "Role"));
}
}
catch (DbEntityValidationException e)
{
var errorMessages = e.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
var fullErrorMessage = string.Join("; ", errorMessages);
var exceptionMessage = string.Concat(e.Message, " El error de validacion es: ", fullErrorMessage);
OMensaje.Tipo = "Error";
OMensaje.Msg = exceptionMessage;
Session["Mensaje"] = OMensaje;
return(View(Omodelo));
}
}
public void UserTest(RoleOption roleOptionIn, RoleOption roleOptionOut)
{
var user = new User()
{
Roles = roleOptionIn
};
user.Roles.Should().BeEquivalentTo(roleOptionOut);
}
public User(int idPharmacien, string password, string email, string firstname, string country, DateTime dateCreate, RoleOption role)
{
IdPharmacien = idPharmacien;
Password = password;
Email = email;
Firstname = firstname;
Country = country;
DateCreate = dateCreate;
Role = role;
}
public async Task <IEnumerable <Role> > GetListAsync(RoleOption option)
{
if (!string.IsNullOrWhiteSpace(option.Name))
{
return(await RoleRep.Find(o => o.Name.Contains(option.Name)).ToListAsync());
}
else
{
return(await RoleRep.Find(null).ToListAsync());
}
}
/// <summary>
/// Converts string to RoleOption. When raiseException is true and is cast error raises exception otherwise returns defaultValue.
/// </summary>
/// <param name="key"></param>
/// <param name="defaultValue"></param>
/// <param name="raiseException"></param>
/// <returns></returns>
public static RoleOption ToRoleOption(this string key, RoleOption defaultValue = RoleOption.Unknown, bool raiseException = false)
{
if (Enum.TryParse(key, true, out RoleOption value))
{
return(value);
}
else
{
return(raiseException ? throw new ArgumentException($"{key} is not RoleOption value.") : defaultValue);
}
}
//
// GET: /<controller>/
public async Task <IActionResult> Index(RoleOption filter, int?page)
{
ViewBag.filter = filter;
var currentPageNum = page.HasValue ? page.Value : 1;
var result = await RoleApp.GetPageAsync(currentPageNum, DefaultPageSize, filter);
var model = new BaseListViewModel <Role>();
model.list = result.Data;
model.Paging.CurrentPage = currentPageNum;
model.Paging.ItemsPerPage = DefaultPageSize;
model.Paging.TotalItems = result.ItemCount;
return(View(model));
}
public async Task <Guid> Register(string email, string password, RoleOption role)
{
var user = new User
{
Email = email,
Name = email,
Password = password,
RoleId = role
};
_context.Users.Add(user);
await _context.SaveChangesAsync();
return(user.UserGuid);
}
//
// GET: /<controller>/
public async Task <IActionResult> Index(RoleOption filter, int?page)
{
ViewBag.filter = filter;
var currentPageNum = page ?? 1;
var result = await RoleApp.GetPageAsync(currentPageNum, DefaultPageSize, filter);
var model = new BaseListViewModel <Role>
{
list = result.Data,
Paging =
{
CurrentPage = currentPageNum,
ItemsPerPage = DefaultPageSize,
TotalItems = result.ItemCount
}
};
return(View(model));
}
public async Task <PageResult <Role> > GetPageAsync(int pageNumber, int rowsPrePage, RoleOption filter)
{
List <Role> data = new List <Role>();
PageResult <Role> list = new PageResult <Role>();
string orderby = " id desc";
var predicate = PredicateBuilder.True <Role>();
if (!string.IsNullOrWhiteSpace(filter.Name))
{
predicate = predicate.And(o => o.Name.Contains(filter.Name));
}
var tlist = await RoleRep.Find(pageNumber, rowsPrePage, orderby, predicate).ToListAsync();
list.Data = tlist.ToList();
int total = await RoleRep.GetCountAsync(predicate);
list.ItemCount = total;
return(list);
}
public void ToRoleOptionExceptionTest(string value, RoleOption defaultValue)
{
Action action = () => value.ToRoleOption(defaultValue, true);
action.Should().Throw <ArgumentException>();
}
public void ToRoleOptionOkTest(string value, RoleOption defaultValue, RoleOption expectedResult)
{
value.ToRoleOption(defaultValue).Should().BeEquivalentTo(expectedResult);
}
public static bool IsNotAdministratorSortByDateCreate(this SearchCriteria searchCriteria, RoleOption role) => searchCriteria.SearchSortFieldOption == SortFieldOption.DateCreate && role != RoleOption.Administrator;
