private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
textBoxName.Text = _data.Name;
textBoxDescription.Text = _data.Description;
textBoxPrice.Text = _data.Price.ToString();
comboBoxitemType.Text = _data.ProductType;
avtImage.ImageSource = new BitmapImage(new Uri(_data.listImages[0]));
_list = new BindingList <Cakes>();
var t = new Cakes()
{
listImages = new BindingList <string>()
};
foreach (var l in _data.listImages)
{
_listImages.Add(l);
t.listImages.Add(l);
}
_list.Add(t);
ItemControlImages.ItemsSource = _list;
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
this.DataContext = _data;
_list = new ObservableCollection <Cakes>();
var folder = AppDomain.CurrentDomain.BaseDirectory;
var database = $"{folder}AllCakes.xlsx";
var workbook = new Workbook(database);
var sheet = workbook.Worksheets[0];
var row = 1;
var cell = sheet.Cells[$"A{row}"];
while (cell.Value != null)
{
if (_data.Name == cell.StringValue)
{
_data.Description = sheet.Cells[$"B{row}"].StringValue;
_data.Price = long.Parse(sheet.Cells[$"C{row}"].StringValue);
_data.ProductType = sheet.Cells[$"D{row}"].StringValue;
break;
}
else
{
row++;
cell = sheet.Cells[$"A{row}"];
}
}
prod = new Cakes()
{
Name = _data.Name,
Description = _data.Description,
Price = _data.Price,
ImagePath = _data.ImagePath,
ProductType = _data.ProductType,
listImages = new BindingList <string>()
};
var count = sheet.Cells[$"E{row}"].IntValue;
var col = 'F';
for (int i = 0; i < count; i++)
{
var value = $"{folder}ListCakes\\{nameProduct}\\" + sheet.Cells[$"{char.ConvertFromUtf32(col + i)}{row}"].StringValue;
prod.listImages.Add(value);
}
;
_list.Add(prod);
PreviewPhoto.ItemsSource = _list;
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
long total = 0;
var folder = AppDomain.CurrentDomain.BaseDirectory;
var database = $"{folder}ShoppingCart.txt";
var lines = File.ReadAllLines(database);
int count = lines.Length / 6;
_data = new ObservableCollection <Cakes>();
for (int i = 0; i < count; i++)
{
var line1 = lines[i * 6];
var line2 = lines[i * 6 + 1];
var line3 = lines[i * 6 + 2];
var line4 = lines[i * 6 + 3];
var line5 = lines[i * 6 + 4];
var p = new Cakes()
{
Name = line1,
ImagePath = line2,
Price = int.Parse(line3),
Quantity = int.Parse(line4),
Total = long.Parse(line5),
};
_data.Add(p);
}
dataListview.ItemsSource = _data;
foreach (var t in _data)
{
total += t.Total;
}
double newValue = double.Parse(total.ToString());
_total.Content = newValue.ToString("N0").Replace(",", ".") + " VNĐ";
}
public UserControlUpdate(Cakes p)
{
InitializeComponent();
_data = p;
nameProduct = _data.Name;
}
private void UserControl_Initialized(object sender, EventArgs e)
{
_listSale = new BindingList <ViewModel>();
ItemSFChart.ItemsSource = _listSale;
_list = new BindingList <Cakes>();
ItemPieChart.ItemsSource = _list;
this.DataContext = this;
var g = new Cakes()
{
Data = new SeriesCollection(),
};
var folder = AppDomain.CurrentDomain.BaseDirectory;
var database = $"{folder}ListCakes\\DB_DA3.xlsx";
var ad = database.Length;
var workbook = new Workbook(database);
var sheet = workbook.Worksheets[1];
var row = 2;
ViewModel SF = new ViewModel()
{
Datas = new List <Sale>(),
};
var cell = sheet.Cells[$"A{row}"];
int i = 12;
int j = 1;
var ColumSF = 'B';
while (cell.Value != null)
{
PieSeries Pie = new PieSeries()
{
Values = new ChartValues <float> {
float.Parse(sheet.Cells[$"C{row}"].StringValue)
},
Title = $"{cell.StringValue}"
};
g.Data.Add(Pie);
row++;
cell = sheet.Cells[$"A{row}"];
}
while (j <= 12)
{
Sale sf = new Sale()
{
Price = float.Parse(sheet.Cells[$"{char.ConvertFromUtf32(ColumSF + j - 1)}8"].StringValue),
Month = $"{j}"
};
SF.Datas.Add(sf);
j++;
}
_listSale.Add(SF);
_list.Add(g);
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
var folder = AppDomain.CurrentDomain.BaseDirectory;
var database = $"{folder}AllCakes.xlsx";
var ad = database.Length;
var workbook = new Workbook(database);
var sheet = workbook.Worksheets[0];
if (_nameComboBox.SelectedIndex == 0)
{
sheet = workbook.Worksheets[0];
}
if (_nameComboBox.SelectedIndex == 2)
{
sheet = workbook.Worksheets[1];
}
else if (_nameComboBox.SelectedIndex == 1)
{
sheet = workbook.Worksheets[2];
}
else if (_nameComboBox.SelectedIndex == 4)
{
sheet = workbook.Worksheets[6];
}
else if (_nameComboBox.SelectedIndex == 6)
{
sheet = workbook.Worksheets[3];
}
else if (_nameComboBox.SelectedIndex == 3)
{
sheet = workbook.Worksheets[4];
}
else if (_nameComboBox.SelectedIndex == 5)
{
sheet = workbook.Worksheets[5];
}
_data = new ObservableCollection <Cakes>();
int index = 1;
var cell = sheet.Cells[$"A{index}"];
var count = sheet.Cells[$"K{index}"];
for (int i = 1; i <= count.IntValue; i++)
{
var _Name = sheet.Cells[$"A{i}"].StringValue;
var _Price = long.Parse(sheet.Cells[$"C{i}"].StringValue);
var _Picture = sheet.Cells[$"F{i}"].StringValue;
var Cak = new Cakes()
{
ImagePath = _Picture,
Name = _Name,
Price = _Price
};
_data.Add(Cak);
}
this._pagination.Visibility = Visibility.Hidden;
if (_data.Count > 12)
{
this._pagination.Visibility = Visibility.Visible;
}
info.CurrentPage = 1;
info.RowsPerPage = 12;
info.Count = _data.Count;
info.TotalPages = (info.Count / info.RowsPerPage) +
(info.Count % info.RowsPerPage == 0 ? 0 : 1);
Thread thread = new Thread(delegate()
{
// Cập nhật UI
Dispatcher.Invoke(() =>
{
dataListview.ItemsSource = _data.Take(info.RowsPerPage);
});
});
thread.Start();
}
public UserControlDetailCakes(Cakes t)
{
InitializeComponent();
_data = t;
nameProduct = _data.Name;
}
