/// <summary>
/// Metodo para ejcutar todos las ciudades por pais
/// </summary>
/// <exception cref="DatabaseException">
/// Lanzada si ocurre un fallo al ejecutar la funcion en la base de
/// datos
/// </exception>
public void Execute()
{
DAOFactory factory = DAOFactory.GetFactory(DAOFactory.Type.Postgres);
LocationDAO locationDao = factory.GetLocationDAO();
_location = locationDao.GetCitiesByCountry(_id);
}
private void LoadDataToCombobox()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
ds = LocationDAO.LoadDataCombobox();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0].Copy();
cboLocation.Items.Add(new clsComboItem(-1, ""));
foreach (DataRow item in dt.Rows)
{
clsComboItem itemCbo = new clsComboItem();
itemCbo.Value = item["Value"];
itemCbo.Display = item["Display"].ToString();
cboLocation.Items.Add(itemCbo);
}
cboLocation.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1;
dt.Clear();
}
ds.Clear();
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
dt.Dispose();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
if (string.IsNullOrWhiteSpace(txtID.Text))
{
clsMessages.ShowInformation("Vui lòng chọn dòng dữ liệu muốn xóa!");
return;
}
long lID = Convert.ToInt64(txtID.Text);
ds = LocationDAO.Location_Del(lID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1)
{
clsMessages.ShowInformation("Xóa thành công!");
LoadDataToForm();
}
else
{
clsMessages.ShowWarning(ds.Tables[0].Rows[0]["ErrorDesc"].ToString());
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
/// <summary>
/// map the dao to the entity
/// </summary>
/// <param name="ssdao"></param>
/// <returns></returns>
public Location MapToEntity(LocationDAO ldao)
{
Location l = null;
Location fromDB = null;
//use automapper to map matching properties
var mapper = LocationMapper.CreateMapper();
if (ldao != null)
{
l = mapper.Map <Location>(ldao);
//get original object from db
if (!string.IsNullOrWhiteSpace(ldao.LocationName))
{
fromDB = db.Location.Where(m => m.LocationName.Equals(ldao.LocationName)).FirstOrDefault();
}
//if db object exist then use existing object and map properties sent from dao
if (fromDB != null)
{
l = fromDB;
if (!string.IsNullOrWhiteSpace(ldao.LocationName))
{
l.LocationName = ldao.LocationName;
}
}
//if db object does not exist use automapper version of object and set active to true
else
{
l.IsActive = true;
}
}
return(l);
}
/// <summary>
/// Metodo para ejecutar el elimnar una ubicacion
/// </summary>
/// <exception cref="DatabaseException">
/// Lanzada si ocurre un fallo al ejecutar la funcion en la base de
/// datos
/// </exception>
public void Execute()
{
DAOFactory factory = DAOFactory.GetFactory(DAOFactory.Type.Postgres);
LocationDAO locationDao = factory.GetLocationDAO();
locationDao.DeleteLocation(_id);
}
private void btnSave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
LocationDTO obj = new LocationDTO();
obj.ID = -1;
obj.City = txtCity.Text;
obj.District = txtDistrict.Text;
obj.Region = txtRegion.Text;
obj.StreetName = txtStreetName.Text;
ds = LocationDAO.Location_InsUpd(obj);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1)
{
clsMessages.ShowInformation("Thêm thành công!");
frmParent.LoadDataToForm();
this.Close();
}
else
{
clsMessages.ShowWarning("Thêm thất bại!");
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
LocationDTO obj = new LocationDTO();
obj.ID = -1;
obj.City = txtCity.Text;
obj.District = txtDistrict.Text;
obj.Region = txtRegion.Text;
obj.StreetName = txtStreetName.Text;
ds = LocationDAO.Location_Search(obj);
if (ds != null && ds.Tables.Count > 0)
{
dgvLocation.DataSource = ds.Tables[0].Copy();
}
else
{
clsMessages.ShowWarning("Không tìm thấy");
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
/// <summary>
/// Metodo para obtener todos los ubicaciones guardados.
/// </summary>
/// <exception cref="DatabaseException">
/// Lanzada si ocurre un fallo al ejecutar la funcion en la base de
/// datos
/// </exception>
public void Execute()
{
DAOFactory factory = DAOFactory.GetFactory(DAOFactory.Type.Postgres);
LocationDAO locationDao = factory.GetLocationDAO();
_location = locationDao.GetLocations();
}
private void LoadWardInfor(int districtID)
{
List <DataConnect.Location> ward = new LocationDAO().ListLocationFromParent(districtID);
cbbWard.DataSource = ward;
cbbWard.DisplayMember = "LocationName";
cbbWard.ValueMember = "LocationID";
}
private void LoadDistrictInfor(int provinceID)
{
List <DataConnect.Location> district = new LocationDAO().ListLocationFromParent(provinceID);
cbbDistrict.DataSource = district;
cbbDistrict.DisplayMember = "LocationName";
cbbDistrict.ValueMember = "LocationID";
}
private void LoadProvinceInfor()
{
List <DataConnect.Location> province = new LocationDAO().ListAllProvince();
cbbProvince.DataSource = province;
cbbProvince.DisplayMember = "LocationName";
cbbProvince.ValueMember = "LocationID";
cbbProvince.SelectedIndex = 0;
}
public ActionResult Index()
{
if (Session["username"] == null)
{
return(RedirectToAction("../Login/Index"));
}
return(View(LocationDAO.FindAll()));
}
/// <summary> Retrieves in this LocationCollection object all LocationEntity objects which are related via a relation of type 'm:n' with the passed in ProductEntity.
/// All current elements in the collection are removed from the collection.</summary>
/// <param name="productInstance">ProductEntity object to be used as a filter in the m:n relation</param>
/// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
/// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
/// <param name="pageNumber">The page number to retrieve.</param>
/// <param name="pageSize">The page size of the page to retrieve.</param>
/// <returns>true if the retrieval succeeded, false otherwise</returns>
public virtual bool GetMultiManyToManyUsingProductCollectionViaProductInventory(IEntity productInstance, long maxNumberOfItemsToReturn, ISortExpression sortClauses, int pageNumber, int pageSize)
{
if (!base.SuppressClearInGetMulti)
{
this.Clear();
}
LocationDAO dao = DAOFactory.CreateLocationDAO();
return(dao.GetMultiUsingProductCollectionViaProductInventory(base.Transaction, this, maxNumberOfItemsToReturn, sortClauses, base.EntityFactoryToUse, productInstance, pageNumber, pageSize));
}
public ActionResult Update(int Id)
{
if (Session["username"] == null)
{
return(RedirectToAction("../Login/Index"));
}
//retorna para a view o objeto a ser atualizado
return(View("Insert", LocationDAO.FindById(Id)));
}
//thong tin chung
public ActionResult CommonInfo()
{
var commonInfo = LocationDAO.GetCommonInfoByID("commoninfo");
if (commonInfo == null)
{
commonInfo = new CommonBO();
}
return(View(commonInfo));
}
/// <summary> Retrieves in this LocationCollection object all LocationEntity objects which are related via a relation of type 'm:n' with the passed in WorkOrderEntity.
/// All current elements in the collection are removed from the collection.</summary>
/// <param name="workOrderInstance">WorkOrderEntity object to be used as a filter in the m:n relation</param>
/// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
/// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
/// <param name="prefetchPathToUse">the PrefetchPath which defines the graph of objects to fetch.</param>
/// <returns>true if the retrieval succeeded, false otherwise</returns>
public bool GetMultiManyToManyUsingWorkOrderCollectionViaWorkOrderRouting(IEntity workOrderInstance, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath prefetchPathToUse)
{
if (!base.SuppressClearInGetMulti)
{
this.Clear();
}
LocationDAO dao = DAOFactory.CreateLocationDAO();
return(dao.GetMultiUsingWorkOrderCollectionViaWorkOrderRouting(base.Transaction, this, maxNumberOfItemsToReturn, sortClauses, base.EntityFactoryToUse, workOrderInstance, prefetchPathToUse));
}
internal static Location GetOrderLocation(Order o)
{
Location Location;
using (var DB = new P0Context())
{
LocationDAO.LoadLocationsList(DB);
Location = DB.LocationList.First(l => l.LocationID == o.LocationID);
}
return(Location);
}
internal static List <Location> GetAllLocations()
{
List <Location> LocationList;
using (var DB = new P0Context())
{
LocationDAO.LoadLocationsList(DB);
LocationList = DB.LocationList;
}
return(LocationList);
}
public string Post(JsonLocation jsonLocation)
{
try
{
LocationDAO.InitializeInsertLocation(jsonLocation);
}
catch (Exception ex)
{
}
return("Location");
}
private void InsertToDBButton_Click(object sender, EventArgs e)
{
if (LocationDAO.InsertMany(reader.GetLocations()))
{
MessageBox.Show("Entries added to the DB.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Error accessing DB", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int addLocation(string nombre, string direccion, string encargado, string companyId)
{
Local l = new Local()
{
Nombre = nombre,
Direccion = direccion,
Encargado = encargado,
Id_Em = Convert.ToInt32(companyId)
};
return(LocationDAO.addLocal(l));
}
public ActionResult Index(string metatitle, int id, int attribute_pa_chon_chat_lieu_op_lung = 0, string cart_item_key = "")
{
if (metatitle.Length <= 0 || metatitle.Split('-').Count() <= 1)
{
return(RedirectToAction("NotFound", "Error"));
}
var product = ProductDAO.GetProductByID(id);
if (product == null)
{
return(RedirectToAction("NotFound", "Error"));
}
product.avatar.OrderBy(x => x.displayorder);
product.slide.OrderBy(x => x.displayorder);
if (product.collectionid > 0)
{
ViewBag.CollectionName = BrandModel.GetCollectionByID(Convert.ToInt32(product.collectionid)).name;
}
else
{
ViewBag.BrandName = BrandModel.GetBrandByID(Convert.ToInt32(product.brandid)).name;
}
ViewBag.CurrentMaterialID = attribute_pa_chon_chat_lieu_op_lung;
CartSession cart = new CartSession();
if (!String.IsNullOrEmpty(cart_item_key))
{
List <CartSession> lstCartItem = Session["fancycart"] as List <CartSession>;
if (lstCartItem != null)
{
cart = lstCartItem.Where(x => x.ItemKey == cart_item_key).FirstOrDefault();
}
}
if (cart == null)
{
cart = new CartSession();
}
if (!String.IsNullOrEmpty(cart.Order))
{
cart.OrderObject = JsonConvert.DeserializeObject <dynamic>(cart.Order);
cart.OrderObject_Additional = cart.OrderObject.product[0];
}
ViewBag.CurrentCartItem = cart;
var commonInfo = LocationDAO.GetCommonInfoByID("commoninfo");
ViewBag.CommonInfo = commonInfo;
return(View(product));
}
public JsonResult GetListWardByDistrictID(int disid)
{
var listWard = LocationDAO.GetListWardByDistrictID(disid);
return(Json(new
{
items = listWard.Select(x => new
{
id = x.id,
text = x.name
})
}, JsonRequestBehavior.AllowGet));
}
public void LoadDataToForm()
{
try
{
DataTable dt = new DataTable();
dt = LocationDAO.Location_GetAll().Tables[0].Copy();
dgvLocation.DataSource = dt;
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
}
public int updateLocation(int locationId, string nombre, string direccion, string encargado)
{
Local l = new Local()
{
Nombre = nombre,
Direccion = direccion,
Telefono = "0",
Encargado = encargado,
Id_Loc = locationId
};
return(LocationDAO.updateLocal(l));
}
public JsonResult GetListDistrictByProvinceID(int proid)
{
var listDistrict = LocationDAO.GetListDistrictByProvinceID(proid);
return(Json(new
{
items = listDistrict.Select(x => new
{
id = x.id,
text = x.name
})
}, JsonRequestBehavior.AllowGet));
}
public ActionResult ChekoutSuccess(string orderid = "")
{
if (string.IsNullOrEmpty(orderid))
{
return(RedirectToAction("Index"));
}
var commonInfo = LocationDAO.GetCommonInfoByID("commoninfo");
ViewBag.CommonInfo = commonInfo;
OrderBO order = OrderDAO.GetOrderByID(orderid);
return(View(order));
}
/// <summary>
/// map the entity to the dao
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public LocationDAO MapToDao(Location l)
{
var mapper = LocationMapper.CreateMapper();
if (l != null)
{
LocationDAO ldao = mapper.Map <LocationDAO>(l);
return(ldao);
}
else
{
return(new LocationDAO());
}
}
internal static List <Order> GetPastOrdersFromCustomer(Customer customer, P1Context _context)
{
List <Order> OrdersByCustomer = new List <Order>();
var DB = _context;
OrderDAO.LoadOrdersList(DB);
OrderProductsDAO.LoadOrderProductsList(DB);
ProductDAO.LoadProductsList(DB);
LocationDAO.LoadLocationsList(DB);
BillingDAO.LoadBillingList(DB);
CustomerDAO.LoadCustomersList(DB);
ShippingDAO.LoadShippingInfomrationList(DB);
OrdersByCustomer = DB.OrdersList.Where(o => o.CustomerID == customer.CustomerID).ToList();
for (int i = 0; i < OrdersByCustomer.Count; i++)
{
Order o = OrdersByCustomer[i];
List <ProductInStock> prodsOrdered = new List <ProductInStock>();
List <OrderProducts> prodIDsAndQuantityInOrder = DB.OrderProductsList.Where(op => op.OrderID == OrdersByCustomer[i].OrderID).ToList();
foreach (OrderProducts OP in prodIDsAndQuantityInOrder)
{
ProductInStock prodOrdered = new ProductInStock();
Product p = DB.ProductsList.First(p => p.ProductID == OP.ProductID);
prodOrdered.Name = p.Name;
prodOrdered.Price = p.Price;
prodOrdered.Description = p.Description;
prodOrdered.Quantity = OP.Quantity;
prodsOrdered.Add(prodOrdered);
}
o.ShoppingCart = prodsOrdered;
o.Billing = DB.BillingInformationList.First(b => b.BillingID == OrdersByCustomer[i].BillingID);
o.Shipping = DB.ShippingInformation.First(s => s.ShippingID == OrdersByCustomer[i].ShippingID);
o.Location = DB.LocationList.First(l => l.LocationID == OrdersByCustomer[i].LocationID);
o.Customer = DB.CustomersList.First(c => c.CustomerID == OrdersByCustomer[i].CustomerID);
OrdersByCustomer[i] = o;
}
return(OrdersByCustomer);
}
/*internal static List<Location> GetAllLocations(P1Context _context)
* {
* List<Location> LocationList;
* var DB = _context;
* LocationDAO.LoadLocationsList(DB);
* LocationList = DB.LocationList;
* return LocationList;
* }*/
public static Location GetLocation(int LocationID, P1Context _context)
{
Location location = new Location();
var DB = _context;
LocationDAO.LoadLocationsList(DB);
foreach (Location l in DB.LocationList)
{
if (l.LocationID == LocationID)
{
location = l;
break;
}
}
return(location);
}
