public ActionResult DeleteConfirmed(long id)
        {
            tblActivity tblactivity = db.tblActivities.Find(id);

            db.tblActivities.Remove(tblactivity);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "activityId,name,locationId,typeId,description,createdBy,createdDate,updatedBy,updatedDate")] tblActivity tblactivity)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tblactivity).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.locationId = new SelectList(db.tblLocations, "locId", "name", tblactivity.locationId);
     ViewBag.typeId     = new SelectList(db.tblMediumPrepTypes, "typeId", "typename", tblactivity.typeId);
     return(View(tblactivity));
 }
        // GET: /Activity/Details/5
        public ActionResult Details(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblActivity tblactivity = db.tblActivities.Find(id);

            if (tblactivity == null)
            {
                return(HttpNotFound());
            }
            return(View(tblactivity));
        }
        // GET: /Activity/Edit/5
        public ActionResult Edit(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblActivity tblactivity = db.tblActivities.Find(id);

            if (tblactivity == null)
            {
                return(HttpNotFound());
            }
            ViewBag.locationId = new SelectList(db.tblLocations, "locId", "name", tblactivity.locationId);
            ViewBag.typeId     = new SelectList(db.tblMediumPrepTypes, "typeId", "typename", tblactivity.typeId);
            return(View(tblactivity));
        }
Пример #5
0
        /// <summary>
        /// Function to get activity by id
        /// </summary>
        /// <returns>ActivityVM</returns>
        /// <devdoc>
        /// Developer Name - Raghuraj Singh
        /// Date - 04/03/2015
        /// </devdoc>
        public static ActivityVM GetActivityById(int id)
        {
            StringBuilder traceLog = null;

            using (LinksMediaContext dataContext = new LinksMediaContext())
            {
                traceLog = new StringBuilder();
                try
                {
                    ///Get challenge detail by challenge
                    traceLog.AppendLine("Start: GetActivityById for retrieving activity by id:" + id);
                    tblActivity activity = dataContext.Activity.Find(id);
                    Mapper.CreateMap <tblActivity, ActivityVM>();
                    ActivityVM objActivity = Mapper.Map <tblActivity, ActivityVM>(activity);
                    tblFeaturedActivityQueue featuredActivityQueue = dataContext.FeaturedActivityQueue.Where(ce => ce.ActivityId == id).FirstOrDefault();
                    if (featuredActivityQueue != null)
                    {
                        objActivity.StartDate = featuredActivityQueue.StartDate;
                        objActivity.EndDate   = featuredActivityQueue.EndDate;
                    }
                    tblCredentials objCred = dataContext.Credentials.FirstOrDefault(c => c.Id == objActivity.TrainerId && c.UserType == Message.UserTypeTrainer);
                    if (objCred != null)
                    {
                        objActivity.TrainerId = objCred.UserId;
                    }
                    return(objActivity);
                }
                catch
                {
                    throw;
                }
                finally
                {
                    traceLog.AppendLine("GetActivityById  end() : --- " + DateTime.Now.ToLongDateString());
                    LogManager.LogManagerInstance.WriteTraceLog(traceLog);
                }
            }
        }
Пример #6
0
        /// <summary>
        /// Function to delete activity
        /// </summary>
        /// <returns>void</returns>
        /// <devdoc>
        /// Developer Name - Raghuraj Singh
        /// Date - 04/04/2015
        /// </devdoc>
        public static void DeleteActivity(int id)
        {
            StringBuilder traceLog = null;

            using (LinksMediaContext dataContext = new LinksMediaContext())
            {
                using (System.Data.Entity.DbContextTransaction dbTran = dataContext.Database.BeginTransaction())
                {
                    traceLog = new StringBuilder();
                    try
                    {
                        traceLog.AppendLine("Start: DeleteActivity  --- " + DateTime.Now.ToLongDateString());
                        tblActivity activity = dataContext.Activity.Find(id);
                        tblFeaturedActivityQueue featuredActivityQueue = dataContext.FeaturedActivityQueue.Where(ce => ce.ActivityId == id).FirstOrDefault();
                        /*Delete Related feateured activity for the activity*/
                        if (featuredActivityQueue != null)
                        {
                            dataContext.FeaturedActivityQueue.Remove(featuredActivityQueue);
                            dataContext.SaveChanges();
                        }
                        dataContext.Activity.Remove(activity);
                        dataContext.SaveChanges();
                        dbTran.Commit();
                    }
                    catch
                    {
                        dbTran.Rollback();
                        throw;
                    }
                    finally
                    {
                        traceLog.AppendLine("DeleteActivity  end() : --- " + DateTime.Now.ToLongDateString());
                        LogManager.LogManagerInstance.WriteTraceLog(traceLog);
                    }
                }
            }
        }
