protected void UpdatePPL_Click(object sender, EventArgs e)
{
string poscode = poscodeLabel.Text;
string Name = NameLabel.Text;
string posname = posnameLabel.Text;
string unitname = unitnameLabel.Text;
string company_id = companyLabel.Text;
string MOBILE = TelLabel.Text;
string group_in = GroupIDINLabel.Text;
string unicode = unitcodeLabel.Text;
string code = codeLabel.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;
}
int index = cl.Items.Count;
string loginName = Session["ID"].ToString();
for (int i = 0; i < index; i++)
{
string id = cl.Items[i].Value;
if (group_in.Contains(id) && !cl.Items[i].Selected)
{
cc2.DeletePTTBPPL(id, "100", code);
}
else if (!group_in.Contains(id) && cl.Items[i].Selected)
{
cc2.InsertPTTBService(id, code);
}
}
string result = cc2.InsertPTTBPPL(poscode, MOBILE, loginName, unicode, code);
if (result != "0")
{
cc2.UpdatePTTBPPL(code, MOBILE, loginName);
}
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail();
}
protected void Grid_ppl_RowCommand(object sender, GridViewCommandEventArgs e)
{
int pindex = Grid_ppl.PageIndex * Grid_ppl.PageSize;
if (e.CommandName == "DelPPL")
{
DataTable dtgroup = ViewState["CurrentPTTBGrp"] as DataTable;
DataTable dtppl = ViewState["CurrentPTTBPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString()) + pindex;
string group_id = groupLabel.Text;
int level = Convert.ToInt32(LevelLabel.Text);
// string text = TreeView1.SelectedNode.Text;
if (group_id == "-1")
{
return;
}
string depart = group_id.Substring(0, 3);
OracleQuery cc = new OracleQuery();
OracleQuery2 cc2 = new OracleQuery2();
string d = dtppl.Rows[index]["GROUP_KEY"].ToString();
string person_id = dtppl.Rows[index]["CODE"].ToString();
cc2.DeletePTTBPPL(group_id, d, person_id);
//TreeView1.Nodes.Clear();
//bindTree();
BindPPLDetail(group_id, level);
}
if (e.CommandName == "EditPPL")
{
AddPPLPanel.Visible = true;
grpPanel.Visible = true;
DataTable dtppl = ViewState["CurrentPTTBPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString()) + +pindex;
string EmployeeID = dtppl.Rows[index]["POSCODE"].ToString();
string Name = dtppl.Rows[index]["NAME"].ToString();
string posname = dtppl.Rows[index]["POSITION"].ToString();
string unitname = dtppl.Rows[index]["COMPANY"].ToString();
string MOBILE = dtppl.Rows[index]["MOBILE"].ToString();
poscodeLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
TelLabel.Text = MOBILE;
}
}