private void cmdSave_Click(object sender, EventArgs e)
{
if (txtpsnCode.Text.Trim() == "")
{
MessageBox.Show("กรุณาเลือกพนักงาน ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtpsnCode.Focus();
return;
}
WorkTable workTable = new WorkTable();
workTable.psnCode = txtpsnCode.Text.Trim();
List<WorkTableDetail> workTableDetails = new List<WorkTableDetail>();
WorkTableDetail workTableDetail = null;
for (int i = 0; i < dgvList.Rows.Count; i++)
{
if (Convert.ToBoolean(dgvList.Rows[i].Cells[0].Value = true))
{
workTableDetail = new WorkTableDetail();
workTableDetail.day = dgvList.Rows[i].Cells[3].Value.ToString();
workTableDetail.start = dgvList.Rows[i].Cells[4].Value.ToString();
workTableDetail.end = dgvList.Rows[i].Cells[5].Value.ToString();
workTableDetails.Add(workTableDetail);
}
}
workTable.workTableDetails = workTableDetails;
int result = workTableService.CreateWorkTable(workTable);
if (result > -1)
{
Console.WriteLine("Insert Complete");
lblresult.Visible = true;
lblresult.Text = " บันทึกเรียบร้อย ";
}
else
{
Console.WriteLine("Insert Not Complete");
lblresult.Visible = true;
lblresult.Text = " ไม่สามารถบันทึกข้อมูลได้";
}
}
private void frmWorkTable_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
try
{
cboSearch.Items.Add("รหัสพนักงาน");
cboSearch.Items.Add("ชื่อพนักงาน");
cboSearch.SelectedIndex = 1;
txtpsnPrefix.Enabled = false;
txtpsnName.Enabled = false;
txtpsnLastName.Enabled = false;
txtpsndpName.Enabled = false;
txtpsnpsName.Enabled = false;
List<WorkTableDetail> workTableDetails = new List<WorkTableDetail>();
WorkTableDetail workTableDetail;
workTableDetail = new WorkTableDetail();
workTableDetail.day = "จันทร์";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "อังคาร";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "พุธ";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "พฤหัสบดี";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "ศุกร์";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "เสาร์";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
workTableDetail = new WorkTableDetail();
workTableDetail.day = "อาทิตย์";
workTableDetail.start = "08.00";
workTableDetail.end = "17.00";
workTableDetails.Add(workTableDetail);
//Bind XML dataset to DataGridView
//DataSet ds = new DataSet();
//ds.ReadXml(_xmlFilePath);
dgvList.DataSource = workTableDetails;
countRow = workTableDetails.Count;
FormatdgvList();
FormatDgvList();
DatagridViewCheckBoxHeaderCell cbHeader = new DatagridViewCheckBoxHeaderCell();
Column1.HeaderCell = cbHeader;
Column1.HeaderText = "";
Column1.Width = 50;
cbHeader.OnCheckBoxClicked += new CheckBoxClickedHandler(cbHeader_OnCheckBoxClicked);
////Add the checkbox column
//dataGridView1.Columns.Insert(0,
// new DataGridViewCheckBoxColumn());
////SendKeys.Send("{TAB}");
//dataGridView1.ReadOnly = false;
//foreach (DataGridViewColumn c in dataGridView1.Columns) {
// c.SortMode = DataGridViewColumnSortMode.NotSortable;
// c.Selected = true;
//}
//dataGridView1.SelectionMode = DataGridViewSelectionMode.FullColumnSelect;
//dataGridView1.Columns[1].Selected = true;
}
catch (Exception ex)
{
MessageBox.Show("Exception: " + ex.ToString());
}
}
