Exemplo n.º 1
0
        public string EditWorkitem(Workitem id)
        {
            try
            {
                using (var entities = new WorkBountyDBEntities())
                {
                    var getWorkitemData = entities.Workitems.Where(x => x.WorkitemID == id.WorkitemID).ToList();
                    getWorkitemData.ForEach(a =>
                    {
                        if (id.Amount != null)
                        {
                            a.Amount = id.Amount;
                        }
                        a.ModifyBy = id.ModifyBy;
                        if (id.ModifyDateTime != null)
                        {
                            a.ModifyDateTime = id.ModifyDateTime;
                        }
                        a.PublishedTo = id.PublishedTo;
                        if (id.Summary != null)
                        {
                            a.Summary = id.Summary;
                        }
                        if (id.Title != null)
                        {
                            a.Title = id.Title;
                        }
                        if (id.ProposedReward != "undefined")
                        {
                            a.ProposedReward = id.ProposedReward;
                        }
                    }

                                            );
                    WorkitemStatu workitemstatusData = new WorkitemStatu();
                    string        statusDescription  = "Update";
                    workitemstatusData.StatusDescription = statusDescription;
                    workitemstatusData.WorkitemID        = id.WorkitemID;
                    entities.WorkitemStatus.Add(workitemstatusData);
                    entities.SaveChanges();
                    WorkitemHistory workitemHistoryData = new WorkitemHistory();
                    workitemHistoryData.WorkitemID      = id.WorkitemID;
                    workitemHistoryData.UpdatedBy       = id.ModifyBy;
                    workitemHistoryData.UpdatedDateTIme = DateTime.Now;
                    var getWorkitemStatusID = entities.WorkitemStatus.Where(s => s.WorkitemID == id.WorkitemID).Select(s => s.WorkitemStatusID).FirstOrDefault();
                    workitemHistoryData.WorkitemStatusID = getWorkitemStatusID;
                    entities.WorkitemHistories.Add(workitemHistoryData);
                    entities.SaveChanges();
                }

                return("Success");
            }
            catch (Exception)
            {
                return("Error");
            }
        }
Exemplo n.º 2
0
        public string EditWorkitem(Workitem id)
        {
            try
            {
                using (var entities = new WorkBountyDBEntities())
                {
                    var getWorkitemData = entities.Workitems.Where(x => x.WorkitemID==id.WorkitemID).ToList();
                    getWorkitemData.ForEach(a =>
                    {
                        if(id.Amount!=null) a.Amount = id.Amount;
                         a.ModifyBy = id.ModifyBy;
                        if (id.ModifyDateTime != null) a.ModifyDateTime = id.ModifyDateTime;
                         a.PublishedTo = id.PublishedTo;
                        if (id.Summary != null) a.Summary = id.Summary;
                        if (id.Title != null) a.Title = id.Title;
                        if (id.ProposedReward != "undefined") a.ProposedReward = id.ProposedReward;
                    }

               );
                    WorkitemStatu workitemstatusData = new WorkitemStatu();
                    string statusDescription = "Update";
                    workitemstatusData.StatusDescription = statusDescription;
                    workitemstatusData.WorkitemID = id.WorkitemID;
                    entities.WorkitemStatus.Add(workitemstatusData);
                    entities.SaveChanges();
                    WorkitemHistory workitemHistoryData = new WorkitemHistory();
                    workitemHistoryData.WorkitemID = id.WorkitemID;
                    workitemHistoryData.UpdatedBy = id.ModifyBy;
                    workitemHistoryData.UpdatedDateTIme = DateTime.Now;
                    var getWorkitemStatusID = entities.WorkitemStatus.Where(s => s.WorkitemID == id.WorkitemID).Select(s => s.WorkitemStatusID).FirstOrDefault();
                    workitemHistoryData.WorkitemStatusID = getWorkitemStatusID;
                    entities.WorkitemHistories.Add(workitemHistoryData);
                    entities.SaveChanges();

                }

                return "Success";
            }
            catch (Exception)
            {
                return "Error";
            }
        }