public int Update(InsuranceCompanyLocationModel model)
{
//TODO - Update Query
string sqlUpdate = "";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
public int Insert(InsuranceCompanyLocationModel model)
{
string sqlInsert = "INSERT INTO InsuranceCompanyLocation (Address, TownZipCode, InsuranceCompanyId) " +
" Values (@Address, @TownZipCode, @InsuranceCompanyId)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
public int Delete(InsuranceCompanyLocationModel model)
{
string sqlDelete = "DELETE FROM InsuranceCompanyLocation WHERE Address = @Address AND " +
" TownZipCode = @TownZipCode AND InsuranceCompanyId = @InsuranceCompanyId";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
/// <summary>
///
/// </summary>
/// <param name="insuranceCompanyLocation"></param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Update(InsuranceCompanyLocationModel insuranceCompanyLocation)
{
return(_insuranceCompanyLocationRepository.Update(insuranceCompanyLocation) > 0 ? true : false);
}
/// <summary>
///
/// </summary>
/// <param name="insuranceCompanyLocation"></param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Insert(InsuranceCompanyLocationModel insuranceCompanyLocation)
{
return(_insuranceCompanyLocationRepository.Insert(insuranceCompanyLocation) > 0 ? true : false);
}
