public MySqlDataReader GetTable(List <KeyValuePair <string, string> > condition)
{
MySqlDataReader data = null;
string Condition = "";
if (condition.Count > 1)
{
Condition = Condition + " AND " + condition[0].Key + " LIKE " + condition[0].Value;
Condition = Condition + " ORDER BY " + condition[1].Key + " " + condition[1].Value;
}
else
{
Condition = Condition + " ORDER BY " + condition[0].Key + " " + condition[0].Value;
}
string Query = "SELECT * FROM (\n" +
" SELECT (@NoUrut := @NoUrut+1) AS `No`, Tbl.* FROM (\n" +
" SELECT " + FIELDNAME + " FROM " + TABLENAME + "\n" +
" ) Tbl CROSS JOIN (SELECT @NoUrut:=0)testing\n" +
") TblLuar WHERE `Hapus` = 0 " + Condition;
if (!aspQuery.Select(Query, ref data))
{
ASPMsgCmp.ErrorMessage("Fail to read get data from Master Group!");
}
return(data);
}
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);
}
}
}
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();
}
public BindingSource GetTable(string query)
{
BindingSource bindingSource = new BindingSource();
string Query = "SELECT * FROM (\n" +
query +
") TblLuar WHERE `Hapus` = 0 LIMIT 0,50";
if (!aspQuery.Select(Query, ref bindingSource))
{
ASPMsgCmp.ErrorMessage("Fail to read get data from Browse Form!");
}
return(bindingSource);
}
protected override bool CekValidate()
{
bool Result = base.CekValidate();
if (Result)
{
if (EditNmMKaryawan.Text.Trim().Equals(""))
{
ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Nama Karyawan"));
Result = false;
}
}
if (Result)
{
if (EditAlamat.Text.Trim().Equals(""))
{
ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Alamat"));
Result = false;
}
}
if (Result)
{
if (EditNoHP.Text.Trim().Equals(""))
{
ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "No. HP"));
Result = false;
}
}
if (Result)
{
if (GMJabatan.IdMJabatan == 0)
{
ASPMsgCmp.WarningMessage(string.Format(ASPMessage.wm_CANNOTNULL, "Jabatan"));
Result = false;
}
}
if (Result)
{
Result = (ASPMsgCmp.QuestionMessage(ASPMessage.cm_SAVE) == DialogResult.Yes);
}
return(Result);
}
public void CopyToObject(ref ASPSysInfo_DO SysInfo, MySqlDataReader data)
{
try
{
//if (data.Read())
//{
// SysInfo.IdSysInfo = data.GetInt16("IdSysInfo");
// SysInfo.AppVersion = data.GetString("AppVersion");
// SysInfo.LocalLicenseCode = data.GetString("LocalLicenseCode");
// SysInfo.GlobalLicenseCode = data.GetString("GlobalLicenseCode");
// SysInfo.TrialLicenseCode = data.("TrialLicenseCode");
// SysInfo.TrialDateLimit = data.GetMySqlDateTime("TrialDateLimit");
//}
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
}
}
public bool Select(String query, ref MySqlDataReader dataReader)
{
bool Result = true;
Command.Connection = MySqlConnect.connection;
if (!MySqlConnect.IsOpen)
{
MySqlConnect.OpenConnection();
}
try
{
Command.CommandText = query;
dataReader = Command.ExecuteReader();
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
Result = false;
}
return(Result);
}
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();
}
}
public void CopyToObject(ref ASPMGroup_DO MGroup, MySqlDataReader data)
{
try
{
if (data.Read())
{
MGroup.IdMGroup = data.GetInt16("IdMGroup");
MGroup.KdMGroup = data.GetString("KdMGroup");
MGroup.NmMGroup = data.GetString("NmMGroup");
MGroup.IdMManager = data.GetInt16("IdMManager");
MGroup.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif"));
MGroup.IdMUserCreate = data.GetInt16("IdMUserCreate");
MGroup.TglCreate = data.GetMySqlDateTime("TglCreate");
MGroup.IdMUserUpdate = data.GetInt16("IdMUserUpdate");
MGroup.TglUpdate = data.GetMySqlDateTime("TglUpdate");
MGroup.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus"));
}
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
}
}
public void CopyToObject(ref ASPMUser_DO MUser, MySqlDataReader data)
{
try
{
if (data.Read())
{
MUser.IdMUser = data.GetInt16("IdMUser");
MUser.Username = data.GetString("Username");
MUser.Password = data.GetString("Password");
MUser.IdMKaryawan = data.GetInt16("IdMKaryawan");
MUser.Aktif = ASPCast.IntToBool(data.GetInt16("Aktif"));
MUser.IdMUserCreate = data.GetInt16("IdMUserCreate");
MUser.TglCreate = data.GetMySqlDateTime("TglCreate");
MUser.IdMUserUpdate = data.GetInt16("IdMUserUpdate");
MUser.TglUpdate = data.GetMySqlDateTime("TglUpdate");
MUser.Hapus = ASPCast.IntToBool(data.GetInt16("Hapus"));
}
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
}
}
public bool Select(String query, ref BindingSource bindingSource)
{
bool Result = true;
MySqlDataAdapter adapter;
DataTable dataTable = new DataTable();
if (!MySqlConnect.IsOpen)
{
MySqlConnect.OpenConnection();
}
try
{
adapter = new MySqlDataAdapter(query, MySqlConnect.connection);
adapter.Fill(dataTable);
bindingSource.DataSource = dataTable;
}
catch (MySqlException ex)
{
ASPMsgCmp.WarningMessage(ex.Message);
Result = false;
}
return(Result);
}
