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 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 tsNumberRangeModel querytsNumberRange() { tsNumberRangeModel tsNumberRangeModel = new tsNumberRangeModel(); 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()); } } } sqlConnection.Close(); return(tsNumberRangeModel); }