Пример #1
0
        // GET: api/Publications/5
        public string Get(string id)
        {
            List <ptPublication> items = ptsHelper.GetAllPublications();
            ptPublication        item  = items.Find(x => x.PublicationId == id);

            return(JsonConvert.SerializeObject(item));
        }
Пример #2
0
        // POST: api/Publications
        public void Post(HttpRequestMessage request)
        {
            string        json   = File.ReadAllText(path);
            var           items  = JsonConvert.DeserializeObject <List <ptPublication> >(json);
            string        body   = request.Content.ReadAsStringAsync().Result;
            ptPublication newPub = JsonConvert.DeserializeObject <ptPublication>(body);

            items.Add(newPub);
            File.WriteAllText(path, JsonConvert.SerializeObject(items));
        }
Пример #3
0
        // PUT: api/Publications/5
        public void Put(string id, HttpRequestMessage request)
        {
            string        json       = File.ReadAllText(path);
            var           items      = JsonConvert.DeserializeObject <List <ptPublication> >(json);
            string        body       = request.Content.ReadAsStringAsync().Result;
            ptPublication updatedPub = JsonConvert.DeserializeObject <ptPublication>(body);
            int           index      = items.IndexOf(items.Find(x => x.PublicationId == id));

            if (index != -1)
            {
                items[index] = updatedPub;
            }
            File.WriteAllText(path, JsonConvert.SerializeObject(items));
        }
Пример #4
0
        // POST: api/Publications
        public void Post(HttpRequestMessage request)
        {
            string        body = request.Content.ReadAsStringAsync().Result;
            ptPublication p    = JsonConvert.DeserializeObject <ptPublication>(body);
            string        sql  = "INSERT INTO [pubtrack].[Publication]([PublicationId],[SortId],[Title],[Type],[Series],[Division],[Roles],[Statuses],[Remarks]) VALUES('" +
                                 p.PublicationId + "'," +
                                 Convert.ToInt32(p.SortId) + ",'" +
                                 p.Title + "','" +
                                 JsonConvert.SerializeObject(p.Type) + "','" +
                                 p.Series + "','" +
                                 JsonConvert.SerializeObject(p.Division) + "','" +
                                 JsonConvert.SerializeObject(p.Roles) + "','" +
                                 JsonConvert.SerializeObject(p.Statuses) + "','" +
                                 p.Remarks + "');";

            ptsHelper.ExcecuteSql(sql);
        }
Пример #5
0
        // PUT: api/Publications/5
        public void Put(string id, HttpRequestMessage request)
        {
            string        body = request.Content.ReadAsStringAsync().Result;
            ptPublication p    = JsonConvert.DeserializeObject <ptPublication>(body);
            string        sql  = "UPDATE [pubtrack].[Publication] SET " +
                                 "[SortId] = " + Convert.ToInt32(p.SortId) +
                                 ",[Title] = '" + p.Title +
                                 "',[Type] = '" + JsonConvert.SerializeObject(p.Type) +
                                 "',[Series] = '" + p.Series +
                                 "',[Division] = '" + JsonConvert.SerializeObject(p.Division) +
                                 "',[Roles] = '" + JsonConvert.SerializeObject(p.Roles) +
                                 "',[Statuses] = '" + JsonConvert.SerializeObject(p.Statuses) +
                                 "',[Remarks] = '" + p.Remarks +
                                 "' WHERE [PublicationId] = '" + p.PublicationId +
                                 "';";

            ptsHelper.ExcecuteSql(sql);
        }
Пример #6
0
        }//End GetAll Users

        public static List<ptPublication> GetAllPublications()
        {
            List<SqlParameter> myParameters = new List<SqlParameter>();
            List<ptPublication> items = new List<ptPublication>();
            string sql = "Select * from pubtrack.Publication;";
            DataSet ds = ExecuteSPDataSetText(sql, conn);
            foreach (DataRow r in ds.Tables[0].Rows)
            {
                ptPublication item = new ptPublication();
                item.PublicationId = r["PublicationId"].ToString();
                item.SortId = Convert.ToInt32(r["SortId"].ToString());
                item.Title = r["Title"].ToString();
                item.Type = JsonConvert.DeserializeObject<ptType>(r["Type"].ToString());
                item.Series = r["Series"].ToString();
                item.Division = JsonConvert.DeserializeObject<ptDivision>(r["Division"].ToString());
                item.Roles = JsonConvert.DeserializeObject<List<ptRoles>>(r["Roles"].ToString());
                item.Statuses = JsonConvert.DeserializeObject<List<ptStatus>>(r["Statuses"].ToString());
                item.Remarks = r["Remarks"].ToString();
                items.Add(item);
            }
            return items;
        }//End GetAll