public async Task <ActionResult <BaseResponse> > PostStageDetail(StageDetail stageDetail) { if (String.IsNullOrEmpty(stageDetail.StarTime) || String.IsNullOrEmpty(stageDetail.EndTime) || String.IsNullOrEmpty(stageDetail.Interview)) { return(new BaseResponse { ErrorCode = 0, Messege = "Thêm mới thất bại!!" }); } else { try { _context.StageDetails.Add(stageDetail); await _context.SaveChangesAsync(); return(new BaseResponse { ErrorCode = 1, Messege = "Thêm mới thành công!!", Data = CreatedAtAction("GetStageDetail", new { id = stageDetail.Id }, stageDetail) }); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } } }
public async Task <ActionResult <BaseResponse> > PostStageDetail(StageDetail stageDetail) { var datas = _context.StageDetails.Where(x => x.Stage_ID.Equals(Convert.ToInt32(stageDetail.Stage_ID))).Where(y => y.Major_ID.Equals(Convert.ToInt32(stageDetail.Major_ID))).Where(z => z.Exam_ID.Equals(Convert.ToInt32(stageDetail.Exam_ID))).ToList(); if (String.IsNullOrEmpty(stageDetail.StarTime) || String.IsNullOrEmpty(stageDetail.EndTime) || String.IsNullOrEmpty(stageDetail.Interview) || Convert.ToInt32(stageDetail.Stage_ID) == 0 || Convert.ToInt32(stageDetail.Major_ID) == 0 || Convert.ToInt32(stageDetail.Exam_ID) == 0) { return(new BaseResponse { ErrorCode = 0, Messege = "Not be emty!!" }); } else if (datas.Count != 0) { return(new BaseResponse { ErrorCode = 2, Messege = "Stage Detail already exist!!" }); } else { _context.StageDetails.Add(stageDetail); await _context.SaveChangesAsync(); return(new BaseResponse { ErrorCode = 1, Messege = "Thêm mới thành công!!", Data = CreatedAtAction("GetStageDetail", new { id = stageDetail.Id }, stageDetail) }); } }
public async Task <ActionResult <BaseResponse> > PutStageDetail(int id, StageDetail stageDetail_update) { var datas = _context.StageDetails.Where(x => x.Stage_ID.Equals(Convert.ToInt32(stageDetail_update.Stage_ID))).Where(y => y.Major_ID.Equals(Convert.ToInt32(stageDetail_update.Major_ID))).Where(z => z.Exam_ID.Equals(Convert.ToInt32(stageDetail_update.Exam_ID))).ToList(); var StageD = await _context.StageDetails.FindAsync(id); if (StageD == null) { return(NotFound()); } else if (String.IsNullOrEmpty(stageDetail_update.StarTime) || String.IsNullOrEmpty(stageDetail_update.EndTime) || String.IsNullOrEmpty(stageDetail_update.Interview) || Convert.ToInt32(stageDetail_update.Stage_ID) == 0 || Convert.ToInt32(stageDetail_update.Major_ID) == 0 || Convert.ToInt32(stageDetail_update.Exam_ID) == 0) { return(new BaseResponse { ErrorCode = 0, Messege = "Not be emty!!" }); } else if (datas.Count != 0) { return(new BaseResponse { ErrorCode = 2, Messege = "Stage Detail already exist!!" }); } else { StageD.Major_ID = stageDetail_update.Major_ID; StageD.Stage_ID = stageDetail_update.Stage_ID; StageD.Exam_ID = stageDetail_update.Exam_ID; StageD.StarTime = stageDetail_update.StarTime; StageD.EndTime = stageDetail_update.EndTime; StageD.Interview = stageDetail_update.Interview; _context.StageDetails.Update(StageD); await _context.SaveChangesAsync(); return(new BaseResponse { ErrorCode = 1, Messege = "Update thành công!!" }); } }
public async Task <IActionResult> PutStageDetail(int id, StageDetail stageDetail_update) { var StageD = await _context.StageDetails.FindAsync(id); if (StageD == null) { return(NotFound()); } StageD.Major_ID = stageDetail_update.Major_ID; StageD.Stage_ID = stageDetail_update.Stage_ID; StageD.Exam_ID = stageDetail_update.Exam_ID; StageD.StarTime = stageDetail_update.StarTime; StageD.EndTime = stageDetail_update.EndTime; StageD.Interview = stageDetail_update.Interview; _context.StageDetails.Update(StageD); await _context.SaveChangesAsync(); return(Ok(StageD)); }
public async Task <IActionResult> UpdatingActivityDetail([FromBody] JsonElement id) { string DownloadDirectory = _configuration["Configuration:DownloadPath"].Replace("/", "\\"); int Status = 0; string JournalName = string.Empty; string filename = string.Empty; var responsedetail = new Response(); string sCaptureError = ""; var fileDetail = new FileDetail(); // client.BaseAddress = new Uri(_configuration["Configuration:Uri"]); // client.DefaultRequestHeaders.Accept.Clear(); // client.DefaultRequestHeaders.Accept.Add( // new MediaTypeWithQualityHeaderValue("application/json")); // client.DefaultRequestHeaders.Add("clientid", _configuration["Configuration:ClientId"]); // client.DefaultRequestHeaders.Add("apikey", _configuration["Configuration:apiKey"]); var data = id.ToString(); JObject jObject = JObject.Parse(data); string value = (string)jObject.SelectToken("id"); var ids = "{\n\t\"ids\":[" + value + "]\n}".ToString(); // var response = client.PostAsync(_configuration["Configuration:GetActivityFiles"], new StringContent(data, Encoding.UTF8, "application/json")).Result; var client = new RestClient(_configuration["Configuration:LiveUri"] + _configuration["Configuration:GetActivityFiles"]); var request = new RestRequest(Method.POST); request.AddHeader("content-type", "application/json"); request.AddHeader("clientid", _configuration["Configuration:ClientId"]); request.AddHeader("apikey", _configuration["Configuration:apiKey"]); request.AddParameter("application/json", data, ParameterType.RequestBody); IRestResponse response = client.Execute(request); if (response.IsSuccessful) { responsedetail = JsonConvert.DeserializeObject <Response>(response.Content.ToString()); } if (responsedetail.is_success) { //updating Status to Trn File Property Details Status = responsedetail.data.Status; JournalName = responsedetail.data.JournalName; filename = responsedetail.data.ArticleName; var bookdetails = _context.BookDetails.FirstOrDefault(x => x.bookName == JournalName); fileDetail = _context.FileDetails.FirstOrDefault(x => x.fileName == filename); try { // var fileDetail = await _context.FileDetails.FirstOrDefaultAsync(x => x.fileName == filename); if (fileDetail == null) { return(StatusCode(200, new { is_success = false, data = "", message = string.Format("File Details Not exist for given Articlname {0} ", filename) })); } else if (fileDetail != null) { var FileProplold = await _context.trnFilePropertyDetails.FirstOrDefaultAsync(x => x.fileId == fileDetail.fileID && x.bookId == bookdetails.bookId && x.id == 195); if (FileProplold != null) { try { FileProplold.value = Status.ToString(); // _context.Recorddetails.Attach(recordetailold); // _context.Entry(recordetailold).Property(x=>x.status & x.bookid &x.fileID).IsModified=true; // _context.SaveChanges(); _context.trnFilePropertyDetails.Update(FileProplold); await _context.SaveChangesAsync(); } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Updating FilePropertDetails Error Desc: " + ex.Message.ToString() })); } } else { var recordetail = new trnFilePropertyDetail { // id = 195, //Customer Category file Property fileId = fileDetail.fileID, bookId = bookdetails.bookId, value = Status.ToString() }; try { await _context.AddAsync(recordetail); await _context.SaveChangesAsync(); } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Inserting FilePropertDetails Error Desc: " + ex.Message.ToString() })); } } } //For CustomerID IOPP from Iatuhor if (responsedetail.data.CustomerId == Customers.IOPPCustomer) { if (responsedetail.data.WorkflowId == (int)WorkFlowIds.authorProofing2 && Status == 3) { //adding Activity and Stage Detail for abovedotne Workflow ID's Enabling HTML Download Acitivity in Copy Editing Stage stageid = (int)IOPPStages.fromAuthor; activityid = (int)activities.HTMLDownload; } else { //adding Activity and Stage Detail for abovedotne Workflow ID's Enabling Pdf Creation Acitivity in Copy Editing Stage stageid = (int)IOPPStages.Copyediting; activityid = (int)activities.IOPPHtmlToPDF; } try { if (fileDetail != null) { var recordetailold = await _context.Recorddetails37.FirstOrDefaultAsync(x => x.fileID == fileDetail.fileID && x.activityid == activityid); if (recordetailold != null) { try { if (recordetailold.status == 0) { recordetailold.status = 1; _context.Recorddetails37.Update(recordetailold); await _context.SaveChangesAsync(); } else { } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Updating Activity Details Error Desc: " + ex.Message.ToString() })); } } else { var recordetail = new Recorddetail37 { fileID = fileDetail.fileID, activityid = (Int16)activityid, stageId = (Int16)stageid, bookid = (Int16)fileDetail.bookid, }; try { await _context.AddAsync(recordetail); await _context.SaveChangesAsync(); } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Inserting Activity Details Error Desc: " + ex.Message.ToString() })); } } } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = ex.Message.ToString() })); } } //For CustomerID BMJ from Iatuhor else if (responsedetail.data.CustomerId == Customers.BMJCustomer) { try { ActivityDetail activityDetail = new ActivityDetail(); StageDetail StageDetail = new StageDetail(); string FileName = Path.GetFileName(responsedetail.data.path.ToString()); DownloadDirectory = DownloadDirectory.Replace(";bookname;", responsedetail.data.JournalName.ToString()); String DownloadPath = DownloadDirectory + filename + "\\" + FileName; int WorkflowId = responsedetail.data.WfdId; string ArticleName = responsedetail.data.ArticleName; Status = responsedetail.data.Status; string UriPath = responsedetail.data.path.ToString(); bool IsitrackStageAdded = false; // string pdfName = Path.GetFileName(jobinputs.pdfPath); // string xmlFName = Path.GetFileName(jobinputs.xmlPath); // string appFName = Path.GetFileName(jobinputs.ApplicationPath); // if (jobinputs.Wfdid == "23" || jobinputs.Wfdid == "24") if (bmjworkflowids.Contains(WorkflowId)) { if (bmjworkflowids.Contains(WorkflowId) && Status == 17) { //adding Activity and Stage Detail for abovedotne Workflow ID's stageid = (int)BMJStages.Revises1; // activityid = (int)activities.BMJXMLCorrection; //dynamically Create folder structure based on activityDetail = _context.ActivityDetails.FirstOrDefault(x => x.activityid == activityid); StageDetail = _context.StageDetails.FirstOrDefault(x => x.stageid == stageid); DownloadPath = DownloadPath.Replace(";stageDetail;", StageDetail.sfoldername); DownloadPath = DownloadPath.Replace(";ActivityDetail;", activityDetail.folderName); IsitrackStageAdded = AddtoItrackStage(ArticleName, "", 128, 513, 3, 1, ref sCaptureError); } else if (bmjworkflowids.Contains(WorkflowId) && Status == 3) { stageid = (int)BMJStages.Preview; activityid = (int)activities.BMJOnlinePDFCreation; activityDetail = await _context.ActivityDetails.FirstAsync(x => x.activityid == activityid); StageDetail = _context.StageDetails.FirstOrDefault(x => x.stageid == stageid); DownloadPath = DownloadPath.Replace(";stageDetail;", StageDetail.sfoldername); DownloadPath = DownloadPath.Replace(";ActivityDetail;", activityDetail.folderName); IsitrackStageAdded = AddtoItrackStage(ArticleName, "", 128, 513, 63, 1, ref sCaptureError); } else { stageid = (int)BMJStages.XMLValidation; activityid = (int)activities.BMJXMLValidation; activityDetail = _context.ActivityDetails.FirstOrDefault(x => x.activityid == activityid); StageDetail = _context.StageDetails.FirstOrDefault(x => x.stageid == stageid); DownloadPath = DownloadPath.Replace(";stageDetail;", StageDetail.sfoldername); DownloadPath = DownloadPath.Replace(";ActivityDetail;", activityDetail.folderName); } if (!string.IsNullOrEmpty(UriPath)) { if ((bmjworkflowids.Contains(WorkflowId))) { try { fileDetail = await _context.FileDetails.FirstOrDefaultAsync(x => x.fileName == filename); if (Decompress(DownloadPath, Path.GetDirectoryName(DownloadPath), UriPath, ref sCaptureError)) { if (fileDetail != null) { var recordetailold = await _context.Recorddetails.FirstOrDefaultAsync(x => x.fileID == fileDetail.fileID && x.activityid == activityid); if (recordetailold != null) { try { if (recordetailold.status == 0) { recordetailold.status = 1; // _context.Recorddetails.Attach(recordetailold); // _context.Entry(recordetailold).Property(x=>x.status & x.bookid &x.fileID).IsModified=true; // _context.SaveChanges(); _context.Recorddetails.Update(recordetailold); await _context.SaveChangesAsync(); } else { } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Updating Activity Details Error Desc: " + ex.Message.ToString() })); } } else { var recordetail = new Recorddetail { fileID = fileDetail.fileID, activityid = (Int16)activityid, stageId = (Int16)stageid, bookid = (Int16)fileDetail.bookid }; try { await _context.AddAsync(recordetail); await _context.SaveChangesAsync(); } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Inserting Activity Details Error Desc: " + ex.Message.ToString() })); } } } } else { return(StatusCode(200, new { is_success = false, data = "", message = sCaptureError })); } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = ex.Message.ToString() })); } } else { return(StatusCode(200, new { is_success = false, data = "", message = "" })); } } else { return(StatusCode(200, new { is_success = false, data = "", message = "File Path Should not be empty" })); } } else { return(StatusCode(200, new { is_success = false, data = "", message = " workflow id is not configured for id: " + WorkflowId })); } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = ex.Message.ToString() })); } } } catch (Exception ex) { return(StatusCode(200, new { is_success = false, data = "", message = ex.Message.ToString() })); } var clientupdate = new RestClient(_configuration["Configuration:Uri"] + _configuration["Configuration:GetActivityFiles"]); var requestupdate = new RestRequest(Method.POST); requestupdate.AddHeader("content-type", "application/json"); requestupdate.AddHeader("clientid", _configuration["Configuration:ClientId"]); requestupdate.AddHeader("apikey", _configuration["Configuration:apiKey"]); requestupdate.AddParameter("application/json", ids, ParameterType.RequestBody); IRestResponse responsenew = client.Execute(request); if (responsenew.IsSuccessful) { responsedetail = JsonConvert.DeserializeObject <Response>(response.Content.ToString()); if (responsedetail.is_success) { return(StatusCode(200, new { is_success = true, data = "", message = "Success" })); } else { return(StatusCode(200, new { is_success = true, data = "", message = "Success" })); } } else { return(StatusCode(200, new { is_success = false, data = "", message = "Error in Updating Status" })); } } else { return(StatusCode(200, new { is_success = false, data = "", message = "No Respond from IAuthor URL " })); } }