public IHttpActionResult save([FromBody] titles title)
{
try
{
titles record = (from e in fmp.titles
where e.id == title.id
select e).SingleOrDefault <titles>();
if (record != null)
{
objMapper.Map <titles>(ref record, title);
//fmp.staff.Add(record);
}
else
{
fmp.titles.Add(title);
}
fmp.SaveChanges();
return(Ok("1"));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public ActionResult DeleteConfirmed(string id)
{
titles titles = db.titles.Find(id);
db.titles.Remove(titles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,degree")] titles titles)
{
if (ModelState.IsValid)
{
db.Entry(titles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(titles));
}
public ActionResult Create([Bind(Include = "id,degree")] titles titles)
{
if (ModelState.IsValid)
{
db.titles.Add(titles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(titles));
}
public ActionResult Edit([Bind(Include = "title_id,title,type,pub_id,price,advance,royalty,ytd_sales,notes,pubdate")] titles titles)
{
if (ModelState.IsValid)
{
db.Entry(titles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", titles.pub_id);
ViewBag.title_id = new SelectList(db.roysched, "title_id", "title_id", titles.title_id);
return(View(titles));
}
// GET: titles/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
titles titles = db.titles.Find(id);
if (titles == null)
{
return(HttpNotFound());
}
return(View(titles));
}
// GET: titles/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
titles titles = db.titles.Find(id);
if (titles == null)
{
return(HttpNotFound());
}
ViewBag.pub_id = new SelectList(db.publishers, "pub_id", "pub_name", titles.pub_id);
ViewBag.title_id = new SelectList(db.roysched, "title_id", "title_id", titles.title_id);
return(View(titles));
}
static void Main(string[] args)
{
List <String> MisTitulos = new List <string>();
HtmlWeb cWeb = new HtmlWeb();
using (PruebaTestingEntities1 db = new PruebaTestingEntities1())
{
for (int i = 1; i <= 32; i++)
{
string url = "http://hdeleon.net/";
if (i > 1)
{
url += "/page" + i + "/";
}
HtmlDocument doc = cWeb.Load(url);
foreach (var Nodo in doc.DocumentNode.CssSelect(".entry-title"))
{
var NodoAncho = Nodo.CssSelect("a").First();
var oTitles = new titles();
oTitles.title = NodoAncho.InnerHtml;
db.titles.Add(oTitles);
MisTitulos.Add(NodoAncho.InnerHtml);
}
Console.WriteLine("Se han visitado: " + i + " paginas");
}
db.SaveChanges();
}
}
public ActionResult DeleteConfirmed(string id)
{
var constring = System.Configuration.ConfigurationManager.ConnectionStrings["pubsEntities"].ConnectionString;
if (constring.ToLower().StartsWith("metadata="))
{
System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder efBuilder = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder(constring);
constring = efBuilder.ProviderConnectionString;
}
var con = new SqlConnection(constring);
con.Open();
string query = "SELECT COUNT(*) FROM titleauthor";
var cmd = new SqlCommand(query, con);
int rowsAmount = (int)cmd.ExecuteScalar();
titleauthor titleauthor;
for (int i = 0; i < rowsAmount; i++)
{
titleauthor = db.titleauthor.FirstOrDefault(x => x.title_id == id);
if (titleauthor == null)
{
}
else
{
db.titleauthor.Remove(titleauthor);
db.SaveChanges();
}
}
query = "SELECT COUNT(*) FROM roysched";
cmd = new SqlCommand(query, con);
rowsAmount = (int)cmd.ExecuteScalar();
roysched roysched;
for (int i = 0; i < rowsAmount; i++)
{
roysched = db.roysched.FirstOrDefault(x => x.title_id == id);
if (roysched == null)
{
}
else
{
db.roysched.Remove(roysched);
db.SaveChanges();
}
}
query = "SELECT COUNT(*) FROM sales";
cmd = new SqlCommand(query, con);
rowsAmount = (int)cmd.ExecuteScalar();
sales sales;
for (int i = 0; i < rowsAmount; i++)
{
sales = db.sales.FirstOrDefault(x => x.title_id == id);
if (sales == null)
{
}
else
{
db.sales.Remove(sales);
db.SaveChanges();
}
}
titles titles = db.titles.Find(id);
db.titles.Remove(titles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
