public MySqlDataReader GetTable(List <KeyValuePair <string, string> > condition) { MySqlDataReader data = null; string Condition = ""; if (condition.Count > 1) { Condition = Condition + " AND " + condition[0].Key + " LIKE " + condition[0].Value; Condition = Condition + " ORDER BY " + condition[1].Key + " " + condition[1].Value; } else { Condition = Condition + " ORDER BY " + condition[0].Key + " " + condition[0].Value; } string Query = "SELECT * FROM (\n" + " SELECT (@NoUrut := @NoUrut+1) AS `No`, Tbl.* FROM (\n" + " SELECT " + FIELDNAME + " FROM " + TABLENAME + "\n" + " ) Tbl CROSS JOIN (SELECT @NoUrut:=0)testing\n" + ") TblLuar WHERE `Hapus` = 0 " + Condition; if (!aspQuery.Select(Query, ref data)) { ASPMsgCmp.ErrorMessage("Fail to read get data from Master Group!"); } return(data); }
private void EditNmMJabatan_Leave(object sender, EventArgs e) { if (!EditNmMJabatan.Text.Trim().Equals("")) { if (GMJabatan.IdMJabatan != 0) { if (!GMJabatan.NmMJabatan.Equals(EditNmMJabatan.Text.Trim())) { if (!GDBMJabatan.SelectByNama(EditNmMJabatan.Text.Trim(), ref GMJabatan)) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_NOTEXIST, "Nama Jabatan: ", EditNmMJabatan.Text.Trim())); GMJabatan = GDBMJabatan.Clear(); } ShowMJabatan(GMJabatan); } } else { if (!GDBMJabatan.SelectByNama(EditNmMJabatan.Text.Trim(), ref GMJabatan)) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_NOTEXIST, "Nama Jabatan: ", EditNmMJabatan.Text.Trim())); GMJabatan = GDBMJabatan.Clear(); } ShowMJabatan(GMJabatan); } } }
public void CopyToObject(ref ASPMKaryawan_DO MKaryawan, MySqlDataReader data) { try { if (data.Read()) { MKaryawan.IdMKaryawan = data.GetInt16("IdMKaryawan"); MKaryawan.KdMKaryawan = data.GetString("KdMKaryawan"); MKaryawan.NmMKaryawan = data.GetString("NmMKaryawan"); MKaryawan.Alamat = data.GetString("Alamat"); MKaryawan.NoHP = data.GetString("NoHP"); MKaryawan.IdMJabatan = data.GetInt16("IdMJabatan"); MKaryawan.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif")); MKaryawan.IdMUserCreate = data.GetInt16("IdMUserCreate"); MKaryawan.TglCreate = data.GetMySqlDateTime("TglCreate"); MKaryawan.IdMUserUpdate = data.GetInt16("IdMUserUpdate"); MKaryawan.TglUpdate = data.GetMySqlDateTime("TglUpdate"); MKaryawan.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus")); } } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); } }
protected override void Save() { LoadData(); if (GMode == ASPConstant.ModeNew) { if (GDBMKaryawan.Insert(GMKaryawan)) { ASPMsgCmp.InfoMessage("Data berhasil disimpan."); } else { ASPMsgCmp.ErrorMessage("Data gagal disimpan."); } } else if (GMode == ASPConstant.ModeEdit) { if (GDBMKaryawan.Update(GMKaryawan)) { ASPMsgCmp.InfoMessage("Data berhasil disimpan."); } else { ASPMsgCmp.ErrorMessage("Data gagal disimpan."); } } GMKaryawan = GDBMKaryawan.Clear(); ShowData(); SetMode(ASPConstant.ModeBrowse); GetTable(); dataGridView.Focus(); }
public BindingSource GetTable(string query) { BindingSource bindingSource = new BindingSource(); string Query = "SELECT * FROM (\n" + query + ") TblLuar WHERE `Hapus` = 0 LIMIT 0,50"; if (!aspQuery.Select(Query, ref bindingSource)) { ASPMsgCmp.ErrorMessage("Fail to read get data from Browse Form!"); } return(bindingSource); }
protected override bool CekValidate() { bool Result = base.CekValidate(); if (Result) { if (EditNmMKaryawan.Text.Trim().Equals("")) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Nama Karyawan")); Result = false; } } if (Result) { if (EditAlamat.Text.Trim().Equals("")) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Alamat")); Result = false; } } if (Result) { if (EditNoHP.Text.Trim().Equals("")) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "No. HP")); Result = false; } } if (Result) { if (GMJabatan.IdMJabatan == 0) { ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Jabatan")); Result = false; } } if (Result) { Result = (ASPMsgCmp.QuestionMessage(ASPMessage.cm_SAVE) == DialogResult.Yes); } return(Result); }
public void CopyToObject(ref ASPSysInfo_DO SysInfo, MySqlDataReader data) { try { //if (data.Read()) //{ // SysInfo.IdSysInfo = data.GetInt16("IdSysInfo"); // SysInfo.AppVersion = data.GetString("AppVersion"); // SysInfo.LocalLicenseCode = data.GetString("LocalLicenseCode"); // SysInfo.GlobalLicenseCode = data.GetString("GlobalLicenseCode"); // SysInfo.TrialLicenseCode = data.("TrialLicenseCode"); // SysInfo.TrialDateLimit = data.GetMySqlDateTime("TrialDateLimit"); //} } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); } }
public bool Select(String query, ref MySqlDataReader dataReader) { bool Result = true; Command.Connection = MySqlConnect.connection; if (!MySqlConnect.IsOpen) { MySqlConnect.OpenConnection(); } try { Command.CommandText = query; dataReader = Command.ExecuteReader(); } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); Result = false; } return(Result); }
protected override void DeleteRecord() { bool CanDelete = true; if (GMode == ASPConstant.ModeBrowse && dataGridView.SelectedRows.Count > 0) { base.DeleteRecord(); DataGridViewRow row = dataGridView.SelectedRows[0]; if (!GDBMKaryawan.SelectById(int.Parse(row.Cells["IdMKaryawan"].Value.ToString()), ref GMKaryawan)) { GMKaryawan = GDBMKaryawan.Clear(); CanDelete = false; } if (CanDelete) { if (ASPMsgCmp.QuestionMessage("Yakin ingin menghapus " + GMKaryawan.NmMKaryawan + "?") == DialogResult.Yes) { GMKaryawan.IdMUserUpdate = MainForm.FMCurrUser.IdMKaryawan; GMKaryawan.TglUpdate = GDBMJabatan.GetNow(); GMKaryawan.Hapus = true; if (GDBMKaryawan.Delete(GMKaryawan)) { ASPMsgCmp.InfoMessage("Data berhasil dihapus."); } else { ASPMsgCmp.ErrorMessage("Data gagal dihapus."); } } } GMKaryawan = GDBMKaryawan.Clear(); ShowData(); SetMode(ASPConstant.ModeBrowse); GetTable(); } }
public void CopyToObject(ref ASPMGroup_DO MGroup, MySqlDataReader data) { try { if (data.Read()) { MGroup.IdMGroup = data.GetInt16("IdMGroup"); MGroup.KdMGroup = data.GetString("KdMGroup"); MGroup.NmMGroup = data.GetString("NmMGroup"); MGroup.IdMManager = data.GetInt16("IdMManager"); MGroup.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif")); MGroup.IdMUserCreate = data.GetInt16("IdMUserCreate"); MGroup.TglCreate = data.GetMySqlDateTime("TglCreate"); MGroup.IdMUserUpdate = data.GetInt16("IdMUserUpdate"); MGroup.TglUpdate = data.GetMySqlDateTime("TglUpdate"); MGroup.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus")); } } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); } }
public void CopyToObject(ref ASPMUser_DO MUser, MySqlDataReader data) { try { if (data.Read()) { MUser.IdMUser = data.GetInt16("IdMUser"); MUser.Username = data.GetString("Username"); MUser.Password = data.GetString("Password"); MUser.IdMKaryawan = data.GetInt16("IdMKaryawan"); MUser.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif")); MUser.IdMUserCreate = data.GetInt16("IdMUserCreate"); MUser.TglCreate = data.GetMySqlDateTime("TglCreate"); MUser.IdMUserUpdate = data.GetInt16("IdMUserUpdate"); MUser.TglUpdate = data.GetMySqlDateTime("TglUpdate"); MUser.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus")); } } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); } }
public bool Select(String query, ref BindingSource bindingSource) { bool Result = true; MySqlDataAdapter adapter; DataTable dataTable = new DataTable(); if (!MySqlConnect.IsOpen) { MySqlConnect.OpenConnection(); } try { adapter = new MySqlDataAdapter(query, MySqlConnect.connection); adapter.Fill(dataTable); bindingSource.DataSource = dataTable; } catch (MySqlException ex) { ASPMsgCmp.WarningMessage(ex.Message); Result = false; } return(Result); }