public VMs()
{
DataClasses1DataContext dc = new DataClasses1DataContext(Properties.Settings.Default.ManagementProjectConnectionString);
List <DiscountDb> modelsDb = dc.DiscountDbs.ToList();
models = new List <ViewModel>();
int n = modelsDb.Count;
for (int i = 0; i < n; i++)
{
DiscountDb model = modelsDb[i];
CategoryDb product = (from p in dc.CategoryDbs where p.id == model.idProduct select p).Single();
String nameProduct = product.nameType;
Score_TypeCustomer typeCustomer = (from p in dc.Score_TypeCustomers where p.id == model.idTypeCustomer select p).Single();
string nameTypeProduct = typeCustomer.nameTypeCustomer;
if (DateTime.Compare(model.endDate, DateTime.Now) < 0) //discount is out of date
{
modelsDb[i].statusDiscount = 0;
dc.SubmitChanges();
}
string status = modelsDb[i].statusDiscount == 1 ? "Đang áp dụng" : "Hết hạn";
int order = i + 1;
if (nameProduct != null && nameProduct != null)
{
ViewModel newItem = new ViewModel(model, nameProduct, nameTypeProduct, status, order);
models.Add(newItem);
}
}
}
private void bntEditCustomer_Click(object sender, RoutedEventArgs e)
{
if (isManager)
{
//Kiểm tra xem discount này đã được áp dụng vào hóa đơn nào chưa
var discountVM = DiscountDataGrid.SelectedItem as ViewModel;
var x = (from p in dc.DetailReceipts where p.idDiscount == discountVM.id select p).ToList();
if (x.Count > 0)
{
MessageBox.Show("Ưu đãi này đã được áp dụng trong hóa đơn nên không thể chỉnh sửa\n");
}
else
{
dialogDiscount.IsOpen = true;
setupDialog();
btnSaveDiscount.Visibility = Visibility.Visible;
btnAddDiscount.Visibility = Visibility.Collapsed;
//fill data in dialog
nameDiscountTxt.Text = discountVM.nameDiscount;
startDate.SelectedDate = discountVM.startDate;
endDate.SelectedDate = discountVM.endDate;
percentDiscountTxt.Text = discountVM.percentageDiscount.ToString();
CategoryDb typeProcut = (from p in dc.CategoryDbs where p.id == discountVM.idProduct select p).Single();
comboBoxTypeProduct.SelectedItem = typeProcut;
Score_TypeCustomer typeCustomer = (from p in dc.Score_TypeCustomers where p.id == discountVM.idTypeCustomer select p).Single();
comboBoxTypeCustomer.SelectedItem = typeCustomer;
}
}
}
private void bntSaveDiscount_Click(object sender, RoutedEventArgs e)
{
if (checkInput())
{
var discountVM = DiscountDataGrid.SelectedItem as ViewModel;
var modelDb = (from p in dc.DiscountDbs where p.id == discountVM.id select p).Single();
modelDb.nameDiscount = nameDiscountTxt.Text;
modelDb.startDate = (DateTime)startDate.SelectedDate;
modelDb.endDate = (DateTime)endDate.SelectedDate;
CategoryDb productInput = comboBoxTypeProduct.SelectedValue as CategoryDb;
modelDb.idProduct = productInput.id;
Score_TypeCustomer customerInput = comboBoxTypeCustomer.SelectedValue as Score_TypeCustomer;
modelDb.idTypeCustomer = customerInput.id;
int percentageInput = Convert.ToInt32(percentDiscountTxt.Text);
modelDb.percentageDiscount = percentageInput;
modelDb.statusDiscount = 1;
try
{
dc.SubmitChanges();
reloadData();
dialogDiscount.IsOpen = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnAddDiscount_Click(object sender, RoutedEventArgs e)
{
if (checkInput())
{
string nameDiscountInput = nameDiscountTxt.Text;
DateTime startDateInput = (DateTime)startDate.SelectedDate;
DateTime endDateInput = (DateTime)endDate.SelectedDate;
CategoryDb productInput = comboBoxTypeProduct.SelectedValue as CategoryDb;
Score_TypeCustomer customerInput = comboBoxTypeCustomer.SelectedValue as Score_TypeCustomer;
int percentageInput = Convert.ToInt32(percentDiscountTxt.Text);
DiscountDb newDiscount = new DiscountDb(nameDiscountInput, productInput.id, customerInput.id, 1, startDateInput, endDateInput, percentageInput);
dc.DiscountDbs.InsertOnSubmit(newDiscount);
try
{
dc.SubmitChanges();
reloadData();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi", ex.Message);
}
dialogDiscount.IsOpen = false;
}
}
public CustomerVMs(List <CustomerDb> modelsDb)
{
models = new List <CustomerViewModel>();
DataClasses1DataContext dc = new DataClasses1DataContext(Properties.Settings.Default.ManagementProjectConnectionString);
int n = modelsDb.Count;
for (int i = 0; i < n; i++)
{
CustomerDb model = modelsDb[i];
Score_TypeCustomer x = (from p in dc.Score_TypeCustomers where p.id == model.typeCustomer select p).Single();
string nameTypeCustomer = x.nameTypeCustomer;
if (nameTypeCustomer == null)
{
nameTypeCustomer = "";
}
models.Add(new CustomerViewModel(model, i + 1, nameTypeCustomer));
}
}
private void btnDetail_Click(object sender, RoutedEventArgs e)
{
var discountVM = DiscountDataGrid.SelectedItem as ViewModel;
dialogDiscount.IsOpen = true;
setupDialog();
btnSaveDiscount.Visibility = Visibility.Visible;
btnAddDiscount.Visibility = Visibility.Collapsed;
//fill data in dialog
nameDiscountTxt.Text = discountVM.nameDiscount;
startDate.SelectedDate = discountVM.startDate;
endDate.SelectedDate = discountVM.endDate;
percentDiscountTxt.Text = discountVM.percentageDiscount.ToString();
CategoryDb typeProcut = (from p in dc.CategoryDbs where p.id == discountVM.idProduct select p).Single();
comboBoxTypeProduct.SelectedItem = typeProcut;
Score_TypeCustomer typeCustomer = (from p in dc.Score_TypeCustomers where p.id == discountVM.idTypeCustomer select p).Single();
comboBoxTypeCustomer.SelectedItem = typeCustomer;
btnAddDiscount.Visibility = Visibility.Hidden;
btnSaveDiscount.Visibility = Visibility.Collapsed;
}
