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