public void deletePermissionCatalog(int id)
{
DBHelper._PermissionCatalog dbhelp = new DBHelper._PermissionCatalog();
PermissionCatalog existingPermissionCatalog = dbhelp.GetByid(id);
dbhelp.Delete(existingPermissionCatalog);
}
public void addPermissionCatalog(Add permissionCatalog)
{
DBHelper._PermissionCatalog dbhelp = new DBHelper._PermissionCatalog();
var newPermissionCatalog = new PermissionCatalog()
{
Name = permissionCatalog.Name,
Description = permissionCatalog.Description,
PermissionId = permissionCatalog.PermissionId
};
dbhelp.Add(newPermissionCatalog);
}
public void Create(Format_Create parseModel)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
PermissionCatalog newData = new PermissionCatalog();
newData.Name = parseModel.Name;
newData.Description = parseModel.Description ?? "";
newData.Code = parseModel.Code;
dbEntity.PermissionCatalog.Add(newData);
dbEntity.SaveChanges();
}
}
public Detail getPermissionCatalogById(int id)
{
DBHelper._PermissionCatalog dbhelp = new DBHelper._PermissionCatalog();
PermissionCatalog permissionCatalog = dbhelp.GetByid(id);
return(new Detail()
{
Id = permissionCatalog.Id,
Name = permissionCatalog.Name,
Description = permissionCatalog.Description,
PermissionId = permissionCatalog.PermissionId,
DeleteFlag = permissionCatalog.DeletedFlag
});
}
public void updatePermissionCatalog(int id, Update permissionCatalog)
{
DBHelper._PermissionCatalog dbhelp = new DBHelper._PermissionCatalog();
PermissionCatalog existingPermissionCatalog = dbhelp.GetByid(id);
existingPermissionCatalog.Name = permissionCatalog.Name;
existingPermissionCatalog.Description = permissionCatalog.Description;
existingPermissionCatalog.PermissionId = permissionCatalog.PermissionId;
if (permissionCatalog.DeletedFlag.HasValue)
{
existingPermissionCatalog.DeletedFlag = (bool)permissionCatalog.DeletedFlag;
}
dbhelp.Update(existingPermissionCatalog);
}
public Format_Detail GetByCode(int code)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
PermissionCatalog existingData = dbEntity.PermissionCatalog.Find(code);
if (existingData == null)
{
throw new CDSException(11701);
}
return(new Format_Detail()
{
Name = existingData.Name,
Description = existingData.Description,
Code = existingData.Code
});
}
}
public void DeleteByCode(int code)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
var L2Enty = from c in dbEntity.PermissionCatalog
where c.Code == code
select c;
PermissionCatalog existingData = L2Enty.First();
if (existingData == null)
{
throw new CDSException(11701);
}
dbEntity.PermissionCatalog.Attach(existingData);
dbEntity.PermissionCatalog.Remove(existingData);
dbEntity.SaveChanges();
}
}