Example #1
0
        public bool SaveActivity(CF_Activity activity)
        {
            if (activity.ActivityID == default(int))
            {
                activity.RecordStatus = "Active";
            }

            var parmsCollection = new ParmsCollection();
            var dataSet         = this.clientDbContext.ExecuteQueryOrStoredProcedure_ToDataSet("[MobileApp].[saveActivity]",
                                                                                               parmsCollection
                                                                                               .AddParm("@ActivityID", SqlDbType.Int, activity.ActivityID)
                                                                                               .AddParm("@ActivityTypeID", SqlDbType.Int, activity.ActivityTypeID)
                                                                                               .AddParm("@Title", SqlDbType.NVarChar, activity.Title)
                                                                                               .AddParm("@Description", SqlDbType.NVarChar, activity.Description)

                                                                                               .AddParm("@AssignedToID", SqlDbType.Int, activity.AssignedToID)
                                                                                               .AddParm("@RefTable", SqlDbType.NVarChar, activity.RefTable)
                                                                                               .AddParm("@RefRecordID", SqlDbType.Int, activity.RefRecordID)

                                                                                               .AddParm("@PlannedDate", SqlDbType.DateTime, activity.PlannedDate)
                                                                                               .AddParm("@ActualDate", SqlDbType.DateTime, activity.ActualDate)
                                                                                               .AddParm("@CompletedDate", SqlDbType.DateTime, activity.CompletedDate)
                                                                                               .AddParm("@DueDate", SqlDbType.DateTime, activity.DueDate)
                                                                                               .AddParm("@PriorityID", SqlDbType.Int, activity.PriorityID)
                                                                                               .AddParm("@NextScheduleDate", SqlDbType.DateTime, activity.NextScheduleDate)

                                                                                               .AddParm("@Remark", SqlDbType.NVarChar, activity.Remark)
                                                                                               .AddParm("@RecordStatus", SqlDbType.NVarChar, activity.RecordStatus)

                                                                                               .AddParm("@CreateUserID", SqlDbType.Int, userContext.LoggedInUserId)
                                                                                               .AddParm("@ModifyUserID", SqlDbType.Int, userContext.LoggedInUserId)
                                                                                               );

            return(true);
        }
        public IActionResult SaveActivity([FromBody] CF_Activity activity)
        {
            activity.CreateUserID = this.userContext.LoggedInUserId;
            activity.CreateDate   = DateTime.Now;

            activity.ModifyUserID = this.userContext.LoggedInUserId;
            activity.ModifyDate   = DateTime.Now;

            return(Ok(activityBusinessAccess.SaveActivity(activity)));
        }
Example #3
0
 public bool SaveActivity(CF_Activity activity)
 {
     return(this.activityDataAccess.SaveActivity(activity));
 }