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