public IHttpActionResult PostCatagoryTable(CatagoryTable catagoryTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CatagoryTables.Add(catagoryTable);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (CatagoryTableExists(catagoryTable.CatagoryID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = catagoryTable.CatagoryID }, catagoryTable));
}
public IHttpActionResult PutCatagoryTable(string id, CatagoryTable catagoryTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != catagoryTable.CatagoryID)
{
return(BadRequest());
}
db.Entry(catagoryTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CatagoryTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetCatagoryTable(string id)
{
CatagoryTable catagoryTable = db.CatagoryTables.Find(id);
if (catagoryTable == null)
{
return(NotFound());
}
return(Ok(catagoryTable));
}
public IHttpActionResult DeleteCatagoryTable(string id)
{
CatagoryTable catagoryTable = db.CatagoryTables.Find(id);
if (catagoryTable == null)
{
return(NotFound());
}
db.CatagoryTables.Remove(catagoryTable);
db.SaveChanges();
return(Ok(catagoryTable));
}
private void add()
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
CatagoryTable dt = new CatagoryTable();
dt.Name = textBox2.Text;
db.CatagoryTables.InsertOnSubmit(dt);
db.SubmitChanges();
MessageBox.Show("Succesfully added!\n");
textBox2.Text = "";
}
catch
{
MessageBox.Show("invalid input");
}
}
private void update()
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
CatagoryTable q = (from CatagoryTable in db.CatagoryTables
where CatagoryTable.Id == Int32.Parse(domainUpDown1.Text)
select CatagoryTable).Single();
q.Name = textBox2.Text;
db.SubmitChanges();
MessageBox.Show("Succesfully updated!\n");
textBox2.Text = "";
}
catch
{
MessageBox.Show("invalid input");
}
}
