public bool Update(ASPMGroup_DO MGroup, List <ASPMGroupD_DO> MGroupD)
{
bool Result = true;
string Values = " KdMGroup = " + ASPCast.SQLStr(MGroup.KdMGroup)
+ ", NmMGroup = " + ASPCast.SQLStr(MGroup.NmMGroup)
+ ", IdMManager = " + ASPCast.SQLIntToStr(MGroup.IdMManager)
+ ", Aktif = " + ASPCast.SQLBoolToStr(MGroup.Aktif)
+ ", IdMUserCreate = " + ASPCast.SQLIntToStr(MGroup.IdMUserCreate)
+ ", TglCreate = " + ASPCast.SQLDateTimeToStr(MGroup.TglCreate)
+ ", IdMUserUpdate = " + ASPCast.SQLIntToStr(MGroup.IdMUserUpdate)
+ ", TglUpdate = " + ASPCast.SQLDateTimeToStr(MGroup.TglUpdate);
string condition = " WHERE IdMGroup = " + ASPCast.SQLIntToStr(MGroup.IdMGroup);
string query = "UPDATE " + TABLENAME + " SET " + Values + condition;
if (Result)
{
Result = GGroupD_DBC.Delete(MGroup.IdMGroup);
}
if (Result)
{
Result = GGroupD_DBC.Insert(MGroupD);
}
if (Result)
{
Result = aspQuery.ExecCUD(query);
}
return(Result);
}
public bool Insert(ASPMGroup_DO MGroup, List <ASPMGroupD_DO> MGroupD)
{
bool Result = true;
string Values = ASPCast.SQLIntToStr(GetNewId()) + ", " +
ASPCast.SQLStr(MGroup.KdMGroup) + ", " +
ASPCast.SQLStr(MGroup.NmMGroup) + ", " +
ASPCast.SQLIntToStr(MGroup.IdMManager) + ", " +
ASPCast.SQLBoolToStr(MGroup.Aktif) + ", " +
ASPCast.SQLIntToStr(MGroup.IdMUserCreate) + ", " +
ASPCast.SQLDateTimeToStr(MGroup.TglCreate) + ", " +
ASPCast.SQLIntToStr(MGroup.IdMUserUpdate) + ", " +
ASPCast.SQLDateTimeToStr(MGroup.TglUpdate) + ", " +
ASPCast.SQLBoolToStr(MGroup.Hapus);
string query = "INSERT INTO " + TABLENAME + " (" + FIELDNAME + ") VALUES (" + Values + ")";
if (Result)
{
Result = GGroupD_DBC.Insert(MGroupD);
}
if (Result)
{
Result = aspQuery.ExecCUD(query);
}
return(Result);
}
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(ASPMGroup_DO MGroup)
{
string Values = "IdMUserUpdate = " + MGroup.IdMUserUpdate
+ ", TglUpdate = " + MGroup.TglUpdate
+ ", Hapus = " + MGroup.Hapus;
string Condition = " WHERE IdMGroup = " + ASPCast.SQLIntToStr(MGroup.IdMGroup);
string Query = "UPDATE " + TABLENAME + " SET " + Values + Condition;
return(aspQuery.ExecCUD(Query));
}
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 ASPMGroup_DO Clear()
{
ASPMGroup_DO MGroup = new ASPMGroup_DO();
MGroup.IdMGroup = 0;
MGroup.KdMGroup = "";
MGroup.NmMGroup = "";
MGroup.IdMManager = 0;
MGroup.Aktif = false;
MGroup.IdMUserCreate = 0;
MGroup.TglCreate = new MySqlDateTime();
MGroup.IdMUserUpdate = 0;
MGroup.TglUpdate = new MySqlDateTime();
MGroup.Hapus = false;
return(MGroup);
}
public bool SelectByNama(string Nama, ref ASPMGroup_DO MGroup)
{
bool Result = false;
string condition = " WHERE NmMGroup = " + ASPCast.SQLStr(Nama);
string query = "SELECT " + FIELDNAME + " FROM " + TABLENAME + condition;
MySqlDataReader data = null;
if (aspQuery.Select(query, ref data))
{
if (data.HasRows)
{
CopyToObject(ref MGroup, data);
Result = true;
}
}
aspQuery.MySqlConnect.CloseConnection();
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);
}
}
