/// <summary>
/// Inserts a new account
/// </summary>
/// <param name="myStory"></param>
/// <returns></returns>
public int InsertURL(youTubeModel myStory)
{
var p = new DynamicParameters();
p.Add("@JakataID", myStory.JakataID);
p.Add("@URL", myStory.URL);
var conString = ConfigurationManager.ConnectionStrings["LocalStory"];
string strConnString = conString.ConnectionString;
int total = 0;
using (System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(strConnString))
{
sqlConnection.Open();
const string storedProcedure = "dbo.InsertURL";
var values = sqlConnection.Query <ReceipeTotalModel>(storedProcedure, p, commandType: CommandType.StoredProcedure);
foreach (var el in values)
{
total = el.totalReceipesInt;
}
}
return(total);
}
public IActionResult InsertURL(youTubeModel myYoutube)
{
GetStories myStories = new GetStories();
int lastRecord = myStories.InsertURL(myYoutube);
MyOder order = new MyOder();
order.MyData = lastRecord.ToString();
return(Ok(order));
}
public HttpResponseMessage DeleteURL(youTubeModel myYoutube)
{
GetStories myStories = new GetStories();
int lastRecord = myStories.DeleteURL(myYoutube);
MyOder order = new MyOder();
order.MyData = lastRecord.ToString();
return(Request.CreateResponse <MyOder>(HttpStatusCode.Created, order));
}