Пример #7
0
        /// <summary>
        /// Function to submit activity into database
        /// </summary>
        /// <returns>void</returns>
        /// <devdoc>
        /// Developer Name - Raghuraj Singh
        /// Date - 04/01/2015
        /// </devdoc>
        public static void SubmitActivity(ActivityVM objActivityVM)
        {
            StringBuilder traceLog = null;

            using (LinksMediaContext dataContext = new LinksMediaContext())
            {
                using (System.Data.Entity.DbContextTransaction tran = dataContext.Database.BeginTransaction())
                {
                    traceLog = new StringBuilder();
                    try
                    {
                        traceLog.AppendLine("Start: SubmitActivity for creating activity");
                        tblCredentials objCred       = dataContext.Credentials.FirstOrDefault(c => c.UserId == objActivityVM.TrainerId && c.UserType == Message.UserTypeTrainer);
                        int            trainerCredId = objCred.Id;
                        objActivityVM.TrainerId = trainerCredId;
                        Mapper.CreateMap <ActivityVM, tblActivity>();
                        tblActivity objActivity = Mapper.Map <ActivityVM, tblActivity>(objActivityVM);
                        objActivity.CreatedDate  = DateTime.Now;
                        objActivity.ModifiedDate = objActivity.CreatedDate;
                        // Add activity in to database
                        dataContext.Activity.Add(objActivity);
                        dataContext.SaveChanges();
                        tran.Commit();
                    }
                    catch
                    {
                        tran.Rollback();
                        throw;
                    }
                    finally
                    {
                        traceLog.AppendLine("SubmitActivity  end() : --- " + DateTime.Now.ToLongDateString());
                        LogManager.LogManagerInstance.WriteTraceLog(traceLog);
                    }
                }
            }
        }
Пример #8
0
        /// <summary>
        /// Function to update activity
        /// </summary>
        /// <returns>void</returns>
        /// <devdoc>
        /// Developer Name - Raghuraj Singh
        /// Date - 04/03/2015
        /// </devdoc>
        public static void UpdateActivity(ActivityVM objActivityVM)
        {
            StringBuilder traceLog = null;

            using (LinksMediaContext dataContext = new LinksMediaContext())
            {
                using (System.Data.Entity.DbContextTransaction tran = dataContext.Database.BeginTransaction())
                {
                    traceLog = new StringBuilder();
                    try
                    {
                        traceLog.AppendLine("Start: UpdateActivity for updating activity");
                        tblCredentials objCred       = dataContext.Credentials.FirstOrDefault(c => c.UserId == objActivityVM.TrainerId && c.UserType == Message.UserTypeTrainer);
                        int            trainerCredId = objCred.Id;
                        objActivityVM.TrainerId    = trainerCredId;
                        objActivityVM.ModifiedDate = DateTime.Now;
                        tblActivity objActivity = dataContext.Activity.Where(ac => ac.ActivityId == objActivityVM.ActivityId).FirstOrDefault();
                        if (objActivity != null)
                        {
                            objActivity.AddressLine1   = objActivityVM.AddressLine1;
                            objActivity.TrainerId      = objActivityVM.TrainerId;
                            objActivity.ModifiedDate   = objActivityVM.ModifiedDate;
                            objActivity.AddressLine2   = objActivityVM.AddressLine2;
                            objActivity.DateOfEvent    = objActivityVM.DateOfEvent;
                            objActivity.Description    = objActivityVM.Description;
                            objActivity.NameOfActivity = objActivityVM.NameOfActivity;
                            objActivity.Pic            = objActivityVM.Pic;
                            objActivity.PromotionText  = objActivityVM.PromotionText;
                            objActivity.State          = objActivityVM.State;
                            objActivity.Video          = objActivityVM.Video;
                            objActivity.Zip            = objActivityVM.Zip;
                            objActivity.LearnMore      = objActivityVM.LearnMore;
                            objActivity.City           = Convert.ToInt32(objActivityVM.City);
                        }
                        dataContext.SaveChanges();
                        ///set activivty to featured queue in database
                        if (objActivityVM.StartDate != null && objActivityVM.EndDate != null)
                        {
                            tblFeaturedActivityQueue featuredActivityQueue = dataContext.FeaturedActivityQueue.Where(ce => ce.ActivityId == objActivityVM.ActivityId).FirstOrDefault();
                            tblFeaturedActivityQueue featuredActivity      = new tblFeaturedActivityQueue();
                            /*if featured activity is created then update else create new featured activity*/
                            if (featuredActivityQueue != null)
                            {
                                featuredActivityQueue.StartDate  = objActivityVM.StartDate;
                                featuredActivityQueue.ActivityId = objActivityVM.ActivityId;
                                featuredActivityQueue.EndDate    = objActivityVM.EndDate;
                            }
                            else
                            {
                                featuredActivity.StartDate  = objActivityVM.StartDate;
                                featuredActivity.ActivityId = objActivityVM.ActivityId;
                                featuredActivity.EndDate    = objActivityVM.EndDate;
                                dataContext.FeaturedActivityQueue.Add(featuredActivity);
                            }
                            dataContext.SaveChanges();
                        }
                        tran.Commit();
                    }
                    catch
                    {
                        tran.Rollback();
                        throw;
                    }
                    finally
                    {
                        traceLog.AppendLine("UpdateActivity  end() : --- " + DateTime.Now.ToLongDateString());
                        LogManager.LogManagerInstance.WriteTraceLog(traceLog);
                    }
                }
            }
        }