private void GetTableGroup() { dataGridViewGroup.Rows.Clear(); dataGridViewGroup.Refresh(); string order = "ASC"; List <KeyValuePair <string, string> > condition = new List <KeyValuePair <string, string> >(); condition.Add(new KeyValuePair <string, string>("NmMGroup", "ASC")); MySqlDataReader dataReader = GDBMGroup.GetTable(condition); while (dataReader.Read()) { dataGridViewGroup.Rows.Add( dataReader.GetInt16("IdMKaryawan").ToString(), dataReader.GetInt16("No").ToString(), dataReader.GetString("KdMKaryawan"), dataReader.GetString("NmMKaryawan"), dataReader.GetInt16("IdMJabatan").ToString(), dataReader.GetString("NmMJabatan"), dataReader.GetString("Alamat"), dataReader.GetString("NoHP"), ASPCast.IntToBool(dataReader.GetInt16("Aktif")) ); } GDBMKaryawan.aspQuery.MySqlConnect.CloseConnection(); }
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); } }
public bool Delete(ASPMKaryawan_DO MKaryawan) { string Values = "IdMUserUpdate = " + ASPCast.SQLIntToStr(MKaryawan.IdMUserUpdate) + ", TglUpdate = " + ASPCast.SQLDateTimeToStr(MKaryawan.TglUpdate) + ", Hapus = " + ASPCast.SQLBoolToStr(MKaryawan.Hapus); string Condition = " WHERE IdMKaryawan = " + ASPCast.SQLIntToStr(MKaryawan.IdMKaryawan); string Query = "UPDATE " + TABLENAME + " SET " + Values + Condition; return(aspQuery.ExecCUD(Query)); }
private void GetTable() { dataGridView.Rows.Clear(); dataGridView.Refresh(); MySqlDataReader dataReader = GDBMJabatan.GetTable(GetCondition()); while (dataReader.Read()) { dataGridView.Rows.Add( dataReader.GetInt16("IdMJabatan").ToString(), dataReader.GetInt16("No").ToString(), dataReader.GetString("KdMJabatan"), dataReader.GetString("NmMJabatan"), ASPCast.IntToBool(dataReader.GetInt16("Aktif")) ); } GDBMJabatan.aspQuery.MySqlConnect.CloseConnection(); }
public bool SelectById(int Id, ref ASPSysInfo_DO SysInfo) { bool Result = true; string condition = " WHERE IdSysInfo = " + ASPCast.SQLIntToStr(Id); string query = "SELECT " + FIELDNAME + " FROM " + TABLENAME + condition; MySqlDataReader data = null; if (aspQuery.Select(query, ref data)) { CopyToObject(ref SysInfo, data); } else { Result = false; } return(Result); }
public bool SelectById(int Id, ref ASPMKaryawan_DO MKaryawan) { bool Result = false; string condition = " WHERE IdMKaryawan = " + ASPCast.SQLIntToStr(Id); string query = "SELECT " + FIELDNAME + " FROM " + TABLENAME + condition; MySqlDataReader data = null; if (aspQuery.Select(query, ref data)) { if (data.HasRows) { CopyToObject(ref MKaryawan, data); Result = true; } } aspQuery.MySqlConnect.CloseConnection(); return(Result); }