protected override void ExecuteChild(mmStdSequenceReq dataReq, ResponseAPI dataRes)
{
var res = new List <ASSETKKF_MODEL.Response.Mcis.mmStdSequenceRes>();
var roles = ASSETKKF_ADO.Mssql.Mcis.mmStdSequenceAdo.GetInstant().GetData(dataReq);
foreach (var x in roles)
{
var tmp = new ASSETKKF_MODEL.Response.Mcis.mmStdSequenceRes();
tmp.DrawingCd = x.DrawingCd;
tmp.SeqNo = x.SeqNo;
tmp.WorkStationGrp = x.WorkStationGrp;
tmp.TaskCode = x.TaskCode;
tmp.WorkCenterCode = x.WorkCenterCode;
tmp.MachCode = x.MachCode;
tmp.SetupTime = x.SetupTime;
tmp.NoOfMins = x.NoOfMins;
tmp.ProductionRate = x.ProductionRate;
tmp.UnitCode = x.UnitCode;
tmp.TimeCode = x.TimeCode;
tmp.CycleTime = x.CycleTime;
tmp.LastUpdDt = x.LastUpdDt;
tmp.LastUpdUser = x.LastUpdUser;
tmp.SECM_NO = x.SECM_NO;
tmp.Tm = x.Tm;
tmp.USER_ID = x.USER_ID;
tmp.USER_DATE = x.USER_DATE;
tmp.RoutingDateSt = x.RoutingDateSt;
tmp.RoutingDateEnd = x.RoutingDateEnd;
tmp.NewFlag = x.NewFlag;
res.Add(tmp);
}
dataRes.data = res;
}
protected override void ExecuteChild(rmEmployeeReq dataReq, ResponseAPI dataRes)
{
var res = new List <ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes>();
var roles = ASSETKKF_ADO.Mssql.bsicpers.rmEmployeeAdo.GetInstant().GetData(dataReq);
foreach (var x in roles)
{
var tmp = new ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes();
tmp.EmployeeID = x.EmployeeID;
tmp.EmploType = x.EmploType;
tmp.Status = x.Status;
tmp.Shift = x.Shift;
tmp.Weekend = x.Weekend;
tmp.DepCode = x.DepCode;
tmp.Position = x.Position;
tmp.TitleName = x.TitleName;
tmp.FirstName = x.FirstName;
tmp.LastName = x.LastName;
tmp.StartDate = x.StartDate;
tmp.EmploDate = x.EmploDate;
tmp.EndDate = x.EndDate;
tmp.EditDate = x.EditDate;
res.Add(tmp);
}
dataRes.data = res;
}
public IActionResult Post(string provider, double amount, string currency, string date, string commentary)
{
ResponseAPI response = new ResponseAPI();
Receipt receipt = new Receipt();
receipt.provider = provider;
receipt.amount = amount;
receipt.currency = currency;
receipt.date = Convert.ToDateTime(date);
receipt.commentary = commentary;
try
{
response = _dataRepository.Validate(receipt);
if (response.Code != 0)
{
return(StatusCode(response.Code.GetHashCode(), response.Message));
}
_dataRepository.Add(receipt);
return(StatusCode(HttpStatusCode.Created.GetHashCode(), receipt));
}
catch (Exception)
{
return(StatusCode(500, "Unable to process request"));
}
}
public IActionResult Put(int id, string provider, decimal amount, string currency, string date, string commentary)
{
ResponseAPI response = new ResponseAPI();
try
{
if (_dataRepository.Count(id) <= 0)
{
return(StatusCode(HttpStatusCode.NotFound.GetHashCode(), "Not found"));
}
Receipt newReceipt = new Receipt();
newReceipt.provider = provider;
newReceipt.amount = Convert.ToDouble(amount);
newReceipt.currency = currency;
newReceipt.date = Convert.ToDateTime(date);
newReceipt.commentary = commentary;
response = _dataRepository.Validate(newReceipt);
if (response.Code != 0)
{
return(StatusCode(response.Code.GetHashCode(), response.Message));
}
_dataRepository.Update(_dataRepository.Get(id), newReceipt);
return(Ok(newReceipt));
}
catch (Exception)
{
return(StatusCode(500, "Unable to process request"));
}
}
public async Task <ResponseAPI <brandCategory> > FetchBrandCategory()
{
ResponseAPI <brandCategory> res = new ResponseAPI <brandCategory>();
return(await Task.Run(async() =>
{
try
{
string url = ApiUrl.apiUrl() + "products/fetchbrandcategory";
using (var client = new HttpClient())
{
HttpResponseMessage response = await client.GetAsync(url);
response.EnsureSuccessStatusCode();
var resp = await response.Content.ReadAsStringAsync();
return JsonConvert.DeserializeObject <ResponseAPI <brandCategory> >(resp);
}
}
catch (Exception ex)
{
res = new ResponseAPI <brandCategory>
{
code = 500,
message = ex.Message,
data = null
};
return res;
}
}));
}
public ActionResult <IEnumerable <string> > CloseRoulette(ResponseBetModel objBet)
{
try
{
ResponseAPI <BetModel> response = new ResponseAPI <BetModel>(Parameters.OK_REQUEST, "Success", _BetService.CloseRoulette(objBet));
var Winners = response.lstResponseList.Where(a => a.objResponseBetModel.iIdRoulette == -999).FirstOrDefault();
if (Winners != null)
{
response.strResponseMessage += " No hubo ganadores !!";
}
else
{
response.strResponseMessage += " Los ganadores son !!";
}
return(Ok(
response
));
}
catch (Exception ex)
{
ResponseAPI <BetModel> response = new ResponseAPI <BetModel>(Parameters.INTERNAL_SERVER_ERROR, ex.Message, false);
return(Ok(
response
));
}
}
public async Task <mdlResponsedata> CallAPIStandard(string url)
{
mdlResponsedata data = new mdlResponsedata();
ResponseAPI aPI = new ResponseAPI();
if (ModelState.IsValid)
{
try
{
string tokendata = Request.Headers["Authorization"];
string bodycontent = "";
using (StreamReader reader = new StreamReader(Request.Body, Encoding.UTF8))
{
bodycontent = await reader.ReadToEndAsync();
}
data = await aPI.GetResponse(url, bodycontent, tokendata);
}
catch (Exception ex)
{
data.Code = 1;
data.Message = ex.Message.ToString();
}
}
return(data);
}
protected override void ExecuteChild(RptWorkOrderReq dataReq, ResponseAPI dataRes)
{
var tmp = new ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderHeadRes();
var res = new List <ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderHeadRes>();
try
{
var roles = ASSETKKF_ADO.Mssql.Mcis.Report.RptFollowsWorkOrderAdo.GetInstant().GetHead(dataReq.WorkOrderID);
foreach (var x in roles)
{
tmp = new ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderHeadRes();
tmp.MchProjectID = x.MchProjectID;
tmp.WorkOrderID = x.WorkOrderID;
tmp.WorkOrderDesc = x.WorkOrderDesc;
tmp.DrawingCd = x.DrawingCd;
tmp.MchProjectNm = x.MchProjectNm;
tmp.QTYAmt = x.QTYAmt;
tmp.Cuscod = x.Cuscod;
tmp.WorkOrderStatus = x.WorkOrderStatus;
tmp.JobTypeCd = x.JobTypeCd;
tmp.JobTypeNm = x.JobTypeNm;
tmp.JobPriorityCd = x.JobPriorityCd;
tmp.STATION_GRP = x.STATION_GRP;
tmp.JobPriorityNm = x.JobPriorityNm;
res.Add(tmp);
}
}
catch (Exception)
{
}
dataRes.data = res;
}
protected override void ExecuteChild(RptWorkOrderReq dataReq, ResponseAPI dataRes)
{
List <RptFollowsWorkOrderHeadRes> resHead = new List <RptFollowsWorkOrderHeadRes>();
resHead = ASSETKKF_ADO.Mssql.Mcis.Report.RptFollowsWorkOrderAdo.GetInstant().GetHead(dataReq.WorkOrderID);
List <RptFollowsWorkOrderDetailRes> resDetail = new List <RptFollowsWorkOrderDetailRes>();
resDetail = ASSETKKF_ADO.Mssql.Mcis.Report.RptFollowsWorkOrderAdo.GetInstant().GetDetail(dataReq.WorkOrderID);
List <RptFollowsWorkOrderLastRes> resLast = new List <RptFollowsWorkOrderLastRes>();
resLast = ASSETKKF_ADO.Mssql.Mcis.Report.RptFollowsWorkOrderAdo.GetInstant().GetLast(dataReq.WorkOrderID);
RptFollowsWorkOrderRes _data = new RptFollowsWorkOrderRes();
_data.WorkOrderID = dataReq.WorkOrderID;
_data.RptFollowsWorkOrder = new RptFollowsWorkOrderViewRes();
if (resHead.Count > 0)
{
_data.RptFollowsWorkOrder.WorkOrderHead = resHead[0];
_data.RptFollowsWorkOrder.WorkOrderDetail = resDetail;
_data.RptFollowsWorkOrder.WorkOrderLast = resLast;
}
dataRes.data = _data;
}
public async Task <ResponseAPI <categories> > GetCategory()
{
ResponseAPI <categories> res = new ResponseAPI <categories>();
try
{
string url = ApiUrl.apiUrl() + "products/GetCategories?status=" + "active";
using (var client = new HttpClient())
{
HttpResponseMessage response = await client.GetAsync(url);
response.EnsureSuccessStatusCode();
var resp = await response.Content.ReadAsStringAsync();
return(JsonConvert.DeserializeObject <ResponseAPI <categories> >(resp));
}
}
catch (Exception ex)
{
res = new ResponseAPI <categories>
{
code = 500,
message = ex.Message,
data = null
};
return(res);
}
}
protected override void ExecuteChild(MtMoveOrderSequenceReq dataReq, ResponseAPI dataRes)
{
var res = new List <ASSETKKF_MODEL.Response.Mcis.MtMoveOrderSequenceRes>();
var roles = ASSETKKF_ADO.Mssql.Mcis.MtMoveOrderSequenceAdo.GetInstant().GetData(dataReq);
foreach (var x in roles)
{
var tmp = new ASSETKKF_MODEL.Response.Mcis.MtMoveOrderSequenceRes();
tmp.Sequence = x.Sequence;
tmp.MoveDate = x.MoveDate;
tmp.MoveTime = x.MoveTime;
tmp.EmployeeId = x.EmployeeId;
tmp.WorkOrderId = x.WorkOrderId;
tmp.DrawingCd = x.DrawingCd;
tmp.WorkStationGrpCd_FR = x.WorkStationGrpCd_FR;
tmp.WorkStationGrpCd_STD = x.WorkStationGrpCd_STD;
tmp.WorkStationGrpCd_TO = x.WorkStationGrpCd_TO;
tmp.SeqNo_NEXT = x.SeqNo_NEXT;
tmp.EndTime = x.EndTime;
tmp.CauseStatus = x.CauseStatus;
tmp.RemarkCause = x.RemarkCause;
tmp.AppvCauseId = x.AppvCauseId;
tmp.AppvCauseDt = x.AppvCauseDt;
tmp.Process_Flag = x.Process_Flag;
tmp.User_Id = x.User_Id;
tmp.User_date = x.User_date;
res.Add(tmp);
}
dataRes.data = res;
}
public ActionResult <IEnumerable <string> > CreateBet(BetModel objBet)
{
try
{
ResponseAPI <BetModel> response = null;
var user = Request.Headers["user_autenticated"].ToString();
if (user != string.Empty)
{
BetModel objOk = BetUtilities.ValidateBet(objBet);
response = new ResponseAPI <BetModel>(Parameters.OK_REQUEST, "OK", _BetService.CreateBet(objOk));
}
else
{
response = new ResponseAPI <BetModel>(Parameters.BAD_REQUEST, "Missig user_autenticated", false);
}
return(Ok(
response
));
}
catch (Exception ex)
{
ResponseAPI <BetModel> response = new ResponseAPI <BetModel>(Parameters.INTERNAL_SERVER_ERROR, ex.Message, false);
return(Ok(
response
));
}
}
public async Task <JsonResult> Login(Login login)
{
ResponseAPI <ResponseLogin> _response = API.Execute <ResponseLogin>("http://localhost:56011/api/login", null, null, login, RestSharp.Method.POST);
if (_response.Object.authenticated)
{
var _claims = new List <Claim>()
{
new Claim("Root", "root"),
new Claim(ClaimTypes.Name, _response.Object.user.Name),
new Claim("IdUser", _response.Object.user.IdUser.ToString()),
new Claim(ClaimTypes.Email, _response.Object.user.Email),
new Claim("AccessToken", _response.Object.accessToken)
};
ClaimsIdentity claimsIdentity = new ClaimsIdentity(_claims, "login");
ClaimsPrincipal claimsPrincipal = new ClaimsPrincipal(claimsIdentity);
await _httpContextAcessor.HttpContext.SignInAsync(
claimsPrincipal,
new AuthenticationProperties()
{
IsPersistent = true
});
}
return(Json(_response.Object));
}
protected override void ExecuteChild(NotifyPushMessage dataReq, ResponseAPI dataRes)
{
DBMode = dataReq.DBMode;
dataRes.ServerAddr = ConnectionString();
string body = "";
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("https://notify-api.line.me/api/notify");
client.DefaultRequestHeaders.Add("Authorization", $"Bearer {dataReq.token}");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/x-www-form-urlencoded"));
var content = new StringContent(ToQueryString(dataReq), Encoding.UTF8, "application/x-www-form-urlencoded");
HttpResponseMessage response = new HttpResponseMessage();
response = client.PostAsync(client.BaseAddress, content).Result;
//await response.CheckResult();
HttpContent self = response.Content;
body = self.ReadAsStringAsync().Result;
if (response.StatusCode == System.Net.HttpStatusCode.BadRequest)
{
dynamic tmps = JsonConvert.DeserializeObject(body);
if (tmps.status != "200")
{
throw new Exception(tmps.message);
}
}
}
}
protected override void ExecuteChild(msWorkStationGrpReq dataReq, ResponseAPI dataRes)
{
var res = new List <ASSETKKF_MODEL.Response.Mcis.msWorkStationGrpRes>();
var roles = ASSETKKF_ADO.Mssql.Mcis.msWorkStationGrpAdo.GetInstant().GetData(dataReq);
foreach (var x in roles)
{
var tmp = new ASSETKKF_MODEL.Response.Mcis.msWorkStationGrpRes();
tmp.WorkStationGrpCd = x.WorkStationGrpCd;
tmp.WorkStationGrpNm = x.WorkStationGrpNm;
tmp.DLCost = x.DLCost;
tmp.FOHCost = x.FOHCost;
tmp.MDCost = x.MDCost;
tmp.WorkStationCD = x.WorkStationCD;
tmp.LastUpdUsr = x.LastUpdUsr;
tmp.LastUpdDt = x.LastUpdDt;
tmp.UnionDLCost = x.UnionDLCost;
tmp.WorkStationNM = x.WorkStationNM;
tmp.MulEmp_flag = x.MulEmp_flag;
tmp.ExtGrp_Flag = x.ExtGrp_Flag;
res.Add(tmp);
}
dataRes.data = res;
}
protected override void ExecuteChild(ASSETASSETNOReq dataReq, ResponseAPI dataRes)
{
var res = new ASSETKKF_MODEL.Response.Asset.ASSETASSETNORes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var obj = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().checkASSETASSETNO(dataReq, null, conString);
if (obj == null)
{
if (dataReq.ASSETNO.Trim().Length > 1)
{
obj = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().getASSETASSETNO(dataReq, null, conString);
res._result._code = "203";
res._result._message = "";
res._result._status = "Non-Authoritative Information";
}
else
{
res._result._code = "204";
res._result._message = "";
res._result._status = "No Content";
}
}
else
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
res.ASSETASSETNO = obj;
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
protected override void ExecuteChild(OauthLoginReq dataReq, ResponseAPI dataRes)
{
DBMode = dataReq.DBMode;
dataRes.ServerAddr = ConnectionString();
ASSETKKF_ADO.Mssql.Asset.muTokenAdo.GetInstant().Delete(this.Token, dataReq.usercode, null, conString);
StaticValue.GetInstant().TokenKey();
}
public dynamic ResponeValid(ResponseAPI res)
{
if (res.status == "F")
{
return(StatusCode(404, new { code = res.code, message = res.message }));
}
return(res.data);
}
protected override void ExecuteChild(MtMoveOrderSequenceReq dataReq, ResponseAPI dataRes)
{
var tmp = new ASSETKKF_MODEL.Response.Mcis.GetNextWorkStationGrpRes();
var res = new List <ASSETKKF_MODEL.Response.Mcis.GetNextWorkStationGrpRes>();
try
{
var roles = ASSETKKF_ADO.Mssql.Mcis.MtMoveOrderSequenceAdo.GetInstant().GetNextWorkStationGrp(dataReq);
if (roles.Count == 0)
{
tmp = new ASSETKKF_MODEL.Response.Mcis.GetNextWorkStationGrpRes();
tmp.workOrderID = dataReq.WorkOrderId;
tmp._result._status = "F";
tmp._result._code = "F0002";
tmp._result._message = "ไม่พบข้อมูล ใบสั่งผลิต." + dataReq.WorkOrderId;
res.Add(tmp);
}
else
{
foreach (var x in roles)
{
tmp = new ASSETKKF_MODEL.Response.Mcis.GetNextWorkStationGrpRes();
tmp.workOrderID = x.WorkOrderID;
tmp.workOrderDesc = x.WorkOrderDesc;
tmp.drawingCd = x.DrawingCd;
tmp.workStationGrpCd = x.WorkStationGrpCd;
tmp.workStationGrp_STD = x.WorkStationGrp_STD;
tmp.seqNo_STD = x.SeqNo_STD;
tmp.workStationGrpNm = x.WorkStationGrpNm;
tmp.scnt = x.sCnt;
tmp.noOfMins = x.NoOfMins;
tmp.message = x.message;
tmp._result._status = x._status;
tmp._result._code = x._code;
tmp._result._message = x._message;
res.Add(tmp);
}
}
}
catch (Exception ex)
{
tmp = new ASSETKKF_MODEL.Response.Mcis.GetNextWorkStationGrpRes();
tmp.workOrderID = dataReq.WorkOrderId;
tmp._result._status = "F";
tmp._result._code = "F0001";
tmp._result._message = "การเชื่อมต่อฐานข้อมูลมีปัญหา..." + ex.Message;
res.Add(tmp);
}
dataRes.data = res;
}
protected override void ExecuteChild(rmEmployeeReq dataReq, ResponseAPI dataRes)
{
var res = new List <ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes>();
var tmp = new ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes();
try
{
var roles = ASSETKKF_ADO.Mssql.bsicpers.rmEmployeeAdo.GetInstant().GetData(dataReq);
if (roles.Count == 0)
{
tmp = new ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes();
tmp.EmployeeID = dataReq.EmployeeID;
tmp._result._status = "F";
tmp._result._code = "F0002";
tmp._result._message = "ไม่พบข้อมูล รหัสพนักงานที่ระบุ";
res.Add(tmp);
}
else
{
foreach (var x in roles)
{
tmp = new ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes();
tmp.EmployeeID = x.EmployeeID;
tmp.EmploType = x.EmploType;
tmp.Status = x.Status;
tmp.Shift = x.Shift;
tmp.Weekend = x.Weekend;
tmp.DepCode = x.DepCode;
tmp.Position = x.Position;
tmp.TitleName = x.TitleName;
tmp.FirstName = x.FirstName;
tmp.LastName = x.LastName;
tmp.StartDate = x.StartDate;
tmp.EmploDate = x.EmploDate;
tmp.EndDate = x.EndDate;
tmp.EditDate = x.EditDate;
res.Add(tmp);
}
}
}
catch (Exception)
{
tmp = new ASSETKKF_MODEL.Response.bsicpers.rmEmployeeRes();
tmp.EmployeeID = dataReq.EmployeeID;
tmp._result._status = "F";
tmp._result._code = "F0001";
tmp._result._message = "การเชื่อมต่อฐานข้อมูลมีปัญหา...";
res.Add(tmp);
}
dataRes.data = res;
}
public BaseResult <T> Request <T>(RequestAPI requestAPI) where T : class
{
try
{
string url = $"{_customerAPIOptions.EndPointUrl}/{requestAPI.Route}";
HttpResponseMessage response;
var httpClient = RequestHeader();
if (requestAPI.MethodType == RequestMethodTypeEnum.Get)
{
if (requestAPI.Body != null)
{
var queryParams = _fieldService.GetQueryString(requestAPI.Body);
if (!String.IsNullOrEmpty(queryParams))
{
url = $"{url}?{queryParams}";
}
}
response = httpClient.GetAsync(url).Result;
}
else
{
response = httpClient.PostAsync(
url,
new StringContent(
JsonConvert.SerializeObject(requestAPI.Body),
Encoding.UTF8,
requestAPI.ContentType)).Result;
}
string content = response.Content.ReadAsStringAsync().Result;
if (response.StatusCode == HttpStatusCode.OK)
{
ResponseAPI <T> responseAPI = JsonConvert.DeserializeObject <ResponseAPI <T> >(content);
if (responseAPI.Success && responseAPI.Data != null)
{
return(BaseResult <T> .OK(responseAPI.Data));
}
}
else if (response.StatusCode == HttpStatusCode.Unauthorized)
{
return(BaseResult <T> .NotOK("Unauthorized. Please logg in.", (int)response.StatusCode));
}
return(BaseResult <T> .NotOK("An error occurred while communicating with the server. Please try again."));
}
catch (Exception e)
{
return(BaseResult <T> .NotOK(e.Message));
}
}
protected override void ExecuteChild(AuditResultReq dataReq, ResponseAPI dataRes)
{
var res = new AuditDuplicateRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
List <AuditResult> auditLst = new List <AuditResult>();
var mode = String.IsNullOrEmpty(dataReq.MODE) ? dataReq.MODE : dataReq.MODE.ToLower();
switch (mode)
{
default:
auditLst = AuditResultAdo.GetInstant().GetData(dataReq, null, conString);
break;
}
res.AuditResultLst = auditLst;
if (auditLst == null)
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
else
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
protected override void ExecuteChild(AuditPostReq dataReq, ResponseAPI dataRes)
{
var res = new AuditPostRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var lstAUDITPOSTMST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST(dataReq, null, null, conString);
//var lstWait = lstAUDITPOSTMST.Where(p => String.IsNullOrEmpty(p.PCODE)).ToList();
var lstChecked = lstAUDITPOSTMST.Where(p => !String.IsNullOrEmpty(p.PCODE)).ToList();
var lstWait = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST_WAIT(dataReq, null, null, conString);
res.AUDITPOSTMSTWAITLST = lstWait;
res.AUDITPOSTMSTCHECKEDLST = lstChecked;
res.AUDITPOSTMSTNOPROBLEMLST = lstChecked.Where(x => x.PFLAG != "Y").ToList();
res.AUDITPOSTMSTPROBLEMLST = lstChecked.Where(x => x.PFLAG == "Y").ToList();
var lstAUDITCUTDATE = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITCUTDATE(dataReq, null, conString);
res.AUDITCUTDATELST = lstAUDITCUTDATE;
//res.AUDITPOSTMSTWAITLST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST(dataReq, "");
//res.AUDITPOSTMSTCHECKEDLST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTMST(dataReq, "Y");
res.AUDITPOSTTRNLST = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAUDITPOSTTRN(dataReq, null, conString);
res.AREACODE = dataReq.AREACODE;
res.COMPANY = dataReq.COMPANY;
res.DEPCODEOL = dataReq.DEPCODEOL;
res.LEADERCODE = dataReq.LEADERCODE;
res.SQNO = dataReq.SQNO;
res._result._code = "201";
res._result._message = "";
res._result._status = "Created";
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
public async Task <ActionResult> AddProducts()
{
TempData["RegisterImage"] = "https://tonsmb.org/wp-content/uploads/2014/03/default-placeholder.png";
ResponseAPI <brandCategory> response = await products.FetchBrandCategory();
ViewBag.Code = response.code;
ViewData["BrandCategory"] = response.data;
return(View());
}
protected override void ExecuteChild(AuditCutInfoReq dataReq, ResponseAPI dataRes)
{
var res = new ASSETKKF_MODEL.Response.Asset.AuditCutInfoRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var objLeaderList = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getCentralOfficerLst(dataReq, null, conString);
res.auditCutLeaderList = objLeaderList;
ASSETOFFICECODEReq reqASSETOFFICECODE = new ASSETOFFICECODEReq()
{
COMPANY = dataReq.Company
};
ASSETASSETNOReq reqASSETASSETNO = new ASSETASSETNOReq()
{
COMPANY = dataReq.Company
};
//var lstASSETOFFICECODE = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().getASSETOFFICECODELST(reqASSETOFFICECODE);
var lstASSETASSETNO = ASSETKKF_ADO.Mssql.Asset.AUDITPOSTTRNADO.GetInstant().getASSETASSETNOLST(reqASSETASSETNO, null, conString);
res.ASSETASSETNOLST = lstASSETASSETNO;
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
public async Task <ActionResult> Category()
{
ResponseAPI <categories> response = await products.GetCategory();
ViewBag.Code = response.code;
ViewBag.GetBrandAlert = DesignClass.AlertDesign(response.code);
ViewBag.GetBrandMessage = DesignClass.StandardMessage(response.code);
ViewData["categories"] = response.data;
return(View());
}
protected override void ExecuteChild(ASAUDITCUTDATEMST dataReq, ResponseAPI dataRes)
{
var res = new AsFixedAsset();
//var obj = ASSETKKF_ADO.Mssql.Asset.AsFixedAssetAdo.GetInstant().Search(new ASSETKKF_MODEL.Data.Mssql.Asset.AsFixedAsset() { OFFICECODE = dataReq.OFFICECODE.Trim() });
//if (obj == null) { throw new Exception("ไม่พบข้อมูล"); }
//res.AsFixedAssetLST = obj;
//dataRes.data = res;
}
protected override void ExecuteChild(AsFixedAsset dataReq, ResponseAPI dataRes)
{
var res = new TaskAuditRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var state = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().AuditCancel(dataReq, null, conString);
var taskReq = new TaskAudit()
{
INPID = dataReq.INPID,
COMPANY = dataReq.COMPANY
};
var lst = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().GetData(taskReq, null, conString);
if (lst == null)
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
else
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
res.TaskAuditLST = lst;
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
protected override void ExecuteChild(RptWorkOrderReq dataReq, ResponseAPI dataRes)
{
var tmp = new ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderDetailRes();
var res = new List <ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderDetailRes>();
try
{
var roles = ASSETKKF_ADO.Mssql.Mcis.Report.RptFollowsWorkOrderAdo.GetInstant().GetDetail(dataReq.WorkOrderID);
foreach (var x in roles)
{
tmp = new ASSETKKF_MODEL.Response.Report.RptFollowsWorkOrderDetailRes();
tmp.WorkOrderID = x.WorkOrderID;
tmp.SeqNo = x.SeqNo;
tmp.WorkStationGrp = x.WorkStationGrp;
tmp.zSequence = x.zSequence;
tmp.WorkStationGrpNm = x.WorkStationGrpNm;
tmp.DlCost = x.DlCost;
tmp.FOHCost = x.FOHCost;
tmp.MDCost = x.MDCost;
tmp.TotalCost = x.TotalCost;
tmp.NoOfMinStd = x.NoOfMinStd;
tmp.NoOfMinsAct = x.NoOfMinsAct;
tmp.zDiffTime = x.NoOfMinStd - x.NoOfMinsAct; // zDiffTime = (NoOfMinStd-NoOfMinsAct);
tmp.StartTime = x.StartTime;
tmp.EndTime = x.EndTime;
tmp.MoveTime = x.MoveTime;
tmp.MoveEmpID = x.MoveEmpID;
tmp.MoveEmpNm = x.MoveEmpNm;
tmp.zWorkStationGrp_Next = x.zWorkStationGrp_Next;
tmp.WorkStationGrp_Next = x.WorkStationGrp_Next;
tmp.ReworkFlag = x.ReworkFlag;
tmp.StartTimeStr = DateTimeUtil.ToStringViewDT(x.StartTime);
tmp.EndTimeStr = DateTimeUtil.ToStringViewDT(x.EndTime);
tmp.MoveTimeStr = DateTimeUtil.ToStringViewDT(x.MoveTime);
tmp.MAXSEQ = x.MAXSEQ;
tmp.CTMCH = x.CTMCH;
tmp.CTEMP = x.CTEMP;
tmp.CTMOVE = x.CTMOVE;
tmp.WorkOrderDesc = x.WorkOrderDesc;
tmp.WorkOrderStatus = x.WorkOrderStatus;
res.Add(tmp);
}
}
catch (Exception)
{
}
dataRes.data = res;
}
public async Task <IActionResult> Create([Bind("ID,Nome,DataNascimento,Morada,Cidade,Distrito,Codigo,Postal,Email,Descricao,ConsentimentoRGPD,Interno")] Voluntario voluntario)
{
HttpClient client = MyConvertHttpClient.Client;
var email = voluntario.Email;
var dataNascimento = voluntario.DataNascimento;
string path = "?key=private_f9cea434f6d212d56da0091d19a97d71&email=" + email;
string json = JsonConvert.SerializeObject(email);
HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Post, path);
request.Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
HttpResponseMessage response = await client.SendAsync(request);
if (!response.IsSuccessStatusCode)
{
return(Redirect("/"));
}
string json_r = await response.Content.ReadAsStringAsync();
ResponseAPI responseResult = JsonConvert.DeserializeObject <ResponseAPI>(json_r);
ViewModelNovoVoluntario viewModelNovoVoluntario = new ViewModelNovoVoluntario();
viewModelNovoVoluntario.ResponsesAPI = responseResult;
if (dataNascimento > DateTime.Now)
{
viewModelNovoVoluntario.VerificaDataNascimento = false;
return(View(viewModelNovoVoluntario));
}
if (responseResult.Result != "valid")
{
return(View(viewModelNovoVoluntario));
}
else
{
if (ModelState.IsValid)
{
_context.Add(voluntario);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(viewModelNovoVoluntario));
}
}
}
