public long CreateVoteJoin(VoteJoin voteJoin)
{
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
conn.Open();
long result = -1;
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@VID", (DbType)SqlDbType.BigInt, 8, voteJoin.VID),
DbHelper.MakeInParam("@UID", (DbType)SqlDbType.BigInt, 8, voteJoin.UID),
DbHelper.MakeInParam("@SelVoteItemIDs", (DbType)SqlDbType.VarChar, 300, voteJoin.SelVoteItemIDs),
DbHelper.MakeInParam("@SelVoteItemNames", (DbType)SqlDbType.VarChar, 500, voteJoin.SelVoteItemNames),
DbHelper.MakeInParam("@IsAnonymous", (DbType)SqlDbType.Int, 4, voteJoin.IsAnonymous),
DbHelper.MakeInParam("@SelCount", (DbType)SqlDbType.Int, 4, voteJoin.SelVoteItemIDs.Split(',').Length - 1),
};
result = TypeConverter.ObjectToLong(DbHelper.ExecuteScalar(CommandType.StoredProcedure, "CreateVoteJoin", parms), -1);
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
conn.Close();
return(result);
}
public static long CreateVoteJoin(VoteJoin voteJoin)
{
try
{
if (voteJoin != null)
{
return(Data.VoteJoins.CreateVoteJoin(voteJoin));
}
return(-1);
}
catch (Exception ex)
{
Logs.WriteErrorLog(ex);
return(-1);
}
}
public static long CreateVoteJoin(VoteJoin voteJoin)
{
return(DatabaseProvider.GetInstance().CreateVoteJoin(voteJoin));
}
