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); }