public static void Update(AssistenceInfo infoToUpdate, UsaAssistenceInfo sourceInfo)
{
infoToUpdate.Email = sourceInfo.Email;
infoToUpdate.Fax = sourceInfo.Fax;
infoToUpdate.Globe = sourceInfo.Globe;
infoToUpdate.Phone = sourceInfo.Phone;
infoToUpdate.Title = sourceInfo.Name;
}
public static Country Create(UsaCountryModel countryDto, AssistenceInfo assistanceInfo, CountryInfo countryInfo)
{
Country country = new Country
{
Name = countryDto.Value,
Code = countryDto.Code,
CountryInfo = countryInfo,
AssistenceInfo = assistanceInfo
};
return(country);
}
public static AssistenceInfo Create(UsaAssistenceInfo sourceInfo)
{
var info = new AssistenceInfo
{
Email = sourceInfo.Email,
Fax = sourceInfo.Fax,
Globe = sourceInfo.Globe,
Phone = sourceInfo.Phone,
Title = sourceInfo.Name
};
return(info);
}
public Task <int> UpdateAsync(int id, AssistenceInfo assistenceInfo)
{
string updateQuery = @"UPDATE AssistenceInfo
SET Email = @Email,
Fax = @Fax
Phone = @Phone
Title = @Title,
Globe = @Globe
WHERE Id = @Id";
var parameters = new
{
Email = assistenceInfo.Email,
Fax = assistenceInfo.Fax,
Phone = assistenceInfo.Phone,
Title = assistenceInfo.Title,
Globe = assistenceInfo.Globe,
Id = id
};
return(connection.ExecuteAsync(updateQuery, parameters));
}
public async Task <int> InsertAsync(AssistenceInfo assistenceInfo)
{
string insertQuery = "INSERT INTO AssistenceInfo VALUES(@Email, @Fax, @Phone, @Globe, @Title)";
return(await connection.ExecuteAsync(insertQuery, assistenceInfo));
}
