// POST: api/User
public void Post(HttpRequestMessage request)
{
string body = request.Content.ReadAsStringAsync().Result;
ptUser d = JsonConvert.DeserializeObject<ptUser>(body);
string sql = "INSERT INTO [pubtrack].[tblUsers]([UserId],[FirstName],[LastName],[Active]) VALUES ('" +
d.UserId + "','" + d.FirstName + "','" + d.LastName + "','" + d.Active.ToString() + "');";
ptsHelper.ExcecuteSql(sql);
}
// PUT: api/User/5
public void Put(string id, HttpRequestMessage request)
{
string body = request.Content.ReadAsStringAsync().Result;
ptUser d = JsonConvert.DeserializeObject<ptUser>(body);
string sql = "UPDATE [pubtrack].[tblUsers] SET [FirstName] = '" +
d.FirstName + "', [LastName] = '" + d.LastName+ "',[Active] = '" + d.Active.ToString() +
"' WHERE UserId = '" + d.UserId + "';";
ptsHelper.ExcecuteSql(sql);
}
// POST api/<controller>
public void Post(HttpRequestMessage request)
{
string json = File.ReadAllText(path);
var items = JsonConvert.DeserializeObject <List <ptUser> >(json);
string body = request.Content.ReadAsStringAsync().Result;
ptUser newPub = JsonConvert.DeserializeObject <ptUser>(body);
items.Add(newPub);
File.WriteAllText(path, JsonConvert.SerializeObject(items));
}
public ActionResult Edit(string id, [Bind(Include = "UserId,LastName,FirstName,Active")] ptUser User)
{
if (Pubtracker2FrontEnd.ptHelper.Edit <ptUser>(id, "users", User))
{
return(RedirectToAction("Index"));
}
else
{
return(View(User));
}
}
public ActionResult Create([Bind(Include = "UserId,LastName,FirstName,Active")] ptUser User)
{
if (Pubtracker2FrontEnd.ptHelper.Create <ptUser>("users", User))
{
return(RedirectToAction("Index"));
}
else
{
return(View(User));
}
}
// PUT api/<controller>/5
public void Put(string id, HttpRequestMessage request)
{
string json = File.ReadAllText(path);
var items = JsonConvert.DeserializeObject <List <ptUser> >(json);
string body = request.Content.ReadAsStringAsync().Result;
ptUser updatedPub = JsonConvert.DeserializeObject <ptUser>(body);
int index = items.IndexOf(items.Find(x => x.UserId == id));
if (index != -1)
{
items[index] = updatedPub;
}
File.WriteAllText(path, JsonConvert.SerializeObject(items));
}
}//End GetAll Types
public static List<ptUser> GetAllUsers()
{
List<ptUser> items = new List<ptUser>();
string sql = "Select * from pubtrack.tblUsers;";
DataSet ds = ExecuteSPDataSetText(sql, conn);
foreach (DataRow r in ds.Tables[0].Rows)
{
ptUser item = new ptUser();
item.UserId = r["UserId"].ToString();
item.FirstName = r["FirstName"].ToString();
item.LastName = r["LastName"].ToString();
item.Active = Convert.ToBoolean(r["Active"].ToString());
items.Add(item);
}
return items;
}//End GetAll Users
// GET: api/User/5
public string Get(string id)
{
ptUser item = ptsHelper.GetAllUsers().Find(x => x.UserId == id);
return JsonConvert.SerializeObject(item);
}
