public JsonResult Put(MenTrousers trou) { string query = @" update dbo.mentrousers set MenTrousersName = '" + trou.MenTrousersName + @"' ,MenTrousersPrice = '" + trou.MenTrousersPrice + @"' ,MenTrousersQuantity = '" + trou.MenTrousersQuantity + @"' ,MenTrousersPhoto = '" + trou.MenTrousersPhoto + @"' where MenTrousersID = " + trou.MenTrousersID + @" "; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("ClothesAppCon"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Update Successful")); }
public JsonResult Post(MenTrousers trou) { string query = @" insert into dbo.mentrousers (MenTrousersName, MenTrousersPrice, MenTrousersQuantity, MenTrousersPhoto) values ( '" + trou.MenTrousersName + @"' ,'" + trou.MenTrousersPrice + @"' ,'" + trou.MenTrousersQuantity + @"' ,'" + trou.MenTrousersPhoto + @"' )"; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("ClothesAppCon"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Added Successful")); }