Exemplo n.º 1
0
        public void Destroy(CoursesViewModel db)
        {
            var entity = new Courses_Table();

            entity.CoursesID = db.CoursesID;

            entities.Courses_Table.Attach(entity);

            entities.Courses_Table.Remove(entity);

            entities.SaveChanges();
        }
Exemplo n.º 2
0
        public void Create(CoursesViewModel db)
        {
            var entity = new Courses_Table();

            entity.CoursesNumber    = db.CoursesNumber;
            entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date;

            entity.CoursesEndDate = (DateTime)db.CoursesEndDate.Date;
            entity.CoursesSummary = HttpUtility.HtmlDecode(db.CoursesSummary);
            entity.UserID         = db.UserID;

            entities.Courses_Table.Add(entity);
            entities.SaveChanges();

            db.CoursesID = entity.CoursesID;
        }
Exemplo n.º 3
0
        public void Update(CoursesViewModel db)
        {
            var entity = new Courses_Table();

            entity.CoursesID        = db.CoursesID;
            entity.CoursesNumber    = db.CoursesNumber;
            entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date;

            entity.CoursesEndDate = (DateTime)db.CoursesEndDate.Date;

            entity.UserID = db.UserID;

            entities.Courses_Table.Attach(entity);

            entities.Entry(entity).State = EntityState.Modified;
            entities.SaveChanges();
        }
Exemplo n.º 4
0
        public void Create(CoursesViewModel db)
        {
            var entity = new Courses_Table();

            entity.CoursesName      = db.CoursesName;
            entity.CoursesStartDate = (DateTime)db.CoursesStartDate.Date;

            entity.CoursesEndDate     = (DateTime)db.CoursesEndDate.Date;
            entity.TotalBeneficiaries = db.TotalBeneficiaries;
            entity.TrainingHours      = db.TrainingHours;
            entity.TotalSessions      = db.TotalSessions;
            entity.Males         = db.Males;
            entity.Females       = db.Females;
            entity.UserID        = db.UserID;
            entity.TargetGroupID = db.TargetGroupID;
            entity.ProjectID     = db.ProjectID;
            entities.Courses_Table.Add(entity);
            entities.SaveChanges();

            db.CoursesID = entity.CoursesID;
        }