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()));
}
}
