protected void SavePPL_Click(object sender, EventArgs e)
{
// string EmployeeID = EmployeeIDLabel.Text;
string Name = NameLabel.Text;
string posname = posnameLabel.Text;
// string unitname = unitnameLabel.Text;
string company_id = unitnameList.SelectedValue;
string MOBILE = TelLabel.Text;
string group_in = GroupIDINLabel.Text;
OracleQuery cc = new OracleQuery();
OracleQuery2 cc2 = new OracleQuery2();
var s = cl.Items.Cast <ListItem>()
.Where(item => item.Selected)
.Aggregate("", (current, item) => current + (item.Text + ", "));
string hh = s.TrimEnd(new[] { ',', ' ' });
if (hh == "")
{
NoResult.Visible = true;
errorlabel.Text = "กรุณาเลือกกลุ่มอย่างน้อย 1 กลุ่ม";
return;
}
DataTable dt_tempChk = ViewState["ALLPPL"] as DataTable;
//dt_tempChk.DefaultView.RowFilter = "[EMPLOYEE_ID] = '" + EmployeeID + "'";
//DataTable dtOutput = dt_tempChk.DefaultView.ToTable();
//if (dtOutput.Rows.Count > 0)
//{
// SavePPL.Enabled = false;
// NoResult.Visible = true;
// errorlabel.Text = "มีชื่อในระบบ";
// resultppl.Visible = false;
// return;
//}
DataView dv = dt_tempChk.DefaultView;
dv.Sort = "EMPLOYEE_ID desc";
DataTable sortedDT = dv.ToTable();
string EmployeeID = (Convert.ToDouble(sortedDT.Rows[0]["EMPLOYEE_ID"].ToString()) + 1).ToString();
int index = cl.Items.Count;
string loginName = Session["ID"].ToString();
cc2.InsertGCPPL(EmployeeID, Name, company_id, MOBILE, posname, loginName);
for (int i = 0; i < index; i++)
{
string id = cl.Items[i].Value;
if (cl.Items[i].Selected)
{
cc2.InsertGCService(id, EmployeeID, company_id);
}
}
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail();
}
protected void UpdatePPL_Click(object sender, EventArgs e)
{
string EmployeeID = EmployeeIDLabel.Text;
string Name = NameLabel.Text;
string posname = posnameLabel.Text;
// string unitname = unitnameLabel.Text;
string company_id = unitnameList.SelectedValue;
string MOBILE = TelLabel.Text;
string group_in = GroupIDINLabel.Text;
OracleQuery cc = new OracleQuery();
OracleQuery2 cc2 = new OracleQuery2();
var s = cl.Items.Cast <ListItem>()
.Where(item => item.Selected)
.Aggregate("", (current, item) => current + (item.Text + ", "));
string hh = s.TrimEnd(new[] { ',', ' ' });
if (hh == "")
{
NoResult.Visible = true;
errorlabel.Text = "กรุณาเลือกกลุ่มอย่างน้อย 1 กลุ่ม";
return;
}
string longinName = Session["ID"].ToString();
int index = cl.Items.Count;
for (int i = 0; i < index; i++)
{
string id = cl.Items[i].Value;
if (group_in.Contains(id) && !cl.Items[i].Selected)
{
cc2.DeleteGCPPL(id, "300", EmployeeID, company_id);
}
else if (!group_in.Contains(id) && cl.Items[i].Selected)
{
cc2.InsertGCService(id, EmployeeID, company_id);
}
}
cc2.updateGCPPL(EmployeeID, Name, company_id, MOBILE, posname, longinName);
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail();
}