private void setupSQLite()
{
SQLiteDataHandler.CreateDBSQLite();
if (API_RESULT_LISTMONAN != null && API_RESULT_LISTMONAN.Count > 0)
{
List <BeanMonAn> listMonAn = new List <BeanMonAn>();
listMonAn = SQLiteDataHandler.BeanMonAn_LoadList();
foreach (BeanMonAn item in API_RESULT_LISTMONAN)
{
if (String.IsNullOrEmpty(item.SearchData)) // de search
{
item.SearchData = CmmFunction.RemoveVietNamAccent(item.TenMon) + " " + CmmFunction.RemoveVietNamAccent(item.MieuTa);
}
if (listMonAn.Any(x => x.MaMon.Equals(item.MaMon))) // da ton tai trong db
{
BeanMonAn temp = listMonAn.Find(x => x.MaMon.Equals(item.MaMon));
if (temp.Modified != item.Modified) // cap nhat moi
{
SQLiteDataHandler.BeanMonAn_Update(item);
Utilities_DownloadImageFromURL download = new Utilities_DownloadImageFromURL(this);
string url = Utilities_API._SiteName + Utilities_API._SiteImageUrl + item.HinhAnh;
download.Execute(url);
}
}
else
{
SQLiteDataHandler.BeanMonAn_Insert(item);
Utilities_DownloadImageFromURL download = new Utilities_DownloadImageFromURL(this);
string url = Utilities_API._SiteName + Utilities_API._SiteImageUrl + item.HinhAnh;
download.Execute(url);
}
}
}
}
public override void OnBindViewHolder(RecyclerView.ViewHolder holder, int position)
{
_monAn = SQLiteDataHandler.BeanMonAn_SearchItem(_lstData[position].MaMonAn);
if (_monAn != null)
{
CartHolder recyclerViewHolder = holder as CartHolder;
recyclerViewHolder._tvDishName.Text = _monAn.TenMon;
recyclerViewHolder._tvDishPrice.Text = String.Format("{0:#,0}", _monAn.GiaTien) + " VNĐ";
Utilities.Utilities_LoadImage.LoadImageToImageView(_monAn.HinhAnh, recyclerViewHolder._imgDish);
recyclerViewHolder._tvCount.Text = _lstData[position].SoLuong.ToString();
}
}
private void setupData()
{
if (Intent != null)
{
MaMon = int.Parse(Intent.GetStringExtra("Detail_MaMon"));
_beanMonAn = SQLite.SQLiteDataHandler.BeanMonAn_SearchItem(MaMon);
if (_beanMonAn != null)
{
Utilities.Utilities_LoadImage.LoadImageToImageView(_beanMonAn.HinhAnh, _imgPortrait);
_tvFoodName.Text = _beanMonAn.TenMon.ToString();
_tvFoodPrice.Text = String.Format("{0:#,0}", _beanMonAn.GiaTien) + " VNĐ";
_tvFoodDescription.Text = _beanMonAn.MieuTa.ToString();
}
}
}
public static bool BeanMonAn_Insert(BeanMonAn item)
{
try
{
if (File.Exists(DbFilePath))
{
db = new SQLiteConnection(DbFilePath);
db.Insert(item);
return(true);
}
return(false);
}
catch (Exception e)
{
throw;
}
}
public static BeanMonAn BeanMonAn_SearchItem(int MaMon)
{
BeanMonAn data = new BeanMonAn();
try
{
if (File.Exists(DbFilePath))
{
db = new SQLiteConnection(DbFilePath);
data = db.Table <BeanMonAn>().Where(x => x.MaMon == MaMon).FirstOrDefault();
}
return(data);
}
catch (Exception e)
{
throw;
}
}
public static bool BeanMonAn_Update(BeanMonAn item)
{
try
{
if (File.Exists(DbFilePath))
{
List <BeanMonAn> data = BeanMonAn_LoadList();
db = new SQLiteConnection(DbFilePath);
db.Update(item);
return(true);
}
return(false);
}
catch (Exception e)
{
throw;
}
}
private float CountTotalMoney(List <BeanShoppingCart> data)
{
float _totalMoney = 0;
List <BeanMonAn> _lstSelectMonAn = new List <BeanMonAn>();
for (int i = 0; i < data.Count; i++)
{
BeanMonAn _monAn = SQLiteDataHandler.BeanMonAn_SearchItem(data[i].MaMonAn);
if (data != null)
{
_lstSelectMonAn.Add(_monAn);
}
}
for (int i = 0; i < data.Count; i++)
{
_totalMoney += data[i].SoLuong * _lstSelectMonAn[i].GiaTien;
}
return(_totalMoney);
}
