/// <summary>
/// Retrieves list of PermissionGroupMap objects from SqlCommand, after database query
/// number of rows retrieved and returned depends upon the rows field value
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <param name="rows">Number of rows to process</param>
/// <returns>A list of PermissionGroupMap objects</returns>
private PermissionGroupMapList GetList(SqlCommand cmd, long rows)
{
// Select multiple records
SqlDataReader reader;
long result = SelectRecords(cmd, out reader);
//PermissionGroupMap list
PermissionGroupMapList list = new PermissionGroupMapList();
using ( reader )
{
// Read rows until end of result or number of rows specified is reached
while (reader.Read() && rows-- != 0)
{
PermissionGroupMap permissionGroupMapObject = new PermissionGroupMap();
FillObject(permissionGroupMapObject, reader);
list.Add(permissionGroupMapObject);
}
// Close the reader in order to receive output parameters
// Output parameters are not available until reader is closed.
reader.Close();
}
return(list);
}
/// <summary>
/// populates a PermissionGroupMap with its child entities
/// </summary>
/// <param name="permissionGroupMap"></param>
/// <param name="fillChilds"></param>
private void FillPermissionGroupMapWithChilds(PermissionGroupMap permissionGroupMapObject, bool fillChilds)
{
// populate child data for a permissionGroupMapObject
if (permissionGroupMapObject != null)
{
}
}
/// <summary>
/// Update PermissionGroupMap Object.
/// Data manipulation processing for: new, deleted, updated PermissionGroupMap
/// </summary>
/// <param name="permissionGroupMapObject"></param>
/// <returns></returns>
public bool Update(PermissionGroupMap permissionGroupMapObject)
{
bool success = false;
success = UpdateBase(permissionGroupMapObject);
return(success);
}
/// <summary>
/// Retrieves PermissionGroupMap object from SqlCommand, after database query
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <returns>PermissionGroupMap object</returns>
private PermissionGroupMap GetObject(SqlCommand cmd)
{
SqlDataReader reader;
long rows = SelectRecords(cmd, out reader);
using (reader)
{
if (reader.Read())
{
PermissionGroupMap permissionGroupMapObject = new PermissionGroupMap();
FillObject(permissionGroupMapObject, reader);
return(permissionGroupMapObject);
}
else
{
return(null);
}
}
}
/// <summary>
/// Update base of PermissionGroupMap Object.
/// Data manipulation processing for: new, deleted, updated PermissionGroupMap
/// </summary>
/// <param name="permissionGroupMapObject"></param>
/// <returns></returns>
public bool UpdateBase(PermissionGroupMap permissionGroupMapObject)
{
// use of switch for different types of DML
switch (permissionGroupMapObject.RowState)
{
// insert new rows
case BaseBusinessEntity.RowStateEnum.NewRow:
return(Insert(permissionGroupMapObject));
// delete rows
case BaseBusinessEntity.RowStateEnum.DeletedRow:
return(Delete(permissionGroupMapObject.Id));
}
// update rows
using (PermissionGroupMapDataAccess data = new PermissionGroupMapDataAccess(ClientContext))
{
return(data.Update(permissionGroupMapObject) > 0);
}
}
/// <summary>
/// Insert new permissionGroupMap.
/// data manipulation for insertion of PermissionGroupMap
/// </summary>
/// <param name="permissionGroupMapObject"></param>
/// <returns></returns>
private bool Insert(PermissionGroupMap permissionGroupMapObject)
{
// new permissionGroupMap
using (PermissionGroupMapDataAccess data = new PermissionGroupMapDataAccess(ClientContext))
{
// insert to permissionGroupMapObject
Int32 _Id = data.Insert(permissionGroupMapObject);
// if successful, process
if (_Id > 0)
{
permissionGroupMapObject.Id = _Id;
return(true);
}
else
{
return(false);
}
}
}
public JsonResult SavedChacked(int permissionId, int UserId)
{
bool result = false;
PermissionGroupMap permissionGroupMap = _Util.Facade.permissionFacade.GetAllPermissionGroupMap().Where(x => x.PermissionId == permissionId && x.PermissionGroupId == UserId).FirstOrDefault();
if (permissionGroupMap == null)
{
PermissionGroupMap pm = new PermissionGroupMap();
pm.PermissionGroupId = UserId;
pm.PermissionId = permissionId;
pm.IsActive = true;
_Util.Facade.permissionFacade.InsertPermissionGroupMap(pm);
result = true;
}
else
{
_Util.Facade.permissionFacade.DeletePermissionGroupMap(permissionGroupMap.Id);
}
return(Json(result));
}
public bool InsertPermissionGroupMap(PermissionGroupMap permissionGroupMap)
{
return(_PermissionGroupMapDataAccess.Insert(permissionGroupMap) > 0);
}
/// <summary>
/// Fill External Childs of PermissionGroupMap Object.
/// </summary>
/// <param name="permissionGroupMapObject"></param>
/// <returns></returns>
public void FillChilds(PermissionGroupMap permissionGroupMapObject)
{
///Fill external information of Childs of PermissionGroupMapObject
}
