public async Task <bool> Update(vCardContainer CardContainer)
{
using (DbConnection db = new SqlConnection(connectionString))
{
string _query = "update vCards set vCard_name= @vCard_name, vCard_PrefNumber=@vCard_PrefNumber, vCard_data=@vCard_data, Modified_date=@Modified_date, vCardAlbum_id=@vCardAlbum_id where vCard_id = @vCard_id";
try
{
await db.ExecuteAsync(_query, CardContainer);
}
catch (Exception)
{
return(false);
}
return(true);
}
}
public async Task <bool> Create(vCardContainer CardContainer)
{
using (DbConnection db = new SqlConnection(connectionString))
{
string _query = "insert into vCards (vCard_usid, vCard_groupname, vCard_name, vCard_PrefNumber, vCard_data, CreateDate, Modified_date) values(@vCard_usid, @vCard_name, @vCard_PrefNumber, vCard_groupname, @vCard_data, @CreateDate, @Modified_date); select cast(scope_identity() as int)";
try
{
int?CardContainer_Id = (await db.QueryAsync <int>(_query, CardContainer)).FirstOrDefault();
CardContainer.vCard_id = CardContainer_Id.Value;
}
catch (Exception)
{
return(false);
}
return(true);
}
}
