public IActionResult Post([FromBody] Business value)
{
try
{
using (var db = My.ConnectionFactory())
{
int result = db.Execute($@"IF EXISTS({My.Table_Business.SelectSingle}) {My.Table_Business.Update} ELSE {My.Table_Business.Insert}", value);
BusinessFacilityController businessFacility = new BusinessFacilityController();
businessFacility.Post(value);
}
return(Ok());
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public Business Get(string businessId)
{
using (var db = My.ConnectionFactory())
{
var businesses = db.Query <Business, IndustryType, Township, City, BusinessType, Business>($@"{My.Table_Business.Select}
LEFT OUTER JOIN dbo.IndustryType ON dbo.Business.industryTypeId = dbo.IndustryType.industryTypeId
LEFT OUTER JOIN dbo.Township ON dbo.Business.townshipId = dbo.Township.townshipId
LEFT OUTER JOIN dbo.City ON dbo.Business.cityId = dbo.City.cityId
LEFT OUTER JOIN dbo.BusinessType ON dbo.Business.businessTypeId = dbo.BusinessType.businessTypeId WHERE dbo.Business.businessId='{businessId}'",
(business, industryType, township, city, businessType) =>
{
if (business.industryTypeId != null)
{
business.industryType = industryType;
}
if (business.cityId != null)
{
business.city = city;
}
if (business.townshipId != null)
{
business.township = township;
}
if (business.businessTypeId != null)
{
business.businessType = businessType;
}
BusinessBranchController bbc = new BusinessBranchController();
business.businessBranch = bbc.Get(businessId).ToArray();
BusinessFacilityController bfc = new BusinessFacilityController();
business.businessFacility = bfc.Get(businessId).ToArray();
return(business);
}, splitOn: "industryTypeId,townshipId,cityId,businessTypeId").ToArray();
//if (businesses != null) return businesses[0]; else return null;
return((businesses.Length == 1) ? businesses[0] : null);
}
}