public JsonResult Put(WomenTrousers trou) { string query = @" update dbo.womentrousers set WomenTrousersName = '" + trou.WomenTrousersName + @"' ,WomenTrousersPrice = '" + trou.WomenTrousersPrice + @"' ,WomenTrousersQuantity = '" + trou.WomenTrousersQuantity + @"' ,WomenTrousersPhoto = '" + trou.WomenTrousersPhoto + @"' where WomenTrousersID = " + trou.WomenTrousersID + @" "; 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(WomenTrousers trou) { string query = @" insert into dbo.womentrousers (WomenTrousersName, WomenTrousersPrice, WomenTrousersQuantity, WomenTrousersPhoto) values ( '" + trou.WomenTrousersName + @"' ,'" + trou.WomenTrousersPrice + @"' ,'" + trou.WomenTrousersQuantity + @"' ,'" + trou.WomenTrousersPhoto + @"' )"; 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")); }