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