private void LoadCustomerClassPrice()
{
var coll = CustomerClassPriceController.GetAllCustomerClassPrices(dtpStartDateCustomerClass.Value, txtProductFilter.Text);
gvCustomerClass.DataSource = coll;
gvCustomerClass.Columns[ConstColumns.ClassId].HeaderText = "รหัสระดับลูกค้า";
gvCustomerClass.Columns[ConstColumns.ClassName].HeaderText = "กลุ่มลูกค้า";
gvCustomerClass.Columns[ConstColumns.ProductCode].HeaderText = "รหัสสินค้า";
gvCustomerClass.Columns[ConstColumns.ProductName].HeaderText = "ชื่อสินค้า";
gvCustomerClass.Columns[ConstColumns.StartDate].HeaderText = "วันที่เริ่มต้น";
gvCustomerClass.Columns[ConstColumns.EndDate].HeaderText = "วินที่สิ้นสุด";
gvCustomerClass.Columns[ConstColumns.UnitPrice].HeaderText = "ราคาต่อหน่วย";
gvCustomerClass.Columns[ConstColumns.Day].HeaderText = "จำนวนวัน";
gvCustomerClass.Columns[ConstColumns.CreateAt].HeaderText = "วันเวลาสร้าง";
gvCustomerClass.Columns[ConstColumns.CreateBy].HeaderText = "ผู้สร้าง";
gvCustomerClass.Columns[ConstColumns.ModifiedAt].HeaderText = "วันเวลาแก้ไข";
gvCustomerClass.Columns[ConstColumns.ModifiedBy].HeaderText = "ผู้แก้ไข";
gvCustomerClass.Columns[ConstColumns.ClassId].Visible = false;
gvCustomerClass.Columns[ConstColumns.UnitPrice].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
gvCustomerClass.Columns[ConstColumns.Day].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
gvCustomerClass.Columns[ConstColumns.UnitPrice].DefaultCellStyle.Format = "N2";
gvCustomerClass.Columns[ConstColumns.Day].DefaultCellStyle.Format = "N0";
gvCustomerClass.Columns[ConstColumns.StartDate].DefaultCellStyle.Format = "dd/MM/yyyy";
gvCustomerClass.Columns[ConstColumns.EndDate].DefaultCellStyle.Format = "dd/MM/yyyy";
gvCustomerClass.Columns[ConstColumns.CreateAt].DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
gvCustomerClass.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;
cboCustomerClass.Enabled = false;
}
CustomerClassPrice customerPrice = CustomerClassPriceController.GetCustomerClassPrice(this.classId, this.productCode, this.startDate);
if (customerPrice != null)
{
cboCustomerClass.SelectedValue = customerPrice.MasterClass.ClassId;
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 customerClassPrice = new CustomerClassPrice
{
MasterClass = new MasterClass
{
ClassId = Convert.ToInt32(cboCustomerClass.SelectedValue)
},
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 && cboCustomerClass.Enabled == true)
{
CustomerClassPriceController.Insert(customerClassPrice);
}
else
{
CustomerClassPriceController.Update(customerClassPrice);
}
}
catch (Exception)
{
throw;
}
}
