private void bntEditCustomer_Click(object sender, RoutedEventArgs e)
{
int row = CustomerDataGrid.SelectedIndex;
if (row != -1)
{
dialogCustomer.IsOpen = true;
btnSaveCustomer.Visibility = Visibility.Visible;
btnAddCustomer.Visibility = Visibility.Collapsed;
CustomerDb customer = CustomerDataGrid.SelectedItem as CustomerDb;
nameCustomerTxt.Text = customer.nameCustomer;
phoneNumberTxt.Text = customer.phoneNumber;
dateOB.SelectedDate = customer.dateOfBirth;
}
}
public DetailReceiptViewModel(CustomerDb customer, ProductDb product, int quantity, int sizeOrder, DateTime date, int order)
{
DataClasses1DataContext dc = new DataClasses1DataContext(Properties.Settings.Default.ManagementProjectConnectionString);
nameProduct = product.nameProduct;
this.quantity = quantity;
this.unitPriceSell = product.priceSell;
this.unitBonusScore = product.bonusScore;
this.sumScore = quantity * (int)unitBonusScore;
this.order = order;
this.size = sizeOrder;
this.stringUnitPrice = Unity.formatMoney((long)unitPriceSell);
this.idProduct = product.id;
this.idTypeProduct = product.category;
//get discount, idTypeCustomer=1 mean all customer, idProduct=6 means all type product
var discount = (from p in dc.DiscountDbs
where p.statusDiscount == 1 && date >= p.startDate && date <= p.endDate &&
(p.idTypeCustomer == 1 || p.idTypeCustomer == customer.typeCustomer) &&
(p.idProduct == 6 || p.idProduct == product.category)
orderby p.percentageDiscount descending
select p).ToList();
if (discount.Count == 0)
{
this.idDiscount = -1;
this.nameDiscount = "(Không có)";
this.discountString = "0%";
this.persentageDiscount = 0;
}
else //chọn ưu đãi cao nhất
{
this.idDiscount = discount[0].id;
this.nameDiscount = discount[0].nameDiscount;
this.discountString = discount[0].percentageDiscount + "%";
this.persentageDiscount = discount[0].percentageDiscount;
}
var x = (long)(quantity * (long)unitPriceSell) * (100.0 - persentageDiscount) / 100.0;
this.sumMoney = (long)x;
var y = sumMoney - product.priceImport * quantity;
this.interest = (long)y;
this.stringSumMoney = Unity.formatMoney(sumMoney);
}
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));
}
}
public DetailReceiptViewModel(DetailReceipt model, int order) : base(model)
{
DataClasses1DataContext dc = new DataClasses1DataContext(Properties.Settings.Default.ManagementProjectConnectionString);
CustomerDb customer = (from p in dc.CustomerDbs where p.id == this.idCustomer select p).Single();
ProductDb product = (from p in dc.ProductDbs where p.id == this.idProduct select p).Single();
nameProduct = product.nameProduct;
this.unitPriceSell = product.priceSell;
this.unitBonusScore = product.bonusScore;
this.sumScore = quantity * (int)unitBonusScore;
this.order = order;
this.stringUnitPrice = Unity.formatMoney((long)unitPriceSell);
this.idProduct = product.id;
this.idTypeProduct = product.category;
//get discount, idTypeCustomer=1 mean all customer, idProduct=6 means all type product
if (this.idDiscount == -1)
{
this.nameDiscount = "(Không có)";
}
else
{
var discount = (from p in dc.DiscountDbs where p.id == this.idDiscount select p).Single();
this.nameDiscount = discount.nameDiscount;
this.discountString = discount.percentageDiscount + "%";
}
var x = (long)(quantity * (long)unitPriceSell) * (100.0 - persentageDiscount) / 100.0;
this.sumMoney = (long)x;
var y = sumMoney - product.priceImport * quantity;
this.interest = (long)y;
this.stringSumMoney = Unity.formatMoney(sumMoney);
}
private void btnAddCustomer_Click(object sender, RoutedEventArgs e)
{
string messageError = "";
if (!checkInput())
{
MessageBox.Show("Lỗi", "Nhập dữ liệu sai");
}
else
{
String name = nameCustomerTxt.Text;
String phoneNumer = phoneNumberTxt.Text;
var dateOfBirth = dateOB.SelectedDate.Value.Date;
CustomerDb newCustomer = new CustomerDb(name, phoneNumer, dateOfBirth);
dc.CustomerDbs.InsertOnSubmit(newCustomer);
try
{
dc.SubmitChanges();
}
catch (Exception except)
{
//error
messageError = "Lưu dữ liệu không thành công";
MessageBox.Show("Lỗi", except.Message);
}
}
if (!messageError.Equals(""))
{
MessageBox.Show("Lỗi", messageError);
}
else
{
MessageBox.Show("Thành công", "Lưu thành công");
dialogCustomer.IsOpen = false;
reloadData();
}
}