protected void btnSave_Click(object sender, EventArgs e) { ProducerDAO dao = new ProducerDAO(); if (mode == "add") { Producer producer = new Producer(); producer.ProducerID = inProducerID.Value; producer.ProducerName = inProducerName.Value; producer.ProducerContact = inProducerContact.Value; producer.ProducerAddress = inProducerAddress.Value; dao.addProducer(producer); } if (mode == "edit") { Producer producer = new Producer(); producer.ProducerID = inProducerID.Value; producer.ProducerName = inProducerName.Value; producer.ProducerContact = inProducerContact.Value; producer.ProducerAddress = inProducerAddress.Value; dao.updateProducer(producer); } init(); emptyForm(); }
private void bindData() { ProducerDAO dao = new ProducerDAO(); DataTable dt = dao.toDataTable(); grdNhaXuatBan.DataSource = dt; grdNhaXuatBan.DataBind(); }
protected void btnAdd_Click(object sender, EventArgs e) { ProducerDAO dao = new ProducerDAO(); String newID = dao.genMaxID(); mode = "add"; inProducerID.Value = newID; setButtonEnable(false, false, true, true, false); }
protected void parseData() { ProducerDAO dao = new ProducerDAO(); Producer producer = dao.getProducerByID(grdNhaXuatBan.SelectedRow.Cells[1].Text); inProducerID.Value = producer.ProducerID; inProducerName.Value = producer.ProducerName; inProducerContact.Value = producer.ProducerContact; inProducerAddress.Value = producer.ProducerAddress; }
public IHttpActionResult Get(int id) { var b = new ProducerDAO().Take(id); // Lay phan tu voi id tuong ung if (b == null) { return(NotFound()); } return(Ok(b)); }
public IHttpActionResult Post([FromUri] JObject jsonResult) { if (!ModelState.IsValid) // Kiem tra tinh hop le cua giu lieu { return(BadRequest(ModelState)); } var x = JsonConvert.DeserializeObject <ProducerDTO>(jsonResult.ToString()); var last = new ProducerDAO().Add(x); return(Ok(last)); }
public IHttpActionResult Delete(int id) { var dao = new ProducerDAO(); if (!dao.isExist(id)) // Kiem tra xem id co hop le hay khong { return(NotFound()); } var check = dao.Delete(id); // Kiem tra viec thuc hien Delete return(Ok(check)); }
public ActionResult Update(Producer producer) { var Upp = new ProducerDAO().Update1(producer); if (Upp == 1) { return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
protected void btnDelete_Click(object sender, EventArgs e) { ProducerDAO dao = new ProducerDAO(); Producer producer = new Producer(); producer.ProducerID = inProducerID.Value; producer.ProducerName = inProducerName.Value; producer.ProducerContact = inProducerContact.Value; producer.ProducerAddress = inProducerAddress.Value; dao.deleteProducer(producer); init(); bindData(); }
public IHttpActionResult Put([FromBody] JObject jsonResult) { if (!ModelState.IsValid) // Kiem tra tinh hop le cua giu lieu { return(BadRequest(ModelState)); } var x = JsonConvert.DeserializeObject <ProducerDTO>(jsonResult.ToString()); // Ep kieu Json sang DTO var dao = new ProducerDAO(); if (!dao.isExist(x.ID)) // Kiem tra id co hop le khong { return(NotFound()); } dao.Update(x); // Cap nhat return(Ok()); }
public IHttpActionResult GetAllUsers(int?number) { IEnumerable <ProducerDTO> ls; if (number == null) { ls = new ProducerDAO().List(); } else { ls = new ProducerDAO().List().Take((int)number); } if (ls == null) { return(NotFound()); } return(Ok(ls)); }
private void getCombobox() { AuthorDAO aDAO = new AuthorDAO(); DataTable dt1 = aDAO.ToDataTable(); DataRow empty1 = dt1.NewRow(); empty1["Mã Tác giả"] = "empty"; empty1["Tên Tác giả"] = "--Chọn--"; empty1["Liên lạc"] = ""; dt1.Rows.InsertAt(empty1, 0); inAuthor.DataSource = dt1; inAuthor.DataTextField = "Tên Tác giả"; inAuthor.DataValueField = "Mã Tác giả"; inAuthor.DataBind(); CategoryDAO cDAO = new CategoryDAO(); DataTable dt2 = cDAO.ToDataTable(); DataRow empty2 = dt2.NewRow(); empty2["Mã Thể loại"] = "empty"; empty2["Tên Thể loại"] = "--Chọn--"; empty2["Mô tả"] = ""; dt2.Rows.InsertAt(empty2, 0); inCategory.DataSource = dt2; inCategory.DataTextField = "Tên Thể loại"; inCategory.DataValueField = "Mã Thể loại"; inCategory.DataBind(); ProducerDAO pDAO = new ProducerDAO(); DataTable dt3 = pDAO.toDataTable(); DataRow empty3 = dt3.NewRow(); empty3["Mã Nhà xuất bản"] = "empty"; empty3["Tên Nhà xuất bản"] = "--Chọn--"; empty3["Liên Hệ"] = ""; empty3["Địa Chỉ"] = ""; dt3.Rows.InsertAt(empty3, 0); inProducer.DataSource = dt3; inProducer.DataTextField = "Tên Nhà xuất bản"; inProducer.DataValueField = "Mã Nhà xuất bản"; inProducer.DataBind(); }
public ActionResult insertProducers(FormCollection formCollection) { foreach (string key in formCollection.AllKeys) { Response.Write("Key = " + key + " "); Response.Write(formCollection[key] + "</br>"); } ProducerDAO pDAO = new ProducerDAO(); string P_Name = formCollection["P_Name"]; int id_N = Convert.ToInt32(formCollection["id_N"]); string Description = formCollection["Description"]; DateTime Birthday = Convert.ToDateTime(formCollection["Birthday"]); string PhoneNumber = formCollection["PhoneNumber"]; string Address = formCollection["Address"]; string Email = formCollection["Email"]; pDAO.CreateProducer(P_Name, id_N, Description, Birthday, Address, PhoneNumber, Email, true); return(View()); }
public ActionResult Delete(int id) { var del1 = new ProducerDAO().Delete(id); return(RedirectToAction("Index", new { currentPage = 1 })); }