示例#1
0
        public void UpdateActivity(PortalActivity updActivity)
        {
            var currActivity = GetActivity(updActivity.Id);

            currActivity.Name        = updActivity.Name;
            currActivity.Description = updActivity.Description;
            currActivity.Date        = updActivity.Date;
        }
 public void UpdateActivity(PortalActivity activity)
 {
     ExecuteNonQuery($@"
         UPDATE {PortalActivityTableName}
         SET Name = '{activity.Name}',
             Description = '{activity.Description}',
             Date = '{activity.Date.ToString("MM/dd/yyyy h:mm tt")}'
         WHERE Id = {activity.Id};
     ");
 }
 public void AddActivity(PortalActivity activity)
 {
     ExecuteNonQuery($@"
         INSERT INTO {PortalActivityTableName} (Name, Description, Date)
         VALUES
         ('{activity.Name}',
             '{activity.Description}',
             '{activity.Date.ToString("MM/dd/yyyy h:mm tt")}' )
     ");
 }
        public PortalActivity GetActivity(int id)
        {
            DataTable dt = GetDataTable($@"Select Id, Name, Description, Date from {PortalActivityTableName}
                                            WHERE Id = {id}");

            PortalActivity activity = null;

            if (dt.Rows.Count > 0)
            {
                activity           = PortalActivityFromDataRow(dt.Rows[0]);
                activity.Attendees = GetActivityAttendees(activity.Id).ToList();
            }

            return(activity);
        }
示例#5
0
        public IActionResult Create(string modifyDate, [Bind("Name,Description,Date")] PortalActivity activity)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    activity.Date = Convert.ToDateTime(modifyDate);
                    _portalRepository.AddActivity(activity);
                    return(RedirectToAction(nameof(Index)));
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(string.Empty, ex.Message);
            }

            return(View(activity));
        }
示例#6
0
        public IActionResult Edit(int id, string modifyDate, [Bind("Id,Name,Description,Date")] PortalActivity activity)
        {
            if (id != activity.Id)
            {
                return(NotFound());
            }

            try
            {
                if (ModelState.IsValid)
                {
                    activity.Date = Convert.ToDateTime(modifyDate);
                    _portalRepository.UpdateActivity(activity);
                    return(RedirectToAction(nameof(Index)));
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(string.Empty, ex.Message);
            }
            return(View(activity));
        }
示例#7
0
 public void UpdateActivity(PortalActivity activity)
 {
     _portalContext.PortalActivity.Update(activity);
     _portalContext.SaveChanges();
 }
示例#8
0
 public void AddActivity(PortalActivity activity)
 {
     _portalContext.PortalActivity.Add(activity);
     _portalContext.SaveChanges();
 }
示例#9
0
 public void AddActivity(PortalActivity activity)
 {
     _activities.Add(activity);
 }