public string InsertLog(string Action, string PageUrl)
{
string username = "";
if (HttpContext.Current.Session["UserLoginData"] != null)
{
MDUserLoginData oUser = new MDUserLoginData();
oUser = (MDUserLoginData)HttpContext.Current.Session["UserLoginData"];
if (oUser.ListOfUser.Count > 0)
{
username = oUser.ListOfUser[0].Username;
}
}
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = "INSERT INTO LogData(LogID,username,Action,PageUrl,LogDate) OUTPUT Inserted.LogID VALUES(";
sql.CommandText += "@LogID,@username,@Action,@PageUrl,@LogDate)";
sql.Parameters.Add(new SqlParameter("@LogID", oGenRunning.GetRunningNumber_FormatWithDate(CGeneral.TypeConfig.Log)));
sql.Parameters.Add(new SqlParameter("@username", username));
sql.Parameters.Add(new SqlParameter("@Action", Action));
sql.Parameters.Add(new SqlParameter("@PageUrl", PageUrl));
sql.Parameters.Add(new SqlParameter("@LogDate", DateTime.Now));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
return(dTable.Rows[0][0].ToString());
}
return("");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
try
{
bool isPermission = false;
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 12)
{
isPermission = true;
}
}
if (!isPermission)
{
Response.Redirect(ResolveClientUrl("~/Cost/CostDIExpSummary.aspx"));
}
}
catch {
Response.Redirect(ResolveClientUrl("~/Cost/CostDIExpSummary.aspx"));
}
}
protected void btSaveModal_Click(object sender, EventArgs e)
{
if (CheckData())
{
int ActiveCheck = 0;
if (chkActive.Checked)
{
ActiveCheck = 1;
}
MDUserLoginData oUserLoginData = new MDUserLoginData();
if (Session["Login"] != null)
{
oUserLoginData = (MDUserLoginData)Session["Login"];
}
if (ViewState["UserID"] == null) // Add
{
string Password = "";
Password = oAuthen.EncryptPasswordNoKey(txtPassword.Text.Trim());
oUser.InsertUserList(txtUsername.Text.Trim(), Password, txtSupplierNo.Text.Trim()
, txtEmpCode.Text.Trim(), Convert.ToInt32(txtPwdExpried.Text.Trim()), ActiveCheck
, oUserLoginData.ListOfUserLoginData[0].UserID.ToString());
}
else
{
oUser.UpdateUserList(Convert.ToInt32(ViewState["UserID"]), txtUsername.Text.Trim(), txtSupplierNo.Text.Trim()
, txtEmpCode.Text.Trim(), Convert.ToInt32(txtPwdExpried.Text.Trim()), ActiveCheck
, oUserLoginData.ListOfUserLoginData[0].UserID.ToString());
}
}
else
{
ModalPopup1.Show();
}
}
public string GetSSUControlMenu()
{
string result = "";
try
{
if (Session["UserName"].ToString() != "")
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
bool _Permission = false;
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11)
{
_Permission = true;
}
}
if (_Permission)
{
//divSSUControlMenu.Visible = true;
result += "<div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator EG Hover' data-navi='http://192.168.226.19/iotweb/EnergyLink.aspx?type=SSUControl'>";
result += " <img src = 'StyleMax/icon/Gear-0.5s-200px.gif' class=imgicon width='70' /><div class='count textMonitor'>SSU Control</div>";
result += "</div>";
}
}
}
catch (Exception ex) { }
return(result);
}
private void SetDataEdit(int ID)
{
MDUserLoginData oUserLoginData = new MDUserLoginData();
oUserLoginData = oUser.GetUserListByID(ID);
if (oUserLoginData.ListOfUserLoginData.Length > 0)
{
trPassword.Visible = false;
trConfirmPassword.Visible = false;
txtUsername.Text = oUserLoginData.ListOfUserLoginData[0].UserName;
txtEmpCode.Text = oUserLoginData.ListOfUserLoginData[0].EmpCode;
txtPwdExpried.Text = oUserLoginData.ListOfUserLoginData[0].PwdExpired.ToString();
txtSupplierNo.Text = oUserLoginData.ListOfUserLoginData[0].SupplierName;
if (oUserLoginData.ListOfUserLoginData[0].Active == 0)
{
chkActive.Checked = false;
}
else
{
chkActive.Checked = true;
}
ModalPopup1.Show();
}
}
public string GetManPowerMenu()
{
string result = "";
try
{
if (Session["UserName"].ToString() != "")
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
bool _Permission = false;
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11)
{
_Permission = true;
}
}
if (_Permission)
{
result += "<div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator MP Hover' data-navi='http://192.168.226.19/iotweb/ManPower/DCIManPower.aspx'>";
result += " <img src='StyleMax/icon/bars.png' class='imgicon' width='64px' height='64px' /><div class='count textMonitor'>Summarize</div>";
result += "</div>";
}
}
}
catch (Exception ex) { }
return(result);
}
public MDUserLoginData LoginSystem(string username, string password)
{
MDUserLoginData oUser = new MDUserLoginData();
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = @"SELECT username,password,firstname,lastname,empCode";
sql.CommandText += @",department,position,email,active,createby,createdate";
sql.CommandText += @",updateby,updatedate";
sql.CommandText += @" FROM userList";
sql.CommandText += @" WHERE username=@username AND password=@password";
sql.Parameters.Add(new SqlParameter("@username", username));
sql.Parameters.Add(new SqlParameter("@password", password));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
foreach (DataRow row in dTable.Rows)
{
MDUserLoginData.CMDUserLoginData oMD = new MDUserLoginData.CMDUserLoginData();
oMD.Username = row["username"].ToString();
oMD.firstname = row["firstname"].ToString();
oMD.lastname = row["lastname"].ToString();
oMD.empCode = row["empCode"].ToString();
oMD.department = row["department"].ToString();
oMD.position = row["position"].ToString();
oMD.email = row["email"].ToString();
oMD.active = row["active"].ToString() == "1" ? "Active" : "Inactive";
oMD.createby = row["createby"].ToString();
oMD.createdate = row["createdate"].ToString();
oMD.updateby = row["updateby"].ToString();
oMD.updatedate = row["updatedate"].ToString();
// Insert Group
sql = new SqlCommand();
DataTable dTableGroup = new DataTable();
sql.CommandText = "SELECT uig_id,username,ug.ug_id,ug_name";
sql.CommandText += " FROM UserInGroup uig";
sql.CommandText += " LEFT JOIN UserGroupList ug ON uig.ug_id = ug.ug_id";
sql.CommandText += " WHERE username = @username";
sql.Parameters.Add(new SqlParameter("@username", username));
dTableGroup = oConn.Query(sql);
if (dTableGroup.Rows.Count > 0)
{
foreach (DataRow rowGroup in dTableGroup.Rows)
{
MDUserLoginData.CMDUserLoginData.CGroup oMDGroup = new MDUserLoginData.CMDUserLoginData.CGroup();
oMDGroup.GroupID = rowGroup["ug_id"] != DBNull.Value ? Convert.ToInt32(rowGroup["ug_id"]) : 0;
oMDGroup.GroupName = rowGroup["ug_name"].ToString();
oMD.ListOfGroup.Add(oMDGroup);
}
}
oUser.ListOfUser.Add(oMD);
}
}
return(oUser);
}
private bool GetPermission()
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
if (UserData == null)
{
return(false);
}
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11)
{
return(true);
}
}
return(false);
}
public string GetBudgetMenu()
{
string result = "";
try
{
if (Session["UserName"].ToString() != "")
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
bool _Permission = false;
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11)
{
_Permission = true;
}
}
if (_Permission)
{
result += "<div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator CO Hover' data-navi='http://192.168.226.19/linecost/Default2.aspx?Line=com'>";
result += " <img src='StyleMax/icon/Cost.png' class='imgicon' /><div class='count textMonitor'>Line Cost Control</div>";
result += "</div>";
result += "<div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator CO Hover' data-navi='http://192.168.226.19/iotweb/Cost/CostDIExpSummary.aspx'>";
result += " <img src='StyleMax/icon/Cost.png' class='imgicon' /><div class='count textMonitor'>Budget Cost</div>";
result += "</div>";
//divQCSampling.Visible = true;
}
}
}
catch (Exception ex) { }
result += "<div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator CO Hover' data-navi='http://192.168.226.19/linecost/Default2_CTSP.aspx?Line=mc'>";
result += " <img src='StyleMax/icon/fund.png' class='imgicon' /><div class='count textMonitor'>Cutting Tools Cost</div>";
result += "</div>";
return(result);
}
public MDUserLoginData GetUser(string inSearch)
{
inSearch = inSearch + "%";
MDUserLoginData oUser = new MDUserLoginData();
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = @"SELECT username,password,firstname,lastname,empCode";
sql.CommandText += @",department,position,email,active,createby,createdate";
sql.CommandText += @",updateby,updatedate";
sql.CommandText += @" FROM userList";
sql.CommandText += @" WHERE ISNULL(username,'')+ISNULL(firstname,'')+ISNULL(lastname,'')";
sql.CommandText += @"+ISNULL(empCode,'') like @inSearch --AND username != 'admin'";
sql.Parameters.Add(new SqlParameter("@inSearch", inSearch));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
foreach (DataRow row in dTable.Rows)
{
MDUserLoginData.CMDUserLoginData oMD = new MDUserLoginData.CMDUserLoginData();
oMD.Username = row["username"].ToString();
oMD.firstname = row["firstname"].ToString();
oMD.lastname = row["lastname"].ToString();
oMD.empCode = row["empCode"].ToString();
oMD.department = row["department"].ToString();
oMD.position = row["position"].ToString();
oMD.email = row["email"].ToString();
oMD.active = row["active"].ToString();
oMD.createby = row["createby"].ToString();
oMD.createdate = row["createdate"].ToString();
oMD.updateby = row["updateby"].ToString();
oMD.updatedate = row["updatedate"].ToString();
oUser.ListOfUser.Add(oMD);
}
}
return(oUser);
}
public string GetLinkQCSampling()
{
string result = "";
try
{
if (Session["UserName"].ToString() != "")
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
bool _Permission = false;
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11 || UsrGroup.GroupID == 1 || UsrGroup.GroupID == 2)
{
_Permission = true;
}
}
if (_Permission)
{
result += " <div class='col-lg-5 col-md-5 col-sm-12 col-xs-12 lnkNavigator QC Hover' data-navi='Quality/QCSamplingMenu.aspx'>";
result += " <img src='StyleMax/icon/trend.png' class='imgicon' /><div class='count textMonitor'>QC Graph Monitor</div>";
result += " </div>";
//divQCSampling.Visible = true;
}
}
}
catch (Exception ex) { }
return(result);
}
protected void btLogin_Click(object sender, EventArgs e)
{
MDUserLoginData oMDUser = new MDUserLoginData();
try
{
if (CheckLogin())
{
string username = txtUsername.Text.Trim();
string password = txtPassword.Text.Trim();
ADHelper.LoginResult lgresr = new ADHelper.LoginResult();
lgresr = adHl.Login(username, password);
if (lgresr == ADHelper.LoginResult.LOGIN_OK)
{
DataSet usr = adHl.GetUserDataSet(username);
DataTable dtUser = new DataTable();
dtUser = usr.Tables["User"];
string EmpCode = dtUser.Rows[0]["Zip"].ToString();
string email = dtUser.Rows[0]["EmailAddress"].ToString();
// Login Success
oMDUser = oUser.LoginSystem(EmpCode);
Session["UserLoginData"] = oMDUser;
Session["EmpCode"] = EmpCode;
Session["UserName"] = username;
Session["UserFullName"] = dtUser.Rows[0]["LoginName"].ToString();
if (ViewState["PathURL"] != "")
{
Response.Redirect(ResolveClientUrl("~/" + ViewState["PathURL"].ToString()));
}
else
{
Response.Redirect(ResolveClientUrl("~/Default.aspx"));
}
}
else
{
string CheckUserInSystem = "false";
CheckUserInSystem = oUser.CheckUserInSystem(txtUsername.Text.Trim());
if (Convert.ToBoolean(CheckUserInSystem))
{
bool CheckUserHavePassword = false;
CheckUserHavePassword = oUser.CheckUserHavePassword(txtUsername.Text.Trim());
if (CheckUserHavePassword)
{
oMDUser = oUser.LoginSystem(txtUsername.Text.Trim(), EncryptPassword(txtPassword.Text.Trim()));
Session["UserLoginData"] = oMDUser;
Session["UserName"] = oMDUser.ListOfUser[0].empCode;
Session["UserFullName"] = oMDUser.ListOfUser[0].firstname + " " + oMDUser.ListOfUser[0].lastname;
if (ViewState["PathURL"] != "")
{
string PathURL = "~/" + ViewState["PathURL"].ToString();
Response.Redirect(ResolveClientUrl(PathURL));
}
else
{
Response.Redirect(ResolveClientUrl("~/Default.aspx"));
}
}
else
{
bool LoginSuccess = false;
using (PrincipalContext pc = new PrincipalContext(ContextType.Domain))
{
if (pc.ValidateCredentials(txtUsername.Text.Trim(), txtPassword.Text.Trim()))
{
// Login With AD Server
LoginSuccess = true;
}
}
if (LoginSuccess)
{
// Login Success
oMDUser = oUser.LoginSystem(txtUsername.Text.Trim());
Session["UserLoginData"] = oMDUser;
Session["UserName"] = oMDUser.ListOfUser[0].empCode;
Session["UserFullName"] = oMDUser.ListOfUser[0].fullname;
if (ViewState["PathURL"] != "")
{
Response.Redirect(ResolveClientUrl("~/" + ViewState["PathURL"].ToString()));
}
else
{
Response.Redirect(ResolveClientUrl("~/Default.aspx"));
}
}
else
{
txtUsername.BackColor = Color.Pink;
txtPassword.BackColor = Color.Pink;
lbError.Text = "Username or Password incorrect!";
txtPassword.Focus();
}
}
}
else
{
txtUsername.BackColor = Color.Pink;
txtPassword.BackColor = Color.Pink;
lbError.Text = "Username or Password incorrect!";
txtPassword.Focus();
}
}
}
}
catch (Exception)
{
}
}
private void LoadGrid()
{
MDUserLoginData oUserLoginData = new MDUserLoginData();
DataTable dTable = new DataTable();
dTable.TableName = "Part Package";
dTable.Columns.Add("CanEdit", typeof(bool));
dTable.Columns.Add("CanDel", typeof(bool));
dTable.Columns.Add("IsActive", typeof(bool));
dTable.Columns.Add("EmpCode", typeof(string));
dTable.Columns.Add("Password", typeof(string));
dTable.Columns.Add("PwdExpired", typeof(string));
dTable.Columns.Add("PwdLastUpdate", typeof(string));
dTable.Columns.Add("SupplierName", typeof(string));
dTable.Columns.Add("UpdateBy", typeof(string));
dTable.Columns.Add("UpdateDate", typeof(string));
dTable.Columns.Add("UserID", typeof(string));
dTable.Columns.Add("Username", typeof(string));
dTable.Columns.Add("PwdRemaining", typeof(string));
int Active = 2; // all
if (rblActive.SelectedValue == "0")
{
Active = 0; // InActive
}
else if (rblActive.SelectedValue == "1")
{
Active = 1; // Active
}
else
{
Active = 2; // all
}
oUserLoginData = oUser.GetUserListAll(txtSearch.Text.Trim(), Active);
if (oUserLoginData.ListOfUserLoginData.Length > 0)
{
for (int i = 0; i <= oUserLoginData.ListOfUserLoginData.Length - 1; i++)
{
DataRow dRow;
dRow = dTable.NewRow();
dRow["CanEdit"] = true;
dRow["CanDel"] = true;
dRow["IsActive"] = oUserLoginData.ListOfUserLoginData[i].Active;
dRow["EmpCode"] = oUserLoginData.ListOfUserLoginData[i].EmpCode;
//oUserLoginData.ListOfUserLoginData[i].ListOfSystem;
//oUserLoginData.ListOfUserLoginData[i].ListOfUserInGroup;
dRow["Password"] = oUserLoginData.ListOfUserLoginData[i].Password;
dRow["PwdExpired"] = oUserLoginData.ListOfUserLoginData[i].PwdExpired;
//dRow[""] = oUserLoginData.ListOfUserLoginData[i].PwdLastUpdate;
//DateTime date = DateTime.ParseExact(oUserLoginData.ListOfUserLoginData[i].PwdLastUpdate, "dd/MM/yyyy", null);
//TimeSpan diff = DateTime.Now - date;
//int days = (int)Math.Abs(Math.Round(diff.TotalDays));
//dRow["PwdRemaining"] = days.ToString();
dRow["SupplierName"] = oUserLoginData.ListOfUserLoginData[i].SupplierName;
//dRow["SupplierNo"] = oUserLoginData.ListOfUserLoginData[i].SupplierNo;
dRow["UpdateBy"] = oUserLoginData.ListOfUserLoginData[i].UpdateBy;
dRow["UpdateDate"] = oUserLoginData.ListOfUserLoginData[i].UpdateDate;
dRow["UserID"] = oUserLoginData.ListOfUserLoginData[i].UserID;
dRow["Username"] = oUserLoginData.ListOfUserLoginData[i].UserName;
dTable.Rows.Add(dRow);
}
}
else
{
DataRow dRow;
dRow = dTable.NewRow();
dRow["CanEdit"] = false;
dRow["CanDel"] = false;
dTable.Rows.Add(dRow);
}
DataView dView = new DataView();
dView.Table = dTable;
gSorting1 = (GVSorting)Session["gSorting1"];
if (gSorting1.GetSorting() != "")
{
try
{
dView.Sort = gSorting1.GetSorting();
}
catch (Exception ex)
{
}
}
GridView1.DataSource = dView;
GridView1.DataBind();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
try
{
if (Session["UserName"].ToString() != "")
{
MDUserLoginData UserData = new MDUserLoginData();
UserData = (MDUserLoginData)Session["UserLoginData"];
bool _Permission = false;
foreach (MDUserLoginData.CMDUserLoginData.CGroup UsrGroup in UserData.ListOfUser[0].ListOfGroup)
{
if (UsrGroup.GroupID == 10 || UsrGroup.GroupID == 11)
{
_Permission = true;
}
}
if (_Permission)
{
string ip = "192.168.229.24";
MemoryStream ms = new MemoryStream();
TextWriter tw = new StreamWriter(ms);
tw.WriteLine("[connection]");
tw.WriteLine("host=" + ip);
tw.WriteLine("port=5900");
tw.WriteLine("[options]");
tw.WriteLine("use_encoding_1=1");
tw.WriteLine("copyrect=1");
tw.WriteLine("viewonly=1");
tw.WriteLine("fullscreen=0");
tw.WriteLine("8bit=0");
tw.WriteLine("shared=1");
tw.WriteLine("belldeiconify=0");
tw.WriteLine("disableclipboard=0");
tw.WriteLine("swapmouse=0");
tw.WriteLine("fitwindow=0");
tw.WriteLine("cursorshape=1");
tw.WriteLine("noremotecursor=0");
tw.WriteLine("preferred_encoding=7");
tw.WriteLine("compresslevel=-1");
tw.WriteLine("quality=High");
tw.WriteLine("localcursor=1");
tw.WriteLine("scale_den=1");
tw.WriteLine("scale_num=1");
tw.WriteLine("local_cursor_shape=1");
tw.Flush();
byte[] bytes = ms.ToArray();
ms.Close();
Response.Clear();
Response.ContentType = "text/plain";
Response.AddHeader("content-disposition", "attachment; filename=" + "IoT_SSUControl.vnc");
Response.BinaryWrite(bytes);
Response.End();
}
else
{
// Alert Message
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "Alert('You don't have permission for this menu. Please Login.')", true);
}
}
}
catch (Exception ex) { }
}