public async Task<IHttpActionResult> RegisterCommonMasters([FromUri]string name, CommonMasters 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);
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter());
}
CommonMasters addNewCommonMaster = new CommonMasters();
addNewCommonMaster.Code = model.Code;
addNewCommonMaster.Value = model.Value;
addNewCommonMaster.Rank = model.Rank;
// add scoreCard code
string query = @"UPDATE " + _bucket.Name + " SET "+ name + " = ARRAY_APPEND("+ name + ", " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewCommonMaster).ToString() + ") where meta().id='REF_EN_US'";
var result = _bucket.Query<object>(query);
return Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), "Master data has been added sucessfully"), new JsonMediaTypeFormatter());
}
catch (Exception ex)
{
return Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter());
}
}
public async Task<IHttpActionResult> UpdateCommonMasters([FromUri]string name, CommonMasters 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);
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter());
}
string query = @"SELECT Contents." + name + " From " + _bucket.Name + " as CommonMasters where meta().id='REF_EN_US'";
var CommonMasterDocument = _bucket.Query<object>(query).ToList();
foreach (var item1 in CommonMasterDocument)
{
var cMData = ((Newtonsoft.Json.Linq.JToken)item1).Root[""+ name +""];
foreach (var item in cMData)
{
if (item["Code"].ToString()==model.Code)
{
// edit Common Master
string updateQuery = @"UPDATE " + _bucket.Name + " SET value = '" + model.Value + "',rank = '" + model.Rank + "' where meta().id='REF_EN_US'";
var result = _bucket.Query<object>(updateQuery);
return Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), name + " has been updated sucessfully"), new JsonMediaTypeFormatter());
}
}
}
return Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), "code not found."), new JsonMediaTypeFormatter());
}
catch (Exception ex)
{
return Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter());
}
}