/// <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? workflowId = null;
string workflowName = null;
int? levelOfApprovals = null;
string createdBy = null;
DateTime?createdOn = null;
string updatedby = null;
DateTime?updatedon = null;
List <WorkflowMaster> objWorkflowMasterCol = WorkflowMaster.SelectAllDynamicWhere(workflowId, workflowName, levelOfApprovals, createdBy, createdOn, updatedby, updatedon);
}
/// <summary>
/// Shows how to Insert or Create a New Record
/// </summary>
private void Insert()
{
// first instantiate a new WorkflowMaster
WorkflowMaster objWorkflowMaster = new WorkflowMaster();
// assign values you want inserted
objWorkflowMaster.WorkflowName = "abc";
objWorkflowMaster.LevelOfApprovals = 4;
objWorkflowMaster.CreatedBy = "abhijit";
objWorkflowMaster.CreatedOn = DateTime.Now;
objWorkflowMaster.Updatedby = "abc";
objWorkflowMaster.Updatedon = DateTime.Now;
// finally, insert a new record
// the insert method returns the newly created primary key
int newlyCreatedPrimaryKey = objWorkflowMaster.Insert();
}
/// <summary>
/// Inserts a record
/// </summary>
internal static int Insert(WorkflowMaster objWorkflowMaster)
{
StudentEnquiryDBContext context = new StudentEnquiryDBContext();
WorkflowMaster entWorkflowMaster = new WorkflowMaster();
entWorkflowMaster.WorkflowName = objWorkflowMaster.WorkflowName;
entWorkflowMaster.LevelOfApprovals = objWorkflowMaster.LevelOfApprovals;
entWorkflowMaster.CreatedBy = objWorkflowMaster.CreatedBy;
entWorkflowMaster.CreatedOn = objWorkflowMaster.CreatedOn;
entWorkflowMaster.Updatedby = objWorkflowMaster.Updatedby;
entWorkflowMaster.Updatedon = objWorkflowMaster.Updatedon;
context.WorkflowMaster.Add(entWorkflowMaster);
context.SaveChanges();
return(entWorkflowMaster.WorkflowId);
}
/// <summary>
/// Updates a record
/// </summary>
internal static void Update(WorkflowMaster objWorkflowMaster)
{
StudentEnquiryDBContext context = new StudentEnquiryDBContext();
WorkflowMaster entWorkflowMaster = context.WorkflowMaster.Where(w => w.WorkflowId == objWorkflowMaster.WorkflowId).FirstOrDefault();
if (entWorkflowMaster != null)
{
entWorkflowMaster.WorkflowName = objWorkflowMaster.WorkflowName;
entWorkflowMaster.LevelOfApprovals = objWorkflowMaster.LevelOfApprovals;
entWorkflowMaster.CreatedBy = objWorkflowMaster.CreatedBy;
entWorkflowMaster.CreatedOn = objWorkflowMaster.CreatedOn;
entWorkflowMaster.Updatedby = objWorkflowMaster.Updatedby;
entWorkflowMaster.Updatedon = objWorkflowMaster.Updatedon;
context.SaveChanges();
}
}
private PageResult LoadPage(string returnUrl)
{
// create the model used by the partial page
AddEditWorkflowStepsMasterPartialModel model = new AddEditWorkflowStepsMasterPartialModel();
model.WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
model.Operation = CrudOperation.Add;
model.ReturnUrl = returnUrl;
// assign values to the model used by this page
PartialModel = model;
// assign the return url
ReturnUrl = returnUrl;
return(Page());
}
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());
}
public async Task <bool> StartWorkflow(WorkflowVM workflowvm, string user)
{
try
{
VMToWorkflowMasterMapper workflowMapper = new VMToWorkflowMasterMapper();
WorkflowMaster request = workflowMapper.MapVMToWorkflowMaster(workflowvm.WorkflowRequest);
RequestBuilder builder = new RequestBuilder(request, _ampRepository, user);
builder.BuildWorkflowMaster();
if (workflowvm.DocumentID != null)
{
WorkflowDocumentBuilder documentBuilder = new WorkflowDocumentBuilder(workflowvm.DocumentID, workflowvm.DocumentDescription, builder.workflow.WorkFlowID, user);
documentBuilder.Build();
_ampRepository.InsertWorkflowDocument(documentBuilder.Document);
}
_ampRepository.InsertWorkFlowMaster(builder.workflow);
_ampRepository.Save();
// need to handle planned end date - the planned end date table row for the project
// is inserted befre workflow task is created. Now the workflow is created
// and being sennt for approval we need to update the newly created row for the project
// in the planned end date table with the workflowTaskID
if (workflowvm.WorkflowRequest.TaskID == Constants.PlannedEndDate)
{
ProjectPlannedEndDate projectPlannedEndToUpdate =
_ampRepository.GetProjectPlannedEndDate(request.ProjectID);
projectPlannedEndToUpdate.WorkTaskID = request.WorkFlowID;
_ampRepository.UpdatePlannedEndDate(projectPlannedEndToUpdate);
_ampRepository.Save();
}
return(true);
}
catch (Exception exception)
{
_errorengine.LogError(workflowvm.WorkflowResponse.ProjectID, exception, user);
return(false);
}
}
/// <summary>
/// Shows how to Update an existing record by Primary Key
/// </summary>
private void Update()
{
// first instantiate a new WorkflowMaster
WorkflowMaster objWorkflowMaster = new WorkflowMaster();
// assign the existing primary key(s)
// of the record you want updated
objWorkflowMaster.WorkflowId = 1;
// assign values you want updated
objWorkflowMaster.WorkflowName = "Issue Tracking";
objWorkflowMaster.LevelOfApprovals = 2;
objWorkflowMaster.CreatedBy = "abhijit";
objWorkflowMaster.CreatedOn = DateTime.Now;
objWorkflowMaster.Updatedby = "abc";
objWorkflowMaster.Updatedon = DateTime.Now;
// finally, update an existing record
objWorkflowMaster.Update();
}
/// <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 workflowIdSample = 1;
// select a record by primary key(s)
WorkflowMaster objWorkflowMaster = WorkflowMaster.SelectByPrimaryKey(workflowIdSample);
if (objWorkflowMaster != null)
{
// if record is found, a record is returned
int workflowId = objWorkflowMaster.WorkflowId;
string workflowName = objWorkflowMaster.WorkflowName;
int? levelOfApprovals = objWorkflowMaster.LevelOfApprovals;
string createdBy = objWorkflowMaster.CreatedBy;
DateTime createdOn = objWorkflowMaster.CreatedOn;
string updatedby = objWorkflowMaster.Updatedby;
DateTime updatedon = objWorkflowMaster.Updatedon;
}
}
public PageResult LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
StudentEnquiryAPI.BusinessObject.WorkflowMaster objWorkflowMaster = WorkflowMaster.SelectByPrimaryKey(id);
// assign values to the model
WorkflowMaster objWorkflowMasterTemp = new WorkflowMaster();
objWorkflowMasterTemp.WorkflowId = objWorkflowMaster.WorkflowId;
objWorkflowMasterTemp.WorkflowName = objWorkflowMaster.WorkflowName;
objWorkflowMasterTemp.LevelOfApprovals = objWorkflowMaster.LevelOfApprovals;
if (objWorkflowMaster.LevelOfApprovals.HasValue)
{
objWorkflowMasterTemp.LevelOfApprovalsHidden = objWorkflowMaster.LevelOfApprovals.Value.ToString();
}
else
{
objWorkflowMasterTemp.LevelOfApprovalsHidden = null;
}
objWorkflowMasterTemp.CreatedBy = objWorkflowMaster.CreatedBy;
objWorkflowMasterTemp.CreatedOn = objWorkflowMaster.CreatedOn;
objWorkflowMasterTemp.Updatedby = objWorkflowMaster.Updatedby;
objWorkflowMasterTemp.Updatedon = objWorkflowMaster.Updatedon;
// create the model used by the partial page
AddEditWorkflowMasterPartialModel model = new AddEditWorkflowMasterPartialModel();
model.Operation = CrudOperation.Update;
model.ReturnUrl = returnUrl;
model.WorkflowMaster = objWorkflowMasterTemp;
// 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 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;
}
}
}
public void ApproveWorkflow(WorkflowVM workflowVm, string userId)
{
try
{
VMToWorkflowMasterMapper workflowMapper = new VMToWorkflowMasterMapper();
WorkflowMaster request = workflowMapper.MapVMToWorkflowMaster(workflowVm.WorkflowRequest);
WorkflowMaster response = workflowMapper.MapVMToWorkflowMaster(workflowVm.WorkflowResponse);
ResponseBuilder responseBuilder = new ResponseBuilder(response, _ampRepository, userId);
RequestModifier requestModifier = new RequestModifier(request);
responseBuilder.BuildApprovalResponse();
requestModifier.Modify();
_ampRepository.InsertWorkFlowMaster(responseBuilder.workflow);
_ampRepository.UpdateWorkFlowMaster(requestModifier.workflow);
_ampRepository.Save();
}
catch (Exception exception)
{
}
}
/// <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 = WorkflowMaster.GetRecordCount();
int startRowIndex = ((_page * rows) - rows);
List <WorkflowMaster> objWorkflowMasterCol = WorkflowMaster.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord);
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (objWorkflowMasterCol is null)
{
return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }"));
}
var jsonData = new
{
total = totalPages,
_page,
records = totalRecords,
rows = (
from objWorkflowMaster in objWorkflowMasterCol
select new
{
id = objWorkflowMaster.WorkflowId,
cell = new string[] {
objWorkflowMaster.WorkflowId.ToString(),
objWorkflowMaster.WorkflowName,
objWorkflowMaster.LevelOfApprovals.HasValue ? objWorkflowMaster.LevelOfApprovals.Value.ToString() : "",
objWorkflowMaster.CreatedBy,
objWorkflowMaster.CreatedOn.ToString("d"),
objWorkflowMaster.Updatedby,
objWorkflowMaster.Updatedon.ToString("d")
}
}).ToArray()
};
return(new JsonResult(jsonData));
}
public void LoadPage(int id, string returnUrl)
{
// select a record by primary key(s)
TemporaryDBappllicationAPI.BusinessObject.WorkflowMaster objWorkflowMaster = WorkflowMaster.SelectByPrimaryKey(id);
// assign values to the model
WorkflowMaster objWorkflowMasterTemp = new WorkflowMaster();
objWorkflowMasterTemp.WorkflowId = objWorkflowMaster.WorkflowId;
objWorkflowMasterTemp.WorkflowName = objWorkflowMaster.WorkflowName;
objWorkflowMasterTemp.LevelOfApprovals = objWorkflowMaster.LevelOfApprovals;
if (objWorkflowMaster.LevelOfApprovals.HasValue)
{
objWorkflowMasterTemp.LevelOfApprovalsHidden = objWorkflowMaster.LevelOfApprovals.Value.ToString();
}
else
{
objWorkflowMasterTemp.LevelOfApprovalsHidden = null;
}
objWorkflowMasterTemp.CreatedBy = objWorkflowMaster.CreatedBy;
objWorkflowMasterTemp.CreatedOn = objWorkflowMaster.CreatedOn;
objWorkflowMasterTemp.Updatedby = objWorkflowMaster.Updatedby;
objWorkflowMasterTemp.Updatedon = objWorkflowMaster.Updatedon;
// assign values to this page's bound property
WorkflowMaster = objWorkflowMasterTemp;
// assign the return url
ReturnUrl = returnUrl;
}
/// <summary>
/// Initial handler the razor page encounters.
/// </summary>
public void OnGet()
{
WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
}
/// <summary>
/// Shows how to get the total number of records
/// </summary>
private void GetRecordCount()
{
// get the total number of records in the WorkflowMaster table
int totalRecordCount = WorkflowMaster.GetRecordCount();
}
/// <summary>
/// Shows how to Delete an existing record by Primary Key
/// </summary>
private void Delete()
{
// delete a record by primary key
WorkflowMaster.Delete(4);
}
public RequestModifier(WorkflowMaster workflowMaster)
{
_workflow = workflowMaster;
}
/// <summary>
/// Sets data needed on page intialization.
/// </summary>
private void SetData()
{
WorkflowStepsMaster = new TemporaryDBappllicationAPI.BusinessObject.WorkflowStepsMaster();
WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
}
/// <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? workflowId = null;
string workflowName = String.Empty;
int? levelOfApprovals = 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() == "workflowid")
{
workflowId = Convert.ToInt32(rule["data"].Value);
}
if (rule["field"].Value.ToLower() == "workflowname")
{
workflowName = rule["data"].Value;
}
if (rule["field"].Value.ToLower() == "levelofapprovals")
{
levelOfApprovals = 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 (workflowId == -1)
{
workflowId = null;
}
if (levelOfApprovals == -1)
{
levelOfApprovals = null;
}
}
int totalRecords = WorkflowMaster.GetRecordCountDynamicWhere(workflowId, workflowName, levelOfApprovals, createdBy, createdOn, updatedby, updatedon);
int startRowIndex = ((_page * rows) - rows);
List <WorkflowMaster> objWorkflowMasterCol = WorkflowMaster.SelectSkipAndTakeDynamicWhere(workflowId, workflowName, levelOfApprovals, createdBy, createdOn, updatedby, updatedon, rows, startRowIndex, sidx + " " + sord);
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (objWorkflowMasterCol is null)
{
return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }"));
}
var jsonData = new
{
total = totalPages,
_page,
records = totalRecords,
rows = (
from objWorkflowMaster in objWorkflowMasterCol
select new
{
id = objWorkflowMaster.WorkflowId,
cell = new string[] {
objWorkflowMaster.WorkflowId.ToString(),
objWorkflowMaster.WorkflowName,
objWorkflowMaster.LevelOfApprovals.HasValue ? objWorkflowMaster.LevelOfApprovals.Value.ToString() : "",
objWorkflowMaster.CreatedBy,
objWorkflowMaster.CreatedOn.ToString("d"),
objWorkflowMaster.Updatedby,
objWorkflowMaster.Updatedon.ToString("d")
}
}).ToArray()
};
return(new JsonResult(jsonData));
}
/// <summary>
/// Updates a record
/// </summary>
public void Update()
{
WorkflowMaster objWorkflowMaster = (WorkflowMaster)this;
WorkflowMasterDataLayer.Update(objWorkflowMaster);
}
/// <summary>
/// Inserts a record
/// </summary>
public int Insert()
{
WorkflowMaster objWorkflowMaster = (WorkflowMaster)this;
return(WorkflowMasterDataLayer.Insert(objWorkflowMaster));
}
/// <summary>
/// Sets data needed on page intialization.
/// </summary>
private void SetData()
{
WorkflowStepsMaster = new fifth_tempDBAPI.BusinessObject.WorkflowStepsMaster();
WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
}
public ResponseBuilder(WorkflowMaster workflowMaster, IAMPRepository ampRepository, string userId)
{
_ampRepository = ampRepository;
_userId = userId;
_workflow = workflowMaster;
}
/// <summary>
/// Sets data needed on page intialization.
/// </summary>
private void SetData()
{
WorkflowStepsMaster = new StudentEnquiryAPI.BusinessObject.WorkflowStepsMaster();
WorkflowMasterDropDownListData = WorkflowMaster.SelectWorkflowMasterDropDownListData();
}
