Beispiel #1
0
        public List <DTO_OpenDraw> CreateDraw(DTO_NewDraw draw)
        {
            using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
            {
                List <DTO_OpenDraw> openDrawList = new List <DTO_OpenDraw>();
                DTO_OpenDraw        openDraw     = new DTO_OpenDraw();

                int?  temp   = 1;
                draws sqlobj = new draws();
                sqlobj.CategoryID    = draw.DrawCategoryID;
                sqlobj.DoodlerUserID = draw.DoodlerID;
                sqlobj.Answer        = draw.Answer;
                sqlobj.DrawStatusID  = temp;
                sqlobj.StartTime     = draw.StartTime;
                sqlobj.EndTime       = System.DateTime.Now;
                db.draws.Add(sqlobj);
                db.SaveChanges();

                int temp2 = 1;
                openDraw.DrawID = sqlobj.DrawID;
                //openDraw.Doodler = db.users.Where(c => c.UserID.Equals(draw.DoodlerID)).FirstOrDefault().DisplayName;
                //openDraw.DrawStatusDesc = db.drawStatus.Where(c => c.DrawStatusID.Equals(temp2)).FirstOrDefault().DrawStatusDesc;
                //openDraw.DrawCategoryName = db.drawCategories.Where(c => c.DrawCategoryID.Equals(draw.DrawCategoryID)).FirstOrDefault().DrawCategoryName;
                openDraw.Doodler          = "Test Doodler";
                openDraw.DrawStatusDesc   = "Test DrawStatusDesc";
                openDraw.DrawCategoryName = "Test DrawCategoryName";
                openDraw.StartTime        = System.DateTime.Now;
                openDrawList.Add(openDraw);

                return(openDrawList);
            }
        }
Beispiel #2
0
        private void runDrawToolStripMenuItem_Click(object sender, EventArgs e)
        {
            draws d = new draws();

            d.ShowDialog();
        }