示例#1
0
        public void CreateBug(DataMembers obj)
        {
            HttpContext context = HttpContext.Current;
            string virtPath = HttpContext.Current.Server.MapPath(".");
            string path = virtPath + "\\App_Data\\" + "XMLFile1.xml";

            XDocument xdoc = XDocument.Load(path);
            XElement BugElement = new XElement("Bug");
            XElement BugWorkPack = new XElement("BugWorkPack");
            BugWorkPack.Value = obj.Worpackage;
            XElement BugTitle = new XElement("BugTitle");
            BugTitle.Value = obj.Title;
            XElement BugDate = new XElement("BugDate");
            BugDate.Value = obj.Date.ToString();
            XElement BugIssue = new XElement("BugIssue");
            BugIssue.Value = obj.Text;
            XElement BugResolution = new XElement("BugResolution");
            BugResolution.Value = obj.Resolution;
            Guid Id = Guid.NewGuid();
            XElement BugId = new XElement("BugId");
            BugId.Value = Convert.ToString(Id);
            BugElement.Add(BugId);
            BugElement.Add(BugWorkPack);
            BugElement.Add(BugTitle);
            BugElement.Add(BugDate);
            BugElement.Add(BugIssue);
            BugElement.Add(BugResolution);
            xdoc.Element("BugReport").Add(BugElement);
            xdoc.Save(path);
        }
示例#2
0
       public bool Create(DataMembers obj)
        {

            StatusReport StatusTable = new StatusReport();
            StatusTable.StatusText = obj.Text;
            StatusTable.StatusTitle = obj.Title;
            StatusTable.WorkPacRefId = obj.WorkPacId;
            StatusTable.StatusDate = obj.Date;
            var _req = from req in ent.WorkPacRefs
            select req;
            foreach (WorkPacRef w in _req)
            {
                if (obj.WorkPacId == w.WorkPacRefId)
                {
                    ent.StatusReports.InsertOnSubmit(StatusTable);
                    ent.SubmitChanges();
                    return true;
                }
                else
                {
                   
                }
            }
            return false;
         }
示例#3
0
        public StatusDisp disp()
        {
            StatusDisp temp = new StatusDisp();
            var _req = from req in ent.StatusReports
                       select req;
            foreach (StatusReport p in _req)
            {
                DataMembers pp = new DataMembers();
                pp.Date = p.StatusDate;
                pp.Text = p.StatusText;
                pp.Title = p.StatusTitle;
                pp.WorkPacId = p.WorkPacRefId;
                pp.Id = p.StatusId;
                temp.report.Add(pp);
            }

            return temp;
        }
示例#4
0
        public void BugEditSave(DataMembers obj)
        {
             DataMembers bug = new DataMembers();
             try
             {
                 HttpContext context = HttpContext.Current;
                 string path = context.Server.MapPath("~\\App_Data\\XMLFile1.xml");

                 XDocument doc = XDocument.Load(path);
                 var query = from row in doc.Elements("BugReport").Elements("Bug") select row;
                 foreach (var q in query)
                 {
                     bug.bugid = q.Element("BugId").Value;
                     if (bug.bugid == obj.bugid)
                     {

                         q.SetElementValue("BugWorkPack", obj.Worpackage);
                         q.SetElementValue("BugTitle", obj.Title);
                         q.SetElementValue("BugDate", obj.Date);
                         q.SetElementValue("BugIssue", obj.Text);
                         q.SetElementValue("BugResolution", obj.Resolution);

                     }
                     doc.Save(path);
                 }
             }
            catch(Exception)
             {
                 
             }

        }
示例#5
0
        public DataMembers BugEditing(string id)
        {
            DataMembers bug = new DataMembers();
            try
            {

                HttpContext context = HttpContext.Current;
                string path = context.Server.MapPath("~\\App_Data\\XMLFile1.xml");

                XDocument doc = XDocument.Load(path);
                var query = from row in doc.Elements("BugReport").Elements("Bug") select row;
                foreach (var elem in query)
                {
                    string i = elem.Element("BugId").Value;
                    bug.bugid = i;
                    if (bug.bugid == id)
                    {

                        bug.Worpackage = elem.Element("BugWorkPack").Value;
                        bug.Title = elem.Element("BugTitle").Value;
                        bug.Date = Convert.ToDateTime(elem.Element("BugDate").Value);
                        bug.Text = elem.Element("BugIssue").Value;
                        bug.Resolution = elem.Element("BugResolution").Value;
                        }
                }

            }
            catch (Exception) 
            {
                return null;
            }
            return bug;
        }
示例#6
0
        public List<DataMembers> LoadWorkPackId()
        {

            List<DataMembers> list = new List<DataMembers>();
            var query = from row in ent.WorkPacRefs
                        select new DataMembers
                        {
                            Id = row.WorkPacRefId

                        };
            foreach (var q in query)
            {
                DataMembers data = new DataMembers();
                data.Id = q.Id;
                list.Add(data);
            }
            return list;
        }
示例#7
0
        public List<DataMembers> LoadStatusId()
        {

            List<DataMembers> list = new List<DataMembers>();
            var query = from row in ent.StatusReports
                        select new DataMembers
                        {
                            Id = row.StatusId

                        };
            foreach (var q in query)
            {
                DataMembers data = new DataMembers();
                data.Id = q.Id;
                list.Add(data);
            }
            return list;

        }
示例#8
0
       public void saveEdit(DataMembers obj)
        {
            var edit = ent.StatusReports.Single(c => c.StatusId == obj.Id);

            edit.StatusTitle = obj.Title;
            edit.StatusText = obj.Text;
            edit.StatusDate = obj.Date;
            edit.WorkPacRefId = obj.WorkPacId;
            ent.SubmitChanges();
        }
示例#9
0
        public DataMembers Edit(int Id)
        {
            StatusReport StatusTable = new StatusReport();
            DataMembers data = new DataMembers();
            var _edit = from req in ent.StatusReports
                        where req.StatusId == Id
                        select req;

            data.Title = _edit.First().StatusTitle;
            data.Text = _edit.First().StatusText;
            data.Date = _edit.First().StatusDate;
            data.WorkPacId = _edit.First().WorkPacRefId;
            return data;

        }