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);
}
