private void Create()
{
loginForm = new LoginForm();
FSysInfo = new ASPSysInfo_DO();
FDBSysInfo = new ASPSysInfo_DBC();
FMCurrUser = new ASPMUser_DO();
FDBMCurrUser = new ASPMUser_DBC();
}
public bool Delete(ASPMUser_DO MUser)
{
string Values = "IdMUserUpdate = " + MUser.IdMUserUpdate
+ ", TglUpdate = " + MUser.TglUpdate
+ ", Hapus = " + MUser.Hapus;
string Condition = " WHERE IdMUser = "******"UPDATE " + TABLENAME + " SET " + Values + Condition;
return(aspQuery.ExecCUD(Query));
}
public ASPMUser_DO SelectByUsername(string Username)
{
ASPMUser_DO MUser = new ASPMUser_DO();
string condition = " WHERE Username = "******"SELECT " + FIELDNAME + " FROM " + TABLENAME + condition;
MySqlDataReader data = null;
if (aspQuery.Select(query, ref data))
{
CopyToObject(ref MUser, data);
}
aspQuery.MySqlConnect.CloseConnection();
return(MUser);
}
public ASPMUser_DO SelectById(int Id)
{
ASPMUser_DO MUser = new ASPMUser_DO();
string condition = " WHERE IdMUser = "******"SELECT " + FIELDNAME + " FROM " + TABLENAME + condition;
MySqlDataReader data = null;
if (aspQuery.Select(query, ref data))
{
CopyToObject(ref MUser, data);
}
return(MUser);
}
private void MainForm_Load(object sender, EventArgs e)
{
this.Visible = false;
if (FMCurrUser.IdMUser == 0)
{
loginForm.ShowDialog();
if (!loginForm.Visible && loginForm.FMCurrUser.IdMUser != 0)
{
FMCurrUser = loginForm.FMCurrUser;
loginForm.Dispose();
this.Visible = true;
}
}
DateApp.Text = System.DateTime.Now.Date.ToString("dddd, dd MMMM yyyy", new System.Globalization.CultureInfo("id-ID"));
UserLogin.Text = FMCurrUser.Username;
}
public bool Update(ASPMUser_DO MUser)
{
string Values = " Username = "******", Password = "******", IdMKaryawan = " + MUser.IdMKaryawan
+ ", Aktif = " + MUser.Aktif
+ ", IdMUserCreate = " + MUser.IdMUserCreate
+ ", TglCreate = " + MUser.TglCreate
+ ", IdMUserUpdate = " + MUser.IdMUserUpdate
+ ", TglUpdate = " + MUser.TglUpdate;
string condition = " WHERE IdMUser = "******"UPDATE " + TABLENAME + " SET " + Values + condition;
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));
}
public ASPMUser_DO Clear()
{
ASPMUser_DO MUser = new ASPMUser_DO();
MUser.IdMUser = 0;
MUser.Username = "";
MUser.Password = "";
MUser.IdMKaryawan = 0;
MUser.Aktif = false;
MUser.IdMUserCreate = 0;
MUser.TglCreate = new MySqlDateTime();
MUser.IdMUserUpdate = 0;
MUser.TglUpdate = new MySqlDateTime();
MUser.Hapus = false;
return(MUser);
}
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);
}
}
private void Initialize()
{
FMCurrUser = FDBMCurrUser.Clear();
FSysInfo = FDBSysInfo.Clear();
}
