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