/// <summary>
/// Shows how to get a specific number of sorted records, starting from an index, based on Search Parameters. The number of records are also retrieved.
/// </summary>
private void SelectSkipAndTakeDynamicWhere()
{
int startRetrievalFromRecordIndex = 0;
int numberOfRecordsToRetrieve = 10;
string sortBy = "StepId";
//string sortBy = "StepId desc";
// search parameters, everything is nullable, only items being searched for should be filled
// note: fields with String type uses a LIKE search, everything else uses an exact match
// also, every field you're searching for uses the AND operator
// e.g. int? productID = 1; string productName = "ch";
// will translate to: SELECT....WHERE productID = 1 AND productName LIKE '%ch%'
int? stepId = null;
int? worKflowId = null;
string approvalLevel = null;
string description = null;
string autoApprove = null;
int? waitTime = null;
string createdBy = null;
DateTime?createdOn = null;
string updatedBy = null;
DateTime?updatedOn = null;
// 1. select a specific number of sorted records starting from the index you specify based on Search Parameters
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTakeDynamicWhere(stepId, worKflowId, approvalLevel, description, autoApprove, waitTime, createdBy, createdOn, updatedBy, updatedOn, numberOfRecordsToRetrieve, startRetrievalFromRecordIndex, sortBy);
// to use objWorkflowStepsMasterCol please see the SelectAll() method examples
// No need for Examples 1 and 2 because the Collection here is already sorted
// Example 3: directly bind to a GridView - for ASP.NET Web Forms
// Example 4: loop through all the WorkflowStepsMaster(s). The example above will only loop for 10 items.
}
/// <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 stepIdSample = 12;
// select a record by primary key(s)
WorkflowStepsMaster objWorkflowStepsMaster = WorkflowStepsMaster.SelectByPrimaryKey(stepIdSample);
if (objWorkflowStepsMaster != null)
{
// if record is found, a record is returned
int stepId = objWorkflowStepsMaster.StepId;
int? worKflowId = objWorkflowStepsMaster.WorKflowId;
string approvalLevel = objWorkflowStepsMaster.ApprovalLevel;
string description = objWorkflowStepsMaster.Description;
string autoApprove = objWorkflowStepsMaster.AutoApprove;
int? waitTime = objWorkflowStepsMaster.WaitTime;
string createdBy = objWorkflowStepsMaster.CreatedBy;
DateTime createdOn = objWorkflowStepsMaster.CreatedOn;
string updatedBy = objWorkflowStepsMaster.UpdatedBy;
DateTime updatedOn = objWorkflowStepsMaster.UpdatedOn;
// get the WorkflowMaster related to WorKflowId.
if (objWorkflowStepsMaster.WorKflowId != null)
{
WorkflowMaster objWorkflowMasterRelatedToWorKflowId = objWorkflowStepsMaster.WorKflowIdNavigation;
}
}
}
/// <summary>
/// The example below shows how to Select the StepId and ApprovalLevel columns for use with a with a Drop Down List, Combo Box, Checked Box List, List View, List Box, etc
/// </summary>
private void SelectWorkflowStepsMasterDropDownListData()
{
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectWorkflowStepsMasterDropDownListData();
// Example 1: directly bind to a drop down list - for ASP.NET Web Forms
// DropDownList ddl1 = new DropDownList();
// ddl1.DataValueField = "StepId";
// ddl1.DataTextField = "ApprovalLevel";
// ddl1.DataSource = objWorkflowStepsMasterCol;
// ddl1.DataBind();
// Example 2: add each item through a loop - for ASP.NET Web Forms
// DropDownList ddl2 = new DropDownList();
// foreach (WorkflowStepsMaster objWorkflowStepsMaster in objWorkflowStepsMasterCol)
// {
// ddl2.Items.Add(new ListItem(objWorkflowStepsMaster.ApprovalLevel, objWorkflowStepsMaster.StepId.ToString()));
// }
// Example 3: bind to a combo box. for Windows Forms (WinForms)
// ComboBox cbx1 = new ComboBox();
// foreach (WorkflowStepsMaster objWorkflowStepsMaster in objWorkflowStepsMasterCol)
// {
// cbx1.Items.Add(new ListItem(objWorkflowStepsMaster.ApprovalLevel, objWorkflowStepsMaster.StepId.ToString()));
// }
}
/// <summary>
/// Handler, updates a record.
/// </summary>
public IActionResult OnGetUpdate(int id, string serializedData)
{
WorkflowStepsMaster objWorkflowStepsMaster = JsonConvert.DeserializeObject <WorkflowStepsMaster>(serializedData);
WorkflowStepsMasterFunctions.AddOrEdit(objWorkflowStepsMaster, CrudOperation.Update, true);
return(new JsonResult(true));
}
/// <summary>
/// Handler, deletes a record.
/// </summary>
public IActionResult OnGetRemove(int id)
{
WorkflowStepsMaster WorkflowStepsMaster = WorkflowStepsMaster.SelectByPrimaryKey(id);
WorkflowStepsMaster.Delete(id);
return(new JsonResult(true));
}
public void LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
CourseEnquiry1API.BusinessObject.WorkflowStepsMaster objWorkflowStepsMaster = WorkflowStepsMaster.SelectByPrimaryKey(id);
// assign values to the model
WorkflowStepsMaster objWorkflowStepsMasterTemp = new WorkflowStepsMaster();
objWorkflowStepsMasterTemp.StepId = objWorkflowStepsMaster.StepId;
objWorkflowStepsMasterTemp.WorKflowId = objWorkflowStepsMaster.WorKflowId;
objWorkflowStepsMasterTemp.ApprovalLevel = objWorkflowStepsMaster.ApprovalLevel;
objWorkflowStepsMasterTemp.Description = objWorkflowStepsMaster.Description;
objWorkflowStepsMasterTemp.AutoApprove = objWorkflowStepsMaster.AutoApprove;
objWorkflowStepsMasterTemp.WaitTime = objWorkflowStepsMaster.WaitTime;
if (objWorkflowStepsMaster.WaitTime.HasValue)
{
objWorkflowStepsMasterTemp.WaitTimeHidden = objWorkflowStepsMaster.WaitTime.Value.ToString();
}
else
{
objWorkflowStepsMasterTemp.WaitTimeHidden = null;
}
objWorkflowStepsMasterTemp.CreatedBy = objWorkflowStepsMaster.CreatedBy;
objWorkflowStepsMasterTemp.CreatedOn = objWorkflowStepsMaster.CreatedOn;
objWorkflowStepsMasterTemp.UpdatedBy = objWorkflowStepsMaster.UpdatedBy;
objWorkflowStepsMasterTemp.UpdatedOn = objWorkflowStepsMaster.UpdatedOn;
// assign values to this page's bound property
WorkflowStepsMaster = objWorkflowStepsMasterTemp;
// assign the return url
ReturnUrl = returnUrl;
}
/// <summary>
/// Shows how to Select all records by WorkflowMaster, related to column WorKflowId sorted by column name in either ascending or descending order.
/// </summary>
private void SelectWorkflowStepsMasterCollectionByWorKflowIdWithSortExpression()
{
int worKflowIdSample = 12;
string sortBy = "StepId"; // ascending order
//string sortBy = "StepId desc"; // descending order
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectWorkflowStepsMasterCollectionByWorKflowId(worKflowIdSample, sortBy);
}
/// <summary>
/// Shows how to Select all records sorted by column name in either ascending or descending order.
/// </summary>
private void SelectAllWithSortExpression()
{
// select all records sorted by StepId in ascending order
string sortBy = "StepId"; // ascending order
//string sortBy = "StepId desc"; // descending order
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectAll(sortBy);
}
/// <summary>
/// Used when adding or updating a record.
/// </summary>
internal static void AddOrEdit(WorkflowStepsMaster model, CrudOperation operation, bool isForListInline = false)
{
WorkflowStepsMaster objWorkflowStepsMaster;
WorkflowStepsMaster objWorkflowStepsMasterOld = new WorkflowStepsMaster();
decimal id = 0;
if (operation == CrudOperation.Add)
{
objWorkflowStepsMaster = new WorkflowStepsMaster();
}
else
{
objWorkflowStepsMaster = WorkflowStepsMaster.SelectByPrimaryKey(model.StepId);
objWorkflowStepsMasterOld = objWorkflowStepsMaster.ShallowCopy();
}
objWorkflowStepsMaster.StepId = model.StepId;
objWorkflowStepsMaster.WorKflowId = model.WorKflowId;
objWorkflowStepsMaster.ApprovalLevel = model.ApprovalLevel;
objWorkflowStepsMaster.Description = model.Description;
objWorkflowStepsMaster.AutoApprove = model.AutoApprove;
objWorkflowStepsMaster.CreatedBy = model.CreatedBy;
objWorkflowStepsMaster.CreatedOn = model.CreatedOn;
objWorkflowStepsMaster.UpdatedBy = model.UpdatedBy;
objWorkflowStepsMaster.UpdatedOn = model.UpdatedOn;
if (isForListInline)
{
objWorkflowStepsMaster.WaitTime = model.WaitTime;
}
else
{
if (!String.IsNullOrEmpty(model.WaitTimeHidden))
{
objWorkflowStepsMaster.WaitTime = Convert.ToInt32(model.WaitTimeHidden);
}
else
{
objWorkflowStepsMaster.WaitTime = null;
}
}
if (operation == CrudOperation.Add)
{
id = objWorkflowStepsMaster.Insert();
}
else
{
objWorkflowStepsMaster.Update();
}
}
/// <summary>
/// Shows how to get a specific number of sorted records, starting from an index. The total number of records are also retrieved when using the SelectSkipAndTake() method.
/// For example, if there are 200 records take only 10 records (numberOfRecordsToRetrieve), starting from the first index (startRetrievalFromRecordIndex = 0)
/// The example below uses some variables, here are their definitions:
/// totalRecordCount - total number of records if you were to retrieve everything
/// startRetrievalFromRecordIndex - the index to start taking records from. Zero (0) E.g. If you want to skip the first 20 records, then assign 19 here.
/// numberOfRecordsToRetrieve - take n records starting from the startRetrievalFromRecordIndex
/// sortBy - to sort in Ascending order by Field Name, just assign just the Field Name, do not pass 'asc'
/// sortBy - to sort in Descending order by Field Name, use the Field Name, a space and the word 'desc'
/// </summary>
private void SelectSkipAndTake()
{
int startRetrievalFromRecordIndex = 0;
int numberOfRecordsToRetrieve = 10;
string sortBy = "StepId";
//string sortBy = "StepId desc";
// 1. select a specific number of sorted records starting from the index you specify
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTake(numberOfRecordsToRetrieve, startRetrievalFromRecordIndex, sortBy);
// to use objWorkflowStepsMasterCol please see the SelectAll() method examples
// No need for Examples 1 and 2 because the Collection here is already sorted
// Example 2: directly bind to a GridView - for ASP.NET Web Forms
// Example 3: loop through all the WorkflowStepsMaster(s). The example above will only loop for 10 items.
}
public PageResult LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
StudentEnquiryAPI.BusinessObject.WorkflowStepsMaster objWorkflowStepsMaster = WorkflowStepsMaster.SelectByPrimaryKey(id);
// assign values to the model
WorkflowStepsMaster objWorkflowStepsMasterTemp = new WorkflowStepsMaster();
objWorkflowStepsMasterTemp.StepId = objWorkflowStepsMaster.StepId;
objWorkflowStepsMasterTemp.WorKflowId = objWorkflowStepsMaster.WorKflowId;
objWorkflowStepsMasterTemp.ApprovalLevel = objWorkflowStepsMaster.ApprovalLevel;
objWorkflowStepsMasterTemp.Description = objWorkflowStepsMaster.Description;
objWorkflowStepsMasterTemp.AutoApprove = objWorkflowStepsMaster.AutoApprove;
objWorkflowStepsMasterTemp.WaitTime = objWorkflowStepsMaster.WaitTime;
if (objWorkflowStepsMaster.WaitTime.HasValue)
{
objWorkflowStepsMasterTemp.WaitTimeHidden = objWorkflowStepsMaster.WaitTime.Value.ToString();
}
else
{
objWorkflowStepsMasterTemp.WaitTimeHidden = null;
}
objWorkflowStepsMasterTemp.CreatedBy = objWorkflowStepsMaster.CreatedBy;
objWorkflowStepsMasterTemp.CreatedOn = objWorkflowStepsMaster.CreatedOn;
objWorkflowStepsMasterTemp.UpdatedBy = objWorkflowStepsMaster.UpdatedBy;
objWorkflowStepsMasterTemp.UpdatedOn = objWorkflowStepsMaster.UpdatedOn;
// create the model used by the partial page
AddEditWorkflowStepsMasterPartialModel model = new AddEditWorkflowStepsMasterPartialModel();
model.WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
model.Operation = CrudOperation.Update;
model.ReturnUrl = returnUrl;
model.WorkflowStepsMaster = objWorkflowStepsMasterTemp;
// assign values to the model used by this page
PartialModel = model;
// assign the return url
ReturnUrl = returnUrl;
return(Page());
}
/// <summary>
/// Gets the list of data for use by the jqgrid plug-in
/// </summary>
public IActionResult OnGetGridDataGroupedByWorKflowId(string sidx, string sord, int _page, int rows)
{
// using a groupField in the jqgrid passes that field
// along with the field to sort, remove the groupField
string groupBy = "WorkflowName asc, ";
sidx = sidx.Replace(groupBy, "");
int totalRecords = WorkflowStepsMaster.GetRecordCount();
int startRowIndex = ((_page * rows) - rows);
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord);
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (objWorkflowStepsMasterCol is null)
{
return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }"));
}
var jsonData = new
{
total = totalPages,
_page,
records = totalRecords,
rows = (
from objWorkflowStepsMaster in objWorkflowStepsMasterCol
select new
{
id = objWorkflowStepsMaster.StepId,
cell = new string[] {
objWorkflowStepsMaster.StepId.ToString(),
objWorkflowStepsMaster.WorKflowId.HasValue ? objWorkflowStepsMaster.WorKflowId.Value.ToString() : "",
objWorkflowStepsMaster.ApprovalLevel,
objWorkflowStepsMaster.Description,
objWorkflowStepsMaster.AutoApprove,
objWorkflowStepsMaster.WaitTime.HasValue ? objWorkflowStepsMaster.WaitTime.Value.ToString() : "",
objWorkflowStepsMaster.CreatedBy,
objWorkflowStepsMaster.CreatedOn.ToString("d"),
objWorkflowStepsMaster.UpdatedBy,
objWorkflowStepsMaster.UpdatedOn.ToString("d"),
objWorkflowStepsMaster.WorKflowId is null ? "" : objWorkflowStepsMaster.WorKflowIdNavigation.WorkflowName
}
}).ToArray()
/// <summary>
/// Shows how to get all records based on Search Parameters.
/// </summary>
private void SelectAllDynamicWhere()
{
// search parameters, everything is nullable, only items being searched for should be filled
// note: fields with String type uses a LIKE search, everything else uses an exact match
// also, every field you're searching for uses the AND operator
// e.g. int? productID = 1; string productName = "ch";
// will translate to: SELECT....WHERE productID = 1 AND productName LIKE '%ch%'
int? stepId = null;
int? worKflowId = null;
string approvalLevel = null;
string description = null;
string autoApprove = null;
int? waitTime = null;
string createdBy = null;
DateTime?createdOn = null;
string updatedBy = null;
DateTime?updatedOn = null;
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectAllDynamicWhere(stepId, worKflowId, approvalLevel, description, autoApprove, waitTime, createdBy, createdOn, updatedBy, updatedOn);
}
/// <summary>
/// Shows how to Insert or Create a New Record
/// </summary>
private void Insert()
{
// first instantiate a new WorkflowStepsMaster
WorkflowStepsMaster objWorkflowStepsMaster = new WorkflowStepsMaster();
// assign values you want inserted
objWorkflowStepsMaster.WorKflowId = 12;
objWorkflowStepsMaster.ApprovalLevel = "abc";
objWorkflowStepsMaster.Description = "abc";
objWorkflowStepsMaster.AutoApprove = "abc";
objWorkflowStepsMaster.WaitTime = 12;
objWorkflowStepsMaster.CreatedBy = "abc";
objWorkflowStepsMaster.CreatedOn = DateTime.Now;
objWorkflowStepsMaster.UpdatedBy = "abc";
objWorkflowStepsMaster.UpdatedOn = DateTime.Now;
// finally, insert a new record
// the insert method returns the newly created primary key
int newlyCreatedPrimaryKey = objWorkflowStepsMaster.Insert();
}
/// <summary>
/// Gets the list of data for use by the jqgrid plug-in
/// </summary>
public IActionResult OnGetGridData(string sidx, string sord, int _page, int rows, bool isforJqGrid = true)
{
int totalRecords = WorkflowStepsMaster.GetRecordCount();
int startRowIndex = ((_page * rows) - rows);
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord);
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (objWorkflowStepsMasterCol is null)
{
return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }"));
}
var jsonData = new
{
total = totalPages,
_page,
records = totalRecords,
rows = (
from objWorkflowStepsMaster in objWorkflowStepsMasterCol
select new
{
id = objWorkflowStepsMaster.StepId,
cell = new string[] {
objWorkflowStepsMaster.StepId.ToString(),
objWorkflowStepsMaster.WorKflowId.HasValue ? objWorkflowStepsMaster.WorKflowId.Value.ToString() : "",
objWorkflowStepsMaster.ApprovalLevel,
objWorkflowStepsMaster.Description,
objWorkflowStepsMaster.AutoApprove,
objWorkflowStepsMaster.WaitTime.HasValue ? objWorkflowStepsMaster.WaitTime.Value.ToString() : "",
objWorkflowStepsMaster.CreatedBy,
objWorkflowStepsMaster.CreatedOn.ToString("d"),
objWorkflowStepsMaster.UpdatedBy,
objWorkflowStepsMaster.UpdatedOn.ToString("d")
}
}).ToArray()
};
return(new JsonResult(jsonData));
}
/// <summary>
/// Shows how to Select all records by WorkflowMaster, related to column WorKflowId
/// </summary>
private void SelectWorkflowStepsMasterCollectionByWorKflowId()
{
int worKflowIdSample = 12;
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectWorkflowStepsMasterCollectionByWorKflowId(worKflowIdSample);
// Example 1: you can optionally sort the collection in ascending order by your chosen field
objWorkflowStepsMasterCol.Sort(WorkflowStepsMaster.ByWorKflowId);
// Example 2: to sort in descending order, add this line to the Sort code in Example 1
objWorkflowStepsMasterCol.Reverse();
// Example 3: directly bind to a GridView - for ASP.NET Web Forms
// GridView grid = new GridView();
// grid.DataSource = objWorkflowStepsMasterCol;
// grid.DataBind();
// Example 4: loop through all the WorkflowStepsMaster(s)
foreach (WorkflowStepsMaster objWorkflowStepsMaster in objWorkflowStepsMasterCol)
{
int stepId = objWorkflowStepsMaster.StepId;
int? worKflowId = objWorkflowStepsMaster.WorKflowId;
string approvalLevel = objWorkflowStepsMaster.ApprovalLevel;
string description = objWorkflowStepsMaster.Description;
string autoApprove = objWorkflowStepsMaster.AutoApprove;
int? waitTime = objWorkflowStepsMaster.WaitTime;
string createdBy = objWorkflowStepsMaster.CreatedBy;
DateTime createdOn = objWorkflowStepsMaster.CreatedOn;
string updatedBy = objWorkflowStepsMaster.UpdatedBy;
DateTime updatedOn = objWorkflowStepsMaster.UpdatedOn;
// get the WorkflowMaster related to WorKflowId.
if (objWorkflowStepsMaster.WorKflowId != null)
{
WorkflowMaster objWorkflowMasterRelatedToWorKflowId = objWorkflowStepsMaster.WorKflowIdNavigation;
}
}
}
/// <summary>
/// Shows how to Update an existing record by Primary Key
/// </summary>
private void Update()
{
// first instantiate a new WorkflowStepsMaster
WorkflowStepsMaster objWorkflowStepsMaster = new WorkflowStepsMaster();
// assign the existing primary key(s)
// of the record you want updated
objWorkflowStepsMaster.StepId = 12;
// assign values you want updated
objWorkflowStepsMaster.WorKflowId = 12;
objWorkflowStepsMaster.ApprovalLevel = "abc";
objWorkflowStepsMaster.Description = "abc";
objWorkflowStepsMaster.AutoApprove = "abc";
objWorkflowStepsMaster.WaitTime = 12;
objWorkflowStepsMaster.CreatedBy = "abc";
objWorkflowStepsMaster.CreatedOn = DateTime.Now;
objWorkflowStepsMaster.UpdatedBy = "abc";
objWorkflowStepsMaster.UpdatedOn = DateTime.Now;
// finally, update an existing record
objWorkflowStepsMaster.Update();
}
public void GetData(string sidx, string sord, int?_page)
{
int rows = Functions.GetGridNumberOfRows();
int numberOfPagesToShow = Functions.GetGridNumberOfPagesToShow();
int currentPage = _page is null ? 1 : Convert.ToInt32(_page);
int startRowIndex = ((currentPage * rows) - rows);
int totalRecords = WorkflowStepsMaster.GetRecordCount();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord);
// fields and titles
string[,] fieldNames = new string[, ] {
{ "StepId", "Step Id" },
{ "WorKflowId", "Wor Kflow Id" },
{ "ApprovalLevel", "Approval Level" },
{ "Description", "Description" },
{ "AutoApprove", "Auto Approve" },
{ "WaitTime", "Wait Time" },
{ "CreatedBy", "Created By" },
{ "CreatedOn", "Created On" },
{ "UpdatedBy", "Updated By" },
{ "UpdatedOn", "Updated On" }
};
// assign properties
WorkflowStepsMasterData = objWorkflowStepsMasterCol;
WorkflowStepsMasterFieldNames = fieldNames;
TotalPages = totalPages;
CurrentPage = currentPage;
FieldToSort = String.IsNullOrEmpty(sidx) ? "StepId" : sidx;
FieldSortOrder = String.IsNullOrEmpty(sord) ? "asc" : sord;
FieldToSortWithOrder = String.IsNullOrEmpty(sidx) ? "StepId" : (sidx + " " + sord).Trim();
NumberOfPagesToShow = numberOfPagesToShow;
StartPage = Functions.GetPagerStartPage(currentPage, numberOfPagesToShow, totalPages);
EndPage = Functions.GetPagerEndPage(StartPage, currentPage, numberOfPagesToShow, totalPages);
}
/// <summary>
/// Shows how to get the total number of records
/// </summary>
private void GetRecordCount()
{
// get the total number of records in the WorkflowStepsMaster table
int totalRecordCount = WorkflowStepsMaster.GetRecordCount();
}
/// <summary>
/// Gets the list of data for use by the jqgrid plug-in
/// </summary>
public IActionResult OnGetGridDataWithFilters(string sidx, string sord, int _page, int rows, string filters)
{
int? stepId = null;
int? worKflowId = null;
string approvalLevel = String.Empty;
string description = String.Empty;
string autoApprove = String.Empty;
int? waitTime = null;
string createdBy = String.Empty;
DateTime?createdOn = null;
string updatedBy = String.Empty;
DateTime?updatedOn = null;
if (!String.IsNullOrEmpty(filters))
{
// deserialize json and get values being searched
var jsonResult = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(filters);
foreach (var rule in jsonResult["rules"])
{
if (rule["field"].Value.ToLower() == "stepid")
{
stepId = Convert.ToInt32(rule["data"].Value);
}
if (rule["field"].Value.ToLower() == "workflowid")
{
worKflowId = Convert.ToInt32(rule["data"].Value);
}
if (rule["field"].Value.ToLower() == "approvallevel")
{
approvalLevel = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "description")
{
description = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "autoapprove")
{
autoApprove = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "waittime")
{
waitTime = Convert.ToInt32(rule["data"].Value);
}
if (rule["field"].Value.ToLower() == "createdby")
{
createdBy = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "createdon")
{
createdOn = Convert.ToDateTime(rule["data"].Value);
}
if (rule["field"].Value.ToLower() == "updatedby")
{
updatedBy = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "updatedon")
{
updatedOn = Convert.ToDateTime(rule["data"].Value);
}
}
// sometimes jqgrid assigns a -1 to numeric fields when no value is assigned
// instead of assigning a null, we'll correct this here
if (stepId == -1)
{
stepId = null;
}
if (worKflowId == -1)
{
worKflowId = null;
}
if (waitTime == -1)
{
waitTime = null;
}
}
int totalRecords = WorkflowStepsMaster.GetRecordCountDynamicWhere(stepId, worKflowId, approvalLevel, description, autoApprove, waitTime, createdBy, createdOn, updatedBy, updatedOn);
int startRowIndex = ((_page * rows) - rows);
List <WorkflowStepsMaster> objWorkflowStepsMasterCol = WorkflowStepsMaster.SelectSkipAndTakeDynamicWhere(stepId, worKflowId, approvalLevel, description, autoApprove, waitTime, createdBy, createdOn, updatedBy, updatedOn, rows, startRowIndex, sidx + " " + sord);
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (objWorkflowStepsMasterCol is null)
{
return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }"));
}
var jsonData = new
{
total = totalPages,
_page,
records = totalRecords,
rows = (
from objWorkflowStepsMaster in objWorkflowStepsMasterCol
select new
{
id = objWorkflowStepsMaster.StepId,
cell = new string[] {
objWorkflowStepsMaster.StepId.ToString(),
objWorkflowStepsMaster.WorKflowId.HasValue ? objWorkflowStepsMaster.WorKflowId.Value.ToString() : "",
objWorkflowStepsMaster.ApprovalLevel,
objWorkflowStepsMaster.Description,
objWorkflowStepsMaster.AutoApprove,
objWorkflowStepsMaster.WaitTime.HasValue ? objWorkflowStepsMaster.WaitTime.Value.ToString() : "",
objWorkflowStepsMaster.CreatedBy,
objWorkflowStepsMaster.CreatedOn.ToString("d"),
objWorkflowStepsMaster.UpdatedBy,
objWorkflowStepsMaster.UpdatedOn.ToString("d")
}
}).ToArray()
};
return(new JsonResult(jsonData));
}
/// <summary>
/// Inserts a record
/// </summary>
public int Insert()
{
WorkflowStepsMaster objWorkflowStepsMaster = (WorkflowStepsMaster)this;
return(WorkflowStepsMasterDataLayer.Insert(objWorkflowStepsMaster));
}
/// <summary>
/// Updates a record
/// </summary>
public void Update()
{
WorkflowStepsMaster objWorkflowStepsMaster = (WorkflowStepsMaster)this;
WorkflowStepsMasterDataLayer.Update(objWorkflowStepsMaster);
}
/// <summary>
/// Shows how to get the total number of records by WorKflowId
/// </summary>
private void GetRecordCountByWorKflowId()
{
// get the total number of records in the WorkflowStepsMaster table by WorKflowId
// 12 here is just a sample WorKflowId change the value as you see fit
int totalRecordCount = WorkflowStepsMaster.GetRecordCountByWorKflowId(12);
}
/// <summary>
/// Shows how to Delete an existing record by Primary Key
/// </summary>
private void Delete()
{
// delete a record by primary key
WorkflowStepsMaster.Delete(12);
}
