public static CommentHistory CommentHistory(int? counter)
{
var rtValue = new CommentHistory();
rtValue.AccessUserId = "AccessUserId" + counter.Extra();
rtValue.Comment = "Comment" + counter.Extra();
rtValue.CreatedBy = "CreatedBy" + counter.Extra();
rtValue.CreatedByUserId = "CreatedByUserId" + counter.Extra();
rtValue.DateCreated = DateTime.UtcNow.ToPacificTime();
rtValue.OrderId = counter.HasValue ? counter.Value : 99;
rtValue.RequestNumber = "RequestNumber" + counter.Extra();
return rtValue;
}
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 Opr CreateReport(DataQualityReport dqr, TotalInsuredReport tir, SubscribeDataEntryReport sder, CommentHistory ch, string createdBy)
{
var now = DateTime.Now;
var report = new Opr
{
DataQualityReport = dqr ?? new DataQualityReport(),
TotalInsuredReport = tir ?? new TotalInsuredReport(),
SubscribeDataEntryReport = sder ?? new SubscribeDataEntryReport(),
CommentHistory = ch ?? new CommentHistory(),
CreatedBy = createdBy,
ModifiedBy = createdBy,
CreatedOn = now,
ModifiedOn = now
};
Opr.Add(report);
SaveChanges();
return(report);
}
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"));
}
