public APICallingResult mergeTag(ContactTagModel tagModel) { string outputMessage = null; int idOut = 0; var tag = AddressProvider.mergeTag(tagModel, out idOut, out outputMessage); return(new APICallingResult { Status = tag != null, Data = tag, ProcessMessage = outputMessage, Id = idOut }); }
public static ContactTagModel mergeTag(ContactTagModel tagModel, out int idOut, out string processMessage) { processMessage = String.Empty; idOut = 0; try { using (var connection = DBProvider.DatabaseConnection) { var command = new SqlCommand("[address].[merge_tag]", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@TagName", tagModel.name); command.Parameters.Add(new SqlParameter { ParameterName = "@IDOut", DbType = DbType.Int32, Direction = ParameterDirection.Output }); command.Parameters.Add(new SqlParameter { ParameterName = "@ProcessMessage", DbType = DbType.String, Size = 200, Direction = ParameterDirection.Output }); command.ExecuteNonQuery(); idOut = int.Parse(command.Parameters["@IDOut"].Value.ToString()); processMessage = command.Parameters["@ProcessMessage"].Value.ToString(); tagModel.id = idOut; } } catch (Exception exp) { processMessage = exp.Message; return(null); } return(tagModel); }