public ActionResult Index(SearchItemModel Model, int?page)
{
var pageNumber = page ?? 1;
int total = new int();
List <ItemDisplayModel> lstModel = new List <ItemDisplayModel>();
List <GetCatetoryModel> lstcombobox = new List <GetCatetoryModel>();
if (!string.IsNullOrEmpty(Session["code"] as string))
{
Model.code = Session["code"].ToString();
}
if (!string.IsNullOrEmpty(Session["name"] as string))
{
Model.name = Session["name"].ToString();
}
if (Session["category_id"] as int? != null)
{
Model.category_id = (int)Session["category_id"];
}
_itemBLL.Search(Model, out lstModel, out total, pageNumber);
var list = new StaticPagedList <ItemDisplayModel>(lstModel, pageNumber, 15, total);
ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id);
_itemBLL.GetCategory(true, out lstcombobox);
ViewBag.lstcombobox = lstcombobox;
ViewBag.page = 0;
if (page != null)
{
ViewBag.page = pageNumber - 1;
}
return(View(new Tuple <SearchItemModel, IPagedList <ItemDisplayModel> >(Model, list)));
}
public void showSearchItemPage(SearchItemModel pantryItem)
{
SearchItemPage searchItemPage = new SearchItemPage();
searchItemPage.BindingContext = new SearchItemViewModel(pantryItem);
navigation.PushAsync(searchItemPage);
}
public SearchItemViewModel(SearchItemModel searchItem)
{
navManager = PageNavigationManager.Instance;
SearchItem = searchItem;
Position itemPosition = new Position(SearchItem.ItemLocation.Latitude, SearchItem.ItemLocation.Longitude);
MapSpan mapSpan = MapSpan.FromCenterAndRadius(itemPosition, Distance.FromKilometers(5));
Map = new Map(mapSpan);
Map.HeightRequest = 150;
Map.WidthRequest = 150;
Map.IsShowingUser = false;
Pin pin = new Pin
{
Type = PinType.Place,
Position = itemPosition,
Label = SearchItem.Description,
Address = SearchItem.Location
};
Map.Pins.Add(pin);
MessageCommand = new Command(MessageUserAsync);
}
public SearchMedicinesViewModel()
{
NewMedicine = new Command(arg => AddItem());
FindMedicines = new Command(arg => FindItem());
DeleteMedicine = new Command(arg => DeleteItem());
_selectedItem = null;
GetDataFromDatabase();
}
public async Task <IHttpActionResult> Search([FromBody] SearchItemModel model)
{
var ids = model.Ids;
var memberId = User.GetMemberId();
var models = await queryService.SearchUnitItems(memberId, ids);
return(Ok(models));
}
public void DeleteMedicine(SearchItemModel medicine)
{
string query = "DELETE FROM `medicine` WHERE id=@id_item";
command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@id_item", medicine.id);
command.ExecuteNonQuery();
command.Dispose();
}
private void DeleteItem()
{
if (_selectedItem != null)
{
DatabaseModel database = new DatabaseModel();
database.DeleteMedicine(_selectedItem);
DataGridMedicines.Remove(_selectedItem);
_selectedItem = null;
}
}
public int Search(SearchItemModel searchCondition, out List <ItemDisplayModel> lstModel, out int total, int _page)
{
_page = _page * 15 - 15;
int returnCode = (int)Common.ReturnCode.Succeed;
lstModel = new List <ItemDisplayModel>();
total = new int();
try
{
string sql = "SELECT item.`id`, item.`code`, item.`name`, cate.`name` AS category_name, item.`specification`, item.`description`, item.`dangerous` ";
sql += "FROM `product_item` AS item ";
sql += "JOIN (SELECT c.`id`, cpp.`name` AS category_parent_name, c.`name` ";
sql += "FROM `product_category` AS c ";
sql += "LEFT JOIN (SELECT cp.`name`, cp.`id` FROM `product_category` cp) cpp on cpp.`id` = c.`parent_id` ";
sql += ") cate ON item.`category_id` = cate.`id` WHERE TRUE ";
string _sql = "SELECT count(item.`id`) ";
_sql += "FROM `product_item` AS item ";
_sql += "JOIN (SELECT c.`id`, cpp.`name` AS category_parent_name, c.`name` ";
_sql += "FROM `product_category` AS c ";
_sql += "LEFT JOIN (SELECT cp.`name`, cp.`id` FROM `product_category` cp) cpp on cpp.`id` = c.`parent_id` ";
_sql += ") cate ON item.`category_id` = cate.`id` WHERE TRUE ";
if (!string.IsNullOrEmpty(searchCondition.category_id.ToString()))
{
sql += "AND (item.`category_id` = @category_id OR item.`category_id` IN (SELECT cate.`id` FROM `product_category` cate WHERE cate.`parent_id` = @category_id)) ";
_sql += "AND (item.`category_id` = @category_id OR item.`category_id` IN (SELECT cate.`id` FROM `product_category` cate WHERE cate.`parent_id` = @category_id)) ";
}
if (!string.IsNullOrEmpty(searchCondition.code))
{
sql += "AND item.`code` LIKE @code ";
_sql += "AND item.`code` LIKE @code ";
}
if (!string.IsNullOrEmpty(searchCondition.name))
{
sql += "AND item.`name` LIKE @name ";
_sql += "AND item.`name` LIKE @name ";
}
sql += " ORDER BY item.`id`ASC LIMIT @page,15";
lstModel = db.Query <ItemDisplayModel>(sql, new { category_id = searchCondition.category_id, code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%', page = _page }).ToList();
total = db.ExecuteScalar <int>(_sql, new { category_id = searchCondition.category_id, code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%', page = _page });
}
catch (Exception ex)
{
return(returnCode = (int)Common.ReturnCode.UnSuccess);
}
return(returnCode);
}
public ActionResult IndexPost(SearchItemModel Model, int?page)
{
var pageNumber = page ?? 1;
List <ItemDisplayModel> lstModel = new List <ItemDisplayModel>();
List <GetCatetoryModel> lstcombobox = new List <GetCatetoryModel>();
int total = new int();
_itemBLL.Search(Model, out lstModel, out total, pageNumber);
var list = new StaticPagedList <ItemDisplayModel>(lstModel, pageNumber, 15, total);
ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id);
Session["code"] = Model.code;
Session["name"] = Model.name;
Session["category_id"] = Model.category_id;
TempData["CountResult"] = total.ToString() + " row(s) found!";
_itemBLL.GetCategory(true, out lstcombobox);
ViewBag.lstcombobox = lstcombobox;
return(View(new Tuple <SearchItemModel, IPagedList <ItemDisplayModel> >(Model, list)));
}
public HashSet <SearchItemModel> GetMedicines()
{
string query = "SELECT id, name, description FROM medicine";
command = new MySqlCommand(query, connection);
MySqlDataReader reader = command.ExecuteReader();
HashSet <SearchItemModel> items = new HashSet <SearchItemModel>();
SearchItemModel item;
while (reader.Read())
{
item = new SearchItemModel();
item.id = (int)reader.GetValue(0);
item.title = reader.GetValue(1).ToString();
item.description = reader.GetValue(2).ToString();
items.Add(item);
}
command.Dispose();
return(items);
}
public int Search(SearchItemModel searchCondition, out List <ItemDisplayModel> lstModel, out int total, int _page)
{
return(_itemDAO.Search(searchCondition, out lstModel, out total, _page));
}
private void AddItem()
{
SearchItemModel item = new SearchItemModel();
}
void SearchItemSelected(SearchItemModel pantryItem)
{
navManager.showSearchItemPage(pantryItem);
}
