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);
}
}
}
protected override void Save()
{
LoadData();
if (GMode == ASPConstant.ModeNew)
{
if (GDBMJabatan.Insert(GMJabatan))
{
ASPMsgCmp.InfoMessage("Data berhasil disimpan.");
}
else
{
ASPMsgCmp.ErrorMessage("Data gagal disimpan.");
}
}
else if (GMode == ASPConstant.ModeEdit)
{
if (GDBMJabatan.Update(GMJabatan))
{
ASPMsgCmp.InfoMessage("Data berhasil disimpan.");
}
else
{
ASPMsgCmp.ErrorMessage("Data gagal disimpan.");
}
}
GMJabatan = GDBMJabatan.Clear();
ShowData();
SetMode(ASPConstant.ModeBrowse);
GetTable();
dataGridView.Focus();
}
protected override void Cancel()
{
base.Cancel();
GMJabatan = GDBMJabatan.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 Initialize()
{
GTitleForm = "Master Karyawan";
GMJabatan = GDBMJabatan.Clear();
ShowData();
GenerateComboColumn();
GetTable();
SetMode(ASPConstant.ModeBrowse);
dataGridView.Focus();
base.Initialize();
}
public bool Delete(ASPMJabatan_DO MJabatan)
{
string Values = "IdMUserUpdate = " + MJabatan.IdMUserUpdate
+ ", TglUpdate = " + MJabatan.TglUpdate
+ ", Hapus = " + MJabatan.Hapus;
string Condition = " WHERE IdMJabatan = " + ASPCast.SQLIntToStr(MJabatan.IdMJabatan);
string Query = "UPDATE " + TABLENAME + " SET " + Values + Condition;
return(aspQuery.ExecCUD(Query));
}
private void BrowseMJabatan()
{
GDBMJabatan.InitBrowse(FColumnSearch, FValueSearch);
GDBMJabatan.BrowseForm.ShowDialog(this);
if (GDBMJabatan.BrowseForm.Select)
{
if (!GDBMJabatan.SelectById(int.Parse(GDBMJabatan.BrowseForm.Result), ref GMJabatan))
{
GMJabatan = GDBMJabatan.Clear();
}
ShowMJabatan(GMJabatan);
}
}
protected override void EditRecord()
{
if (GMode == ASPConstant.ModeBrowse && dataGridView.SelectedRows.Count > 0)
{
base.EditRecord();
DataGridViewRow row = dataGridView.SelectedRows[0];
if (!GDBMJabatan.SelectById(int.Parse(row.Cells["IdMJabatan"].Value.ToString()), ref GMJabatan))
{
GMJabatan = GDBMJabatan.Clear();
}
ShowData();
}
EditNmMJabatan.Focus();
}
public bool Update(ASPMJabatan_DO MJabatan)
{
string Values = " KdMJabatan = " + ASPCast.SQLStr(MJabatan.KdMJabatan)
+ ", NmMJabatan = " + ASPCast.SQLStr(MJabatan.NmMJabatan)
+ ", Aktif = " + ASPCast.SQLBoolToStr(MJabatan.Aktif)
+ ", IdMUserCreate = " + ASPCast.SQLIntToStr(MJabatan.IdMUserCreate)
+ ", TglCreate = " + ASPCast.SQLDateTimeToStr(MJabatan.TglCreate)
+ ", IdMUserUpdate = " + ASPCast.SQLIntToStr(MJabatan.IdMUserUpdate)
+ ", TglUpdate = " + ASPCast.SQLDateTimeToStr(MJabatan.TglUpdate);
string condition = " WHERE IdMJabatan = " + ASPCast.SQLIntToStr(MJabatan.IdMJabatan);
string query = "UPDATE " + TABLENAME + " SET " + Values + condition;
return(aspQuery.ExecCUD(query));
}
public ASPMJabatan_DO Clear()
{
ASPMJabatan_DO MJabatan = new ASPMJabatan_DO();
MJabatan.IdMJabatan = 0;
MJabatan.KdMJabatan = "";
MJabatan.NmMJabatan = "";
MJabatan.Aktif = false;
MJabatan.IdMUserCreate = 0;
MJabatan.TglCreate = new MySqlDateTime();
MJabatan.IdMUserUpdate = 0;
MJabatan.TglUpdate = new MySqlDateTime();
MJabatan.Hapus = false;
return(MJabatan);
}
public bool Insert(ASPMJabatan_DO MJabatan)
{
string Values = ASPCast.SQLIntToStr(GetNewId()) + ", " +
ASPCast.SQLStr(MJabatan.KdMJabatan) + ", " +
ASPCast.SQLStr(MJabatan.NmMJabatan) + ", " +
ASPCast.SQLBoolToStr(MJabatan.Aktif) + ", " +
ASPCast.SQLIntToStr(MJabatan.IdMUserCreate) + ", " +
ASPCast.SQLDateTimeToStr(MJabatan.TglCreate) + ", " +
ASPCast.SQLIntToStr(MJabatan.IdMUserUpdate) + ", " +
ASPCast.SQLDateTimeToStr(MJabatan.TglUpdate) + ", " +
ASPCast.SQLBoolToStr(MJabatan.Hapus);
string query = "INSERT INTO " + TABLENAME + " (" + FIELDNAME + ") VALUES (" + Values + ")";
return(aspQuery.ExecCUD(query));
}
public bool SelectByNama(string Nama, ref ASPMJabatan_DO MJabatan)
{
bool Result = false;
string condition = " WHERE NmMJabatan = " + ASPCast.SQLStr(Nama);
string query = "SELECT " + FIELDNAME + " FROM " + TABLENAME + condition;
MySqlDataReader data = null;
if (aspQuery.Select(query, ref data))
{
if (data.HasRows)
{
CopyToObject(ref MJabatan, data);
Result = true;
}
}
aspQuery.MySqlConnect.CloseConnection();
return(Result);
}
protected void ShowData()
{
if (GMode == ASPConstant.ModeNew)
{
GMKaryawan.KdMKaryawan = GDBMKaryawan.GetNewKode();
GMKaryawan.Aktif = true;
}
EditKdMKaryawan.Text = GMKaryawan.KdMKaryawan;
EditNmMKaryawan.Text = GMKaryawan.NmMKaryawan;
EditAlamat.Text = GMKaryawan.Alamat;
EditNoHP.Text = GMKaryawan.NoHP;
if (!GDBMJabatan.SelectById(GMKaryawan.IdMJabatan, ref GMJabatan))
{
GMJabatan = GDBMJabatan.Clear();
}
ShowMJabatan(GMJabatan);
CbAktif.Checked = GMKaryawan.Aktif;
}
public void CopyToObject(ref ASPMJabatan_DO MJabatan, MySqlDataReader data)
{
try
{
if (data.Read())
{
MJabatan.IdMJabatan = data.GetInt16("IdMJabatan");
MJabatan.KdMJabatan = data.GetString("KdMJabatan");
MJabatan.NmMJabatan = data.GetString("NmMJabatan");
MJabatan.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif"));
MJabatan.IdMUserCreate = data.GetInt16("IdMUserCreate");
MJabatan.TglCreate = data.GetMySqlDateTime("TglCreate");
MJabatan.IdMUserUpdate = data.GetInt16("IdMUserUpdate");
MJabatan.TglUpdate = data.GetMySqlDateTime("TglUpdate");
MJabatan.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus"));
}
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
}
}
protected override void DeleteRecord()
{
bool CanDelete = true;
if (GMode == ASPConstant.ModeBrowse && dataGridView.SelectedRows.Count > 0)
{
base.DeleteRecord();
DataGridViewRow row = dataGridView.SelectedRows[0];
if (!GDBMJabatan.SelectById(int.Parse(row.Cells["IdMJabatan"].Value.ToString()), ref GMJabatan))
{
GMJabatan = GDBMJabatan.Clear();
CanDelete = false;
}
if (CanDelete)
{
if (ASPMsgCmp.QuestionMessage("Yakin ingin menghapus " + GMJabatan.NmMJabatan + "?") == DialogResult.Yes)
{
GMJabatan.IdMUserUpdate = MainForm.FMCurrUser.IdMKaryawan;
GMJabatan.TglUpdate = GDBMJabatan.GetNow();
GMJabatan.Hapus = true;
if (GDBMJabatan.Delete(GMJabatan))
{
ASPMsgCmp.InfoMessage("Data berhasil dihapus.");
}
else
{
ASPMsgCmp.ErrorMessage("Data gagal dihapus.");
}
}
}
GMJabatan = GDBMJabatan.Clear();
ShowData();
SetMode(ASPConstant.ModeBrowse);
GetTable();
}
}
protected override void LoadData()
{
if (GMode == ASPConstant.ModeNew)
{
GMKaryawan.IdMKaryawan = GDBMKaryawan.GetNewId();
GMKaryawan.IdMUserCreate = MainForm.FMCurrUser.IdMKaryawan;
GMKaryawan.TglCreate = GDBMJabatan.GetNow();
}
GMKaryawan.KdMKaryawan = EditKdMKaryawan.Text;
GMKaryawan.NmMKaryawan = EditNmMKaryawan.Text;
GMKaryawan.Alamat = EditAlamat.Text;
GMKaryawan.NoHP = EditNoHP.Text;
if (!GDBMJabatan.SelectByKode(EditKdMJabatan.Text.Trim(), ref GMJabatan))
{
GMJabatan = GDBMJabatan.Clear();
}
GMKaryawan.IdMJabatan = GMJabatan.IdMJabatan;
GMKaryawan.Aktif = CbAktif.Checked;
GMKaryawan.IdMUserUpdate = MainForm.FMCurrUser.IdMKaryawan;
GMKaryawan.TglUpdate = GDBMJabatan.GetNow();
}
private void ShowMJabatan(ASPMJabatan_DO MJabatan)
{
EditKdMJabatan.Text = MJabatan.KdMJabatan;
EditNmMJabatan.Text = MJabatan.NmMJabatan;
}
