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