public bool SendOTP(EmpProperty dataItem) { bool _result = false; try { string OTP = this.GetOTP(); if (this.InsertOTP(dataItem, OTP)) { string EXP = this.GetEXP_OTP(dataItem, OTP); if (EXP != "") { string sendTo = dataItem.email; string Subject = @"Program : Login"; string Body = @"OTP for Program Login is " + OTP + @" <br>EXP : " + EXP + @" <br>Do not open this code to other people."; if (_emailControllors.SentEmail(sendTo, Subject, Body)) { _result = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public string GetEXP_OTP(EmpProperty dataItem, string OTP) { string _result = ""; try { resultData = _models.SearchOTP(dataItem, OTP); if (resultData.StatusOnDb == true) { if (resultData.ResultOnDb.Rows.Count > 0) { string EXP_OTP = resultData.ResultOnDb.Rows[0]["EXP_OTP"].ToString(); _result = EXP_OTP; } } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public bool CheckEmpCompanyExist(EmpProperty dataItem) { bool _result = false; try { resultData = _models.SearchEmpCompany(dataItem); if (resultData.StatusOnDb == true) { if (resultData.ResultOnDb.Rows.Count > 0) { if (resultData.ResultOnDb.Rows[0]["EMP_STATUS"].ToString() == "1") { _result = true; } } else { MessageBox.Show("Couldn't find Employee ID", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public EmpProperty GetEmpProperty(EmpProperty dataItem) { EmpProperty _result = new EmpProperty(); try { resultData = _models.SearchEmpCompany(dataItem); if (resultData.StatusOnDb == true) { if (resultData.ResultOnDb.Rows.Count > 0) { _result = new EmpProperty { code = resultData.ResultOnDb.Rows[0]["EMP_ID"].ToString(), name = resultData.ResultOnDb.Rows[0]["EMP_NAME"].ToString(), sername = resultData.ResultOnDb.Rows[0]["EMP_SURNAME"].ToString(), email = resultData.ResultOnDb.Rows[0]["EMP_EMAIL"].ToString(), startwork = resultData.ResultOnDb.Rows[0]["START_WORK"].ToString(), depertment = resultData.ResultOnDb.Rows[0]["DEPARTMENT"].ToString(), position = resultData.ResultOnDb.Rows[0]["POSITION"].ToString() }; } } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(_result); } }
private void lblLogOut_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Do you want Logout?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (result == DialogResult.Yes) { this.panShowName.Visible = false; this.panSettingTopic.Visible = false; this.btnLogin.Visible = true; //btn this.btnSearch.Visible = true; this.btnInput.Visible = false; this.btnSetFlow.Visible = false; this.btnSetPurchase.Visible = false; this.btnUpdateInput.Visible = false; this.btnProcessSetting.Visible = false; this.btnCreateProductType.Visible = false; this.btnPO.Visible = false; _empLogin = new EmpProperty(); this.Load_PageSearch(); } }
private void picChangePass_Click(object sender, EventArgs e) { frmChangePass_Main _frmChangePass_Main = new frmChangePass_Main(_empLogin); _frmChangePass_Main.ShowDialog(); if (_frmChangePass_Main.DialogResult == DialogResult.OK) { this.panShowName.Visible = false; this.panSettingTopic.Visible = false; this.btnLogin.Visible = true; this.btnSearch.Visible = true; this.btnInput.Visible = false; this.btnSetFlow.Visible = false; this.btnSetPurchase.Visible = false; this.btnUpdateInput.Visible = false; this.btnProcessSetting.Visible = false; this.btnCreateProductType.Visible = false; _empLogin = new EmpProperty(); this.Load_PageSearch(); } }
public string UpdatePassLoginFitelGroup(EmpProperty dataItem) { sql = @"UPDATE `logon_fitel_group` SET `PASSWORD` = UNHEX(MD5('" + dataItem.pass + @"')) WHERE `EMP_ID` = '" + dataItem.code + @"'"; return(sql); }
public string SearchEmpFitelGroup(EmpProperty dataItem) { sql = @"SELECT * FROM `logon_fitel_group` WHERE EMP_ID = '" + dataItem.code + @"';"; return(sql); }
public string UpdateOTPUsed(EmpProperty emp, string OTP) { sql = @"UPDATE `otp` SET USED = 1 WHERE EMP_ID = '" + emp.code + @"' AND OTP = '" + OTP + @"'"; return(sql); }
public OutputOnDbProperty UpdateOTPUsed(EmpProperty dataItem, string OTP) { TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionPersonnel"].ConnectionString; sql = _sqlFactory.UpdateOTPUsed(dataItem, OTP); resultData = base.UpdateBySql(sql); TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionStrMysql"].ConnectionString; return(resultData); }
public OutputOnDbProperty UpdatePassLoginFitelGroup(EmpProperty dataItem) { TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionPersonnel"].ConnectionString; sql = _sqlFactory.UpdatePassLoginFitelGroup(dataItem); resultData = base.UpdateBySql(sql); TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionStrMysql"].ConnectionString; return(resultData); }
public OutputOnDbProperty SearchEmpCompany(EmpProperty dataItem) { TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionLogin"].ConnectionString; sql = _sqlFactory.SearchEmpCompany(dataItem); resultData = base.SearchBySql(sql); TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionStrMysql"].ConnectionString; return(resultData); }
public string DeleteOTP(EmpProperty emp) { sql = @"DELETE FROM `otp` WHERE EMP_ID = '" + emp.code + @"' OR USED = 1 OR EXP_OTP < NOW();"; return(sql); }
public string LoginFitelGroup(EmpProperty dataItem) { sql = @"SELECT* FROM `logon_fitel_group` WHERE EMP_ID = '" + dataItem.code + @"' AND `PASSWORD` = UNHEX(MD5('" + dataItem.pass + "'))"; return(sql); }
private void btnLogin_Click(object sender, EventArgs e) { frmLogin_Main _frmLogin = new frmLogin_Main(); _frmLogin.ShowDialog(); _resultLogin = _frmLogin._resultLogin; //_resultLogin = new LoginProperty //{ // loginStatus = true, // empDetial = new EmpProperty // { // name = "Ausada", // sername = "Sukkheesuec" // } //}; if (_resultLogin.loginStatus == true) { _empLogin = _resultLogin.empDetial; this.btnLogin.Visible = false; this.panShowName.Visible = true; this.panSettingTopic.Visible = true; this.btnInput.Visible = true; this.btnSetFlow.Visible = true; this.btnSetPurchase.Visible = true; this.btnUpdateInput.Visible = true; this.btnProcessSetting.Visible = true; this.btnSubProcessSetting.Visible = true; this.btnCreateProductType.Visible = true; this.btnPO.Visible = true; this.lblShowName.Text = String.Format("{0} {1}.", _empLogin.name, _empLogin.sername.Substring(0, 3)); //if (_empPCControllors.CheckEmpPCExist(_empLogin) == true) //{ // this.bttNewOrder.Visible = true; // this.panOnNewOrder.Visible = true; // this.bttNewCondition.Visible = true; // this.panOnNewCondition.Visible = true; // this.bttUploadFile.Visible = true; // this.panOnUploadFile.Visible = true; // this.bttUpdateData.Visible = true; // this.panOnUpdateData.Visible = true; //} } }
public OutputOnDbProperty InsertOTP(EmpProperty dataItem, string OTP) { //Delete OTP Hittory OutputOnDbProperty _resultData = this.DeleteOTP(dataItem); TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionPersonnel"].ConnectionString; sql = _sqlFactory.InsertOTP(dataItem, OTP); resultData = base.InsertBySql(sql); TransMysqlModels.strConnection = ConfigurationManager.ConnectionStrings["ConnectionStrMysql"].ConnectionString; return(resultData); }
public string SearchOTP(EmpProperty emp, string OTP) { sql = @"SELECT EMP_ID ,USED ,OTP ,EXP_OTP FROM `otp` WHERE EMP_ID = '" + emp.code + @"' AND OTP = '" + OTP + @"'"; return(sql); }
public string InsertLoginFitelGroup(EmpProperty dataItem) { sql = @"INSERT INTO `logon_fitel_group` ( `EMP_ID` , `PASSWORD` , `CREATE_ACC_DATE` ) VALUES( '" + dataItem.code + @"' ,UNHEX(MD5('" + dataItem.pass + @"')) , NOW() );"; return(sql); }
public bool EnterOTP(EmpProperty dataItem, string OTP) { bool _result = false; try { resultData = _models.SearchOTP(dataItem, OTP); if (resultData.StatusOnDb == true) { if (resultData.ResultOnDb.Rows.Count > 0) { //Check EXP Date. string EXP_OTP = resultData.ResultOnDb.Rows[0]["EXP_OTP"].ToString(); DateTime oEXP_OTP = DateTime.Parse(EXP_OTP); string dateTimeNow = this.GetDateTime(); if (dateTimeNow != "") { DateTime odateTimeNow = DateTime.Parse(dateTimeNow); if (oEXP_OTP >= odateTimeNow) { if (this.UpdateOTPUsed(dataItem, OTP)) { _result = true; } } else { MessageBox.Show("OTP has expired, please click 'Send again.'", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("You have entered an incorrect code. Please try again.", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public string SearchEmpCompany(EmpProperty dataItem) { sql = @"SELECT EmpCode AS EMP_ID ,IF(EmpCodeResign IS NULL,'1','0') AS EMP_STATUS ,EmpName AS EMP_NAME ,EmpSurname AS EMP_SURNAME ,EmpEmail AS EMP_EMAIL ,EmpStartwork AS START_WORK ,EmpPosition AS `POSITION` ,EmpDept AS `DEPARTMENT` FROM `info_employees` WHERE empCode = '" + dataItem.code + @"';"; return(sql); }
public string InsertOTP(EmpProperty emp, string OTP) { sql = @"INSERT INTO `otp` ( EMP_ID ,USED ,OTP ,EXP_OTP ) VALUES( '" + emp.code + @"' ,0 ,'" + OTP + @"' ,NOW() + INTERVAL 3 MINUTE );"; return(sql); }
private void bttNext_Click(object sender, EventArgs e) { if (this.txtEmpID.Text.Trim() == "") { return; } _empProperty = new EmpProperty { code = this.txtEmpID.Text.Trim() }; if (_controllors.CheckEmpCompanyExist(_empProperty) == true) { _empProperty = _controllors.GetEmpProperty(_empProperty); } else { this.txtEmpID.Text = ""; return; } _frmMain._resultLogin.empDetial = _empProperty; if (_controllors.CheckEmpFitelGroupExist(_empProperty) == true) { //Clear panel Body. _frmMain.panBody.Controls.Clear(); //Load page search. pageEnter_Password _pageEnter_User = new pageEnter_Password(_frmMain); _frmMain.panBody.Controls.Add(_pageEnter_User); _pageEnter_User.Dock = DockStyle.Fill; _pageEnter_User.BringToFront(); } else { //Clear panel Body. _frmMain.panBody.Controls.Clear(); //Load page search. pageEnter_Create _pageEnter_User = new pageEnter_Create(_frmMain); _frmMain.panBody.Controls.Add(_pageEnter_User); _pageEnter_User.Dock = DockStyle.Fill; _pageEnter_User.BringToFront(); } }
public bool InsertLoginFitelGroup(EmpProperty dataItem) { bool _result = false; try { resultData = _models.InsertLoginFitelGroup(dataItem); if (resultData.StatusOnDb == true) { _result = true; } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public bool UpdateOTPUsed(EmpProperty dataItem, string OTP) { bool _result = false; try { resultData = _models.UpdateOTPUsed(dataItem, OTP); if (resultData.StatusOnDb == true) { _result = true; } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public bool SendNewPassword(EmpProperty dataItem) { bool _result = false; try { string sendTo = dataItem.email; string Subject = @"Program : Login"; string Body = "Your new password is : " + dataItem.pass; if (_emailControllors.SentEmail(sendTo, Subject, Body)) { _result = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public bool CheckEmpFitelGroupExist(EmpProperty dataItem) { bool _result = false; try { resultData = _models.SearchEmpFitelGroup(dataItem); if (resultData.StatusOnDb == true) { if (resultData.ResultOnDb.Rows.Count > 0) { _result = true; } } else { MessageBox.Show(resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); }
public OutputOnDbProperty SearchOTP(EmpProperty dataItem, string OTP) { resultData = _services.SearchOTP(dataItem, OTP); return(resultData); }
public frmEnter_OTP(EmpProperty empIN) { InitializeComponent(); emp = empIN; this.DialogResult = DialogResult.None; }
public OutputOnDbProperty UpdateOTPUsed(EmpProperty dataItem, string OTP) { resultData = _services.UpdateOTPUsed(dataItem, OTP); return(resultData); }
public OutputOnDbProperty UpdatePassLoginFitelGroup(EmpProperty dataItem) { resultData = _services.UpdatePassLoginFitelGroup(dataItem); return(resultData); }