private void LoadCustomerPrice()
{
var coll = CustomerPriceController.GetAllCustomerPrices(dtpStartDateCv.Value, cboProductCv.SelectedValue.ToString());
gvCv.DataSource = coll;
gvCv.Columns[ConstColumns.CustomerCode].HeaderText = "รหัสลูกค้า";
gvCv.Columns[ConstColumns.CustomerName].HeaderText = "ชื่อลูกค้า";
gvCv.Columns[ConstColumns.ProductCode].HeaderText = "รหัสสินค้า";
gvCv.Columns[ConstColumns.ProductName].HeaderText = "ชื่อสินค้า";
gvCv.Columns[ConstColumns.StartDate].HeaderText = "วันที่เริ่มต้น";
gvCv.Columns[ConstColumns.EndDate].HeaderText = "วินที่สิ้นสุด";
gvCv.Columns[ConstColumns.UnitPrice].HeaderText = "ราคาต่อหน่วย";
gvCv.Columns[ConstColumns.Day].HeaderText = "จำนวนวัน";
gvCv.Columns[ConstColumns.CreateAt].HeaderText = "วันเวลาสร้าง";
gvCv.Columns[ConstColumns.CreateBy].HeaderText = "ผู้สร้าง";
gvCv.Columns[ConstColumns.ModifiedAt].HeaderText = "วันเวลาแก้ไข";
gvCv.Columns[ConstColumns.ModifiedBy].HeaderText = "ผู้แก้ไข";
gvCv.Columns[ConstColumns.UnitPrice].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
gvCv.Columns[ConstColumns.Day].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
gvCv.Columns[ConstColumns.UnitPrice].DefaultCellStyle.Format = "N2";
gvCv.Columns[ConstColumns.Day].DefaultCellStyle.Format = "N0";
gvCv.Columns[ConstColumns.StartDate].DefaultCellStyle.Format = "dd/MM/yyyy";
gvCv.Columns[ConstColumns.EndDate].DefaultCellStyle.Format = "dd/MM/yyyy";
gvCv.Columns[ConstColumns.CreateAt].DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
gvCv.Columns[ConstColumns.ModifiedAt].DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
}
private void LoadData()
{
if (String.IsNullOrEmpty(this.productCode) == false)
{
btnLovProduct.Enabled = false;
txtProductName.Enabled = false;
cboCustomer.Enabled = false;
}
CustomerPrice customerPrice = CustomerPriceController.GetCustomerPrice(this.customerCode, this.productCode, this.startDate);
if (customerPrice != null)
{
cboCustomer.SelectedValue = customerPrice.Customer.CustomerCode;
this.productCode = customerPrice.Product.ProductCode;
txtProductName.Text = customerPrice.Product.ProductName;
txtUnitPrice.Text = customerPrice.UnitPrice.ToString();
txtDay.Text = customerPrice.Day.ToString();
dtpStartDate.Value = customerPrice.StartDate;
dtpStartDate.Enabled = false;
BtnSaveAndNew.Visible = false;
}
}
private void Save()
{
try
{
var customerPrice = new CustomerPrice
{
Customer = new Customer
{
CustomerCode = cboCustomer.SelectedValue.ToString()
},
Product = new Product
{
ProductCode = this.productCode
},
StartDate = dtpStartDate.Value,
EndDate = dtpStartDate.Value.AddDays(Convert.ToInt16(txtDay.Text) - 1),
Day = Convert.ToInt16(txtDay.Text),
UnitPrice = Convert.ToDecimal(txtUnitPrice.Text),
CreateBy = "system",
ModifiedBy = "system"
};
if (btnLovProduct.Enabled == true && cboCustomer.Enabled == true)
{
CustomerPriceController.Insert(customerPrice);
}
else
{
CustomerPriceController.Update(customerPrice);
}
}
catch (Exception)
{
throw;
}
}
