/// <summary>
/// 選票匯入
/// </summary>
protected void SetVoteTrans(DataSet dsVote)
{
BVote bVote = new BVote();
//刪除所有Vote
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg選票資料");
bVote.DelAll();
lbState.Invoke((Action <string>)SetStatus, "從access取選票資料移到FoodOrg");
lbl_VoteAll.Invoke((Action <string>)SetVoteAll, dsVote.Tables[0].Rows.Count.ToString());
int intVoteCount = 0;
foreach (DataRow dr in dsVote.Tables[0].Rows)
{
MVote mod = new MVote();
mod.TWYear = SetTWYear(dr["Period"].ToString());
mod.MemberID = SetMemberGed(dr["MemberID"].ToString());
mod.AgentMemberID = dr["AgentMemberID"].ToString();
mod.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
mod.CreateUser = dr["CreateUser"].ToString();
new BVote().Add(mod);
intVoteCount++;
lbVoteCount.Invoke((Action <int>)SetVote, intVoteCount);
}
}
public ActionResult EditAndCreate(VoteModel vote)
{
BVote oldVote = AutoMapper <VoteModel, BVote> .Map(vote);
voteService.CreateOrUpdate(oldVote);
return(RedirectToActionPermanent("Index", "Books"));
}
public ActionResult VoteBook(int id = 0)
{
BVote vote = voteService.GetVote(id);
vote.Votes += 1;
voteService.CreateOrUpdate(vote);
return(PartialView(AutoMapper <IEnumerable <BVote>, List <VoteModel> > .Map(voteService.GetVotes)));
}
public BVote GetVote(int id)
{
if (id != 0)
{
BVote vote = AutoMapper <Vote, BVote> .Map(Database.Vote.Get, (int)id);
vote.BookName = Database.Books.Get(vote.BookId).Title;
return(vote);
}
return(new BVote());
}
public void CreateOrUpdate(BVote vote)
{
if (vote.Id == 0)
{
Vote dvote = new Vote()
{
BookId = vote.BookId, Votes = vote.Votes
};
Database.Vote.Create(dvote);
}
else
{
Vote editVote = AutoMapper <BVote, Vote> .Map(vote);
Database.Vote.Update(editVote);
}
Database.Save();
}
