/// <summary>
/// Insert/Update Assigned Unit Picklist
/// </summary>
/// <param name="db">DB Context</param>
/// <param name="se">Picklist Assigned Unit Model</param>
/// <returns></returns>
public async Task <bool> AssignedUnitUpdateAsync(PicklistAssignedUnit se)
{
bool result = true;
using (_context)
{
try
{
var model = await _context.PicklistAssignedUnit.FirstOrDefaultAsync(p => p.UnitID == se.UnitID);
if (model == null)
{
_context.PicklistAssignedUnit.Add(se);
}
else
{
_context.PicklistAssignedUnit.Update(se);
}
await _context.SaveChangesAsync();
}
catch (Exception e)
{
result = false;
}
}
return(result);
}
public async Task <ActionResult <PicklistAssignedUnit> > PostAssignedUnit([FromBody] SimpleModel list)
{
PicklistAssignedUnit model = Newtonsoft.Json.JsonConvert.DeserializeObject <PicklistAssignedUnit>(list.Name);
var response = this.StatusCode((int)HttpStatusCode.OK, await _service.AssignedUnitUpdateAsync(model));
_service.Dispose();
return(response);
}
public bool SendUpdateAssignedUnit()
{
bool result = false;
DataTable table = getTable($"SELECT * FROM armyunit WHERE UnitID = {this.ReferenceID}");
if (table.Rows.Count > 0)
{
PicklistAssignedUnit dtSet = Mapper.DynamicMap <IDataReader, List <PicklistAssignedUnit> >(table.CreateDataReader()).First();
var json = JsonConvert.SerializeObject(dtSet);
this.List = new SimpleModel();
this.List.Code = this.Code;
this.List.SiteCode = this.SiteCode;
this.List.IsSCMLocation = this.IsSupplyChain;
this.List.Name = json;
_messageSender = new RestClientMessageSender();
var response = (RestResponseBase)_messageSender.sendRequest <PicklistAssignedUnit>(this);
if (response.Content != string.Empty)
{
result = ((response.Content == "true") ? true : false);
}
/**
* Insert / Queue value to tmp_update table to process by auto snyc when request failed
*/
if (!result && this.FailOver)
{
queueFailedRequest(this.Module.ToString(), this.ReferenceID.ToString());
}
}
else
{
result = true;
}
return(result);
}
