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