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();
}
protected override void Cancel()
{
base.Cancel();
GMKaryawan = GDBMKaryawan.Clear();
ShowData();
SetMode(ASPConstant.ModeBrowse);
}
protected override void Create()
{
base.Create();
GMKaryawan = new ASPMKaryawan_DO();
GDBMKaryawan = new ASPMKaryawan_DBC();
GMJabatan = new ASPMJabatan_DO();
GDBMJabatan = new ASPMJabatan_DBC();
}
protected override void Create()
{
base.Create();
GMManager = new ASPMKaryawan_DO();
GMAnggota = new ASPMKaryawan_DO();
GDBMKaryawan = new ASPMKaryawan_DBC();
GMGroup = new ASPMGroup_DO();
GDBMGroup = new ASPMGroup_DBC();
}
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));
}
protected override void EditRecord()
{
if (GMode == ASPConstant.ModeBrowse && dataGridView.SelectedRows.Count > 0)
{
base.EditRecord();
DataGridViewRow row = dataGridView.SelectedRows[0];
if (!GDBMKaryawan.SelectById(int.Parse(row.Cells["IdMKaryawan"].Value.ToString()), ref GMKaryawan))
{
GMKaryawan = GDBMKaryawan.Clear();
}
ShowData();
}
EditNmMKaryawan.Focus();
}
protected override void Initialize()
{
GTitleForm = "Master Group";
GMManager = GDBMKaryawan.Clear();
GMAnggota = GDBMKaryawan.Clear();
GMGroup = GDBMGroup.Clear();
tabControl1.TabIndex = 1;
ShowData();
GenerateComboColumn();
GetTable();
SetMode(ASPConstant.ModeBrowse);
dataGridViewInput.Focus();
base.Initialize();
}
public bool SelectByKode(string Kode, ref ASPMKaryawan_DO MKaryawan)
{
bool Result = false;
string condition = " WHERE KdMKaryawan = " + ASPCast.SQLStr(Kode);
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);
}
public bool Insert(ASPMKaryawan_DO MKaryawan)
{
string Values = ASPCast.SQLIntToStr(GetNewId()) + ", " +
ASPCast.SQLStr(MKaryawan.KdMKaryawan) + ", " +
ASPCast.SQLStr(MKaryawan.NmMKaryawan) + ", " +
ASPCast.SQLStr(MKaryawan.Alamat) + ", " +
ASPCast.SQLStr(MKaryawan.NoHP) + ", " +
ASPCast.SQLIntToStr(MKaryawan.IdMJabatan) + ", " +
ASPCast.SQLBoolToStr(MKaryawan.Aktif) + ", " +
ASPCast.SQLIntToStr(MKaryawan.IdMUserCreate) + ", " +
ASPCast.SQLDateTimeToStr(MKaryawan.TglCreate) + ", " +
ASPCast.SQLIntToStr(MKaryawan.IdMUserUpdate) + ", " +
ASPCast.SQLDateTimeToStr(MKaryawan.TglUpdate) + ", " +
ASPCast.SQLBoolToStr(MKaryawan.Hapus);
string query = "INSERT INTO " + TABLENAME + " (" + FIELDNAME + ") VALUES (" + Values + ")";
return(aspQuery.ExecCUD(query));
}
public ASPMKaryawan_DO Clear()
{
ASPMKaryawan_DO MKaryawan = new ASPMKaryawan_DO();
MKaryawan.IdMKaryawan = 0;
MKaryawan.KdMKaryawan = "";
MKaryawan.NmMKaryawan = "";
MKaryawan.Alamat = "";
MKaryawan.NoHP = "";
MKaryawan.IdMJabatan = 0;
MKaryawan.Aktif = false;
MKaryawan.IdMUserCreate = 0;
MKaryawan.TglCreate = new MySqlDateTime();
MKaryawan.IdMUserUpdate = 0;
MKaryawan.TglUpdate = new MySqlDateTime();
MKaryawan.Hapus = false;
return(MKaryawan);
}
public bool Update(ASPMKaryawan_DO MKaryawan)
{
string Values = " KdMKaryawan = " + ASPCast.SQLStr(MKaryawan.KdMKaryawan)
+ ", NmMKaryawan = " + ASPCast.SQLStr(MKaryawan.NmMKaryawan)
+ ", Alamat = " + ASPCast.SQLStr(MKaryawan.Alamat)
+ ", NoHP = " + ASPCast.SQLStr(MKaryawan.NoHP)
+ ", IdMJabatan = " + ASPCast.SQLIntToStr(MKaryawan.IdMJabatan)
+ ", Aktif = " + ASPCast.SQLBoolToStr(MKaryawan.Aktif)
+ ", IdMUserCreate = " + ASPCast.SQLIntToStr(MKaryawan.IdMUserCreate)
+ ", TglCreate = " + ASPCast.SQLDateTimeToStr(MKaryawan.TglCreate)
+ ", IdMUserUpdate = " + ASPCast.SQLIntToStr(MKaryawan.IdMUserUpdate)
+ ", TglUpdate = " + ASPCast.SQLDateTimeToStr(MKaryawan.TglUpdate);
string condition = " WHERE IdMKaryawan = " + ASPCast.SQLIntToStr(MKaryawan.IdMKaryawan);
string query = "UPDATE " + TABLENAME + " SET " + Values + condition;
return(aspQuery.ExecCUD(query));
}
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();
}
}
