public void queryDataLoginStatus() { MST007Controller mst007Ctrl = new MST007Controller(); try { object[] result = mst007Ctrl.queryDataLoginStatus(); MsgForm msgForm = (MsgForm)result[0]; LOGIN_STATUS data = (LOGIN_STATUS)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { cboStatusFlag.SelectedValue = data.LOGIN_STATUS_VALUE; formLoginStatus = data; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void queryDataManageUserLoginByUserId() { MST007Controller mst007Ctrl = new MST007Controller(); try { object[] result = mst007Ctrl.queryDataManageUserLoginByUserId(formUserLogin); MsgForm msgForm = (MsgForm)result[0]; USER_LOGIN data = (USER_LOGIN)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { txtUserId.Text = data.USER_ID; txtUserPassword.Text = data.USER_PASSWORD; txtUserFirstname.Text = data.USER_FIRSTNAME; txtUserLastname.Text = data.USER_LASTNAME; //cboStatusFlag.SelectedValue = data.STATUS_FLAG; formUserLogin = data; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void searchDataManageUserLogin() { MST007Controller mst007Ctrl = new MST007Controller(); try { object[] result = mst007Ctrl.searchDataManageUserLogin(); MsgForm msgForm = (MsgForm)result[0]; List <USER_LOGIN> lstdata = (List <USER_LOGIN>)result[1]; if (msgForm.statusFlag.Equals(1)) { List <UserLoginForm> lstUserLogin = new List <UserLoginForm>(); foreach (USER_LOGIN data in lstdata) { UserLoginForm userLoginForm = new UserLoginForm(); userLoginForm.userId = data.USER_ID; userLoginForm.userPassword = data.USER_PASSWORD; userLoginForm.userFirstname = data.USER_FIRSTNAME; userLoginForm.userLastname = data.USER_LASTNAME; userLoginForm.status = data.STATUS_FLAG.Equals(0) ? "ไม่ใช้งาน" : data.STATUS_FLAG.Equals(1) ? "ใช้งาน" : ""; lstUserLogin.Add(userLoginForm); } dataGridView1.DataSource = lstUserLogin; dataGridView1.DefaultCellStyle.Font = new Font("TH SarabunPSK", 16); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dataGridView1.EnableHeadersVisualStyles = false; dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.SkyBlue; dataGridView1.ColumnHeadersHeight = 150; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("TH SarabunPSK", 16, FontStyle.Bold); dataGridView1.RowTemplate.Height = 40; dataGridView1.Columns[0].HeaderCell.Value = "ชื่อผู้ใช้งาน"; dataGridView1.Columns[1].HeaderCell.Value = "รหัสผ่าน"; dataGridView1.Columns[2].HeaderCell.Value = "ชื่อ"; dataGridView1.Columns[3].HeaderCell.Value = "นามสกุล"; dataGridView1.Columns[4].HeaderCell.Value = "สถานะ"; lblCountData.Text = "แสดงข้อมูลทั้งหมด " + lstUserLogin.Count() + " รายการ"; } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void deleteDataManageUserLogin() { MST007Controller mst007Ctrl = new MST007Controller(); USER_LOGIN form = new USER_LOGIN(); try { form.USER_ID = txtUserId.Text; if (Util.isEmpty(form.USER_ID)) { MessageBox.Show(CommonUtil.SELECT_DATA_DELETE); return; } if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes) { object[] result = mst007Ctrl.deleteDataManageUserLogin(form); MsgForm msgForm = (MsgForm)result[0]; if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.DELETE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void insertOrUpdateDataManageUserLogin() { MST007Controller mst007Ctrl = new MST007Controller(); USER_LOGIN form = new USER_LOGIN(); LOGIN_STATUS formUpdateStatusLogin = new LOGIN_STATUS(); try { if (Util.isEmpty(txtUserId.Text) || Util.isEmpty(txtUserPassword.Text) || Util.isEmpty(cboStatusFlag.SelectedValue)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } form.USER_ID = txtUserId.Text; form.USER_PASSWORD = txtUserPassword.Text; form.USER_FIRSTNAME = txtUserFirstname.Text; form.USER_LASTNAME = txtUserLastname.Text; //form.STATUS_FLAG = Int32.Parse(cboStatusFlag.SelectedValue.ToString()); form.STATUS_FLAG = Int32.Parse("1"); formUpdateStatusLogin.LOGIN_STATUS_VALUE = Int32.Parse(cboStatusFlag.SelectedValue.ToString()); if (Util.isEmpty(form) && Util.isEmpty(formUpdateStatusLogin.LOGIN_STATUS_VALUE)) { return; } object[] result = mst007Ctrl.insertOrUpdateDataManageUserLogin(form, formUpdateStatusLogin, flagAddEdit); MsgForm msgForm = (MsgForm)result[0]; USER_LOGIN data = (USER_LOGIN)result[1]; if (flagAddEdit.Equals("A")) { if (Util.isNotEmpty(data)) { if (msgForm.statusFlag.Equals(1)) { MessageBox.Show(CommonUtil.DUPLICATE_DATA); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } else { if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } else if (flagAddEdit.Equals("E")) { if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }