public bool Sale(SalesmanAccountModel salesmanAcc)
{
using (var con = ConnectionGetway.GetConnection())
{
string query = $"INSERT INTO tblAccounts (Code,Amount, CompanyCode) VALUES ('{salesmanAcc.Code}',{salesmanAcc.Amount},'{salesmanAcc.CompanyCode}')";
return(con.Execute(query) > 0);
}
}
public double SaleBySalesman(SalesmanAccountModel salesmanAcc)
{
if (_salesmanAcc.Sale(salesmanAcc))
{
return(_salesmanAcc.GetSalesAmount(salesmanAcc.CompanyCode, code: salesmanAcc.Code));
}
else
{
throw new InvalidException("Sales Operation failed.");
}
}
public double PurchaseBySalesman(SalesmanAccountModel salesmanAcc)
{
if (_salesmanAcc.Purchase(salesmanAcc))
{
return(_salesmanAcc.GetPurchaseAmount(salesmanAcc.CompanyCode, code: salesmanAcc.Code));
}
else
{
throw new InvalidException("Purchase Operation Failed.");
}
}
public IActionResult SalesmanSale(SalesmanAccountModel accountModel)
{
try
{
var currentMonthSale = _employee.SaleBySalesman(accountModel);
return(Ok(new { status = true, result = currentMonthSale }));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult SalesmanPurchase(SalesmanAccountModel accountModel)
{
try
{
var currentMonthPurchase = _employee.PurchaseBySalesman(accountModel);
return(Ok(new { status = true, result = currentMonthPurchase }));
}
catch (InvalidException err) { return(Ok(new { status = false, result = err.Message })); }
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
