public async Task <string> PostAsyncUsedIn([FromBody] string value)
{
string NewInsertionID = "0";
try
{
ProductUsedIn newProductUsedIn = JsonConvert.DeserializeObject <ProductUsedIn>(value);
NewInsertionID = await _ProductRepo.CreateProductUsedIn(newProductUsedIn);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in making new line items with message" + ex.Message);
}
return(NewInsertionID);
}
/*Developer: ubaid
* Date:13-7-19
* Action:get ProductUsedIn Model from controller and insert the ProductUsedIn
* Input: ProductUsedIn Model
* output: New product UsedIn id
*/
public async Task <string> CreateProductUsedIn(ProductUsedIn NewUsedIn)
{
string ProductUsedInExistsQuery = "SELECT * FROM product_used_in WHERE po_id='" + NewUsedIn.po_id + "' and product_id='" + NewUsedIn.product_id + "';";
using (IDbConnection conn = Connection)
{
var ProductUsedInExists = await conn.QueryAsync <ProductUsedIn>(ProductUsedInExistsQuery);
if (ProductUsedInExists == null || ProductUsedInExists.Count() == 0)
{
var result = await conn.InsertAsync <ProductUsedIn>(NewUsedIn);
return(result.ToString());
}
else
{
return(ProductUsedInExists.First().product_used_in_id.ToString());
}
}
}
