public void Remove(RoleColumns rolecolumn)
{
if (Context.Entry(rolecolumn).State == EntityState.Detached)
{
context.RoleColumns.Attach(rolecolumn);
}
context.RoleColumns.Remove(rolecolumn);
}
public void UpdateRoleGridColumns(IEnumerable <RoleGridColumnsViewModel> models, string objectName, byte version, int companyId)
{
if (models == null)
{
return;
}
var roleId = models.Select(r => r.RoleId).First();
var roleColumns = context.RoleColumns.Where(a => a.CompanyId == companyId && a.ObjectName == objectName && a.Version == version && a.RoleId == roleId).ToList();
foreach (var model in models)
{
var rc = roleColumns.FirstOrDefault(a => a.ColumnName == model.ColumnName);
//&& model.isVisible == false
if (rc == null)
{
//insert new record in Role columns
RoleColumns record = new RoleColumns
{
RoleId = model.RoleId,
isVisible = model.isVisible,
ColumnName = model.ColumnName,
isEnabled = model.isEnabled,
ObjectName = objectName,
CompanyId = companyId,
Version = version
};
context.RoleColumns.Add(record);
}
//&& model.isVisible == true
else if (rc != null)
{
//update record in Role colums
rc.isVisible = model.isVisible;
rc.isEnabled = model.isEnabled;
context.RoleColumns.Attach(rc);
context.Entry(rc).State = EntityState.Modified;
}
}
}
