/// <summary>
/// Used when adding or updating a record.
/// </summary>
internal static void AddOrEdit(RoleMaster model, CrudOperation operation, bool isForListInline = false)
{
RoleMaster objRoleMaster;
RoleMaster objRoleMasterOld = new RoleMaster();
decimal id = 0;
if (operation == CrudOperation.Add)
{
objRoleMaster = new RoleMaster();
}
else
{
objRoleMaster = RoleMaster.SelectByPrimaryKey(model.RoleId);
objRoleMasterOld = objRoleMaster.ShallowCopy();
}
objRoleMaster.RoleId = model.RoleId;
objRoleMaster.RoleDescription = model.RoleDescription;
objRoleMaster.CreatedOn = model.CreatedOn;
objRoleMaster.CreatedBy = model.CreatedBy;
objRoleMaster.ModifiedOn = model.ModifiedOn;
objRoleMaster.ModifiedBy = model.ModifiedBy;
if (operation == CrudOperation.Add)
{
id = objRoleMaster.Insert();
}
else
{
objRoleMaster.Update();
}
}
/// <summary>
/// Handler, deletes a record.
/// </summary>
public IActionResult OnGetRemove(int id)
{
RoleMaster RoleMaster = RoleMaster.SelectByPrimaryKey(id);
RoleMaster.Delete(id);
return(new JsonResult(true));
}
/// <summary>
/// Shows how to Select a record by Primary Key. It also shows how to retrieve Lazily-loaded related Objects. Related Objects are assigned for each Foreign Key.
/// </summary>
private void SelectByPrimaryKey()
{
int userRoleIdSample = 1;
// select a record by primary key(s)
UserRoles objUserRoles = UserRoles.SelectByPrimaryKey(userRoleIdSample);
if (objUserRoles != null)
{
// if record is found, a record is returned
int userRoleId = objUserRoles.UserRoleId;
int? userId = objUserRoles.UserId;
int? roleId = objUserRoles.RoleId;
bool?status = objUserRoles.Status;
// get the UserMaster related to UserId.
if (objUserRoles.UserId != null)
{
UserMaster objUserMasterRelatedToUserId = UserMaster.SelectByPrimaryKey(userId.Value);
}
// get the RoleMaster related to RoleId.
if (objUserRoles.RoleId != null)
{
RoleMaster objRoleMasterRelatedToRoleId = RoleMaster.SelectByPrimaryKey(roleId.Value);
}
}
}
public void LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
fifth_tempDBAPI.BusinessObject.RoleMaster objRoleMaster = RoleMaster.SelectByPrimaryKey(id);
// assign values to this page's bound property
RoleMaster = objRoleMaster;
// assign the return url
ReturnUrl = returnUrl;
}
/// <summary>
/// Shows how to Select a record by Primary Key. It also shows how to retrieve Lazily-loaded related Objects. Related Objects are assigned for each Foreign Key.
/// </summary>
private void SelectByPrimaryKey()
{
int roleIdSample = 1;
// select a record by primary key(s)
RoleMaster objRoleMaster = RoleMaster.SelectByPrimaryKey(roleIdSample);
if (objRoleMaster != null)
{
// if record is found, a record is returned
int roleId = objRoleMaster.RoleId;
string roleDescription = objRoleMaster.RoleDescription;
DateTime createdOn = objRoleMaster.CreatedOn;
string createdBy = objRoleMaster.CreatedBy;
DateTime?modifiedOn = objRoleMaster.ModifiedOn;
string modifiedBy = objRoleMaster.ModifiedBy;
}
}
public PageResult LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
CourseEnquiryAPI.BusinessObject.RoleMaster objRoleMaster = RoleMaster.SelectByPrimaryKey(id);
// create the model used by the partial page
AddEditRoleMasterPartialModel model = new AddEditRoleMasterPartialModel();
model.Operation = CrudOperation.Update;
model.ReturnUrl = returnUrl;
model.RoleMaster = objRoleMaster;
// assign values to the model used by this page
PartialModel = model;
// assign the return url
ReturnUrl = returnUrl;
return(Page());
}
/// <summary>
/// Shows how to Select all records by RoleMaster, related to column RoleId
/// </summary>
private void SelectUserRolesCollectionByRoleId()
{
int roleIdSample = 1;
List <UserRoles> objUserRolesCol = UserRoles.SelectUserRolesCollectionByRoleId(roleIdSample);
// Example 1: you can optionally sort the collection in ascending order by your chosen field
objUserRolesCol.Sort(UserRoles.ByUserId);
// Example 2: to sort in descending order, add this line to the Sort code in Example 1
objUserRolesCol.Reverse();
// Example 3: directly bind to a GridView - for ASP.NET Web Forms
// GridView grid = new GridView();
// grid.DataSource = objUserRolesCol;
// grid.DataBind();
// Example 4: loop through all the UserRoles(s)
foreach (UserRoles objUserRoles in objUserRolesCol)
{
int userRoleId = objUserRoles.UserRoleId;
int? userId = objUserRoles.UserId;
int? roleId = objUserRoles.RoleId;
bool?status = objUserRoles.Status;
// get the UserMaster related to UserId.
if (objUserRoles.UserId != null)
{
UserMaster objUserMasterRelatedToUserId = UserMaster.SelectByPrimaryKey(userId.Value);
}
// get the RoleMaster related to RoleId.
if (objUserRoles.RoleId != null)
{
RoleMaster objRoleMasterRelatedToRoleId = RoleMaster.SelectByPrimaryKey(roleId.Value);
}
}
}