public string Put(Models_Cars mod)
{
try
{
string query = @"update dbo.Models
set ModelName= '" + mod.ModelName + @"'
,Type_Chasi= '" + mod.Type_Chasi + @"'
,DateOfProduction= '" + mod.DateOfProduction + @"'
,PhotoFileName= '" + mod.PhotoFileName + @"'
where ModelId =" + mod.ModelId + @" ";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarsDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Updated Successfully!");
}
catch (Exception)
{
return("Failed to Update!");
}
}
public string Post(Models_Cars mod)
{
try
{
string query = @"insert into dbo.Models values (
'" + mod.ModelName + @"'
,'" + mod.Type_Chasi + @"'
,'" + mod.DateOfProduction + @"'
,'" + mod.PhotoFileName + @"'
)";
DataTable table = new DataTable();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarsDB"].ConnectionString))
using (var cmd = new SqlCommand(query, con))
using (var da = new SqlDataAdapter(cmd))
{
cmd.CommandType = CommandType.Text;
da.Fill(table);
}
return("Added Successfully!");
}
catch (Exception)
{
return("Failed to Add!");
}
}
