//Edit:
public ActionResult Edit(int SellerID) //Hiện thông tin hiện tại của Seller lên View
{
var dao = new SellerDAO();
var seller = dao.ViewDetails(SellerID);
return(View(seller));
}
public void RetrieveData()
{
ConnectionManager connectionManager = new ConnectionManager();
SellerDAO sellerDAO = new SellerDAO();
EnterpriseDAO enterpriseDAO = new EnterpriseDAO();
DirectorDAO directorDAO = new DirectorDAO();
NpgsqlConnection conn = connectionManager.getConnection();
enterpriseDAO.readAll(conn);
sellerDAO.readAll(conn);
directorDAO.readAll(conn);
sellerDAO.setEnterprisesToSellers(enterpriseDAO);
directorDAO.setEnterprisesToDirectors(enterpriseDAO);
listEnterprises = sellerDAO.readEmpresasInUse(listEnterprises);
listEnterprises = directorDAO.readEmpresasInUse(listEnterprises);
listDirectors = directorDAO.listDirectors;
listSellers = sellerDAO.listSellers;
conn.Close();
conn.Dispose();
}
public ActionResult Delete(int sellerID)
{
var dao = new SellerDAO();
dao.DeleteSeller(sellerID);
return(View());
}
// Page: Seller list
public ActionResult Index(int page = 1, int pageSize = 5)
{
var dao = new SellerDAO();
var model = dao.ListAllPaging(page, pageSize);
return(View(model));
}
public UniversalEntity RetrieveSellers()
{
SellerDAO entDAO = new SellerDAO();
sc = new SqlCommand("RetrieveSellers");
sc.CommandType = CommandType.StoredProcedure;
return(entDAO.retrieveEntity(sc));
}
public UniversalEntity RetrieveSellersByDiameter(int d)
{
SellerDAO entDAO = new SellerDAO();
sc = new SqlCommand("RetrieveSellersByDiameter");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@Diameter", d);
return(entDAO.retrieveEntity(sc));
}
private void button1_Click(object sender, EventArgs e) // 로그인
{
int a = 0;
SellerDAO seller = new SellerDAO();
try
{
a = seller.ChkLogin(txtId.Text, txtPwd.Text);
}
catch (Exception)
{
}
public int CreateUser(Seller ent)
{
int createdid = 0;
SellerDAO entDAO = new SellerDAO();
sc = new SqlCommand("CreateSeller");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public bool UpdateSeller(Seller ent)
{
bool success = true;
SellerDAO entDAO = new SellerDAO();
sc = new SqlCommand("UpdateSeller");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@ID", ent.ID);
addParameters(ent);
success = entDAO.updateEntity(sc);
return(success);
}
public ActionResult Create(Seller seller)
{
if (ModelState.IsValid)
{
var dao = new SellerDAO();
long newSellerID = dao.CreateSeller(seller);
if (newSellerID > 0) // SellerID vừa tạo > 0 => Thành công
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Create Fail");
}
}
return(View("Index"));
}
public ActionResult Edit(Seller seller) //Chỉnh sửa thông tin Seller
{
if (ModelState.IsValid)
{
var dao = new SellerDAO();
var result = dao.EditDetails(seller);
if (result)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Edit Fail !!!");
}
}
return(View("Index"));
}
//View Details:
public ActionResult Details(int SellerID)
{
var user = new SellerDAO().ViewDetails(SellerID);
return(View(user));
}
public SellersController(SellerDAO sellerDAO, DepartmentsDAO departmentsDAO)
{
_selerDAO = sellerDAO;
_departmentsDAO = departmentsDAO;
}
