private void Gv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
DataGridView senderGrid = (DataGridView)sender;
int id = Convert.ToInt32(gv.Rows[e.RowIndex].Cells[1].Value);
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewImageColumn && e.RowIndex >= 0)
{
var frm = new Form_MasterClassAddEdit
{
customerClassId = id
};
if (frm.ShowDialog() == DialogResult.OK)
{
Populate();
}
}
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewLinkColumn && e.RowIndex >= 0)
{
var customers = MasterClassController.GetCustomersByClass(id, "2020-01-24");
var coll = customers.Select(p => new
{
p.CustomerCode,
p.CustomerName
}).ToList();
gvCustomer.DataSource = coll;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Populate()
{
try
{
var coll = MasterClassController.GetAllMasterClass(TxtFilter.Text.Trim());
gv.DataSource = coll;
//gv.Columns[ConstColumns.ClassId].HeaderText = "รหัสระดับลุกค้า";
//gv.Columns[ConstColumns.ClassName].HeaderText = "ชื่อระดับลุกค้า";
//gv.Columns[ConstColumns.Active].HeaderText = "ใช้งาน";
//gv.Columns[ConstColumns.CreateAt].HeaderText = "วันเวลาสร้าง";
//gv.Columns[ConstColumns.CreateBy].HeaderText = "ผู้สร้าง";
//gv.Columns[ConstColumns.ModifiedAt].HeaderText = "วันเวลาแก้ไข";
//gv.Columns[ConstColumns.ModifiedBy].HeaderText = "ผู้แก้ไข";
gv.Columns[4].DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
gv.Columns[6].DefaultCellStyle.Format = "dd/MM/yyyy HH:mm:ss";
//gv.Columns[7].Visible = false;
gvCustomer.DataSource = null;
}
catch (Exception)
{
throw;
}
}
private void Form_CustomerClassAddEdit_Load(object sender, System.EventArgs e)
{
if (customerClassId > 0)
{
var customerClass = MasterClassController.GetMasterClass(this.customerClassId);
if (customerClass != null)
{
txtCustomerClassCode.Text = customerClass.ClassId.ToString();
txtCustomerClassCode.Enabled = false;
txtCustomerClassName.Text = customerClass.ClassName;
chkActive.Checked = customerClass.Active;
}
}
}
private void BtnSave_Click(object sender, System.EventArgs e)
{
try
{
if (customerClassId == 0)
{
var customerClass = new MasterClass
{
//UnitCode = Convert.ToInt32(txtUnitCode.Text),
ClassName = txtCustomerClassName.Text.Trim(),
Active = chkActive.Checked,
CreateBy = "system",
};
MasterClassController.Insert(customerClass);
MessageBox.Show("บันทึกข้อมูลเรียบร้อย.", "Sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var customerClass = new MasterClass
{
ClassId = Convert.ToInt32(txtCustomerClassCode.Text),
ClassName = txtCustomerClassName.Text.Trim(),
Active = chkActive.Checked,
ModifiedBy = "system",
};
MasterClassController.Update(customerClass);
MessageBox.Show("บันทึกข้อมูลเรียบร้อย.", "Sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void BtnSaveAndNew_Click(object sender, System.EventArgs e)
{
try
{
var customerClass = new MasterClass
{
//UnitCode = Convert.ToInt32(txtUnitCode.Text),
ClassName = txtCustomerClassName.Text.Trim(),
Active = chkActive.Checked,
CreateBy = "system",
};
MasterClassController.Insert(customerClass);
MessageBox.Show("บันทึกข้อมูลเรียบร้อย.", "Sucess", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCustomerClassCode.Text = "";
txtCustomerClassCode.Focus();
txtCustomerClassName.Text = "";
chkActive.Checked = true;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadMasterClass()
{
comboxMasterClass.DataSource = MasterClassController.GetAllMasterClassCombobox();
comboxMasterClass.ValueMember = "ClassId";
comboxMasterClass.DisplayMember = "ClassName";
}
