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"));
}
