/// <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(); }