protected void UpdatePPL_Click(object sender, EventArgs e)
{
string group_id = groupLabel.Text;
int level = Convert.ToInt32(LevelLabel.Text);
string EmployeeID = EmployeeIDLabel.Text;
string MOBILE = TelLabel.Text;
string loginName = Session["ID"].ToString();
OracleQuery2 cc2 = new OracleQuery2();
cc2.UpdateTCSPPL(EmployeeID, MOBILE, loginName);
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail(group_id, level);
}
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["CurrentGCGrp"] as DataTable;
DataTable dtppl = ViewState["CurrentGCPPL"] 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);
OracleQuery2 cc2 = new OracleQuery2();
string d = dtppl.Rows[index]["GROUP_KEY"].ToString();
string person_id = dtppl.Rows[index]["EMPLOYEE_id"].ToString();
string company_id = dtppl.Rows[index]["COMPANY_id"].ToString();
cc2.DeleteGCPPL(group_id, d, person_id, company_id);
//TreeView1.Nodes.Clear();
//bindTree();
BindPPLDetail(group_id, level);
}
if (e.CommandName == "EditPPL")
{
AddPPLPanel.Visible = true;
grpPanel.Visible = true;
DataTable dtppl = ViewState["CurrentGCPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString()) + pindex;
string EmployeeID = dtppl.Rows[index]["EMPLOYEE_ID"].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();
string company_id = dtppl.Rows[index]["COMPANY_id"].ToString();
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
TelLabel.Text = MOBILE;
CompanyIDLabel.Text = company_id;
}
}
protected void Grid_ppl_RowCommand(object sender, GridViewCommandEventArgs e)
{
int pindex = Grid_ppl.PageIndex * Grid_ppl.PageSize;
if (e.CommandName == "DelPPL")
{
DataTable dtppl = ViewState["CurrentCSEditPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString()) + pindex;
OracleQuery2 cc2 = new OracleQuery2();
string d = dtppl.Rows[index]["GROUP_KEY"].ToString();
string person_id = dtppl.Rows[index]["Person_ID"].ToString();
// string company_id = dtppl.Rows[index]["COMPANY_id"].ToString();
cc2.DeleteCSPPLFromAllGroup(person_id);
BindPPLDetail();
}
if (e.CommandName == "EditPPL")
{
AddPPLPanel.Visible = true;
grpPanel.Visible = true;
GroupIDINLabel.Text = "";
DataTable dtppl = ViewState["CurrentCSEditPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString()) + pindex;
string EmployeeID = dtppl.Rows[index]["Person_id"].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();
// string company_id = dtppl.Rows[index]["company_id"].ToString();
SetGroup(EmployeeID);
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
//companyLabel.Text = company_id;
TelLabel.Text = MOBILE;
resultppl.Visible = true;
SavePPL.Enabled = true;
grpPanel.Visible = true;
AddPPLPanel.Visible = true;
HeadModal.Visible = false;
UpdatePPL.Visible = true;
SavePPL.Visible = false;
NoResult.Visible = false;
}
}
private void bindGroupList()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dtgroup = cc2.LoadAllGroups();
dtgroup.Columns.Add("text");
foreach (DataRow r in dtgroup.Rows)
{
r["text"] = r["DEPARTMENT"] + " - " + r["GROUP_NAME"];
}
GroupList.DataSource = dtgroup;
GroupList.DataTextField = "text";
GroupList.DataValueField = "GROUP_ID";
GroupList.DataBind();
GroupList.Items.Insert(0, new ListItem("--ทั้งหมด--", "-1"));
GroupList.SelectedIndex = 0;
}
protected void EditGrp_Click(object sender, EventArgs e)
{
string grpname = EditGroupTextBox.Text.Trim();
string grpid = EditGroupIDTextBox.Text;
string loginName = Session["ID"].ToString();
grpid = grpid.Remove(0, 1);
OracleQuery2 cc2 = new OracleQuery2();
cc2.UpdateGroup(grpid, grpname, loginName);
grpPanel.Visible = false;
EditGrpPanel.Visible = false;
string group_id = TreeView1.SelectedNode.Value;
int level = TreeView1.SelectedNode.Depth;
BindGroupDetail(group_id, level);
SetGroup(group_id, level);
}
public void BindGroupDetail(string group_id, int level)
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dtgroup = cc2.LoadGroupAllCreate(group_id);
ViewState["CurrentEditGrp"] = dtgroup;
if (dtgroup.Rows.Count > 0)
{
Grid_group.DataSource = dtgroup;
Grid_group.DataBind();
}
else
{
Grid_group.DataSource = null;
Grid_group.DataBind();
}
}
protected void cl_SelectedIndexChanged(object sender, EventArgs e)
{
string group_id = GROUP_IDLabel.Text;
string st = group_id.Remove(0, 1);
OracleQuery2 cc2 = new OracleQuery2();
string loginName = Session["ID"].ToString();
foreach (ListItem item in cl.Items)
{
if (item.Selected)
{
cc2.updateDisplayGroup(st, item.Value, 1, loginName);
}
else
{
cc2.updateDisplayGroup(st, item.Value, 0, loginName);
}
}
}
protected void SAVEGrp_Click(object sender, EventArgs e)
{
if (InputGroup.Text == "")
{
return;
}
int level = TreeView1.SelectedNode.Depth + 2;
if (level > 4)
{
return;
}
DataTable dt = ViewState["AllGroup"] as DataTable;
string master_Group_id = GROUP_IDLabel.Text;// TreeView1.SelectedNode.Value;
string department = master_Group_id.Substring(0, 3);
DataTable dt2 = new DataTable();
string maxId;
DataRow[] row = dt.Select("DEPARTMENT_ID=" + department + " AND GROUP_LEVEL =" + level);
if (row.Count() > 0)
{
dt2 = row.CopyToDataTable();
var maxRow = dt2.Select("Group_id = MAX(Group_id)");
maxId = (Convert.ToInt32(maxRow[0]["Group_id"]) + 1).ToString();
}
else
{
maxId = department + level + "001";
}
string Group_id = maxId;
string Group_name = InputGroup.Text;
string longinName = Session["ID"].ToString();
OracleQuery2 cc2 = new OracleQuery2();
cc2.InsertNewGroup(Group_id, Group_name, level, master_Group_id, longinName);
grpPanel.Visible = false;
AddGroupPanel.Visible = false;
TreeView1.Nodes.Clear();
bindTree();
BindGroupDetail(master_Group_id, 0);
}
public void BindGroupDetail(string group_id, int level)
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dtgroup = cc2.LoadGroup(group_id);
ViewState["CurrentGrp"] = dtgroup;
if (dtgroup.Rows.Count > 0)
{
Grid_group.DataSource = dtgroup;
Grid_group.DataBind();
GROUP_PANEL.Visible = true;
}
else
{
Grid_group.DataSource = null;
Grid_group.DataBind();
GROUP_PANEL.Visible = false;
}
}
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 = companyLabel.Text;
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;
}
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.DeleteCSPPL(id, "400", EmployeeID);
}
else if (!group_in.Contains(id) && cl.Items[i].Selected)
{
cc2.InsertCSService(id, EmployeeID, company_id);
}
}
cc2.updateCSPPL(EmployeeID, MOBILE);
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail();
}
public void BindPPLDetail()
{
SchPPL.Text = "";
OracleQuery2 cc2 = new OracleQuery2();
DataTable dtppl = cc2.LoadGCPPL();
ViewState["CurrentGCEditPPL"] = dtppl;
ViewState["ALLPPL"] = dtppl;
if (dtppl.Rows.Count > 0)
{
Grid_ppl.DataSource = dtppl;
Grid_ppl.DataBind();
PPL_PANEL.Visible = true;
}
else
{
Grid_ppl.DataSource = null;
Grid_ppl.DataBind();
PPL_PANEL.Visible = false;
}
}
private void bindLink()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAllDepart();
string name = "";
string value = "";
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
name = r["NAME"].ToString();
value = r["ID"].ToString();
LinkButton lb = new LinkButton();
lb.Text = "" + name + "" + "<br/>";
lb.Command += new CommandEventHandler(bindGrid);
lb.CommandArgument = value;
LinkHolder.Controls.Add(lb);
}
}
}
private void bindTree()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAllGroups();
ViewState["AllGroup"] = dt;
try
{
foreach (DataRow r in dt.Rows)
{
if (r["MASTER_GROUP_ID"].ToString() == r["GROUP_ID"].ToString())
{
TreeNode root = new TreeNode(r["master_name"].ToString(), r["MASTER_GROUP_ID"].ToString());
// root.SelectAction = TreeNodeSelectAction.Expand;
CreateNode(root, dt, r["GROUP_ID"].ToString());
TreeView1.Nodes.Add(root);
}
}
}
catch (Exception Ex) { throw Ex; }
}
protected void UpdatePPL_Click(object sender, EventArgs e)
{
string group_id = groupLabel.Text;
int level = Convert.ToInt32(LevelLabel.Text);
string poscode = poscodeLabel.Text;
string loginName = Session["ID"].ToString();
string MOBILE = TelLabel.Text;
string unitcode = "";
string code = "";
OracleQuery cc = new OracleQuery();
OracleQuery2 cc2 = new OracleQuery2();
string result = cc2.InsertPTTBPPL(poscode, MOBILE, loginName, unitcode, code);
if (result != "0")
{
cc2.UpdatePTTBPPL(code, MOBILE, loginName);
}
grpPanel.Visible = false;
AddPPLPanel.Visible = false;
BindPPLDetail(group_id, level);
}
protected void DelGroup_Click(object sender, EventArgs e)
{
string Group_id = GROUP_IDLabel.Text;//TreeView1.SelectedNode.Value;
OracleQuery2 cc2 = new OracleQuery2();
if (TreeView1.SelectedNode.Depth == 0)
{
return;
}
cc2.DeleteGroup(Group_id);
TreeView1.Nodes.Clear();
bindTree();
string group_id = TreeView1.Nodes[0].Value;
GROUPLabel.Text = TreeView1.SelectedNode.Text;
GROUP_IDLabel.Text = TreeView1.SelectedNode.Value;
Grid_group.DataSource = null;
Grid_group.DataBind();
cl.DataSource = null;
cl.DataBind();
BindGroupDetail(group_id, 0);
}
public void BindPPLDetail(string group_id, int level)
{
groupLabel.Text = group_id;
LevelLabel.Text = level.ToString();
OracleQuery2 cc2 = new OracleQuery2();
DataTable dtppl = cc2.LoadGCPPL(group_id);
//dtppl = findPTTPerson(dtppl, group_id);
ViewState["CurrentGCPPL"] = dtppl;
if (dtppl.Rows.Count > 0)
{
Grid_ppl.DataSource = dtppl;
Grid_ppl.DataBind();
PPL_PANEL.Visible = true;
}
else
{
Grid_ppl.DataSource = null;
Grid_ppl.DataBind();
PPL_PANEL.Visible = false;
}
}
private void SetGroup(string group_id, int level)
{
OracleQuery2 cc2 = new OracleQuery2();
string st = group_id.Remove(0, 1);
DataTable dt = cc2.LoadDisplayGroup(st); //cc2.LoadCSGroup(group_id);
cl.DataSource = dt;
cl.DataTextField = "NAME";
cl.DataValueField = "DEPARTMENT_ID";
cl.DataBind();
cl.Enabled = level > 1;
//string select_group = "";
foreach (DataRow r in dt.Rows)
{
string Group_id_in = r["isshow"].ToString();
string depart = r["DEPARTMENT_ID"].ToString();
if (!String.IsNullOrEmpty(Group_id_in))
{
cl.Items.FindByValue(depart).Selected = Group_id_in == "1";
}
}
//GroupIDINLabel.Text = select_group;
}
private void bindTree()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAllGroups2Edit();
dt = dt.Select("DEPARTMENT_ID =300").CopyToDataTable();
ViewState["AllGroup"] = dt;
try
{
foreach (DataRow r in dt.Rows)
{
if (r["MASTER_GROUP_ID"].ToString() == r["GROUP_ID"].ToString())
{
TreeNode root = new TreeNode("กลุ่ม", r["MASTER_GROUP_ID"].ToString());
// root.SelectAction = TreeNodeSelectAction.Expand;
CreateNode(root, dt, r["GROUP_ID"].ToString());
TreeView1.Nodes.Add(root);
}
}
TreeView1.Nodes[0].Selected = true;
}
catch (Exception Ex) { throw Ex; }
}
protected void Grid_ppl_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DelPPL")
{
DataTable dtgroup = ViewState["CurrentGrp"] as DataTable;
DataTable dtppl = ViewState["CurrentPPL"] as DataTable;
int index = Convert.ToInt32(e.CommandArgument.ToString());
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);
OracleQuery2 cc2 = new OracleQuery2();
string person_id = dtppl.Rows[index]["id"].ToString();
cc2.DeleteTESTPPL(group_id, person_id);
//TreeView1.Nodes.Clear();
//bindTree();
BindPPLDetail(group_id, level);
}
}
private void SetGroup(string EmployeeID, string company_id)
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadGCGroup(EmployeeID, company_id);
cl.DataSource = dt;
cl.DataTextField = "GROUP_NAME";
cl.DataValueField = "group_id";
cl.DataBind();
string select_group = "";
foreach (DataRow r in dt.Rows)
{
string Group_id_in = r["Group_id_in"].ToString();
if (!String.IsNullOrEmpty(Group_id_in))
{
cl.Items.FindByValue(Group_id_in).Selected = true;
select_group += Group_id_in + " ";
}
}
GroupIDINLabel.Text = select_group;
}
public void BindPPLDetail()
{
SchPPL.Text = "";
OracleQuery2 cc2 = new OracleQuery2();
SQLServerQuery ss = new SQLServerQuery();
DataTable dt = cc2.LoadPTTPPL();
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["EMPLOYEE_ID"].ToString() + ",";
}
result = result.TrimEnd(',');
DataTable dt_pis = ss.LoadINPIS("", result);
DataTable dtppl = new DataTable();
dtppl.Columns.Add("EMPLOYEE_ID");
dtppl.Columns.Add("NAME");
dtppl.Columns.Add("POSITION");
dtppl.Columns.Add("COMPANY");
dtppl.Columns.Add("UNITCODE");
dtppl.Columns.Add("MOBILE");
dtppl.Columns.Add("LASTUPDATE", typeof(DateTime));
dtppl.Columns.Add("UPDATE_BY");
dtppl.Columns.Add("Keyword");
dtppl.Columns.Add("GROUP_KEY");
dtppl.Columns.Add("MOBILE_FM");
dtppl.Columns.Add("STATUS");
if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0)
{
var results = from table1 in dt.AsEnumerable()
join table2 in dt_pis.AsEnumerable() on table1["EMPLOYEE_ID"].ToString() equals table2["P_ID"].ToString()
select new
{
EMPLOYEE_ID = table1["EMPLOYEE_ID"].ToString(),
FULLNAMETH = table2["FULLNAMETH"].ToString(),
POSNAME = table2["POSNAME"].ToString(),
unitname = table2["unitname"].ToString(),
unitcode = table2["UNITCODE"].ToString(),
lastupdate = table1["LASTUPDATE"],
updateby = table1["UPDATE_BY"].ToString(),
keyword = table1["EMPLOYEE_ID"].ToString() + " " + table2["FULLNAMETH"].ToString() + " " + table2["POSNAME"].ToString() + " " + table2["unitname"].ToString(),
mobile = !string.IsNullOrEmpty(table2["mobile"].ToString()) ? table2["mobile"].ToString() : table1["mobile"].ToString(),
MOBILE_FM = string.IsNullOrEmpty(table2["mobile"].ToString()) ?1:0,
STATUS = table1["STATUS"].ToString(),
};
foreach (var item in results)
{
dtppl.Rows.Add(item.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.unitcode, item.mobile, item.lastupdate, item.updateby, item.keyword, 200, item.MOBILE_FM, item.STATUS);
}
}
// dtppl = findPTTPerson(dtppl, group_id);
ViewState["CurrentPTTEditPPL"] = dtppl;
ViewState["ALLPPL"] = dtppl;
if (dtppl.Rows.Count > 0)
{
Grid_ppl.DataSource = dtppl;
Grid_ppl.DataBind();
PPL_PANEL.Visible = true;
}
else
{
Grid_ppl.DataSource = null;
Grid_ppl.DataBind();
PPL_PANEL.Visible = false;
}
}
public bool AuthenticateUser(string domain, string username, string password, string LdapPath, out string Errmsg)
{
Errmsg = "";
string domainAndUsername = domain + @"\" + username;
DirectoryEntry entry = new DirectoryEntry(LdapPath, domainAndUsername, password);
OracleQuery2 cc2 = new OracleQuery2();
try
{
if (username == "X9MICT" && password == "x9mict")
{
string _filterAttribute = "-1";
string _filterNameAttribute = "X9MICT";
string _filterFullnameAttribute = "X9MICT";
Session.Timeout = 20;
// Session["ID"] = _filterFullnameAttribute;
Session["ID"] = _filterAttribute;
Session["ADMIN"] = 1;
}
else if (username == "GASCONTROL" && password == "gascontrol")
{
string _filterAttribute = "GC";
string _filterNameAttribute = "GASCONTROL";
string _filterFullnameAttribute = "GASCONTROL";
Session.Timeout = 20;
// Session["ID"] = _filterFullnameAttribute;
Session["ID"] = _filterAttribute;
Session["ADMIN"] = 0;
}
else
{
// Bind to the native AdsObject to force authentication.
Object obj = entry.NativeObject;
DirectorySearcher search = new DirectorySearcher(entry);
search.Filter = "(SAMAccountName=" + username + ")";
search.PropertiesToLoad.Add("cn");
search.PropertiesToLoad.Add("SAMAccountName");
search.PropertiesToLoad.Add("displayName");
SearchResult result = search.FindOne();
if (null == result)
{
Errmsg = "Invalid user name or Password!";
return(false);
}
// Update the new path to the user in the directory
LdapPath = result.Path;
string _filterAttribute = (String)result.Properties["cn"][0];
string _filterNameAttribute = (String)result.Properties["SAMAccountName"][0];
string _filterFullnameAttribute = (String)result.Properties["displayName"][0];
Session.Timeout = 20;
// Session["ID"] = _filterFullnameAttribute;
DataTable dt = cc2.findAdmin(_filterAttribute);
if (dt.Rows.Count > 0)
{
Session["ID"] = _filterAttribute;
Session["ADMIN"] = Convert.ToInt16(dt.Rows[0]["IS_ADMIN"]);
}
else
{
Session["ID"] = null;
Session["ADMIN"] = 0;
Errmsg = "Invalid User";
return(false);
}
}
}
catch (Exception ex)
{
Errmsg = ex.Message;
return(false);
throw new Exception("Error authenticating user." + ex.Message);
}
return(true);
}
private void bindreportgrid()
{
DataTable dt = new DataTable();
if (ReportList.SelectedValue != "-1")
{
errorLabel.Visible = false;
grpPanel.Visible = true;
reportPanel.Visible = true;
ReportResultView.Visible = true;
SumChart.Visible = false;
ExcelBtn.Visible = true;
ReportNameLabel.Text = ReportList.SelectedItem.Text;
int stahrs = Convert.ToInt32(StaTime.SelectedValue);
int endhrs = Convert.ToInt32(EndTime.SelectedValue);
DateTime st_date = staCalendar.SelectedDate.AddHours(stahrs); // Convert.ToDateTime(startLabel.Text);
DateTime end_date = endCalendar.SelectedDate.AddHours(endhrs); //Convert.ToDateTime(endLabel.Text).AddHours(24);
if (end_date < st_date)
{
end_date = st_date;
EndTime.SelectedValue = StaTime.SelectedValue;
}
OracleQuery2 cc2 = new OracleQuery2();
string groupid = GroupList.SelectedValue;
if (ReportList.SelectedValue == "1")
{
dt = cc2.LoadAllSMSReport(st_date, end_date, groupid);
}
else if (ReportList.SelectedValue == "2")
{
dt = cc2.LoadSMSReport(st_date, end_date, 1, groupid);
}
else if (ReportList.SelectedValue == "3")
{
dt = cc2.LoadSMSReport(st_date, end_date, 0, groupid);
}
else if (ReportList.SelectedValue == "5")
{
dt = cc2.LoadManualSMSReport(st_date, end_date);
}
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Add("SEND_DATE_STR");
foreach (DataRow r in dt.Rows)
{
r["SEND_DATE_STR"] = ((DateTime)r["SEND_DATE"]).ToString("dd/MM/yyyy HH:mm:ss");
}
ReportResultView.DataSource = dt;
ReportResultView.DataBind();
NodataLabel.Visible = false;
}
else
{
ReportResultView.DataSource = null;
ReportResultView.DataBind();
NodataLabel.Visible = true;
}
}
else
{
errorLabel.Visible = true;
}
ViewState["ReportResultView"] = dt;
}
protected void SchBox_Changed(object sender, EventArgs e)
{
string sch = SchBox.Text;
try
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadToAddGCPPL(sch);
if (dt.Rows.Count > 0)
{
string EmployeeID = dt.Rows[0]["EMPLOYEE_ID"].ToString();
string Name = dt.Rows[0]["NAME"].ToString();
string posname = dt.Rows[0]["POSITION"].ToString();
string unitname = dt.Rows[0]["COMPANY"].ToString();
string MOBILE = dt.Rows[0]["MOBILE"].ToString();
string company_id = dt.Rows[0]["company_id"].ToString();
TelLabel.Text = MOBILE;
SetGroup(EmployeeID, company_id);
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
// unitnameLabel.Text = unitname;
companyLabel.Text = company_id;
resultppl.Visible = true;
SavePPL.Enabled = true;
NoResult.Visible = false;
}
else
{
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
string company_id = "";
string MOBILE = "";
TelLabel.Text = MOBILE;
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
// unitnameLabel.Text = unitname;
companyLabel.Text = company_id;
SavePPL.Enabled = false;
NoResult.Visible = true;
resultppl.Visible = false;
errorlabel.Text = "ไม่พบข้อมูล";
}
}
catch {
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
string company_id = "";
string MOBILE = "";
TelLabel.Text = MOBILE;
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
// unitnameLabel.Text = unitname;
companyLabel.Text = company_id;
SavePPL.Enabled = false;
NoResult.Visible = true;
resultppl.Visible = false;
errorlabel.Text = "ไม่พบข้อมูล";
}
}
public void BindPPLDetail(string group_id, int level)
{
groupLabel.Text = group_id;
LevelLabel.Text = level.ToString();
OracleQuery2 cc2 = new OracleQuery2();
SQLServerQuery ss = new SQLServerQuery();
DataTable dt = cc2.LoadPTTBPPL(group_id);
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["CODE"].ToString() + ",";
}
result = result.TrimEnd(',');
result = result.TrimStart(',');
DataTable dt_pis = ss.LoadPosecodeINPIS(result);
DataTable dtppl = new DataTable();
dtppl.Columns.Add("POSCODE");
dtppl.Columns.Add("NAME");
dtppl.Columns.Add("POSITION");
dtppl.Columns.Add("COMPANY");
dtppl.Columns.Add("MOBILE");
dtppl.Columns.Add("UNITCODE");
dtppl.Columns.Add("CODE");
dtppl.Columns.Add("GROUP_KEY");
if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0)
{
var results = from table1 in dt.AsEnumerable()
join table2 in dt_pis.AsEnumerable() on table1["CODE"].ToString() equals table2["P_ID"].ToString()
select new
{
POSCODE = table1["POSCODE"].ToString(),
FULLNAMETH = table2["FULLNAMETH"].ToString(),
POSNAME = table2["POSNAME"].ToString(),
unitname = table2["unitname"].ToString(),
unitcode = table1["UNITCODE"].ToString(),
code = table1["CODE"].ToString(),
mobile = !string.IsNullOrEmpty(table2["mobile"].ToString()) ? table2["mobile"].ToString() : table1["mobile"].ToString()
};
foreach (var item in results)
{
dtppl.Rows.Add(item.POSCODE, item.FULLNAMETH, item.POSNAME, item.unitname, item.mobile, item.unitcode, item.code, 100);
}
}
ViewState["CurrentPTTBPPL"] = dtppl;
if (dtppl.Rows.Count > 0)
{
Grid_ppl.DataSource = dtppl;
Grid_ppl.DataBind();
PPL_PANEL.Visible = true;
}
else
{
Grid_ppl.DataSource = null;
Grid_ppl.DataBind();
PPL_PANEL.Visible = false;
}
}
