public List <SODetailsDB> GetSoListFromCust(RequestSODetailsFromCustAndSo data)
{
List <SODetailsDB> ResultSet = new List <SODetailsDB>();
using (IDbConnection connection = GetOpenConnection())
{
try
{
var param = new DynamicParameters();
param.Add("@UserType", data.UserType);
param.Add("@CustomerCode", data.CustomerCode);
param.Add("@LoadingPlanFrom", data.LoadingPlanFrom);
param.Add("@LoadingPlanTo", data.LoadingPlanTo);
ResultSet = connection.Query <SODetailsDB>("SP_GetSoListFromCust", param, commandType: CommandType.StoredProcedure).ToList();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
return(ResultSet);
}
public ResponseInfo <ResponseSODetails> GetSoListFromCust([FromBody] RequestSODetailsFromCustAndSo data)
{
try
{
return(base.PostDataToAPINotAuth <ResponseInfo <ResponseSODetails> >(base.apiPathAndQuery, data));
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseInfo <ResponseSODetails> GetSoListFromCust([FromBody] RequestSODetailsFromCustAndSo data)
{
ResponseInfo <ResponseSODetails> res = new ResponseInfo <ResponseSODetails>();
try
{
res = process.GetSoListFromCust(data);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public ResponseInfo <ResponseSODetails> GetSoListFromCust(RequestSODetailsFromCustAndSo data)
{
ResponseInfo <ResponseSODetails> response = new ResponseInfo <ResponseSODetails>();
try
{
response.ResponseData = new ResponseSODetails();
var listData = SODAL.GetSoListFromCust(data);
response.ResponseData.sODetails = HelperUtil.GenerateSoDetailBase64String(listData);
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
