/**************************************************************
* Author: Gustavo ZC
* Creation date: 05/07/2019
* Description: Method responsible for communicating with the DataAccess and for extracting information
* Modifications:
* ************************************************************
* Number:
* Date:
* Ticket:
* Author:
* Descripction:
* ************************************************************
*/
public async virtual Task <Message> List(Message message)
{
try
{
var resultMessage = new Message();
var model = message.DeSerializeObject <Import_Product>();
using (var repository = new Gbl_Wrk_Agreement_Detail_Repository(message.Connection))
{
var returnObject = await repository.List(model);
resultMessage.Status = Status.Success;
resultMessage.Result = "Proceso efectuado satisfactoriamente...";
resultMessage.MessageInfo = returnObject.SerializeObject();
return(resultMessage);
}
}
catch (Exception ex)
{
var resultMessage = new Message();
resultMessage.Status = Status.Failed;
resultMessage.Result = string.Format("{0}", ex.Message);
resultMessage.MessageInfo = string.Empty;
return(resultMessage);
}
}
/**************************************************************
* Author: Gustavo ZC
* Creation date: 05/07/2019
* Description: Method responsible for communicating with the DataAccess and for save information
* Modifications:
* ************************************************************
* Number:
* Date:
* Ticket:
* Author:
* Descripction:
* ************************************************************
*/
public async virtual Task <Message> Save(Message message)
{
try
{
var resultMessage = new Message();
var model = message.DeSerializeObject <Import_Product>();
using (var repository = new Gbl_Wrk_Agreement_Detail_Repository(message.Connection))
{
if (model.Option == Agreement_Option.Process_Work_Table)
{
var resultDetailList = await repository.ExecuteProcess(model);
resultMessage.MessageInfo = resultDetailList.SerializeObject();;
}
else
{
if (model.Pk_Ac_Trade_Agreement != 0)
{
await repository.Delete(model);
}
var repository_funcionality = new Generic_Funcionality(message.Connection);
//var result = await repository.SaveGet(model);
// model.Pk_Ac_Trade_Agreement = result.Pk_Ac_Trade_Agreement;
model.Pk_Ac_Trade_Agreement = model.Pk_Ac_Trade_Agreement;
model.Total_Records = repository_funcionality.readAsExcelFile(model);
await repository.Save(model);
var resultProductList = repository.ListWorkTable(model);
resultMessage.MessageInfo = resultProductList.Result.SerializeObject();
}
resultMessage.Status = Status.Success;
resultMessage.Result = "Proceso efectuado satisfactoriamente...";
return(resultMessage);
}
}
catch (Exception ex)
{
var resultMessage = new Message();
resultMessage.Status = Status.Failed;
resultMessage.Result = string.Format("{0}", ex.Message);
resultMessage.MessageInfo = string.Empty;
return(resultMessage);
}
}
