// GET api/<controller>
public IEnumerable<Vaccin> Get()
{
// return new string[] { "value1", "value2" };
string query = "select * from vaccineinfo";
DataSet aSet = aGateway.Select(query);
List<Vaccin> vaList = new List<Vaccin>();
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
Vaccin aVaccin = new Vaccin();
aVaccin.ID = Convert.ToInt32(dataRow["ID"].ToString());
aVaccin.Name = dataRow["VaccineName"].ToString();
aVaccin.StartDay = Convert.ToInt32(dataRow["StartDay"].ToString());
aVaccin.EndDay = Convert.ToInt32(dataRow["EndDay"].ToString());
aVaccin.Description = dataRow["Description"].ToString();
vaList.Add(aVaccin);
}
return vaList;
}
// GET api/<controller>/5
public Vaccin Get(int id)
{
string query = "select * from vaccineinfo where ID=@id";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("id", id);
DataSet aSet = aGateway.Select(query,aHashtable);
// List<Vaccin> vaList = new List<Vaccin>();
Vaccin aVaccin = new Vaccin();
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
aVaccin.ID = Convert.ToInt32(dataRow["ID"].ToString());
aVaccin.Name = dataRow["VaccineName"].ToString();
aVaccin.StartDay = Convert.ToInt32(dataRow["StartDay"].ToString());
aVaccin.EndDay = Convert.ToInt32(dataRow["EndDay"].ToString());
aVaccin.Description = dataRow["Description"].ToString();
}
return aVaccin;
}
//// POST api/<controller>
//public void Post([FromBody]string value)
//{
//}
// POST api/employee
public HttpResponseMessage Post(Vaccin aVaccin)
{
if (ModelState.IsValid)
{
//db.Employees.Add(model);
//db.SaveChanges();
string query = "INSERT INTO vaccineinfo (VaccineName, StartDay, EndDay,Description) VALUES (@name, @start_day, @end_day,@description);";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("name", aVaccin.Name);
aHashtable.Add("start_day", aVaccin.StartDay);
aHashtable.Add("end_day", aVaccin.EndDay);
aHashtable.Add("description", aVaccin.Description);
aGateway.Insert(query, aHashtable);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, aVaccin);
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
// PUT api/Vaccination/5
//public void Put(int id, [FromBody]string value)
//{
//}
public HttpResponseMessage Put(Vaccin aVaccin)
{
if (ModelState.IsValid)
{
//db.Entry(model).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
//UPDATE `tikaappdb`.`vaccination` SET `start_day`=30 WHERE `id`=2;
string query1 = "UPDATE vaccineinfo SET VaccineName=@name, StartDay=@start_day, EndDay=@end_time,Description=@description WHERE ID=@id;";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("name",aVaccin.Name);
aHashtable.Add("start_day", aVaccin.StartDay);
aHashtable.Add("end_time", aVaccin.EndDay);
aHashtable.Add("id", aVaccin.ID);
aHashtable.Add("description", aVaccin.Description);
aGateway.Update(query1,aHashtable);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, aVaccin);
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}