public async Task <IHttpActionResult> Approved_DocIn(string id, DocIn model) { try { string query = @"select * from " + _bucket.Name + " where meta().id='" + id + "'"; var docInData = _bucket.Query <IndividualOutPut>(query).ToList(); if (docInData.Count == 0) { return(Content(HttpStatusCode.NotFound, MessageResponse.Message(HttpStatusCode.NotFound.ToString(), MessageDescriptions.NotFound, id), new JsonMediaTypeFormatter())); } /////////////////////////////////////////////////// Update Document Status Code if (model.Status) { _bucket.Query <object>(@"Update " + _bucket.Name + " set status=true where meta().id='" + id + "'").ToList(); return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, id + " status has been updated successfully."), new JsonMediaTypeFormatter())); } if (string.IsNullOrEmpty(model.RejReas)) { return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "193-Rejection reason is required."), new JsonMediaTypeFormatter())); } else { _bucket.Query <object>(@"Update " + _bucket.Name + " set rejReas='" + model.RejReas + "',status=false where meta().id='" + id + "'").ToList(); return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.Update, id + " status has been updated successfully."), new JsonMediaTypeFormatter())); } } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter())); } }
public async Task <IHttpActionResult> Update_DOCIN(string Id, DocIn model) { try { if (!ModelState.IsValid) { var modelErrors = new List <string>(); foreach (var modelState in ModelState.Values) { foreach (var modelError in modelState.Errors) { modelErrors.Add(modelError.ErrorMessage == "" ? modelError.Exception.Message : modelError.ErrorMessage); } } return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter())); } // Validate company is exist or not var docInDocument = _bucket.Query <object>(@"SELECT * From " + _bucket.Name + " as docIn where meta().id='" + Id + "'").ToList(); if (docInDocument.Count > 0) { // edit docIn #region Updare docIn string updatequeryString = string.Empty; updatequeryString = @"update " + _bucket.Name + " set "; updatequeryString += " docType ='" + model.DocType + "',"; updatequeryString += " docRef ='" + model.DocRef + "',"; updatequeryString += " lang ='" + model.Lang + "',"; updatequeryString += " version ='" + model.Version + "',"; updatequeryString += " status ='" + model.Status + "',"; updatequeryString += " dateTime ='" + model.DateTime + "',"; updatequeryString += " validFrom ='" + model.ValidFrom + "',"; updatequeryString += " validTo ='" + model.ValidTo + "',"; updatequeryString += " rejReas ='" + model.RejReas + "',"; updatequeryString += " indivID ='" + model.IndivID + "',"; updatequeryString += " vehID ='" + model.VehID + "',"; updatequeryString += " compID ='" + model.CompID + "',"; updatequeryString += " docClass ='" + model.DocClass + "',"; /////////////////// New Fields updatequeryString += " id ='" + model.Id + "',"; updatequeryString += " issueDate ='" + model.IssueDate + "',"; updatequeryString += " expiryDate ='" + model.ExpiryDate + "',"; updatequeryString += " place ='" + model.Place + "',"; updatequeryString += " categories ='" + model.Categories + "',"; updatequeryString += "docFile =[],"; /////// Doc Content if (model.DocContent != null) { updatequeryString += " docContent.fees ='" + model.DocContent.Fees + "',"; updatequeryString += " docContent.duration ='" + model.DocContent.Duration + "'"; } //updatequeryString += " auditInfo = ARRAY_APPEND( auditInfo, " + Newtonsoft.Json.JsonConvert.SerializeObject(auditInfo).ToString() + ")"; updatequeryString += " where meta().id='" + Id + "'"; var result = _bucket.Query <object>(updatequeryString); foreach (var item in model.DocFile) { var queryUpdatedocFile = @"update " + _bucket.Name + " SET docFile= ARRAY_APPEND(docFile, " + Newtonsoft.Json.JsonConvert.SerializeObject(item).ToString() + " ) where meta().id='" + Id + "'"; _bucket.Query <object>(queryUpdatedocFile); } return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), Id + " has been updated sucessfully"), new JsonMediaTypeFormatter())); #endregion //Vehicles = lstVehicles,Roles = lstRoles,Documents = lstDocuments,LoginDetails = model.LoginDetails //Fines = lstFines,,ScoreCards = LstScoreCard,Incidents = LstIncident } else { return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), MessageDescriptions.NotFound, "document does not exist"), new JsonMediaTypeFormatter())); } } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter())); } }