public IHttpActionResult readRequester(string Jabatan) { try { using (var dc = new PurchaserRequisitionDataContext()) { var javaScriptSerializer = new JavaScriptSerializer(); var user = dc.Companies.Where(o => o.Jabatan == Jabatan).SingleOrDefault(); if (Jabatan != null) { var result = javaScriptSerializer.Serialize(new { User = user }); return(Ok(result)); } else { return(Ok("")); } } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IHttpActionResult> SubmitTaskEdit(AddRequest param) { try { using (var context = new PurchaserRequisitionDataContext()) { var usr = context.Companies.Where(o => o.Email == param.Email).FirstOrDefault(); var token = usr.Token; var bodyCreate = "{" + "\"data\": {" + "\"form_data\": {" + "\"pvAction\" : \"" + param.Action + "\"," + " \"pvEditor\": \"[email protected]\"," + "\"pvReq\" : \"" + param.Email + "\"," + "}," + "\"comment\": \"Edited\"" + "}" + "}"; JObject jsonCreate = JObject.Parse(bodyCreate); var action = string.Empty; using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://mosaic.dev.nextflow.tech/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var response = await client.PostAsJsonAsync("nextflow/api/tasks/" + param.TaskId + "/submit", jsonCreate); var result = await response.Content.ReadAsAsync <dynamic>(); } if (param.Action == "Edit") { var requester = context.RequesterSummaries.Where(o => o.ProcessId == param.ProcessId).FirstOrDefault(); requester.ApproveStatus = param.Action; requester.Comment = param.Comment; context.SubmitChanges(); CommentHistory commentHistory = new CommentHistory(); commentHistory.ProcessId = param.ProcessId; commentHistory.Name = usr.Name; commentHistory.Action = param.Action; commentHistory.Date = DateTime.Now; commentHistory.Comment = "Tolong diedit"; context.CommentHistories.InsertOnSubmit(commentHistory); context.SubmitChanges(); } return(Ok(new { success = true, message = "Request " + action })); } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message })); } }
public IHttpActionResult updateData([FromBody] RequesterSummary req) { try { if (req != null) { using (var dc = new PurchaserRequisitionDataContext()) { var data = dc.RequesterSummaries.FirstOrDefault(o => o.Id == req.Id); { data.Manager = req.Manager; }; dc.SubmitChanges(); return(Ok(data)); } } else { return(Unauthorized()); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult deleteData(int Id) { try { using (var dc = new PurchaserRequisitionDataContext()) { var data = dc.RequesterSummaries.FirstOrDefault(o => o.Id == Id); dc.RequesterSummaries.DeleteOnSubmit(data); dc.SubmitChanges(); return(Ok(data)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult readData([FromBody] Company req) { try { if (req != null) { using (var dc = new PurchaserRequisitionDataContext()) { var user = dc.Companies.Where(o => o.Username == req.Username && o.Password == req.Password).SingleOrDefault(); return(Ok(user)); } } else { return(Unauthorized()); } } catch (Exception) { return(BadRequest("Error")); } }
public ApproverController() { context = new PurchaserRequisitionDataContext(); }
public async Task <IHttpActionResult> GetTaskList(string Email) { using (var context = new PurchaserRequisitionDataContext()) { try { var usr = context.Companies.Where(o => o.Email == Email).FirstOrDefault(); var token = usr.Token; List <TaskListGrid> grids = new List <TaskListGrid>(); using (var client = new HttpClient()) { dynamic response; dynamic parseResult; string uri = "https://mosaic.dev.nextflow.tech/nextflow/api/tasks?folder=app:task:all&page[number]=1&page[size]=10"; client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); response = await client.GetStringAsync(uri); parseResult = JObject.Parse(response); //result = JsonConvert.DeserializeObject<List<dynamic>>(parseResult[0]); foreach (var item in parseResult.data) { TaskListGrid task = new TaskListGrid(); string email = item.created_by.email; task.ProcessId = item.process_id; task.TaskId = item.id; var dd = context.RequesterSummaries.Where(o => o.ProcessId == task.ProcessId).FirstOrDefault(); task.Payroll = dd.Payroll; task.Id = dd.Id; task.RequesterPosition = dd.RequesterPosition; task.AsalCompany = dd.AsalCompany; task.Location = dd.Location; task.Plant = dd.Plant; task.BudgetSource = dd.BudgetSource; task.Currency = dd.Currency; task.Date = dd.Date; task.SinglePanel = dd.SinglePanel; task.ItemText = dd.ItemText; task.Description = dd.Description; task.EstPrice = dd.EstPrice; task.Qty = dd.Qty; task.QtySatuan = dd.QtySatuan; task.MaterialGroup = dd.MaterialGroup; task.Subtotal = dd.Subtotal; task.ApproveStatus = dd.ApproveStatus; task.Manager = dd.Manager; task.Owner = dd.Owner; task.Name = dd.Name; task.Comment = dd.Comment; task.RecordId = dd.RecordId; task.Payroll = dd.Payroll; task.RequesterPosition = dd.RequesterPosition; grids.Add(task); } } return(Ok(new { success = true, data = grids })); } catch (Exception ex) { return(Ok(new { success = false, data = ex.Message })); } } }
public ManagerController() { context = new PurchaserRequisitionDataContext(); }
public LoginController() { context = new PurchaserRequisitionDataContext(); }
public async Task <IHttpActionResult> updateData([FromBody] AddRequest param) { try { using (var context = new PurchaserRequisitionDataContext()) { var usr = context.Companies.Where(o => o.Email == param.Email).FirstOrDefault(); var token = usr.Token; var bodyCreate = "{" + "\"data\": {" + "\"form_data\": {" + "\"pvAction\" : \"" + param.Action + "\"," + " \"pvApprover\": \"[email protected]\"," + " \"pvReq\": \"" + param.Email + "\"" + "}," + "\"comment\": \"Tes\"" + "}" + "}"; JObject jsonCreate = JObject.Parse(bodyCreate); var action = string.Empty; using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://mosaic.dev.nextflow.tech/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var response = await client.PostAsJsonAsync("nextflow/api/tasks/" + param.TaskId + "/submit", jsonCreate); var result = await response.Content.ReadAsAsync <dynamic>(); } if (param.Action == "Edit") { var requester = context.RequesterSummaries.Where(o => o.ProcessId == param.ProcessId).FirstOrDefault(); requester.ApproveStatus = null; requester.Name = param.Name; requester.Email = param.Email; requester.Payroll = param.Payroll; requester.RequesterPosition = param.RequesterPosition; requester.AsalCompany = param.AsalCompany; requester.Location = param.Location; requester.Plant = param.Plant; requester.BudgetSource = param.BudgetSource; requester.Currency = param.Currency; requester.Date = param.Date; requester.SinglePanel = param.SinglePanel; requester.ItemText = param.ItemText; requester.MaterialGroup = param.MaterialGroup; requester.Description = param.Description; requester.Qty = param.Qty; requester.QtySatuan = param.QtySatuan; requester.EstPrice = param.EstPrice; requester.Subtotal = param.Qty * param.EstPrice; context.SubmitChanges(); CommentHistory commentHistory = new CommentHistory(); commentHistory.ProcessId = param.ProcessId; commentHistory.Name = usr.Name; commentHistory.Action = param.Action; commentHistory.Date = DateTime.Now; commentHistory.Comment = "Sudah diedit"; context.CommentHistories.InsertOnSubmit(commentHistory); context.SubmitChanges(); } return(Ok(new { success = true, message = "Request " + action })); } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message })); } }
public async Task <IHttpActionResult> Create([FromBody] AddRequest req) { var flowId = ConfigurationManager.AppSettings["FlowId"]; CommentHistory comment = new CommentHistory(); RequesterSummary requester = new RequesterSummary(); using (var dc = new PurchaserRequisitionDataContext()) { var data = dc.Companies.FirstOrDefault(o => o.Name == req.Name); string RecordId = string.Empty; string ProcessId = string.Empty; var bodyCreate = "{ " + "\"data\": { " + " \"definition\": { " + " \"id\": \"" + flowId + "\"" + "}" + "}" + "}"; JObject jsonCreate = JObject.Parse(bodyCreate); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://mosaic.dev.nextflow.tech/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", data.Token); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var response = await client.PostAsJsonAsync("nextflow/api/records", jsonCreate); var result = await response.Content.ReadAsAsync <dynamic>(); RecordId = result.data.id; var bodySubmit = "{ " + "\"data\": { " + " \"form_data\": { " + " \"pvInitiator\": \"" + data.Email + "\"," + " \"pvInitiatorName\": \"" + data.Name + "\"," + " \"pvAction\": \"submit\"," + " \"pvReq\": \"" + data.Email + "\"," + " \"pvApprover\": \"[email protected]\"" + "}," + "\"comment\" : \"" + req.comment + "\"" + "}" + "}"; JObject jsonSubmit = JObject.Parse(bodySubmit); var responseSubmit = await client.PostAsJsonAsync("nextflow/api/records/" + RecordId + "/submit", jsonSubmit); var resultSubmit = await responseSubmit.Content.ReadAsAsync <dynamic>(); ProcessId = resultSubmit.data.process_id; } requester.Name = req.Name; requester.Email = req.Email; requester.Payroll = req.Payroll; requester.RequesterPosition = req.RequesterPosition; requester.AsalCompany = req.AsalCompany; requester.Location = req.Location; requester.Plant = req.Plant; requester.BudgetSource = req.BudgetSource; requester.Currency = req.Currency; requester.Date = req.Date; requester.SinglePanel = req.SinglePanel; requester.ItemText = req.ItemText; requester.MaterialGroup = req.MaterialGroup; requester.Description = req.Description; requester.Qty = req.Qty; requester.QtySatuan = req.QtySatuan; requester.EstPrice = req.EstPrice; requester.Subtotal = req.Qty * req.EstPrice; requester.ProcessId = ProcessId; requester.RecordId = RecordId; dc.RequesterSummaries.InsertOnSubmit(requester); dc.SubmitChanges(); comment.Name = req.Name; comment.ProcessId = ProcessId; comment.Action = "Submit"; comment.Date = DateTime.Now; comment.Comment = "Tolong diperiksa dengan saksama"; dc.CommentHistories.InsertOnSubmit(comment); dc.SubmitChanges(); } return(Ok("Success")); }
public RequestController() { context = new PurchaserRequisitionDataContext(); }