public static int CreateVote(VoteInfo vote)
{
int num = 0;
VoteDao dao = new VoteDao();
long num2 = dao.CreateVote(vote);
if (num2 > 0L)
{
ReplyInfo reply = new TextReplyInfo {
Keys = vote.Keys,
MatchType = MatchType.Equal,
ReplyType = ReplyType.Vote,
ActivityId = Convert.ToInt32(num2)
};
new ReplyDao().SaveReply(reply);
num = 1;
if (vote.VoteItems == null)
{
return(num);
}
foreach (VoteItemInfo info2 in vote.VoteItems)
{
info2.VoteId = num2;
info2.ItemCount = 0;
num += dao.CreateVoteItem(info2, null);
}
}
return(num);
}
public ActionResult Vote(VoteModel model)
{
if (!ModelState.IsValid)
{
model = initVoteModel(model.questionID);
return(View(model));
}
VoteDao votedao = new VoteDao();
//检查用户是否已经投过票了 否则在原来的基础上更改
User u = new UserDao().getById(model.userID);
Question q = new QuestionDao().getById(model.questionID);
Vote v = votedao.getByUserAndQuestion(u, q);
if (v == null)
{
v = new Models.Vote();
}
v.queID = new QuestionDao().getById(model.questionID);
v.userID = u;
v.voteComment = model.voteComment;
v.voteTime = DateTime.Now;
v.voteRecord = model.voteRecord;
if (v.ID != 0)
{
votedao.update(v);
}
else
{
votedao.add(v);
}
return(RedirectToAction("Index"));
}
public static bool UpdateVote(VoteInfo vote)
{
Database database = DatabaseFactory.CreateDatabase();
bool result;
using (System.Data.Common.DbConnection dbConnection = database.CreateConnection())
{
VoteDao voteDao = new VoteDao();
dbConnection.Open();
System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction();
try
{
if (!voteDao.UpdateVote(vote, dbTransaction))
{
dbTransaction.Rollback();
result = false;
}
else
{
if (!voteDao.DeleteVoteItem(vote.VoteId, dbTransaction))
{
dbTransaction.Rollback();
result = false;
}
else
{
int num = 0;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo current in vote.VoteItems)
{
current.VoteId = vote.VoteId;
current.ItemCount = 0;
num += voteDao.CreateVoteItem(current, dbTransaction);
}
if (num < vote.VoteItems.Count)
{
dbTransaction.Rollback();
result = false;
return(result);
}
}
dbTransaction.Commit();
result = true;
}
}
}
catch
{
dbTransaction.Rollback();
result = false;
}
finally
{
dbConnection.Close();
}
}
return(result);
}
public static bool UpdateVote(VoteInfo vote)
{
bool flag;
VoteDao dao = new VoteDao();
using (DbConnection connection = DatabaseFactory.CreateDatabase().CreateConnection())
{
connection.Open();
DbTransaction dbTran = connection.BeginTransaction();
try
{
if (!dao.UpdateVote(vote, dbTran))
{
dbTran.Rollback();
return(false);
}
if (!dao.DeleteVoteItem(vote.VoteId, dbTran))
{
dbTran.Rollback();
return(false);
}
int num = 0;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo info in vote.VoteItems)
{
info.VoteId = vote.VoteId;
info.ItemCount = 0;
num += dao.CreateVoteItem(info, dbTran);
}
if (num < vote.VoteItems.Count)
{
dbTran.Rollback();
return(false);
}
}
dbTran.Commit();
flag = true;
}
catch
{
dbTran.Rollback();
flag = false;
}
finally
{
connection.Close();
}
}
return(flag);
}
public static bool UpdateVote(VoteInfo vote)
{
Database database = DatabaseFactory.CreateDatabase();
using (DbConnection dbConnection = database.CreateConnection())
{
VoteDao voteDao = new VoteDao();
dbConnection.Open();
DbTransaction dbTransaction = dbConnection.BeginTransaction();
try
{
if (!voteDao.Update(vote, null))
{
dbTransaction.Rollback();
return(false);
}
if (!voteDao.DeleteVoteItem(vote.VoteId, dbTransaction))
{
dbTransaction.Rollback();
return(false);
}
int num = 0;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo voteItem in vote.VoteItems)
{
voteItem.VoteId = vote.VoteId;
voteItem.ItemCount = 0;
num += (int)voteDao.Add(voteItem, null);
}
if (num < vote.VoteItems.Count)
{
dbTransaction.Rollback();
return(false);
}
}
dbTransaction.Commit();
return(true);
}
catch (Exception)
{
dbTransaction.Rollback();
return(false);
}
finally
{
dbConnection.Close();
}
}
}
public static int CreateVote(VoteInfo vote)
{
int num = 0;
VoteDao voteDao = new VoteDao();
long num3 = vote.VoteId = voteDao.Add(vote, null);
if (num3 > 0)
{
num = 1;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo voteItem in vote.VoteItems)
{
voteItem.VoteId = num3;
voteItem.ItemCount = 0;
num += (int)voteDao.Add(voteItem, null);
}
}
}
return(num);
}
public static int CreateVote(VoteInfo vote)
{
int num = 0;
VoteDao voteDao = new VoteDao();
long num2 = voteDao.CreateVote(vote);
if (num2 > 0L)
{
num = 1;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo current in vote.VoteItems)
{
current.VoteId = num2;
current.ItemCount = 0;
num += voteDao.CreateVoteItem(current, null);
}
}
}
return(num);
}
public static int CreateVote(VoteInfo vote)
{
int num = 0;
VoteDao voteDao = new VoteDao();
long num1 = voteDao.CreateVote(vote);
if (num1 > (long)0)
{
num = 1;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo voteItem in vote.VoteItems)
{
voteItem.VoteId = num1;
voteItem.ItemCount = 0;
num = num + voteDao.CreateVoteItem(voteItem, null);
}
}
}
return(num);
}
//查看已投票的问题
public ActionResult MyVote()
{
MyVoteModel model = new MyVoteModel();
UserDao userdao = new UserDao();
User user = userdao.getById(int.Parse(Request.Cookies["Menber"].Values["ID"]));
VoteDao votedao = new VoteDao();
List <Vote> votes = votedao.getByUser(user);
QuestionDao questiondao = new Dao.QuestionDao();
model.questions = new List <Question>();
foreach (Vote v in votes)
{
Question q = v.queID;
model.questions.Add(q);
}
TypeDao typedao = new TypeDao();
model.types = typedao.getTypeList();
return(View(model));
}
public static int CreateVote(VoteInfo vote)
{
int num = 0;
VoteDao dao = new VoteDao();
long num2 = dao.CreateVote(vote);
if (num2 > 0L)
{
num = 1;
if (vote.VoteItems == null)
{
return(num);
}
foreach (VoteItemInfo info in vote.VoteItems)
{
info.VoteId = num2;
info.ItemCount = 0;
num += dao.CreateVoteItem(info, null);
}
}
return(num);
}
static VoteHelper()
{
VoteHelper._vote = new VoteDao();
}
public static bool UpdateVote(VoteInfo vote)
{
bool flag;
VoteDao voteDao = new VoteDao();
DbConnection dbConnection = DatabaseFactory.CreateDatabase().CreateConnection();
try
{
dbConnection.Open();
DbTransaction dbTransaction = dbConnection.BeginTransaction();
try
{
try
{
if (!voteDao.UpdateVote(vote, dbTransaction))
{
dbTransaction.Rollback();
flag = false;
}
else if (voteDao.DeleteVoteItem(vote.VoteId, dbTransaction))
{
int num = 0;
if (vote.VoteItems != null)
{
foreach (VoteItemInfo voteItem in vote.VoteItems)
{
voteItem.VoteId = vote.VoteId;
voteItem.ItemCount = 0;
num = num + voteDao.CreateVoteItem(voteItem, dbTransaction);
}
if (num < vote.VoteItems.Count)
{
dbTransaction.Rollback();
flag = false;
return(flag);
}
}
dbTransaction.Commit();
flag = true;
}
else
{
dbTransaction.Rollback();
flag = false;
}
}
catch
{
dbTransaction.Rollback();
flag = false;
}
}
finally
{
dbConnection.Close();
}
}
finally
{
if (dbConnection != null)
{
((IDisposable)dbConnection).Dispose();
}
}
return(flag);
}
