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);
}
public bool Insert(List <ASPMGroupD_DO> MGroupD)
{
string Values = "";
CreateValues(ref Values, MGroupD);
string Query = "INSERT INTO " + TABLENAMED + " (" + FIELDNAMED + ") VALUES " + Values;
return(aspQueryD.ExecCUD(Query));
}
public bool Insert(ASPMJabatan_DO MJabatan)
{
string Values = ASPCast.SQLIntToStr(GetNewId()) + ", " +
ASPCast.SQLStr(MJabatan.KdMJabatan) + ", " +
ASPCast.SQLStr(MJabatan.NmMJabatan) + ", " +
ASPCast.SQLBoolToStr(MJabatan.Aktif) + ", " +
ASPCast.SQLIntToStr(MJabatan.IdMUserCreate) + ", " +
ASPCast.SQLDateTimeToStr(MJabatan.TglCreate) + ", " +
ASPCast.SQLIntToStr(MJabatan.IdMUserUpdate) + ", " +
ASPCast.SQLDateTimeToStr(MJabatan.TglUpdate) + ", " +
ASPCast.SQLBoolToStr(MJabatan.Hapus);
string query = "INSERT INTO " + TABLENAME + " (" + FIELDNAME + ") VALUES (" + Values + ")";
return(aspQuery.ExecCUD(query));
}
public bool Insert(ASPMUser_DO MUser)
{
string Values = GetNewId().ToString() + ", " +
MUser.Username + ", " +
MUser.Password + ", " +
MUser.IdMKaryawan + ", " +
MUser.Aktif + ", " +
MUser.IdMUserCreate + ", " +
MUser.TglCreate + ", " +
MUser.IdMUserUpdate + ", " +
MUser.TglUpdate + ", " +
MUser.Hapus;
string query = "INSERT INTO " + TABLENAME + " (" + FIELDNAME + ") VALUES (" + Values + ")";
return(aspQuery.ExecCUD(query));
}