public ActionResult <Address> Post([FromBody] Address adr)
{
//return Ok(AddressDAO.Create(adr));
Address found = AddressDAO.Create(adr);
return(found != null ? (ActionResult <Address>)Ok(found) : NotFound("This address is already exist"));
}
private void btnActualizarDireccion_Click(object sender, EventArgs e)
{
try
{
if (txtNewAddress.Text.Length > 5)
{
int id = Convert.ToInt32(cmbAddress.SelectedValue.ToString());
AddressDAO.ActualizarDire(id, txtNewAddress.Text);
MessageBox.Show("Se actualizó la dirección", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Information);
txtAddress.Clear();
actualizarDatos();
}
else
{
MessageBox.Show("Verifique los datos ingresados", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception)
{
MessageBox.Show("Verifique los datos ingresados", "Hugo App",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public User CreateUserAndAddress(UserAndAddress user)
{
Address adr = AddressDAO.Create(user.Address);
user.User.Idadr = adr.Id;
return(UserDAO.Create(user.User));
}
private void frmUsuario_Load(object sender, EventArgs e)
{
cmbAddress.DataSource = null;
cmbAddress.ValueMember = "idAddress";
cmbAddress.DisplayMember = "address";
cmbAddress.DataSource = AddressDAO.GetLista();
dgAddress.DataSource = null;
dgAddress.DataSource = AddressDAO.GetLista();
cmbProductos.DataSource = null;
cmbProductos.ValueMember = "idProduct";
cmbProductos.DisplayMember = "name";
cmbProductos.DataSource = ProducDAO.GetLista();
cmbDirecciones.DataSource = null;
cmbDirecciones.ValueMember = "idAddress";
cmbDirecciones.DisplayMember = "address";
cmbDirecciones.DataSource = AddressDAO.GetLista();
dgOrders.DataSource = null;
dgOrders.DataSource = AppOrderDAO.GetLista();
cmbOrders.DataSource = null;
cmbOrders.ValueMember = "idOrder";
cmbOrders.DisplayMember = "product";
cmbOrders.DataSource = AppOrderDAO.GetLista();
}
public Place CreatePlaceAndAddress(PlaceAndAddress place)
{
Address adr = AddressDAO.Create(place.Address);
place.Place.IdAdr = adr.Id;
return(PlaceDAO.Create(place.Place));
}
private void updatePublicControls()
{
List <Address> listA = AddressDAO.getUserList(user.idUser);
List <Product> listP = ProductDAO.getList();
List <Order> listO = OrderDAO.getUserList(user.idUser);
comboBox1.DataSource = null;
comboBox1.DisplayMember = "address";
comboBox1.ValueMember = "idaddress";
comboBox1.DataSource = listA;
comboBox6.DataSource = null;
comboBox6.DisplayMember = "name";
comboBox6.ValueMember = "idproduct";
comboBox6.DataSource = listP;
comboBox7.DataSource = null;
comboBox7.DisplayMember = "address";
comboBox7.ValueMember = "idaddress";
comboBox7.DataSource = listA;
comboBox8.DataSource = null;
comboBox8.DisplayMember = "idorder";
comboBox8.ValueMember = "idorder";
comboBox8.DataSource = listO;
dataGridView5.DataSource = null;
dataGridView5.DataSource = listA;
dataGridView4.DataSource = null;
dataGridView4.DataSource = listO;
}
private void btnAddAddress_Click(object sender, EventArgs e)
{
Address a = new Address();
a.idUser = user.id_User;
a.address = textBox4.Text;
try
{
AddressDAO.addAddress(a);
MessageBox.Show($"Dirección agregada exitosamente!",
"HugoApp - Food Delivery",
MessageBoxButtons.OK, MessageBoxIcon.Information);
btnClearAddress_Click(sender, e);
actualizarControlesCommon();
actualizarTablasCommon();
}
catch (Exception exception)
{
MessageBox.Show("Error: " + exception.Message, "Error dialog",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void actualizarControlesCommon()
{
List <Address> listaA = AddressDAO.getLista(user.id_User);
cmbAddressId.DataSource = null;
cmbAddressId.DisplayMember = "idAddress";
cmbAddressId.ValueMember = "idAddress";
cmbAddressId.DataSource = listaA;
cmbAiD.DataSource = null;
cmbAiD.DisplayMember = "idAddress";
cmbAiD.ValueMember = "idAddress";
cmbAiD.DataSource = listaA;
List <Business> listaB = BusinessDAO.getLista();
cmbBiD2.DataSource = null;
cmbBiD2.DisplayMember = "idBusiness";
cmbBiD2.ValueMember = "idBusiness";
cmbBiD2.DataSource = listaB;
List <Product> listaP = ProductDAO.getLista();
cmbPiD.DataSource = null;
cmbPiD.DisplayMember = "idProduct";
cmbPiD.ValueMember = "idProduct";
cmbPiD.DataSource = listaP;
List <AppOrder> listaO = AppOrderDAO.getListaUser(user.id_User);
cmbOrderiD.DataSource = null;
cmbOrderiD.DisplayMember = "idOrder";
cmbOrderiD.ValueMember = "idOrder";
cmbOrderiD.DataSource = listaO;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.Length >= 5)
{
AddressDAO.crearaddress(usuario.iduser, textBox1.Text);
MessageBox.Show("¡Dirección Agregada Exitosamente!",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Clear();
actualizarControles();
}
else
{
MessageBox.Show("Favor digite una dirección mas detallada (longitud minima, 10 caracteres)",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception)
{
MessageBox.Show("La dirección no se encuentra disponible",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void actualizarControles()
{
cmbUpdateAddr.DataSource = null;
cmbUpdateAddr.ValueMember = "IdAddress";
cmbUpdateAddr.DisplayMember = "Addr";
cmbUpdateAddr.DataSource = AddressDAO.getLista(user);
}
/// <summary>
/// 创建收件人地址绑定表
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
private DataTable createReceiveAddrTable(string name)
{
DataTable table = new DataTable();
DataColumn dc = new DataColumn("address", typeof(string));
table.Columns.Add(dc);
dc = new DataColumn("addr_id", typeof(int));
table.Columns.Add(dc);
DataTable addr_table = new AddressDAO().getReceiveAddressTable(name);
DataRow dr = table.NewRow();
dr["addr_id"] = -1;
dr["address"] = "从地址簿中选择地址";
table.Rows.Add(dr);
for (int i = 0; i < addr_table.Rows.Count; i++)
{
dr = table.NewRow();
dr["addr_id"] = addr_table.Rows[i]["addr_id"];
dr["address"] = addr_table.Rows[i]["addr_contact"].ToString() + " " + addr_table.Rows[i]["addr_line1"] + addr_table.Rows[i]["addr_line2"] + addr_table.Rows[i]["addr_line3"] + " " + addr_table.Rows[i]["city"] + " " + addr_table.Rows[i]["post_code"] + addr_table.Rows[i]["country"] + " " + addr_table.Rows[i]["phone"];
table.Rows.Add(dr);
}
return(table);
}
public ActionResult EditAddress(int id)
{
var addressDAO = new AddressDAO();
Address address = addressDAO.getAddressEdit(id);
return(View(address));
}
private void actualizarTablasCommon()
{
dGAdress.DataSource = null;
dGAdress.DataSource = AddressDAO.getLista(user.id_User);
dGUserOrders.DataSource = null;
dGUserOrders.DataSource = AppOrderDAO.getListaUser(user.id_User);
}
public void SetViewBagAddress(int?selectedIDAddress = null)
{
int idCustomer = Int32.Parse(Session["IDCustomer"].ToString());
var addressDAO = new AddressDAO();
var listAddress = addressDAO.getAddress(idCustomer);
ViewBag.IDAddress = new SelectList(listAddress, "IDAddress", "AddressName", selectedIDAddress);
}
public static AddressDAO Address_AddressDAO(CustomerAddress s)
{
var e = new AddressDAO();
e.ID = s.AddressID;
e.Address = s.CustomerAddress1;
return(e);
}
public ActionResult AddressPartial()
{
int idCustomer = Int32.Parse(Session["IDCustomer"].ToString());
var addressDAO = new AddressDAO();
IEnumerable <Address> listAddress = addressDAO.getAddress(idCustomer);
return(PartialView(listAddress));
}
public static CustomerAddress AddressDAO_Address(AddressDAO s)
{
var e = new CustomerAddress();
e.AddressID = s.ID;
e.CustomerAddress1 = s.Address;
return(e);
}
public ActionResult DeleteAddress(int id)
{
var addressDAO = new AddressDAO();
addressDAO.deleteIDAddressinContact(id);
addressDAO.deleteAddress(id);
return(RedirectToAction("Address", "Address"));
}
void actualizarDatos()
{
cmbAddress.DataSource = AddressDAO.GetLista();
dgAddress.DataSource = AddressDAO.GetLista();
cmbProductos.DataSource = ProducDAO.GetLista();
cmbDirecciones.DataSource = AddressDAO.GetLista();
dgOrders.DataSource = AppOrderDAO.GetLista();
cmbOrders.DataSource = AppOrderDAO.GetLista();
}
private void actualizarControles()
{
List <Usuario> usu = UsuarioDAO.getLista();
List <Address> addr = AddressDAO.addresslist();
List <Order> ord = OrderDAO.orderlist();
List <Enterprise> ent = EnterpriseDAO.businesslist();
List <Product> prod = ProductDAO.productlist();
List <Address> propaddress = AddressDAO.idaddresslist(usuario.iduser);
List <Order> proporder = OrderDAO.iduserorder(usuario.iduser);
dataGridView1.DataSource = null;
dataGridView1.DataSource = propaddress;
dataGridView2.DataSource = null;
dataGridView2.DataSource = proporder;
comboBox1.DataSource = null;
comboBox1.DisplayMember = "idaddress";
comboBox1.DataSource = addr;
comboBox2.DataSource = null;
comboBox2.DisplayMember = "idaddress";
comboBox2.DataSource = addr;
comboBox3.DataSource = null;
comboBox3.DisplayMember = "idproduct";
comboBox3.DataSource = prod;
comboBox4.DataSource = null;
comboBox4.DisplayMember = "idorder";
comboBox4.DataSource = ord;
comboBox5.DataSource = null;
comboBox5.DisplayMember = "idbusiness";
comboBox5.DataSource = ent;
comboBox6.DataSource = null;
comboBox6.DisplayMember = "idbusiness";
comboBox6.DataSource = ent;
comboBox7.DataSource = null;
comboBox7.DisplayMember = "idproduct";
comboBox7.DataSource = prod;
comboBox8.DataSource = null;
comboBox8.DisplayMember = "idaddress";
comboBox8.DataSource = addr;
comboBox9.DataSource = null;
comboBox9.DisplayMember = "iduser";
comboBox9.DataSource = usu;
}
private void button3_Click(object sender, EventArgs e)
{
AddressDAO.actualizaraddress(comboBox1.Text, textBox2.Text);
MessageBox.Show("¡Dirección actualizada exitosamente!",
"CEGE-APP", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
public ActionResult CreateAddress(Address model)
{
if (ModelState.IsValid)
{
var addressDAO = new AddressDAO();
addressDAO.insertAddress(model, Int32.Parse(Session["IDCustomer"].ToString()));
return(RedirectToAction("Address", "Address"));
}
ModelState.AddModelError("", "Please enter the address name");
return(View());
}
public static AddressDAO MapToAddressDAO(AddressDTO b)
{
var a = new AddressDAO();
a.City = b.City;
a.State = b.State;
a.Street = b.Street;
a.Zip = b.Zip;
return(a);
}
public ActionResult EditAddress(Address model)
{
if (!ModelState.IsValid)
{
var addressDAO = new AddressDAO();
addressDAO.updateAddress(model);
return(RedirectToAction("Address", "Address"));
}
ModelState.AddModelError("", "Please enter the new address name");
return(View());
}
private void btnAddSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que desea editar la direccion ?",
"Hugo App", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
AddressDAO.addAddress(user.IdUser, txtAddrUpdate.Text);
MessageBox.Show("¡Direccion editada exitosamente!",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
actualizarControles();
}
public static Address MapToAddress(AddressDAO address)
{
var c = new Address();
c.Id = address.Id;
c.Street = address.Street;
c.City = address.City;
c.State = address.State;
c.Zip = address.Zip;
return(c);
}
private void button14_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que desea eliminar la dirección " + comboBox8.Text + "?",
"CEGE APP", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
AddressDAO.eliminar(comboBox8.Text);
MessageBox.Show("¡Dirección eliminada exitosamente!",
"CEGE APP", MessageBoxButtons.OK, MessageBoxIcon.Information);
actualizarControles();
}
}
private void btnAddrDelete_Click(object sender, EventArgs e)
{
Address a = (Address)cmbUpdateAddr.SelectedItem;
if (MessageBox.Show("¿Seguro que desea eliminar la direccion ?",
"Hugo App", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
AddressDAO.removeAddress(a);
MessageBox.Show("¡Direccion eliminada exitosamente!",
"Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
actualizarControles();
}
public void doDelete()
{
if (isMinimumValid())
{
AddressDAO addressDao = new AddressDAO();
addressDao.removeByUserId(view.getUsername(), view.getAddressType());
view.pageReload();
view.showFeedback("Successfully deleted");
}
else
{
view.showFeedback("Error Field vlaues are not valid");
}
}
//En attendant de la résolution de la contrainte on delete cascade en bdd
public bool DeleteWithCascade(int id)
{
if (!AddressDAO.Delete(PlaceDAO.Get(id).IdAdr))
{
return(false);
}
if (!ReviewDAO.DeleteByPlace(id))
{
return(false);
}
return(PlaceDAO.Delete(id));
}
public void doReset()
{
if (isMinimumValid())
{
AddressDAO addressDao = new AddressDAO();
AddressDTO addressDto = addressDao.find(view.getUsername(), view.getAddressType());
setAddressDto(addressDto);
view.showFeedback("Fields are reset.");
}
else
{
view.showFeedback("Error Field vlaues are not valid");
}
}
public List<AddressDTO> getUserAddresses(string username)
{
List<AddressDTO> addressDtoList = new List<AddressDTO>();
AddressDAO addressDao = new AddressDAO();
List<AddressDTO> addressList = addressDao.findAll();
foreach (AddressDTO address in addressList)
{
if (address.userName.Equals(username))
{
addressDtoList.Add(address);
}
}
return addressDtoList;
}
/// <summary>
/// 收件人下拉列表响应事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void receive_addr_dropdown_list_SelectedIndexChanged(object sender, EventArgs e)
{
string addr = receive_addr_dropdown_list.SelectedValue;
if (addr == "-1")
{
initReceiveAddrNull();
}
else
{
int addr_id = Convert.ToInt32(addr);
Address address = new AddressDAO().getAddress(addr_id);
initReceiveAddr(address);
}
}
public void AddressDAO_Test()
{
/*Context*/
AccountDAO acc_context = new AccountDAO();
AddressDAO address_context = new AddressDAO();
/*Insert*/
AccountDTO acc = new AccountDTO();
acc.userName = "******";
acc.password = "******";
acc.accountType = "administrator";
acc.status = "active";
acc_context.presist(acc);
AddressDTO address = new AddressDTO();
address.userName = "******";
address.addressType = "postal";
address.country = "South Africa";
address.province = "WP";
address.street = "Frans";
address.suburb = "Parow";
address.town = "Cape Town";
address.unitNumber = 22;
address_context.presist(address);
/*Update*/
address.town = "Pretoria";
address_context.merge(address);
string expectedUpdate = "Pretoria";
AddressDTO upd = address_context.find("griddy", "postal");
Assert.AreEqual(expectedUpdate, upd.town);
/*Delete*/
address_context.removeByUserId("griddy", "postal");
bool expectedDelAddress = false;
bool actualDeleteAddress = address_context.isFound("griddy", "postal");
Assert.AreEqual(expectedDelAddress, actualDeleteAddress);
acc_context.removeByUserId("griddy");
}
public void doUpdate()
{
if (isValid())
{
AddressDAO addressDao = new AddressDAO();
addressDao.merge(getAddressDto());
view.showFeedback("Successfully updated");
}
else
{
view.showFeedback("Error Field vlaues are not valid");
}
}
protected void rptAddress_ItemCommand(object source, RepeaterCommandEventArgs e)
{
AddressDTO addressDto;
AddressDAO addressDao = new AddressDAO();
String element = e.CommandName.ToString();
if (element.Equals("addressType"))
{
addressDto = addressDao.find(getUsername(), e.CommandArgument.ToString());
presenter.setAddressDto(addressDto);
presenter.updateView();
}
}
public bool isUniqueAddress(String username, String addressType)
{
bool isUnique = false;
AddressDAO addressDao = new AddressDAO();
try
{
return (!addressDao.isFound(username, addressType));
}
catch (InvalidOperationException ioe)
{
isUnique = true;
}
return isUnique;
}
public void doSave()
{
AccountService accountService = new AccountServiceImpl();
if (isValid())
{
if(accountService.isUniqueAddress(view.getUsername(), view.getAddressType()))
{
AddressDAO addressDao = new AddressDAO();
addressDao.presist(getAddressDto());
ApplicationControler appControler = new ApplicationControler();
view.pageReload();
view.showFeedback("Successfully added Address");
}
else
{
view.setAddressTypeError("Error, this address type is already used. Enter another value");
}
}
else
{
view.showFeedback("Error Field vlaues are not valid");
}
}
