public static void CreateLoginTransaction(LoginMessage loginMessage) { tsNumberRangeModel newNumberRange = new tsNumberRangeModel() { login_id = (Int32.Parse(DatabaseConnection.querytsNumberRange().login_id) + 1).ToString() }; tsLoginDetailModel tsLoginDetailModel = new tsLoginDetailModel() { login_id = newNumberRange.login_id, login_account_id = loginMessage.zAccountDetailModel.account_id, login_username = loginMessage.zAccountDetailModel.account_username, login_time = DateTime.Now.ToString("HHmm"), login_date = DateTime.Now.Date.ToString("ddMMyyyy"), login_ip = GlobalFunctions.GetIPAddress(), login_token = "null", login_status = loginMessage.returnStatusModel.status.ToString() }; DatabaseConnection.inserttsLoginDetail(tsLoginDetailModel); returnStatusModel = DatabaseConnection.updatetsNumberRange(newNumberRange); if (GlobalFunctions.isNotError(returnStatusModel.status)) { GlobalFunctions.ShowDebug("COMPLETED"); } }
public static ReturnStatusModel updatetsNumberRange(tsNumberRangeModel tsNumberRangeModel) { ReturnStatusModel returnStatusModel = new ReturnStatusModel(); string CommandText = "SELECT * " + "FROM tsNumber_Range_Model"; sqlConnection.Open(); sqlCommand = sqlConnection.CreateCommand(); using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { tsNumberRangeModel.login_id = (rdr["login_id"].ToString()); } } } returnStatusModel.status = true; returnStatusModel.error_message = Messages.m_update_success; sqlConnection.Close(); return(returnStatusModel); #endregion }
public static LoginMessage queryLogin(LoginModel loginModel) { LoginMessage loginMessage = new LoginMessage(); zAccountDetailModel zAccountDetailModel = new zAccountDetailModel(); ReturnStatusModel returnStatusModel = new ReturnStatusModel(); string CommandText = "SELECT * " + "FROM zAccount_Detail " + "WHERE " + "account_username = '******' " + "AND account_password ='******'"; sqlConnection.Open(); sqlCommand = sqlConnection.CreateCommand(); using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { if (rdr.HasRows != false) { while (rdr.Read()) { zAccountDetailModel.account_id = (rdr["account_id"].ToString()); zAccountDetailModel.account_username = (rdr["account_username"].ToString()); zAccountDetailModel.account_password = (rdr["account_password"].ToString()); zAccountDetailModel.account_created_date = (rdr["account_created_date"].ToString()); zAccountDetailModel.account_created_by = (rdr["account_created_by"].ToString()); zAccountDetailModel.account_firstname = (rdr["account_firstname"].ToString()); zAccountDetailModel.account_lastname = (rdr["account_lastname"].ToString()); zAccountDetailModel.account_lastlogin_time = (rdr["account_lastlogin_time"].ToString()); zAccountDetailModel.account_lastlogin_date = (rdr["account_lastlogin_date"].ToString()); zAccountDetailModel.account_language_default = (rdr["account_language_default"].ToString()); zAccountDetailModel.account_role_id = (rdr["account_role_id"].ToString()); zAccountDetailModel.account_expire_date = (rdr["account_expire_date"].ToString()); zAccountDetailModel.account_status = (rdr["account_status"].ToString()); } returnStatusModel.status = true; returnStatusModel.error_message = Messages.m_login_success; } else { returnStatusModel.status = false; returnStatusModel.error_message = Messages.m_user_or_pass_inc; } } } loginMessage.zAccountDetailModel = zAccountDetailModel; loginMessage.returnStatusModel = returnStatusModel; sqlConnection.Close(); return(loginMessage); }
public static LoginMessage queryLoginUsername(LoginModel loginModel) { LoginMessage loginMessage = new LoginMessage(); zAccountDetailModel zAccountDetailModel = new zAccountDetailModel(); ReturnStatusModel returnStatusModel = new ReturnStatusModel(); string CommandText = "SELECT account_username " + "FROM zAccount_Detail " + "WHERE " + "account_username = '******'"; sqlConnection.Open(); sqlCommand = sqlConnection.CreateCommand(); using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { if (rdr.HasRows != false && rdr.Read()) { zAccountDetailModel.account_username = (rdr["account_username"].ToString()); returnStatusModel.status = false; returnStatusModel.error_message = Messages.m_pass_inc; } else { returnStatusModel.status = false; returnStatusModel.error_message = Messages.m_user_not_exist; } } } loginMessage.zAccountDetailModel = zAccountDetailModel; loginMessage.returnStatusModel = returnStatusModel; sqlConnection.Close(); return(loginMessage); }