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